CMS MADE SIMPLE FORGE

Showtime Module

 
Back Back to List

[#10155] Error showing up when saving a show after latest update

avatar
Created By: Dean Demetria (atomrev)
Date Submitted: Wed Aug 13 03:25:51 -0400 2014

Assigned To: Peter (Pedrosken)
Version: Showtime-3.4
CMSMS Version: None
Severity: Major
Resolution: Fixed
State: Open
Summary:
Error showing up when saving a show after latest update
Detailed Description:
I tried to update the module and update some shows, but an error comes up with 
"Unknown column 'st_sizing' in 'field list'".

I have updated the Showtime Slideshow to 3.4 on the CMS 1.10.3, so there must
have been some incompatibility issues there. Now, I cannot save any slideshow,
nor make changes to the settings.


History

Comments
avatar 
Date: 2014-08-15 06:30
Posted By: Martin Poettgen (map_1961)

Hi all.

I just updated a dev site to 1.11.11 and also updated showtime to 3.4. I also
receive this error message:
"Unknown column 'st_sizing' in 'field list'".

Thx 4 fix

map_1961
avatar 
Date: 2014-08-15 06:44
Posted By: Dean Demetria (atomrev)

It works now. After upgrading, I had to uninstall and reinstall the module
again. The only problem with this is that it deleted my slideshows (I had to
recreate 30 slideshows), but at least it's working fine now. :)

Would be great if someone could look into this upgrade issue. :)
avatar 
Date: 2015-01-30 07:57
Posted By: Sander Hartveld (sanderhartveld)

I have the same error: 

Error _updateshow: Unknown column 'st_sizing' in 'field list' 

I will make a backup of my shows and try to reinstall the module.
Showtime 3.4 on cmsms 1.11.11
avatar 
Date: 2015-01-30 08:18
Posted By: Sander Hartveld (sanderhartveld)

In phpMyAdmin I added collumn named st_sizing char(20) to table
cms_module_showtime_name. That helps.
No need to uninstall and reinstall.
avatar 
Date: 2015-01-30 08:41
Posted By: Sander Hartveld (sanderhartveld)

the correct sql query to solve this bug is:

ALTER TABLE  `cms_module_showtime_name` ADD  `st_sizing` VARCHAR( 20 ) NULL
DEFAULT NULL
Updates

Updated: 2014-08-15 06:44
resolution_id: 5 => 7
severity_id: 1 => 2

Updated: 2014-08-13 03:27
description: I have updated the Showtime Slideshow to 3.4 on the CMS 1.10.3, so there must have been some incompatibility issues there. Now, I cannot save any slideshow, nor make changes to the settings. => I tried to update the module and update some shows, but an error comes up with "Unknown column 'st_sizing' in 'field list'". I have updated the Showtime Slideshow to 3.4 on the CMS 1.10.3, so there must have been some incompatibility issues there. Now
summary: Error showing up after update "Unknown column 'st_sizing' in 'field list'" => Error showing up when saving a show after latest update
resolution_id: => 5