Jump to content

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

Upgrade From 4.9.2.sp3 To 4.9.2.sp4 Rate Topic   - - - - -

 
  • vanderex
  • Senior Member
  • Members
  • Join Date: 27-May 10
  • 386 posts

Posted 31 May 2019 - 09:50 PM #1

Validation issue

Validator "0" returned fail status

File Table 'cs.cscart_lock_keys' doesn't exist in engine (1932)

SHOW CREATE TABLE cscart_lock_keys

 


Get Cost Effective Content Delivery CDN
Unbeatable speed, stats, & price
MaxCDN Site Acceleration

 
  • The Tool
  • Been Here Way Too Long Member
  • Members
  • Join Date: 30-Mar 07
  • 3800 posts

Posted 01 June 2019 - 12:51 PM #2

Looks like the table didn't update during previous updates.  Run the following queries:

CREATE TABLE `cscart_lock_keys` (
  `key_id` varchar(64) NOT NULL,
  `token` varchar(64) NOT NULL,
  `expiry_at` int(11) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `cscart_lock_keys`
  ADD PRIMARY KEY (`key_id`);
COMMIT;


 
  • vanderex
  • Senior Member
  • Members
  • Join Date: 27-May 10
  • 386 posts

Posted 02 June 2019 - 02:14 PM #3

#1050 - Table 'cscart_lock_keys' already exists


Get Cost Effective Content Delivery CDN
Unbeatable speed, stats, & price
MaxCDN Site Acceleration

 
  • The Tool
  • Been Here Way Too Long Member
  • Members
  • Join Date: 30-Mar 07
  • 3800 posts

Posted 03 June 2019 - 10:01 AM #4

I just realized that the table referenced in you original post contains a "cs." prefix.  If this is how your tables are set up then rename the table cscart_lock_keys to cs.cscart_lock_keys.