Post by Markticulous » Thu Mar 09, 2023 7:58 am

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!

User avatar
Newbie

Posts

Joined
Thu Mar 09, 2023 7:26 am

Post by Johnathan » Thu Mar 09, 2023 10:04 pm

"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.

Image Image Image Image Image


User avatar
Administrator

Posts

Joined
Fri Dec 18, 2009 3:08 am


Post by SohBH » Wed Apr 26, 2023 7:59 pm

Go to phpmyadmin
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


User avatar
Active Member

Posts

Joined
Mon Nov 02, 2020 12:01 am
Location - Malaysia
Who is online

Users browsing this forum: No registered users and 378 guests