Jump to content

Upgrade fail

trident
 Share

Recommended Posts

trident Newbie

trident

Posted
Posted

So far i have failed miserably to manage the upgrade to V1.2 or above.
Crashed the site 3 times trying on V1.2
Now tried on 2 different 'pooters running Wamp to get a local set up upgraded to V1.2.1 Won't have it. System just seems to freeze/lock upat stage 3.

It saddens me to say it but this is now getting beyond the point of worrying. Far too many hours are taken up on what should be straightforward procedures.

Any suggestions anybody?

Link to comment
Share on other sites
webdevguy Newbie

webdevguy

Posted
Posted

Not much better for me. I should have looked at what others said about this upgrade. My site still isn't good and I'd almost pay for a not-so-nice ecommerce than to mess with this forever.

Try looking at some of the topics about upgrading in the Installation and Upgrading section of this forum. Several errors are discussed (and a couple fixed!) there.

Link to comment
Share on other sites
Patric Newbie

Patric

Posted
Posted
So far i have failed miserably to manage the upgrade to V1.2 or above.
Crashed the site 3 times trying on V1.2
Now tried on 2 different 'pooters running Wamp to get a local set up upgraded to V1.2.1 Won't have it. System just seems to freeze/lock upat stage 3.

It saddens me to say it but this is now getting beyond the point of worrying. Far too many hours are taken up on what should be straightforward procedures.

Any suggestions anybody?


could you give more details ? Which problem occurs on step 3 ?

Is the database connection successful ? Is there any error in the firebug console when you click "Next" ?
Link to comment
Share on other sites
trident Newbie

trident

Posted
  • Author
Posted

Hi Patric,
Same problem many others appear to be finding.
Enter the shop details, press confi etc then just the continuous candy bar. eventually manually stop the process, all appears ok but when you run the shop the errors then appear. It fails to convert the database correctly. The problem occurs on both a Vista machine and a XP machine. The database conversion is not consistent either. Different tables are dropped at each attempt.

Link to comment
Share on other sites
platacelta.com Newbie

platacelta.com

Posted
Posted

I get this error on front:
"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 ')) > 0 AS new, (p.price - IF((DATEDIFF(reduction_from, CURDATE()) <= 0 AND ' at line 1

SELECT p.*, pa.`id_product_attribute`, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, i.`id_image`, il.`legend`, m.`name` AS manufacturer_name, tl.`name` AS tax_name, t.`rate`, cl.`name` AS category_default, DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL DAY)) > 0 AS new,
(p.price - IF((DATEDIFF(reduction_from, CURDATE()) <= 0 AND DATEDIFF(reduction_to, CURDATE()) >=0) OR reduction_from = reduction_to, IFNULL(reduction_price, (p.price * reduction_percent / 100)),0)) AS orderprice
FROM `ps2_category_product` cp
LEFT JOIN `ps2_product` p ON p.`id_product` = cp.`id_product`
LEFT JOIN `ps2_product_attribute` pa ON (p.`id_product` = pa.`id_product` AND default_on = 1)
LEFT JOIN `ps2_category_lang` cl ON (p.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 3)
LEFT JOIN `ps2_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 3)
LEFT JOIN `ps2_image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = 1)
LEFT JOIN `ps2_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
LEFT JOIN `ps2_tax` t ON t.`id_tax` = p.`id_tax`
LEFT JOIN `ps2_tax_lang` tl ON (t.`id_tax` = tl.`id_tax` AND tl.`id_lang` = 3)
LEFT JOIN `ps2_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE cp.`id_category` = 1 AND p.`active` = 1
ORDER BY p.`date_add` DESC
LIMIT 0,10"

What's wrong?

Thanks

Link to comment
Share on other sites
peej Newbie

peej

Posted
Posted
Hi Patric,
Same problem many others appear to be finding.
Enter the shop details, press confi etc then just the continuous candy bar. eventually manually stop the process, all appears ok but when you run the shop the errors then appear. It fails to convert the database correctly. The problem occurs on both a Vista machine and a XP machine. The database conversion is not consistent either. Different tables are dropped at each attempt.


