Project

General

Profile

Actions

Bug #2280

closed

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

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

Added by ThePiston almost 15 years ago. Updated almost 15 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

Updated by krileon almost 15 years ago Actions #1

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.

Updated by beat almost 15 years ago Actions #2

  • 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: PDF Atom