Rikc Posted March 29, 2014 Share Posted March 29, 2014 (edited) Hi all, Hope someone can shed abit of light on this for me. I was running 1.4.6.2. version and wanted to upgrade to lastest version, downloaded the latest 1 click installer and it ran and said: Upgrade complete, but warnings has been found. The warnings are SQL Errors this is the first SQL 1.4.7.0 1286 in CREATE TABLE IF NOT EXISTS `ps_order_tax` ( `id_order` int(10) NOT NULL, `tax_name` varchar(40) NOT NULL, `tax_rate` decimal(6,3) NOT NULL, `amount` decimal(20,6) NOT NULL ) ENGINE=_MYSQL_ENGINE_ DEFAULT CHARSET=utf8: SQL 1.4.7.0 1286 in CREATE TABLE IF NOT EXISTS `ps_order_tax` ( `id_order` int(10) NOT NULL, `tax_name` varchar(40) NOT NULL, `tax_rate` decimal(6,3) NOT NULL, `amount` decimal(20,6) NOT NULL ) ENGINE=_MYSQL_ENGINE_ DEFAULT CHARSET=utf8: Unknown table engine '_MYSQL_ENGINE_' '_MYSQL_ENGINE_' is the first looks like the database is missing tables and it cannot add them maybe? lots of these erros for new tables in database maybe? The Database was a backup of the original does it need to have a certain access or anything? I did notice when the backup was added to a fresh database via phpmyadmin it was larger in size compared to original? Just tried to access the shop and im getting 500 Error and not able to login to backoffice, just reloads page have cleared browser settings etc already. Edited March 29, 2014 by Rikc (see edit history) Link to comment Share on other sites More sharing options...
Rikc Posted March 29, 2014 Author Share Posted March 29, 2014 Just put error reporting on and the cause of 500 server error is: ps_shop_url' doesn't exist seems like database did not like upgrading? Link to comment Share on other sites More sharing options...
Rikc Posted March 29, 2014 Author Share Posted March 29, 2014 Ok going to try upgrading from 1.4 to 1.5 then to 1.6 maybe? As the site is a few years old i dont want to loose its urls on search engines etc, is there a way to clean install 1.6 and keep urls and also import customer orders and data? failing this i may just get a new theme for the 1.4 and leave it at that if were going to loose everything Link to comment Share on other sites More sharing options...
Rikc Posted March 31, 2014 Author Share Posted March 31, 2014 Seems like upgrading 1.4.6.2. with core changes and modules is going to be next to imposible ;( I have tried cart2cart to import products to a fresh 1.6 install and seems it will be the way to go. Demo transfered some data to test and looks like its not too bad. Will reinstall 1.6.0.5 and migrate the whole store keeping urls etc and should be good to go i hope! Link to comment Share on other sites More sharing options...
mareksmareks Posted April 2, 2014 Share Posted April 2, 2014 Hi, did you manage to make complete transfer with cart2cart? Link to comment Share on other sites More sharing options...
Rikc Posted April 4, 2014 Author Share Posted April 4, 2014 I have been bait tied up last week plan on completing the migration tomorrow of the products urls etc. I will post to let you know how this goes Link to comment Share on other sites More sharing options...
mareksmareks Posted April 5, 2014 Share Posted April 5, 2014 I tried migrating my quite a bit modified 1.4.9 version to latest 1.6 available and got 404 errors on products, some 500 errors etc. Probably it could be something related with 1.4 modification with removing category and product numbers from links. So my idea was this - migrate with 1-click update to latest version, let it do all the updates. then make complete backup to database (products, orders, clients, etc). After that make a fresh install of latest prestashop 1.6 verion and import old database. This way 1-click update makes necessary changes to databse and with clean shop install you get rid of old sh*t you done with old shop that could break new shop. This is theory, i tried this with my clone website paralelly doing some other things, but it worked. Maybe someone could test this more seriously? Link to comment Share on other sites More sharing options...
tuk66 Posted April 7, 2014 Share Posted April 7, 2014 Your database has not been upgraded correctly. You should check MySQL user rights, PHP timeout as well as memory settings. Link to comment Share on other sites More sharing options...
mareksmareks Posted April 7, 2014 Share Posted April 7, 2014 Your database has not been upgraded correctly. You should check MySQL user rights, PHP timeout as well as memory settings. Hmm, can you some tips on what to start? Link to comment Share on other sites More sharing options...
tuk66 Posted April 7, 2014 Share Posted April 7, 2014 Check User privileges in phpMyAdmin for the user owned PrestaShop database (_DB_USER_). See Memory limit and Max execution time values under Advanced Parameters > Configuration Information. Link to comment Share on other sites More sharing options...
mareksmareks Posted April 7, 2014 Share Posted April 7, 2014 max_execution_time = 30 memory_limit = 128M This info is from php.ini I couldn`t find in phpMyAdmin section with something related to User privileges. Link to comment Share on other sites More sharing options...
tuk66 Posted April 7, 2014 Share Posted April 7, 2014 Probably max_execution_time = 30 is not enough to upgrade your database. I would do it locally with a database backup. Link to comment Share on other sites More sharing options...
mareksmareks Posted April 7, 2014 Share Posted April 7, 2014 Im on VPS, i can change any value it needs. What would you suggest? Link to comment Share on other sites More sharing options...
tuk66 Posted April 7, 2014 Share Posted April 7, 2014 max_execution_time = 600 Link to comment Share on other sites More sharing options...
mareksmareks Posted April 7, 2014 Share Posted April 7, 2014 ok, thanks! I`ll try to make 1-Click update on my clone site again. I will report how it goes. Link to comment Share on other sites More sharing options...
mareksmareks Posted April 7, 2014 Share Posted April 7, 2014 (edited) Nope, it still gives me errors. you can check - romualds.id.lv Click any product, it says The requested URL /product.php was not found on this server. I think it has to be something with override folder and way shop manages product url. In 1.4.9 i followed guide posted here in forums to remove product and category numbers from product links. edit: backoffice works fine, i can see old orders, customers, etc Edited April 7, 2014 by mareksmareks (see edit history) 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