OSCA2M Posted June 6, 2010 Share Posted June 6, 2010 I attempted an upgrade to 1.3 previously but had problems with the database so rolled back to 1.2.5.It seems that a number of tables were modified on the most recent releases.I compared the databases with :http://www.addictivetips.com/windows-tips/compare-two-mysql-database-with-mysql-structure-compare/Is there a way to export the products from prestashop?The tricky part is all the attribute tables.Can anyone suggest how to solve this?All suggestions appreciated! Link to comment Share on other sites More sharing options...
rocky Posted June 6, 2010 Share Posted June 6, 2010 I think the issues most people are having with upgrades are because PrestaShop has added many indexes to database tables in PrestaShop v1.3 to improve performance. Unfortunately, if there are any duplicate rows in any of these tables, the installation will fail. I've already posted a bug report asking PrestaShop to check for these errors and remove duplicate rows to prevent the upgrade from failing. I'm still waiting for a response.I'm pretty sure that the product and attributes tables are the same in PrestaShop v1.2.5 and v1.3, so it should be safe to export the product and attribute tables and import them into a clean install of PrestaShop v1.3. Link to comment Share on other sites More sharing options...
OSCA2M Posted June 7, 2010 Author Share Posted June 7, 2010 Interesting, please keep me posted. The problem with exporting the product tables and attributes is that it doesn't move over the CMS and all the custom meta tags or other manual process that have to be setup.There should be a simple way to move from one presta to another. How will people do it moving forward? I'm surprised they didn't create a .sql that could be executed. (the software I used did, but I had a hard time getting it to execute.) Link to comment Share on other sites More sharing options...
rocky Posted June 7, 2010 Share Posted June 7, 2010 They do provide upgrade SQL files in install/sql/upgrade, but running them directly won't work, since they include calls to PHP functions in the installer. You must run the installer to upgrade your database, but that doesn't automatically upgrade PrestaShop's files, of course. You must do that manually, which is what many people seem to be having trouble with for some reason. I didn't encounter any problems upgrading my PrestaShop v1.2.5 site to PrestaShop v1.3. Link to comment Share on other sites More sharing options...
OSCA2M Posted June 8, 2010 Author Share Posted June 8, 2010 The problem I encountered is when you enter the database information.You can not get past that screen because it says the database already exists and to change the Name or Prefix.Neither solves the problem.So you can't get further down the install process.Any suggestions? Link to comment Share on other sites More sharing options...
rocky Posted June 8, 2010 Share Posted June 8, 2010 You must have chosen the "Install" option rather than the "Update" option. You can do a clean install using a different prefix, or upgrade your existing PrestaShop v1.2.5 database to PrestaShop v1.3 using the "Update" option. It will read your config/settings.inc.php file and use the details in there. Link to comment Share on other sites More sharing options...
OSCA2M Posted June 8, 2010 Author Share Posted June 8, 2010 Thanks for that TIP!I did not know it was there.In order to activate the function you have to modify the version number.Then it allows the option. THANKS AGAIN! Link to comment Share on other sites More sharing options...
makaraci Posted June 20, 2010 Share Posted June 20, 2010 I think the issues most people are having with upgrades are because PrestaShop has added many indexes to database tables in PrestaShop v1.3 to improve performance. Unfortunately, if there are any duplicate rows in any of these tables, the installation will fail. I've already posted a bug report asking PrestaShop to check for these errors and remove duplicate rows to prevent the upgrade from failing. I'm still waiting for a response.I'm pretty sure that the product and attributes tables are the same in PrestaShop v1.2.5 and v1.3, so it should be safe to export the product and attribute tables and import them into a clean install of PrestaShop v1.3. I got same errors : Duplicaterows The process of Updating was waste of time for me.The biggest fault of presta is almost impossibilty of update Link to comment Share on other sites More sharing options...
joedenoble Posted August 2, 2010 Share Posted August 2, 2010 it will allow you to udate but you need to delete the file config/settings.inc.php uploaded and then send your old one in as it will not let you just replace it.Then it will work Link to comment Share on other sites More sharing options...
tekneto Posted August 16, 2010 Share Posted August 16, 2010 Does anyone know how to find the duplicate tables once you've done the upgrade? Once you find them how do you know which ones to delete? This might be good to know when someone gets mysql errors when updating. Thanks. Link to comment Share on other sites More sharing options...
rocky Posted August 16, 2010 Share Posted August 16, 2010 When you perform the upgrade, you should get an SQL error log. In that log, you can see the SQL queries and errors caused by duplicate rows. Using that, you can figure out which tables need to have duplicate rows remove, then remove them using phpMyAdmin, then manually re-run the SQL query that caused the error.Unfortunately, if you didn't copy that log, there is no way to access it. You'll have a hybrid v1.2.5/v1.3.1 database that won't function correctly. In that case, it is best to restore a backup of your v1.2.5 database and upgrade your site again so that you can get the SQL error log. If you didn't back up your v1.2.5 database, you're out of luck. The PrestaShop installer can only upgrade from a v1.2.5 database to a v1.3.1 database and not from a hybrid v1.2.5/v1.3.1 database. Link to comment Share on other sites More sharing options...
tekneto Posted August 16, 2010 Share Posted August 16, 2010 Well this update was from 1.1 to 1.3 and it came up with 156 SQL errors. I did copy it this time. Isn't that a bit excessive for an update? So from here just delete the new duplicate or the old? Link to comment Share on other sites More sharing options...
rocky Posted August 16, 2010 Share Posted August 16, 2010 Post the error log here and I'll have a look at the error messages. Link to comment Share on other sites More sharing options...
tekneto Posted August 16, 2010 Share Posted August 16, 2010 Well I tried something else which I haven't read much about but let me know if you think this would work. I did a clean install of 1.3. I then went into phpmyadmin and imported my 1.1 backed up database into the clean 1.3 database. It appears all the products and categories transferred and it's working. Could this be an alternate way of updating minus all the sql errors from my last attempt? Or will there be unforseen issues later? Thanks. Link to comment Share on other sites More sharing options...
tekneto Posted August 16, 2010 Share Posted August 16, 2010 So has anyone tried the method above? Link to comment Share on other sites More sharing options...
cammo Posted August 19, 2010 Share Posted August 19, 2010 I'm interested to know also?.. Looking for a way to upgrade without directly affecting the store. A parallel installation would be ideal rather than scratching my head with upgrade errors.. Link to comment Share on other sites More sharing options...
tekneto Posted August 30, 2010 Share Posted August 30, 2010 Well according to Rocky yes it should work. So far I've updated using this method and no problems so far. I think it would be a good idea for the developers of Prestashop to mention alternative ways of updating since it's such a hassle. Just my 2 cents. 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