Jump to content

Whole store down after php update


Guest wellis

Recommended Posts

Guest wellis

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!

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...