Questions about Payment Form extension

pf_coupons table does not exist

  • Pieter77
  • Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 11 months ago #79730 by Pieter77
pf_coupons table does not exist was created by Pieter77
Hi,

I'am migrating an Joomla 2.5.28 site with PF 1.9 to an Joomla 3.5.0 site and updated PF to 4.2.

Things like to work fine, but I can not open all configuration pages, while getting an error:
- main dashboardpage of the component
- the coupons page
- the processed payment page
On these pages I get the error:
Code:
1146 Table 'databasename.#__pf_coupons' doesn't exist SQL=SELECT tbl.*, b.title, c.username, d.code AS coupon_code FROM #__pf_payments AS tbl INNER JOIN #__pf_forms AS b ON tbl.form_id = b.id LEFT JOIN #__users AS c ON tbl.user_id = c.id LEFT JOIN #__pf_coupons AS d ON tbl.coupon_id = d.id WHERE (tbl.published=1 OR tbl.payment_method LIKE "os_offline%") ORDER BY tbl.created_date DESC LIMIT 0, 20

I can open the other configuration pages and make changes to the forms.

I uninstalled the package, the plugins, the modules. Re-installed them (content remains in the database). This doesn't fix the issue.

Can you explain how to repair this missing database table?

Thanks!
Pieter

Please Log in or Create an account to join the conversation.

More
7 years 11 months ago #79931 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic pf_coupons table does not exist
Hi Pieter

I think the upgrade process was not success for some reasons. Could you please submit a support ticket sending us super admin account of your site so that we can check and solve it for you ?

Regards,

Tuan
The following user(s) said Thank You: Pieter77

Please Log in or Create an account to join the conversation.

  • Pieter77
  • Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 11 months ago - 7 years 11 months ago #80085 by Pieter77
Replied by Pieter77 on topic pf_coupons table does not exist
Thanks Tuan.

The migrated concept is not open to the internet (local MAMP Pro platform), so I can't give you access. Thanks for the offer.

I managed to manualy uninstall all traces of the old package. So manualy deleted files and database references. After that I made a clean install.
I only had 4 forms, so manually re-entered the information of the fields. I lost the processed payments.. but thats okay for me.

Regards,
Pieter
Last edit: 7 years 11 months ago by Pieter77.

Please Log in or Create an account to join the conversation.

More
7 years 11 months ago #80169 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic pf_coupons table does not exist
Hmm

You should not have to do that. If you want, you can email me a copy of your old Payment Form database. I will then check, install latest version, make sure the new database is correct

Then I will send it to you and you can import back to your site. By doing that, you won't loose anything

Tuan

Please Log in or Create an account to join the conversation.

More
7 years 7 months ago #86248 by thepiston
Replied by thepiston on topic pf_coupons table does not exist
same issue here, I will submit ticket

Please Log in or Create an account to join the conversation.

Moderators: Tuan Pham Ngoc