- Posts: 5
- Thank you received: 0
Questions about Payment Form extension
pf_coupons table does not exist
- Pieter77
- Topic Author
- Offline
- New Member
Less
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:
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
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.
- Tuan Pham Ngoc
- Offline
- Administrator
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
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
Less
More
- Posts: 5
- Thank you received: 0
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
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.
- Tuan Pham Ngoc
- Offline
- Administrator
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
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.
- thepiston
- Offline
- Premium Member
Less
More
- Posts: 150
- Thank you received: 5
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
Support
Documentation
Information
Copyright © 2024 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.