Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Site is dead due to error .... didn't change a thing recently


Guest

Recommended Posts

Posted

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

Posted

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

Posted

(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

Posted

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

Posted

"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

Posted
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

Posted

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 ...

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...