Database metainfo.asp error after update to 7.6.2

Author	« Topic »
joetuesday Advanced Member 183 Posts Pre-sales questions only (More Details...)	Posted - 08/26/2023 : 12:39:03 Hi - I have an issue that I have likely caused somewhere along the way. We updated to version 7.6.2, but the site is erroring out on the proddetail page. It is likely to do with some past code I didn't update properly or a missing value in a database maybe? The issue occurs when going to the productdetail.asp page: Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [MySQL][ODBC 3.51 Driver][mysqld-5.6.40]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1 imageSrc FROM productimages WHERE imageProduct='PROD1234' AND imageType IN (0,1)' at line 1 /vsadmin/inc/metainfo.asp, line 100 Checking to see if anyone has encountered something similar. Thanks. Joe
joetuesday Advanced Member 183 Posts Pre-sales questions only (More Details...)	Posted - 08/26/2023 : 12:46:21 When I edited out lines 99-105 or so in metainfo it worked again Joe
Vince Administrator 42756 Posts	Posted - 08/26/2023 : 14:51:20 Hi Joe It seems that you are using mySQL server with the ASP version but by the looks of the error, the metainfo script doesn't know that. It could be that you have the parameter... mysqlserver=TRUE ...in the includes.asp file but don't have the includes.asp file before the metainfo.asp include line. How about just adding "mysqlserver=TRUE" directly in the db_conn_open.asp file? Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
	« Topic »