Products & Categories Aren't Showing But Database Is Full. Please Help.

[DPM]

This is what happened a few months ago...

http://www.zen-cart.com/forum/showthread.php?t=97527

It has happened again on Tuesday evening where the all the categories and products are gone and don't show up in either the website or the backend/admin.

A friend who works on the site has checked and there seems to be 'nothing' wrong and all the database is full with the products and categories.

We would just restore a backup but what we thought was getting backed up every night has turned out to be empty files.

We're now at a major problem and really don't know what to do. The website is my only job and income and the fact that all the products and categories aren't showing makes it some what useless at the moment.

Any help would be very gratefully received.

www.dpmperformance.co.uk

[DPM]

Just heard back from the hosting company, Hosting Unlimited, and they don't have any backups of the site either. Does anyone know what i can do or is it a lost?

[Ajeh]

Check the configure.php files on the server:
/includes/configure.php
/admin/includes/configure.php

are they using the same database and server information as that you are looking at via phpMyAdmin?

How records are in the tables:
products
products_description
categories
categories_description
products_to_categories

[DPM]

I've looked at the PHPmyadmin and those records are there but when looking at the 'products' it has very few in and they look like old products that we deleted from the site a while ago.

I can't seem to find the /includes/configure.php

[Ajeh]

Using your FTP program you need to find your configure.php file to know what database is being used on your site ...

This should be in a directory like:
/public_html/includes/configure.php

When in your phpMyAdmin, is there just 1 database or several databases?

How many records are in each of the tables I posted?

[DPM]

Sorry, i couldn't see the woods for the trees... so stressed right now.

Found the configure and in the file is as follows...

define('DB_DATABASE', 'bubbles_perfnewdb');

There's 2 databases, bubbles_perfnewdb (102) and information_scheme (17).

bubbles_perfnewdb...

categories - 0
categories_descriptions - 0
products - 83
product_descriptions - 0
product_to_categories - 0

[DPM]

Further down the list i have just noticed the following...

zen_zen_products - 1809
zen_zen_product descriptions - 1726
zen_zen_product_to_categorie - 1726

[Ajeh]

There's 2 databases, bubbles_perfnewdb (102) and information_scheme (17).

bubbles_perfnewdb...

categories - 0
categories_descriptions - 0
products - 83
product_descriptions - 0
product_to_categories - 0

Well that is bad ... you do not have enough information in the database to even begin to produce categories and products ...

All you currently have are Products in the products table which holds things like products_id, products_image and products_price ... but you have nothing for the products_name, products_description etc.

You have no categories nor categories descriptions and you have no relationships between Products and Categories in the products_to_categories table ...

How did you originally add your Products and Categories to your site?

[DPM]

Check the post above your reply Linda, what is your opinion on this? To me it looks about right as to the amount of products i use to have.

I use to add products and categories via the admin/backend.

[Ajeh]

You now appear to have mismatched table names and in the zen_zen_ set of tables, you have mismatched products to products_descriptions ...

Your tables are really out of sorts and you still do not know what your configure.php file(s) are saying ...

Now it is important to figure out if you are using table prefixes ...

102 tables is not the default number of tables and it is not proportional to being a double set of tables where one set has prefixes and the other does not ...

More or less ... you are in a real mess here ...

Do you have any good backups or someone who knows how to work with database tables to see if it can be salvaged?