alvinouch Posted April 18, 2013 Share Posted April 18, 2013 Hi everyone, thanks for reading this, here's my issue : I changed the location of my shop to go on prod today, changing the BASE_URL didn't work and kinda broke the shop but i think it came from the server or own mistake. Anyway, i decided to do a fresh install of the new version, and import the older database (PS 1.5.3) in the new one (PS 1.5.4) . Everything worked, i got back my pictures, my conf, my products etc... but the shop doesn't seem to 'communicate' with the database(i can't add products to cart [nothing happens], i can't create new account, can't login to a customer account [authentication fails]) The weird thing is that everything works, as if all the SELECT this were right, but every other operations like INSERT were not. I searched and didn't find an answer to that :/ Does anybody know if i missed something ? if there is a field to change in the DB, or something to configure inside the BO ? This is my first prestashop so i'm not familiar with all the connections in the database, can anybody help ? Thank you in advance, Link to comment Share on other sites More sharing options...
benjamin utterback Posted April 18, 2013 Share Posted April 18, 2013 Hi alvin, I'm not sure exactly how to solve the problem...However, i think you should import the 1.5.3 database into a 1.5.3 installation. From there, you can upgrade if you want. Link to comment Share on other sites More sharing options...
alvinouch Posted April 18, 2013 Author Share Posted April 18, 2013 Thanks for the reply, i'll try this evening to reinstall the 1.5.3 version (the upgrade doesn't really matter) Link to comment Share on other sites More sharing options...
benjamin utterback Posted April 18, 2013 Share Posted April 18, 2013 Okay, that sounds good. Keep us posted and I'll keep an eye on this thread. Thank you for choosing PrestaShop! Link to comment Share on other sites More sharing options...
alvinouch Posted April 18, 2013 Author Share Posted April 18, 2013 Ok so i thought that database coherence stayed between 'minor' update like 1.5.3 to 1.5.4, and changed only from major versions like 1.4 to 1.5. It appears that some tables are missing in 1.5.4 (like ps_alias, and i thought it would give me an error while trying to import a different version of the DB). So, I reinstalled PS 1.5.3 and reimported my DB, it works Next step, upgrade to 1.5.4 Anyway, thanks for the reply Link to comment Share on other sites More sharing options...
benjamin utterback Posted April 18, 2013 Share Posted April 18, 2013 No Problem, Alvin, I'm glad I could help. Yes, there are still minor database changes that can occur between versions. Happy Selling! Link to comment Share on other sites More sharing options...
pnova Posted April 19, 2013 Share Posted April 19, 2013 -First of all, I tried to install 1.5.4.0 but Product images aren't uploading and displaying while Categories images are. -On the other hand, I could try to go back to my previous installation but keep showing SQL Bad Request. Any help? Link to comment Share on other sites More sharing options...
benjamin utterback Posted April 19, 2013 Share Posted April 19, 2013 Hi pnova, welcome to the forum. You tried to install or upgrade? Link to comment Share on other sites More sharing options...
pnova Posted April 19, 2013 Share Posted April 19, 2013 Thanks! First, I tried to Upgrade and had error 28 so I tried a new installation but can't upload product images. So I thought the last option was to use my previous version and it's when I get the SQL bad request. Any solution? Link to comment Share on other sites More sharing options...
benjamin utterback Posted April 19, 2013 Share Posted April 19, 2013 Hi pnova, just use your backup you created before you Upgraded your store. That is pretty much foolproof. Link to comment Share on other sites More sharing options...
pnova Posted April 19, 2013 Share Posted April 19, 2013 The fact is that I'm using the back Up but it keeps showing the sql bad request, I took a look on the settings.inc.php and my db user, db password and db server are OK. Should I do anything with the COOKIE_KEY_ and COOKIE_IV? Please help!!! :-( Link to comment Share on other sites More sharing options...
pnova Posted April 21, 2013 Share Posted April 21, 2013 Ok I'm back to my previous installation and upgraded succesfully to PrestaShop 1.4.10.0. Now I have the same problem that made me want to upgrade to the last version. Invalid date error when I try to see some orders. Don't know what to do. Please help!! :-( 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