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.
If your DB still has the ‘membership’ tables, try:
create:
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`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
then:
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