Mysql error urgent help needed.

HI

I HAVE BEEN ADDING SOME MODS TO MY STORE AND NOW CANNOT SEE MY LIVE STORE AT ALL CAN SOMEOME PLEASE TELL ME WHAT THIS ERROR MESSAGE MEANS AND MAYBE HOW TO CORRECT IT. I HAVE NEVER USED A MOD WHERE I HAVE TO EDIT OR ADD TO MY SQL AND DO NOT KNOW MUCH ON THIS SUBJECT. MESSAGE IS AS FOLLOWS.

1146 Table 'web86-odinsshop.TABLE_EZPAGES' doesn't exist
in:
[select * from TABLE_EZPAGES where status_header = 1 and header_sort_order > 0 order by header_sort_order, pages_title]

THIS IS VISABLE TO MY CUSTOMERS. BUT NO SHOP.

THANKS
MICHELLE
:oops:

You didn't execute the infopages.sql, did you? It's included in your download of that mod in the very first folder. Copy the text and paste it in Admin/Tools/install SQL Patches.

Hope this helps.

I CANT MY Admin/Tools/install SQL Patches. HAS GONE FROM MY ADMIN PANEL. IS THERE ANYWAY I CAN JUST DELETE THE PROBLEM FROM THE DATABASE.

THE Admin/Tools/install SQL Patches. DISAPEARED WHEN I EXECUTED THE SQL FILE.

SHOULD I JUST REINSTALL A NEW STORE, OR CAN THIS BE FIXED AS I HAVE OVER 800 PRODUCTS.

THANKS
MICHELLE :(

ODINSMINIATURES:

I CANT MY Admin/Tools/install SQL Patches. HAS GONE FROM MY ADMIN PANEL. IS THERE ANYWAY I CAN JUST DELETE THE PROBLEM FROM THE DATABASE.

THE Admin/Tools/install SQL Patches. DISAPEARED WHEN I EXECUTED THE SQL FILE.

SHOULD I JUST REINSTALL A NEW STORE, OR CAN THIS BE FIXED AS I HAVE OVER 800 PRODUCTS.

THANKS
MICHELLE :(

It can easily be fixed. On your Server, you will have a link to phpMyAdmin, right? Go to it, click on your database that your store is in, click the SQL tab. When it comes up, paste your text from your sql file in there, click "Go".
That should do it.

Hope this helps.

ODINSMINIATURES:

I HAVE BEEN ADDING SOME MODS TO MY STORE

...

1146 Table 'web86-odinsshop.TABLE_EZPAGES' doesn't exist
You've likely overwritten the original "/includes/database_tables.php" file with an older version of the file, perhaps taken from a mod designed for a much older version of Zen Cart, which doesn't contain the definition for the ez-pages table.

Put back the original version of that file, and that particular error should go away. Then you'll have to work on fixing whatever is missing for the mod you attempted to install.

Thankyou so much, yes this was one of the problems i reinstalled the file you told me to and my shop is back. still a few probs to sort out but that i can deal with. Once again thankyou.
hugs
michelle.:clap: