Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

4.7.1 Upgrade Locked Out - Unknown Column 'cscart_Statuses.position' In 'order Clause' Rate Topic   - - - - -

 
  • grafis
  • Junior Member
  • Members
  • Join Date: 12-Jan 11
  • 150 posts

Posted 06 January 2018 - 03:35 PM #1

Upgraded to 4.7.1 and error was returned - now locked out of admin. Any help appreciated!

 

Error shown on Store Closed / Service Unavailable page:
 

Tygh\Exceptions\AException
Unknown column 'cscart_statuses.position' in 'order clause' (1054)SELECT cscart_statuses.*, cscart_status_descriptions.* FROM cscart_statuses LEFT JOIN cscart_status_descriptions ON cscart_status_descriptions.status_id = cscart_statuses.status_id AND cscart_status_descriptions.lang_code = 'en' WHERE 1 = 1 AND cscart_statuses.type = 'O' ORDER BY cscart_statuses.position asc


CS-Cart 4.7.1


 
  • grafis
  • Junior Member
  • Members
  • Join Date: 12-Jan 11
  • 150 posts

Posted 06 January 2018 - 04:37 PM #2

Fixed it after some hacking based on this forum thread and comments by the #CS-Cart-Team Moderators

ALTER TABLE `cscart_statuses` ADD `position` MEDIUMINT(8) NOT NULL;

CS-Cart 4.7.1