- Posts: 99
- Thank you received: 5
1146 Table 'XXXXXX.#__hikashop_files' doesn't exist
5 years 3 weeks ago - 5 years 3 weeks ago #335605
by byoguru
1146 Table 'XXXXXX.#__hikashop_files' doesn't exist was created 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
-- 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.
5 years 3 weeks ago #335613
by nicolas
Replied by nicolas on topic 1146 Table 'XXXXXX.#__hikashop_files' doesn't exist
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.
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.
5 years 3 weeks ago #335626
by byoguru
Replied by byoguru on topic 1146 Table 'XXXXXX.#__hikashop_files' doesn't exist
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:
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.
5 years 3 weeks ago #335627
by nicolas
Replied by nicolas on topic 1146 Table 'XXXXXX.#__hikashop_files' doesn't exist
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.
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.
5 years 2 weeks ago #335662
by byoguru
Replied by byoguru on topic 1146 Table 'XXXXXX.#__hikashop_files' doesn't exist
Great, thank you Nicolas.
Now works as expected!
Now works as expected!
Please Log in or Create an account to join the conversation.
Time to create page: 0.242 seconds