Jump to content

Database syntax error upon upgrade to 4.2.2


Guest JodieR

Recommended Posts

Guest JodieR

AHH!

I just upgraded both my sites to 4.2.2 and received this error on my main site www.alluringfashions.com

My admin panel shows the following info:

CubeCart Version: 4.2.2

PHP Version: 5.2.5

MySQL Version: 4.0.27-max-log

My other site is using the same except the MySql version:

MySQL Version: 5.0.45-log

and didn't have any problems with the upgrade on the other site with the MySql version 5.

MySQL Error Occurred

Error Message:

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 'DATABASE `jodier` DEFAULT CHARACTER SET utf8 COLLATE utf8_unico

SQL:

ALTER DATABASE `jodier` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

I am seriously crap at databases and have no idea what I should be looking for and even if I found what and where I would need to change it.

I'd be very grateful for any advice please.

Can someone also tell me what this 'syntax' actually DOES as well - just so I know where things may not be working correctly?

ta

Link to comment
Share on other sites

CubeCart 4 uses UTF-8 character set. MySQL up to 4.0.x version DOES NOT support UTF-8 character set natively, 4.1 and newer versions have built-in support for UTF-8 that is the reason of your issue.

Minimal mySQL version recommended is 4.1.2

Link to comment
Share on other sites

Guest JodieR

Unless you are the server administrator you cant. You will have to contact your host and ask them to do it.

Okay. I will do that. thank you.

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