Greetings,
Error logged when the following Scheduled Task (CRON) ./core/includes/cron/subscriptions.php
I check the table and the install script, no "subscriptionid" field in "userban" table.
#7 vB_dB_Assertor->update() called in [path]/includes/class_paid_subscription.php on line 578
Is in ./core/includes/class_paid_subscription.php line 578
Is this a bug? Or is something broken on my install?
The Error...
Error logged when the following Scheduled Task (CRON) ./core/includes/cron/subscriptions.php
I check the table and the install script, no "subscriptionid" field in "userban" table.
#7 vB_dB_Assertor->update() called in [path]/includes/class_paid_subscription.php on line 578
Is in ./core/includes/class_paid_subscription.php line 578
PHP Code:
vB::getDbAssertor()->update('userban', $userbansql, array('subscriptionid' => $subscriptionid, 'userid' => $user['userid']));
The Error...
Code:
Invalid SQL: UPDATE userban SET `customtitle`=0,`usertitle`='Registered' WHERE (`subscriptionid` = 1 AND `userid` = 6841) /**userban- crontab_script**/; MySQL Error : Unknown column 'subscriptionid' in 'where clause' Error Number : 1054 Request Date : Saturday, July 15th 2017 @ 09:00:41 AM Error Date : Saturday, July 15th 2017 @ 09:01:15 AM Referrer : IP Address : Username : Guest Classname : vB_Database_MySQLi MySQL Version : Stack Trace: #0 vB_Database->getErrorData() called in [path]/vb/database.php on line 1188 #1 vB_Database->halt() called in [path]/vb/database/mysqli.php on line 201 #2 vB_Database_MySQLi->execute_query() called in [path]/vb/database.php on line 542 #3 vB_Database->query_write() called in [path]/vb/db/query/update.php on line 115 #4 vB_dB_Query_Update->doUpdates() called in [path]/vb/db/query/update.php on line 101 #5 vB_dB_Query_Update->execSQL() called in [path]/vb/db/assertor.php on line 302 #6 vB_dB_Assertor->assertQuery() called in [path]/vb/db/assertor.php on line 537 #7 vB_dB_Assertor->update() called in [path]/includes/class_paid_subscription.php on line 578 #8 vB_PaidSubscription->delete_user_subscription() called in [path]/includes/cron/subscriptions.php on line 42 #9 include_once([path]/includes/cron/subscriptions.php) called in /srv/www/pit_scripts/cron.php on line 32
Comment