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
Actions