JerseyG Posted August 16, 2013 Share Posted August 16, 2013 (edited) Hi I have just tried an upgrade on my test server from 1.5.2 to 1.5.4.1 using the 1 - step upgrade from a local directory. Apart from a slight cosmetic error on the layout all looks good and it has cured a couple of problem I have already raised posts about. Unfortunately the cart does not work. item moves to cart but cart remains empty. I have tried non ajax and re installing modules but nothing has worked. On the upgrade I did receive warnings but when looking up on the web I don't see any help except for possibly ignoring them.... To people who have already given me advice on sql you will know it is a "dark art" to me so please give me very bacis instructions. I have my own servers so I can log on to run any script. Server information Server information: Windows NT build 6002 (Windows Server 2008 Standard Edition Service Pack 2) i586 Server software version: Microsoft-IIS/7.0 PHP version: 5.3.8 Memory limit: 128M Max execution time: 1000 Database information MySQL version: 5.5.15 MySQL engine: InnoDB Tables prefix: ps_ Store information Prestashop version: 1.5.2.0 Error on upgrade:- [ERROR] SQL 1.5.3.0 1265 in ALTER TABLE `ps_cart` CHANGE `delivery_option` `delivery_option` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL: Data truncated for column 'delivery_option' at row 1 [ERROR] SQL 1.5.3.1 1265 in ALTER TABLE `ps_cart` CHANGE `delivery_option` `delivery_option` TEXT NOT NULL: Data truncated for column 'delivery_option' at row 1 Warning detected during upgrade. Thanks in advance G Edited August 19, 2013 by JerseyG (see edit history) Link to comment Share on other sites More sharing options...
NemoPS Posted August 16, 2013 Share Posted August 16, 2013 Hi! Is it possible to see the live site? Also, is it working if you disable the ajax cart? Link to comment Share on other sites More sharing options...
JerseyG Posted August 16, 2013 Author Share Posted August 16, 2013 Hi Nemo1 Thank you for your prompt help. I have a spare set of servers that I test my items on before I do any work on my live server. Saves a lot of tears.... my working site is www.firstplacetogo.co.uk it is almost a pure default site. Works well for my situation. I have tried disabling ajax cart without success. As we speak I have just wiped and re installed my test server from last backup and trying to upgrade again after manually deleting cache in the cache folder and the theme folder. What are your thoughts on the database errors? G Link to comment Share on other sites More sharing options...
NemoPS Posted August 16, 2013 Share Posted August 16, 2013 hmm, can you try checking the current datatype for that column? Link to comment Share on other sites More sharing options...
JerseyG Posted August 16, 2013 Author Share Posted August 16, 2013 Ok Nemo1 I can build you a windows server with exchange and many other things. SQL is a "dark art" to me and I have no confidence with it or knowledge of it. When I go into the console what am i looking for? An idiots guide will not offend :-) G Link to comment Share on other sites More sharing options...
NemoPS Posted August 16, 2013 Share Posted August 16, 2013 No worries, I mean this one Where it says 'type' Just login to phpmyadmin, click on that table and then on 'structure' at the top Link to comment Share on other sites More sharing options...
JerseyG Posted August 16, 2013 Author Share Posted August 16, 2013 Hi Nemo1 Sorry for delay. Hope the attached file is the one you were looking for. Geoff Link to comment Share on other sites More sharing options...
NemoPS Posted August 16, 2013 Share Posted August 16, 2013 uh... nope, you must click on your prestashop database, then on the ps_cart table Link to comment Share on other sites More sharing options...
JerseyG Posted August 16, 2013 Author Share Posted August 16, 2013 Hi Nemo1 See I did not lie about my ability with database work... Link to comment Share on other sites More sharing options...
JerseyG Posted August 16, 2013 Author Share Posted August 16, 2013 Hi Nemo1 Good news. My latest attempt at an upgrade worked. Same database errors reported but the cart worked. I am just restoring my server back to the last backup and I will try again by deleting the cache manually in both the cache folder and the default theme folder. Once i have done this three times I will be confident that I could upgrade the main server over the weekend. That is if we have the answer to the database errors. Kind Regards G Link to comment Share on other sites More sharing options...
NemoPS Posted August 16, 2013 Share Posted August 16, 2013 well, you can manually change the delivery option type to text even if you have that error, just do it afterwards, it should be okay anyway Link to comment Share on other sites More sharing options...
JerseyG Posted August 16, 2013 Author Share Posted August 16, 2013 Hi Nemo1 Just come away from my other server, upgrade looks fine and cart works. Looks like clearing the cache in the default theme was my answer. However a bit of gloom. The last two upgrades have given me an extra line fault for some reason. Looking at my database product_sqlstock does not exist, should I be worried? If not then I will mark this as solved and let you get on with your life and prepare for the weekend. Thanks again G [ERROR] SQL 1.5.3.0 1265 in ALTER TABLE `ps_cart` CHANGE `delivery_option` `delivery_option` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL: Data truncated for column 'delivery_option' at row 1 [ERROR] SQL 1.5.3.1 1265 in ALTER TABLE `ps_cart` CHANGE `delivery_option` `delivery_option` TEXT NOT NULL: Data truncated for column 'delivery_option' at row 1 [ERROR] PHP 1.5.4.0 /* PHP:p1540_add_missing_columns(); */ 1 - Can't DROP 'product_sqlstock'; check that column/key exists Warning detected during upgrade. Link to comment Share on other sites More sharing options...
JerseyG Posted August 19, 2013 Author Share Posted August 19, 2013 First of all thanks To Nemo1 for his assistance, and being patient with my lack of knowledge on the "Database" I have tested out 8 upgrades now on my Test server. I have deleted the cache content manually in the root and theme folders. All have worked (except for the database error above) without a problem with the cart. the 2 upgraded I tried without deleting the cache failed as the cart did not work. G Link to comment Share on other sites More sharing options...
jimmyc Posted August 28, 2013 Share Posted August 28, 2013 [ERROR] PHP 1.5.4.0 /* PHP:p1540_add_missing_columns(); */ 1 - Can't DROP 'product_sqlstock'; check that column/key exists Warning detected during upgrade. got the same message now accessing the customer service page seems to crash the server??? Link to comment Share on other sites More sharing options...
JerseyG Posted August 28, 2013 Author Share Posted August 28, 2013 Hi Jimmyc Just to confirm that my live server upgraded fine. I did 8 tests and then the live server, all the upgrade gave that error but none failed. I think clearing the cache manually was the trick as the structure changes with V 1.5.4.1 Sorry that I cannot help on this one. G Link to comment Share on other sites More sharing options...
jimmyc Posted August 28, 2013 Share Posted August 28, 2013 Ok thanks for the response though. Much appreciated. Will have to delve further. Link to comment Share on other sites More sharing options...
Recommended Posts