Project

General

Profile

Actions

Bug #2280

closed

J1.6: SQL error when fixing user table in "Tools"

Added by ThePiston about 13 years ago. Updated about 13 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Target version:
Start date:
02 February 2011
Due date:
09 February 2011
% Done:

100%

Estimated time:
1:00 h

Description

installed fine in 1.6. I went to check users table and saw this:

Warning: 2 entries in the users table without corresponding core_acl_aro table rows.

user id: 43, 45 are missing in core_acl_aro table

This one can be fixed by first backing up database

I clicked the fix link and then this new error came up:

SQL error DB function failed with error number 1146 
Table 'societys_doc2doc.jos_core_acl_aro' doesn't exist SQL=INSERT INTO jos_core_acl_aro (section_value,value,order_value,name,hidden) SELECT 'users' AS section_value, u.id AS value, 0 AS order_value, u.name as name, 0 AS hidden FROM jos_users u LEFT JOIN jos_core_acl_aro a ON a.section_value = 'users' AND a.value = CAST( u.id AS CHAR ) WHERE a.value IS NULL
SQL =
INSERT INTO #__core_acl_aro (section_value,value,order_value,name,hidden) SELECT 'users' AS section_value, u.id AS value, 0 AS order_value, u.name as name, 0 AS hidden FROM #__users u LEFT JOIN #__core_acl_aro a ON a.section_value = 'users' AND a.value = CAST( u.id AS CHAR ) WHERE a.value IS NULL

Files

2280.patch (7.66 KB) 2280.patch krileon, 04 February 2011 19:48
Actions

Also available in: Atom PDF