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 #1

Updated by krileon about 13 years ago

Patch proposed adds fix queries for ACL tools. Names are not changed (didn't know if language strings were to be changed yet and to what style.. such as using CBTxt::P) so will still display old table names, but will insert the user appropriately.

Actions #2

Updated by beat about 13 years ago

  • Status changed from Resolved to Closed

Fixed as suggested in r1434 and r1435
(and added language string with correct table name mentioned, CB 1.2-style language string)

Thanks Kyle.

Actions

Also available in: Atom PDF