Actions
Bug #2280
closedJ1.6: SQL error when fixing user table in "Tools"
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
Updated by krileon almost 14 years ago
- File 2280.patch 2280.patch added
- Status changed from New to Resolved
- % Done changed from 0 to 100
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 14 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