Skip to main content

1146 Table 'XXXXXX.#__hikashop_files' doesn't exist

More
5 years 3 weeks ago - 5 years 3 weeks ago #335605 by byoguru
-- HikaShop version -- : 4.4.3
-- Joomla version -- : 3.10.1
-- PHP version -- : 7.4.20
-- Browser(s) name and version -- : Google Chrome is up to date Version 93.0.4577.63 (Official Build) (x86_64)
-- Error-message(debug-mod must be tuned on) -- : when debug is on only a blank white screen is returned...

In MASS ACTIONS when trying to export CSV and selecting all tables and columns this is the response:
1146 Table 'artonstuff.#__hikashop_files' doesn't exist
1146 Table 'artonstuff.#__hikashop_images' doesn't exist

When selecting Export CSV vs DISPLAY RESULTS vs there are 2 additional lists of items Files + Images
If any items are selected in either of those 'lists' the 1146 error occurs

I went back to an archived site with Hikashop 4.1.0 and the export works
Last edit: 5 years 3 weeks ago by byoguru. Reason: adding reference: https://www.hikashop.com/forum/install-update/902407-since-the-last-update-hikashop-images-doesn-t-exist.html#331853

Please Log in or Create an account to join the conversation.

More
5 years 3 weeks ago #335613 by nicolas
Hi,

If it says it's missing some tables, then you can click on the "check database" button of the HikaShop configuration so that it will fix the tables.

Please Log in or Create an account to join the conversation.

More
5 years 3 weeks ago #335626 by byoguru
Thanks I did this and result is still the same.

I notice this item when tables are checked:
-- OK Table "hikashop_file" checked
but the errors says
-- "hikashop_files"

Also in the list of tables no IMAGES table:
Code:
OK Table "hikashop_address" checked OK Table "hikashop_badge" checked OK Table "hikashop_banner" checked OK Table "hikashop_cart" checked OK Table "hikashop_cart_product" checked OK Table "hikashop_category" checked OK Table "hikashop_characteristic" checked OK Table "hikashop_click" checked OK Table "hikashop_config" checked OK Table "hikashop_currency" checked OK Table "hikashop_discount" checked OK Table "hikashop_download" checked OK Table "hikashop_entry" checked OK Table "hikashop_field" checked OK Table "hikashop_file" checked OK Table "hikashop_filter" checked OK Table "hikashop_geolocation" checked OK Table "hikashop_history" checked OK Table "hikashop_limit" checked OK Table "hikashop_massaction" checked OK Table "hikashop_order" checked OK Table "hikashop_orderstatus" checked OK Table "hikashop_order_product" checked OK Table "hikashop_payment" checked OK Table "hikashop_price" checked OK Table "hikashop_product" checked OK Table "hikashop_product_category" checked OK Table "hikashop_product_related" checked OK Table "hikashop_plugin" checked OK Table "hikashop_shipping" checked OK Table "hikashop_shipping_price" checked OK Table "hikashop_tax" checked OK Table "hikashop_taxation" checked OK Table "hikashop_user" checked OK Table "hikashop_variant" checked OK Table "hikashop_vote" checked OK Table "hikashop_vote_user" checked OK Table "hikashop_waitlist" checked OK Table "hikashop_widget" checked OK Table "hikashop_zone" checked OK Table "hikashop_zone_link" checked OK Table "hikashop_warehouse" checked OK Table "hikashop_email_log" checked OK Product categories checked OK Variants orphan links cleaned OK Joomla users synchronized OK User email addresses synchronized

Please Log in or Create an account to join the conversation.

More
5 years 3 weeks ago #335627 by nicolas
Hi,

Ah yes, I had missed that in your first message.
That's indeed a bug in the massaction export system due to recent changes to better handle the auto detection of data types in the export.

I've made a patch which fixes that.
Download again the install package of the latest version of HikaShop on our website and install it on yours and you'll have the patch.
The following user(s) said Thank You: byoguru

Please Log in or Create an account to join the conversation.

More
5 years 2 weeks ago #335662 by byoguru
Great, thank you Nicolas.
Now works as expected!

Please Log in or Create an account to join the conversation.

Time to create page: 0.154 seconds
Powered by Kunena Forum