I'm having the same problem. On my test-site a was able to upgrade from 1.1 to 1.2.0.8 and later from 1.2.0.8 to 1.2.1.0. When trying to upgrade my prod-site directly from 1.1 to 1.2.1.0 it stops when converting the db.

I will try to restore my db and then upgrade one version at the time....

//PJ
Link to comment
Share on other sites
peej Newbie

peej

Posted
Posted
Hi Patric,
Same problem many others appear to be finding.
Enter the shop details, press confi etc then just the continuous candy bar. eventually manually stop the process, all appears ok but when you run the shop the errors then appear. It fails to convert the database correctly. The problem occurs on both a Vista machine and a XP machine. The database conversion is not consistent either. Different tables are dropped at each attempt.


I'm having the same problem. On my test-site a was able to upgrade from 1.1 to 1.2.0.8 and later from 1.2.0.8 to 1.2.1.0. When trying to upgrade my prod-site directly from 1.1 to 1.2.1.0 it stops when converting the db.

I will try to restore my db and then upgrade one version at the time....

//PJ


The upgrade was a success! I had to first upgrade to 1.2.0.8 and then to 1.2.1.0. I'm not sure if there are any changes to the database between the two version, but I did the update anyway.

//PJ
Link to comment
Share on other sites
trident Newbie

trident

Posted
  • Author
Posted

Unfortanetely it didn't work for me.
Tried a fresh install of 1.2.0.8 on local machine using a known good copy of the database. Each time it converts it results in sql errors.
Seem to be moving backwards rather than forwards now.

Link to comment
Share on other sites
rudders18 Newbie

rudders18

Posted
Posted

Hi,
I have a working site running version 1.2.0.2 and have been experimenting locally with an upgrade to 1.2.1.0 and had many errors until I found the following.

It appears that for some reason the upgrade option was not running the upgrade sql files to change the DB from 1.2.0.2 format to 1.2.1.0 format, if I run them manually using phpmyadmin it cures the errors. You do have to modify the sql files to change PREFIX_ to what ever value you have as a table prefix in your DB.

Upgrading from 1.2.0.8 does not seem to have this problem, I have not tried all combinations.

Secondly I found that after the upgrade anything AJAX based such as the category or cart modules did not work until I uninstalled the search module in BO, at that point I seemd to have a working local shop running version 1.2.1.0.

A key component of your setup that also has a major impact on the working of your shop is the version of PHP you are running, I am using 5.2.9 both locally via XAMPP and with my web host.

I still have a lot of testing to do but it looks good so far.

Hope this helps someone

Regards

Link to comment
Share on other sites
bprado Newbie

bprado

Posted
Posted
So far i have failed miserably to manage the upgrade to V1.2 or above.
Crashed the site 3 times trying on V1.2
Now tried on 2 different 'pooters running Wamp to get a local set up upgraded to V1.2.1 Won't have it. System just seems to freeze/lock upat stage 3.

It saddens me to say it but this is now getting beyond the point of worrying. Far too many hours are taken up on what should be straightforward procedures.

Any suggestions anybody?


could you give more details ? Which problem occurs on step 3 ?

Is the database connection successful ? Is there any error in the firebug console when you click "Next" ?


Patric Codron this is the error i get using Firebug when trying to upgrade from 1.1.0.5 to 1.2.1.0

uncaught exception: [Exception... "Could not convert JavaScript argument arg 0" nsresult: "0x80570009 (NS_ERROR_XPC_BAD_CONVERT_JS)" location: "JS frame :: http://www.mysite.com/store_new/js/jquery/jquery-1.2.6.pack.js :: anonymous :: line 11" data: no]

Using the IE 8.0 i get this error:

Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.0; WOW64; Trident/4.0; SLCC1; .NET CLR 2.0.50727; InfoPath.2; .NET CLR 3.5.30729; Media Center PC 5.0; OfficeLiveConnector.1.3; OfficeLivePatch.0.0; .NET CLR 3.0.30729)
Timestamp: Mon, 17 Aug 2009 12:31:05 UTC


Message: No such interface supported

Line: 751
Char: 4
Code: 0
URI: http://www.mysite.com/store_new/install/controller.js
Link to comment
Share on other sites
  • 3 weeks later...

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing
×
×
  • Create New...