
Originally Posted by
dealbyethan.com
I dropped the tables zen_zen_un_wishlists and zen_zen_un_products_to_wishlists in phpmyadmin and reran the sql file. This time zen_un_wishlists and zen_un_products_to_wishlists were created. So I thought it would be working but it's not. I turned on the sidebox in the admin but it doesn't show up on my shop. And in my admin > Extras > Wishlists, I still get the following error. Please help.
1146 Table 'dealbyet_zc4.un_wishlists' doesn't exist
in:
[SELECT w.id, w.customers_id, w.created, w.modified, w.name, w.comment, w.default_status, w.public_status, count(p.products_id) as items_count, c.customers_email_address, c.customers_firstname, c.customers_lastname FROM un_wishlists w LEFT JOIN un_products_to_wishlists p2w ON w.id=p2w.un_wishlists_id LEFT JOIN zen_products p ON p2w.products_id=p.products_id LEFT JOIN zen_customers c ON w.customers_id=c.customers_id GROUP BY w.id ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.