Upgrade from 2.5.1 - 2.5.2 Error

[ALElder]

1054 - Unknown column 'slideshow_active' in 'field list'

select slideshow_id, slideshow_image, slideshow_title, slideshow_sort_order, slideshow_link, slideshow_target, slideshow_active, slideshow_cg_hide, date_added, last_modified from slideshow order by slideshow_sort_order limit 0, 20

[TEP STOP]


Any thoughts on correcting the above issue.

Adam

[ALElder]

This is an easy fix the upgrade script didn't add to fields to TABLE_SLIDESHOW you will just need to add the following.

slideshow_active varchar(3) NOT NULL,
slideshow_cg_hide varchar(255) NOT NULL,


Please update the upgrade script.

Thanks,


Adam

[freeman78]

Also missing from the upgrade script the fields to add to the TABLE orders :
delivery_date DATETIME NOT NULL,

[ALElder]

Good call

Thanks

[ALElder]

Good call

Thanks

[dieter]

Also missing from the upgrade script the fields to add to the TABLE orders :
delivery_date DATETIME NOT NULL,

In 2.5.1_to2.5.2.sql

Replace

ALTER TABLE `orders`
ADD COLUMN `delivery_date` DATETIME NOT NULL after `address_format_id`;

With

ALTER TABLE `orders`
ADD COLUMN `delivery_date` DATETIME NOT NULL after `customers_address_format_id`;

Dieter

[craige]

Hi
How can you execute the upgrade script again. In the Administrator /upgrade system it says I already upgraded which I have.

I am not very DB savvy so if sone one could put what needs to be done into a .sql file and I can apply it VIA MYSQL admin for the slider bit.

Thanks

Craig

[michael_s]

Thanks for the quick reports on this. The fixes have been applied and both DL packages have corrected the upgrade problems.

[craige]

Thanks for the quick reports on this. The fixes have been applied and both DL packages have corrected the upgrade problems.

Thanks for the quick action. I have put all the new files on the server.

But under Administrator / Upgrade System it says the version is already updated to 2.5.2.

How can I rerun the upgrade script again to initiate the new changes.?

[celeroncillo]

Hi, I upgrade it (after fix the DL by michael_s) and now if I have enable the Slideshow show this message.


1054 - Unknown column 'slideshow_cg_hide' in 'where clause'

select slideshow_image from slideshow where NOT find_in_set('0', slideshow_cg_hide) and slideshow_active = 'yes' order by slideshow_sort_order


My upgrade Steps is: Overwrite all files, acces to admin and click in Administrator / Upgrade System).

Thanks