Table 'addon_filters_categories' doesn't exist

**todoonada** · 7 Aug 2018, 06:44 AM

I have a live shop running and wanted to make a local copy to experiment. Zencart version 1.5.5f is used.
When I import the database on my local PC, the backend runs fine. But when I go the the Catalog->Categories page, only the first category is displayed. An error is displayed: WARNING: An Error occurred, please refresh the page and try again.
I check the log files and get this:
PHP Fatal error: 1146:Table 'addon_filters_categories' doesn't exist :: SELECT `filters_status`
FROM `addon_filters_categories`
WHERE `categories_id` = 1 ==> (as called by) admin/includes/classes/products_filters.php on line 1004 <== in /includes/classes/db/mysql/query_factory.php on line 171

I do not have a table called addon_filters_categories in my original DB. Does anybody know what this table is?

Thank you

**Design75** · 7 Aug 2018, 09:26 AM

That table must come from an add-on you have installed on your live site. Compare the two databases, and copy the missing tables to your dev site.

**carlwhat** · 7 Aug 2018, 03:26 PM

its seems that this add-on has that table:

https://www.zen-cart.com/downloads.php?do=file&id=2177

its not part of the base ZC. so you have installed that add-on... although entirely possible that there is another one with the same table name.... although maybe not!

best.

**todoonada** · 9 Aug 2018, 01:28 AM

Thank you, Design75 and carlwhat.
The add-on, carlwhat mentioned, was missing.

**mc12345678** · 9 Aug 2018, 11:19 AM

Originally Posted by todoonada

Thank you, Design75 and carlwhat.
The add-on, carlwhat mentioned, was missing.

Curious how the plugin could be missing from the fileset if, as the original post suggested, a copy of the live site was made to the local computer? Further is ZC 1.5.5f being used in both systems or is the local server being used to create an upgrade?

**todoonada** · 10 Aug 2018, 07:41 AM

Had a set of files on localhost. Used them to play around with addons. Live system has less addons installed. Made a fresh installation of OS on my PC. zencart files were on backup and copied to fresh installation on my PC, but DB was gone.
Made a copy of DB and files (to same directory like files from backup) from live zencart to localhost. So the files for filters-addon were still on my localhost, but the table in DB for this addon was missing, because DB was copy from live shop which does not use this addon.