The Plugin Management, User Management, and Field Management tabs are showing DB error 1030. This happened earlier today and performing a Global Checkin resolved it. But the problem is reoccuring and Global Checkin doesn't fix it.
Here's the full error msg on the User Management tab:
DB function failed with error number 1030
Got error 28 from storage engine SQL=SELECT DISTINCT u.*, g.name AS groupname, ue.approved, ue.confirmed FROM jos_users AS u LEFT JOIN jos_comprofiler AS ue ON u.id = ue.id INNER JOIN jos_core_acl_aro AS aro ON aro.value = u.id INNER JOIN jos_core_acl_groups_aro_map AS gm ON gm.aro_id = aro.id INNER JOIN jos_core_acl_aro_groups AS g ON g.id = gm.group_id WHERE aro.section_value = 'users' LIMIT 0, 20
When I do a Global Check-in I get this error msg repeated about 20x:
Warning: Invalid argument supplied for foreach() in /home/outryder/public_html/sandbox/libraries/joomla/database/database/mysql.php on line 678
Other areas of the site seem to be ok. No pertinent errors in the server log. I can't look at the CBSubs log because of the db error. Please let me know how I can get past this. This site should be going live soon.
Here is my environment info:
Joomla 1.5.14
CB 1.2.1
CBSubs 1.02
Apache Version: 2.2.13
MySQL Version: 5.0.81
OpenSSL Version: 0.9.8e-fips-rhel5
Operating System: CentOS release 5.3 (Final)
Perl Version: 5.8.8
PHP Version: 5.2.10
SSH Version: SSH-2.0-OpenSSH_4.3
cURL Information libcurl/7.19.5
ionCube PHP Loader v3.1.34
Thanks.