0.7.9RC2 ugrade question

Ok, Just to make sure I could do it properly, I just upgraded from 0.7.9RC1 to RC2.

When I ran  the upgrade.php file it said that both the configuration files where updated successfully and then there is the following message

"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 'UPDATE `setting` SET `value` = '3' WHERE `key`='coupon_sort_order'' at line 2"

I have no idea what this means or what I am supposed to do about it, if anything. The shop and admin seem to be working fine so will it make a difference if i do nothing ?

Thanks
Ian (rincerofwinds)

Thanks
Already addressed in the latest SVN

rincerofwinds wrote: "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 'UPDATE `setting` SET `value` = '3' WHERE `key`='coupon_sort_order'' at line 2"

I have no idea what this means or what I am supposed to do about it, if anything. The shop and admin seem to be working fine so will it make a difference if i do nothing ?

and to answer the question 

Just have a look at the customer coupons list in your store admin. If you can see, edit, delete, add them then there is no problem.

bruce wrote:

rincerofwinds wrote: "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 'UPDATE `setting` SET `value` = '3' WHERE `key`='coupon_sort_order'' at line 2"

I have no idea what this means or what I am supposed to do about it, if anything. The shop and admin seem to be working fine so will it make a difference if i do nothing ?

and to answer the question   :)

Just have a look at the customer coupons list in your store admin. If you can see, edit, delete, add them then there is no problem.

Actually no, the upgrade script actually failed at the first line. Which means it didn't add any of the 5 new sql commands it needs. The error was actually referring to the sort order of the coupon in the calculate modules. So now the sort is wrong, which isn't a big deal. But the rest of the commands were not executed. So you will be hardpressed to get Min Ord Qty to work properly, as well as proper language codes, proper currency coversions, etc.

If you are not planning on using the current SVN version, I would suggest that you open the upgrade.sql file from RC2 and add the missing semi-colon to the end of the first line. Then copy all of the lines and paste them into your sql window in phpmyadmin to ensure all new fields and such are added correctly.

Well I added the missing semi-colon and copied the whole txt into the sql window in phpmyadmin, but it came back with an error

SQL query:

ALTER TABLE `product` ADD `min_qty` int( 4 ) NOT NULL default '1' AFTER `quantity` ;

MySQL said: Documentation
#1060 - Duplicate column name 'min_qty'

Do I not need to copy the last line or is it already there so I dont need to worry about it ?

Thanks
Ian (rincerofwinds)

That means you already have it. Did you install RC1 then upgrade to RC2? if so, then you probably don't have to worry about it. Only if you were upgrading from 0.7.8 would it be an issue.

So you are probably ok.

c'est la vie