Guest JodieR Posted May 3, 2008 Share Posted May 3, 2008 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 Quote Link to comment Share on other sites More sharing options...
convict Posted May 4, 2008 Share Posted May 4, 2008 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 Quote Link to comment Share on other sites More sharing options...
Guest JodieR Posted May 4, 2008 Share Posted May 4, 2008 yeah, that's what I was afraid of. How do I upgrade the database though? I so suck at databases :( Quote Link to comment Share on other sites More sharing options...
Guest JodieR Posted May 5, 2008 Share Posted May 5, 2008 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. 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.