Guest Posted May 14, 2008 Posted May 14, 2008 1146 - Table 'nameoftable_video.configuration' doesn't exist select configuration_key as cfgKey, configuration_value as cfgValue from configuration I did a search and went through my config file under /sqadmin/includes/ and I haven't changed a thing. I just logged into phpMyadmin from the info in the config file and got in with no problem Help! Edit: I should add this site has been up for 5 years, it's not a new install
Jack_mcs Posted May 14, 2008 Posted May 14, 2008 That error is saying the database can't be loaded. It is either corrupted or has been erased. When you go into phpmyadmin, can you see the database? Is it populated? Jack Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons
Guest Posted May 14, 2008 Posted May 14, 2008 Solved. Well, my host uploaded a backup to fix it as he said other tables were gone, too. I'd love to know why the tables disappeared after years and years of use
Guest Posted May 14, 2008 Posted May 14, 2008 (quote button won't work) "That error is saying the database can't be loaded. It is either corrupted or has been erased. When you go into phpmyadmin, can you see the database? Is it populated?" When I was in it earlier, I had 15 tables. With the host uploading a backup, I have 57 tables. WHERE did 42 tables go? Like I said, site has been running for years and years and I haven't changed much this year ... added a few lines of text to default.php (main page) on the 7th but the site was fine after that as I tested it
Jack_mcs Posted May 14, 2008 Posted May 14, 2008 There's no way to tell, it could be a number of things. If you keep backups in admin->tools->Database Backup, the backups may not be valid. If you then try a restore from one of them, this could happen. Jack Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons
Guest Posted May 14, 2008 Posted May 14, 2008 "There's no way to tell, it could be a number of things. If you keep backups in admin->tools->Database Backup, the backups may not be valid. If you then try a restore from one of them, this could happen." I can't use the internal backup, my db is too large -- I have another script I use but I've never had to restore before. My host does daily backups so was able to restore one from 2 days ago that had all the tables, so this happened within the past 2 days. My host tells me that the admin area wasn't pass protected, but it always had been, so that's something new, yet no one has logged into the server and they can't delete tables from the admin area. They think maybe some sort of exploit and suggest I upgrade but I thought I had the latest version. Going through my products I see something that has happened before -- a product will be marked out of stock yet when you edit it, it shows 233 in stock ... couple of dozen I've had to edit so far. L
Jack_mcs Posted May 15, 2008 Posted May 15, 2008 My host tells me that the admin area wasn't pass protected, but it always had been, so that's something new, yet no one has logged into the server and they can't delete tables from the admin area.Having access to admin means having access to the file manager. That means the database login information can be obtained from the configure files so access to the database is quite possible that way. Why someone would do damge like that eludes me but there are those that would. You shoud, obviously, make sure it is protected. Jack Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons
Guest Posted May 15, 2008 Posted May 15, 2008 File manager isn't installed -- was removed years ago. My host figures it's an sql injection but I can't figure out which version I am using to see if I'm up-to-date. Not sure why the protected area wasn't protected either, since it always had been. If I were going to break into a site, I'd wipe out everything, not just a handful of tables, but maybe that's why I'm not a hacker :) Edit: It was removed, btw, as one of the mods on this forum also did side work and he set up the site for me and said it was a security risk, and I agreed. Not sure if he's still a mod or not ...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.