Group Subscription (PayPal)

Missing Table/s from Database - Group Subscription (PayPal)

Missing Table/s from Database

by Thunderer » Mon Oct 14, 2019 11:15 pm

I tried installing on 3.2.8 after updating and it appears to install OK, however, it comes up with some errors and missing DB tables.



The error returned is as follows;

General Error
SQL ERROR [ mysqli ]

Table '[dB name removed].f1_groupsub_subs' doesn't exist [1146]

SQL

SELECT s.*, p.pkg_name, p.pkg_deleted, u.username FROM (f1_groupsub_subs s) LEFT JOIN f1_groupsub_packages p ON (s.pkg_id = p.pkg_id) LEFT JOIN f1_users u ON (s.user_id = u.user_id) ORDER BY u.username ASC LIMIT 25

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 997
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 196
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/mysql_base.php
LINE: 45
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 270
CALL: phpbb\db\driver\mysql_base->_sql_query_limit()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 321
CALL: phpbb\db\driver\driver->sql_query_limit()

FILE: [ROOT]/ext/stevotvr/groupsub/operator/subscription.php
LINE: 265
CALL: phpbb\db\driver\factory->sql_query_limit()

FILE: [ROOT]/ext/stevotvr/groupsub/operator/subscription.php
LINE: 204
CALL: stevotvr\groupsub\operator\subscription->get_subscription_rows()

FILE: [ROOT]/ext/stevotvr/groupsub/controller/acp_subs_controller.php
LINE: 118
CALL: stevotvr\groupsub\operator\subscription->get_subscriptions()

FILE: [ROOT]/ext/stevotvr/groupsub/acp/main_module.php
LINE: 139
CALL: stevotvr\groupsub\controller\acp_subs_controller->display()

FILE: [ROOT]/ext/stevotvr/groupsub/acp/main_module.php
LINE: 44
CALL: stevotvr\groupsub\acp\main_module->manage_subscriptions()

FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: stevotvr\groupsub\acp\main_module->main()

FILE: [ROOT]/adm/index.php
LINE: 82
CALL: p_master->load_active()

(I have attached a screengrab for clarification.)...
error1.png


Is there a specific method of resolving this as I do need to use the Subscription system.
Thunderer
Registered User
Posts: 132
Joined: Mon Apr 20, 2009 1:49 am
Contact:

Re: Missing Table/s from Database

by StevoTVR » Mon Oct 14, 2019 11:28 pm

Have you tried disabling, deleting data, and then re-enabling the extension?
User avatar
StevoTVR
Registered User
Posts: 271
Joined: Thu Jul 13, 2006 6:23 pm
Name: Steve Guidetti
Contact:

Re: Missing Table/s from Database

by Thunderer » Tue Oct 15, 2019 12:17 am

Yes and still the same thing


***EDIT****

changing the database key name from "f1_" to "phpbb_" solved the issue ;)

***EDIT***
Thunderer
Registered User
Posts: 132
Joined: Mon Apr 20, 2009 1:49 am
Contact: