All of a sudden, without me changing ANYTHING, Today I'm getting the following error: MYSQL ERROR: Table 'winningracin.amember_members' doesn't exist in query: SELECT status,COUNT(*) FROM amember_members GROUP BY statu Now this means that I cannot access my database, I cannot email my members and they cannot access my information page, all of these things are CRITICAL to my business EVERY DAY. I have submitted a ticket but really every hour is potentially costing me money. I am no expert I just rely on the software which has been fine for 2 years - until today. Please tell me what this means and if it can be fixed I am very worried, particulary as rather stupidly I have not backed up the database for about 6 weeks. Thanks any help appreciated.
If MySQL says "Table 'winningracin.amember_members' doesn't exist", it probably really does not. If you have phpmyadmin installed on the server, use it to check whether the database connection is working properly and if the above mentioned table is present. Other than that, it's hard to help without having access to your server. Tomas
That sounds like a big time error- you need to contact amember support. What version of aMember? Do you have a backup of the database? Does your host do backups? David
thanks. I think the table does still exist, why wouldn't it? I have logged in via my web host control panel and I can see the database. I dont know what phpmyadmin is so I dont know whether the connection is working correctly. I use names.co.uk and all I can say is that their status page is showing all ok. I have a backup but it is 6 weeks old!! I dont know if my host backs up for me also. Script Version: 3.0.9PRO I am still awaiting a response from amember support and expect they will be back monday along with tech support at my hosts, if I dont get any joy from them though I my well be back here and asking/begging one of you guys to access my server and help me out. I dont mind paying at all. This is my livelyhood. And yes I do feel a twat for not backing up more regularly, having said that a 6 week old version that works is better than what I;ve got right now!
If you want, send me your cPanel (or whatever control panel you may be using) account username and password at tomfra[at]centrum.cz and I will see if everything looks OK. I can't promise anything though. And I also suggest you change your account password to a temporary one before sending it to me. Tomas
Thanks for the offer of help, I have now had the database restored by my host, who thankfully had a backup from last thursday when it was working. Amember support told me that the database was REMOVED BY HACKERS and that he had to remove several hacker tools from my site. My hosts say that there is no way that could have happened through them and that it must have been via the script. I have yet to receive a response from amember about how this could happen with the latest version of their script as as such I and all of us are open to attack again.
If a hacker deleted your MySQL database, I seriously doubt it was because of a security hole in the aMember script. The hacker would have to get access to your hosting account, either through SSH, or the control panel. Of course, this could be possible through the aMember script *if* the PHP is configured badly on the webhost side. If you create a test file, for example test.php with this content: PHP: <?php phpinfo() ?> , and upload it somewhere to your website, I may be able to see if there is something wrong with the PHP configuration. There is more to security than securing PHP of course. For example using private certificates for SSH access if you have one etc. Tomas