Shopping Cart Operations > Support

Error on 2nd language

(1/3) > >>

pask2008:
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>

dvagner:
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

pask2008:
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   

HADY:
Hello!

I am trying to fix some products information so I deleted them and started to correct the information inside each item but during this i got next error:

2020-09-22 12:01:11 - database error: AbanteCart core v.1.2.16 SQL Error: Duplicate entry '01-644-1011-1012-1013-1014-1015-1016-1017-1018-1019-1020-1021...' for key 'ac_url_aliases_idx'
Error No: 1062
SQL: INSERT INTO ac_url_aliases (`keyword`, `query`, `language_id`) VALUES ('01-644-1011-1012-1013-1014-1015-1016-1017-1018-1019-1020-1021-1022-1023-1024-1025-1026-1027-1028-1029-1030-1031-1032-1033-1034-1035-1036-1037-1038-1039-1040-1041-1042-1043-1044-1045-1046-1047-1048-1049-1050-1051-1052-1053-1054-1055-1056-1057-1058-1059-106-1062', 'product_id=1062', '18')
PHP call stack:
#0 /home/public_html/core/lib/db.php:100
#1 /home/public_html/core/engine/extensions.php:1176
#2 /home/public_html/core/engine/extensions.php:1127
#3 /home/public_html/core/lib/db.php:67
#4 /home/public_html/core/lib/language_manager.php:443
#5 /home/public_html/core/lib/language_manager.php:191
#6 /home/public_html/admin/model/catalog/product.php:155
#7 /home/public_html/admin/model/catalog/product.php:1124
#8 /home/public_html/admin/controller/pages/catalog/product.php:362
#9 /home/public_html/core/engine/dispatcher.php:293
#10 /home/public_html/core/engine/dispatcher.php:328
#11 /home/public_html/core/engine/page.php:108
#12 /home/public_html/core/engine/router.php:176
#13 /home/public_html/core/engine/router.php:80
#14 /home/public_html/index.php:94
in <b>/home/public_html/core/database/amysqli.php</b> on line <b>119</b>


I will be thankful for your support and help in advance.

Basara:

--- Quote from: HADY on September 22, 2020, 05:49:41 AM ---started to correct the information inside

--- End quote ---

Hello. What exactly you did and on what page?

Navigation

[0] Message Index

[#] Next page