Jump to content

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

Update problem! site short down Rate Topic   - - - - -

  • qrsystems
  • Junior Member
  • Members
  • Join Date: 09-Oct 08
  • 7 posts

Posted 30 November 2009 - 07:02 PM #1

Can somebody help me, i got the following error while i was updating to the leatest version from the Admin section;

" Database error: Table 'qrscomputers20.cscart_usergroup_links' doesn't exist (1146)
Invalid query: SELECT link_id, usergroup_id, status FROM cscart_usergroup_links WHERE user_id = 1


Backtrace: File: /home/content/q/r/s/qrscomputers/html/core/fn.database.php
Line: 310
Function: db_error
File: /home/content/q/r/s/qrscomputers/html/core/fn.database.php
Line: 70
Function: db_query
File: /home/content/q/r/s/qrscomputers/html/controllers/common/auth.php
Line: 268
Function: db_get_hash_array
File: /home/content/q/r/s/qrscomputers/html/controllers/common/auth.php
Line: 38
Function: fn_auth_routines
File: /home/content/q/r/s/qrscomputers/html/core/fn.control.php
Line: 487
Function: include
File: /home/content/q/r/s/qrscomputers/html/core/fn.control.php
Line: 352
Function: fn_run_controller
File: /home/content/q/r/s/qrscomputers/html/admin.php
Line: 27
Function: fn_dispatch"

The error shows up immediately i logged on, nothing works now.
Anybody have similar problem?
Thanks for your help.


Posted 30 November 2009 - 07:36 PM #2


Performance & Styling Auto Parts
CS-Cart v4.5.2


Posted 09 December 2009 - 01:41 AM #3

If your DB still has the 'membership' tables, try:

CREATE TABLE `cscart_usergroup_links` (
  `link_id` mediumint(8) unsigned NOT NULL auto_increment,
  `user_id` mediumint(8) unsigned NOT NULL default '0',
  `usergroup_id` mediumint(8) unsigned NOT NULL default '0',
  `status` char(1) NOT NULL default 'A',
  PRIMARY KEY  (`link_id`),
  UNIQUE KEY `user_id` (`user_id`,`usergroup_id`)


Rename cscart_memberships to cscart_usergroups, rename its membership_id to usergroup_id

Rename cscart_membership_descriptions to cscart_usergroups_descriptions, rename membership_id to usergroup_id, rename membership to usergroup

Rename cscart_membership_privileges to cscart_usergroups_privileges, rename membership_id to usergroup_id

I just upgraded from 1.3.5sp4 to 2.0.10, and a lot of the tables are missing, or have old tablenames or have old fieldnames in the table. If in doubt, check /install/database/scheme.sql for the correct table data