Guest wellis Posted March 26, 2008 Share Posted March 26, 2008 We have a store on a client site http://leadershiptraininginstitute.org/store Everything was fine with php 4.5, but whe we updated to PHP 5.2.5 everything went crazy. We now get: 1064: 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 '' at line 1 No store or admin access. We are using cubecart 3.017 Please help! If you need more info that I cannot post please PM me. Thanks! Quote Link to comment Share on other sites More sharing options...
bsmither Posted March 26, 2008 Share Posted March 26, 2008 My opinion (based on experience) is that the MySQL error is not caused by the upgraded version of PHP, but rather the possibility of having had MySQL upgraded from MySQL4 to MySQL5. There is a setting in the mysql "my.ini" file. See: http://forums.cubecart.com/index.php?showtopic=28871 http://forums.cubecart.com/index.php?showtopic=28650 The problem, as I see it, is that CC3 adds and updates records with null values (...use near apostrophe-apostrophe...) when they really should be zero's. The "my.ini" file is something your hosting provider should be able to deal with. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.