My site worked fine on my previous web hosting providers server, but the site had to be moved to a new hosting server. I'm getting the following error when attempting to reach the site by its URL:
Fatal error: Uncaught exception 'ErrorException' with message 'Error: Field 'categories_viewed' doesn't have a default value<br />Error No: 1364<br />INSERT INTO `oc_online_plus` (`ip_address`, `browser_string`, `country_name`, `referer`,`base_referer`,`referer_query_string`,`landing_page`,`exit_page`,`time_arrived`,`last_click`,`search_term`) VALUES ... /public_html/system/database/mysqli.php:40 Stack trace: #0 /home/twohotpeppers/public_html/vqmod/vqcache/vq2-system_library_db.php(20): DBMySQLi->query('INSERT INTO `oc...') #1 /home/twohotpeppers/public_html/catalog/model/tool/online_plus.php(276): DB->query('INSERT INTO `oc...') #2 /home/twohotpeppers/public_html/vqmod/vqcache/vq2-catalog_controller_common_footer.php(72): ModelTool in /home/twohotpeppers/public_html/system/database/mysqli.php on line 40
OpenCart 1.5.6.1
VQMod 2.6.4 -- confirmed installed
Journal Theme 2.6.3
PHP 5.6 -- all required extensions enabled, not sure if STRICT MODE is 'on' or 'off', of if that matters
- vqcache has been cleared
- journal-cache has been cleared
- I can login and navigate the admin side (http:// only, not https://)
Any assistance would be greatly appreciated.
Thanks!
"categories_viewed" and "online_plus" are not normal database tables, so some extension added those, and they aren't set up properly. Since it's OpenCart 1.5 it must be a vQmod extension, so go through your mods in /vqmod/xml/ and try disabling ones that might be related. (You can disable a vQmod file by renaming it from .xml to .xml_ or something else.)
Once you find the problematic extension, you can leave it disabled, or contact its developer for assistance.
Once you find the problematic extension, you can leave it disabled, or contact its developer for assistance.
Go to phpmyadmin
Run sql query
Run sql query
Code: Select all
ALTER TABLE `oc_online_plus` ALTER `categories_viewed` SET DEFAULT 0;
Business Web Development | Content Creation | Analytics and Reporting | SEO
Who is online
Users browsing this forum: No registered users and 378 guests