drmad Posted February 27, 2011 Share Posted February 27, 2011 Error while inserting data in the database:'/* Timezone */ INSERT INTO `ps2_timezone` (`name`) VALUES (\'Africa/Abidjan\'),(\'Africa/Accra\'),(\'Africa/Addis_Ababa\'),(\'Africa/Algiers\'), (\'Africa/Asmara\'),(\'Africa/Asmera\'),(\'Africa/Bamako\'),(\'Africa/Bangui\'),(\'Africa/Banjul\'),(\'Africa/Bissau\'),(\'Africa/Blantyre\'), (\'Africa/Brazzaville\'),(\'Africa/Bujumbura\'),(\'Africa/Cairo\'),(\'Africa/Casablanca\'),(\'Africa/Ceuta\'),(\'Africa/Conakry\'),(\'Africa/Dakar\'), (\'Africa/Dar_es_Salaam\'),(\'Africa/Djibouti\'),(\'Africa/Douala\'),(\'Africa/El_Aaiun\'),(\'Africa/Freetown\'),(\'Africa/Gaborone\'),(\'Africa/Harare\'), (\'Africa/(it goes on and on)(\'Etc/Greenwic UPDATE `ps2_customer` SET `passwd` = \'3cbf6ce91b589df25b90d4cbd6e060bb\' WHERE `id_customer` =1'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 \'3cbf6ce91b589df25b90d4cbd6e060bb\' WHERE `id_customer` =1\' at line 74(Error: : 1064)--------I'm not sure what is the problem. The DB_USER has the right privileges. The charset is defined to utf8_general_ci (or something like that).Does anyone know what is going on?Tks in advance---------------Edit solved. Not sure what it was. I tried to install earlier version and it was ok. So I deleted everything, drop the tables of the DB and installed RC5 again. Everything fine. Probably an error uploading a file... Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now