None of my members can log in to their accounts. I can log in as admin. In the error log, I see this message: "Can't find file: 'am_access_cache'" I attempted to rebuild the core and httpasswd databases and got this error: The database has encountered a problem, please try again later. In the log file it said: Invalid argument: $pages must be an array, an instance of Zend_Config or an instance of Zend_Navigation_Container I am running version 4.3.6. The root disk got full last night and I suspect something did not get written correctly in the database but I do not know how to fix it. I have a backup of the entire database from the previous day but I don't want to overwrite the existing database unless I have no other option. Any suggestions how to proceed? Thanks, Hari http://xplanetclouds.com
Please try to open url http://example.com/amember/admin-upgrade-db (You should be logged in as admin, also you need to replace http://example.com/amember with actual url of your aMember installation). This script will restore am_access_cache database table (data in this table is not important, it will be populated with proper data when you run rebuild database). Then run rebuild core database. It should fix your issue.
Thank you for your response, Caesar. I did this and got this message: The database has encountered a problem, please try again later. The log file has this message: Can't find file: 'am_access_cache' (errno: 2) at amember4/library/Am/DbSync.php line 802(1017) in query: SHOW CREATE TABLE `am_access_cache`
Also, the nightly mysqldump of my database is empty! I went ahead and restored the backup from the previous night. All appears to be well now. Backup early and often, everyone!