Author Topic: Error on 2nd language  (Read 155 times)

Offline pask2008

  • Newbie
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Error on 2nd language
« on: April 15, 2020, 12:30:04 PM »
hello
i was adding a second language through extension to my project.
after installed it, set the language on, and start to load missing data from english (unsuccesful ), i have received the following
mysql error in log that i don't know how to fix. It looks like spacing problem in SQL command, so i have add in my.ini  SQL_MODE=IGNORE_SPACE
but still the LOAD command doesn't work.
do you have any suggestion ? thanks a lot

2020-04-14 10:40:42 - database error: AbanteCart core v.1.2.15 SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE language_id = 1' at line 3
Error No: 1064
SQL: SELECT COUNT(*) as cnt
FROM
WHERE language_id = 1 in <b>C:\Bitnami\abantecart-1.2.15-10\apps\abantecart\htdocs\core\database\amysqli.php</b> on line <b>114</b>


Offline dvagner

  • Core/UI Developer
  • Newbie
  • *
  • Posts: 34
  • Karma: +13/-0
    • View Profile
Re: Error on 2nd language
« Reply #1 on: April 16, 2020, 04:36:25 AM »
1. Clear cache.
2. If Step1 not solved your issue -   Show result of query

SELECT DISTINCT table_name
                FROM information_schema.columns
                WHERE column_name = 'language_id' AND table_schema='DB_DATABASE';

Where DB_DATABASE - your DB name

Offline pask2008

  • Newbie
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Re: Error on 2nd language
« Reply #2 on: April 18, 2020, 12:52:31 PM »
hi Dvagner
thanks for your suggestion but clearing the cache didn't solve
here the query result

SELECT DISTINCT table_name
                FROM information_schema.columns
                WHERE column_name = 'language_id' AND table_schema='solution1_ps';


TABLE_NAME   
ac_banner_descriptions   
ac_block_descriptions   
ac_category_descriptions   
ac_content_descriptions   
ac_country_descriptions   
ac_coupon_descriptions   
ac_download_descriptions   
ac_field_descriptions   
ac_field_values   
ac_fields_group_descriptions   
ac_form_descriptions   
ac_global_attributes_descriptions   
ac_global_attributes_groups_descriptions   
ac_global_attributes_type_descriptions   
ac_global_attributes_value_descriptions   
ac_language_definitions   
ac_languages   
ac_length_class_descriptions   
ac_order_data_types   
ac_order_statuses   
ac_orders   
ac_page_descriptions   
ac_product_descriptions   
ac_product_filter_descriptions   
ac_product_filter_ranges_descriptions   
ac_product_option_descriptions   
ac_product_option_value_descriptions   
ac_product_tags   
ac_resource_descriptions   
ac_stock_statuses   
ac_store_descriptions   
ac_tax_class_descriptions   
ac_tax_rate_descriptions   
ac_url_aliases   
ac_weight_class_descriptions   
ac_zone_descriptions   

 

Powered by SMFPacks Social Login Mod