Author Topic: Reported this but no reply : Error 1054  (Read 3084 times)

Offline DocB

  • Newbie
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Reported this but no reply : Error 1054
« on: May 10, 2017, 06:20:37 AM »
SQL Error: Unknown column 'gad.placeholder' in 'field list'
Error No: 1054
SQL: SELECT ga.*, gad.name, gad.error_text, gad.placeholder, gatd.type_name FROM abc_global_attributes ga LEFT JOIN abc_global_attributes_descriptions gad ON ( ga.attribute_id = gad.attribute_id AND gad.language_id = '1' ) LEFT JOIN abc_global_attributes_type_descriptions gatd ON ( gatd.attribute_type_id = ga.attribute_type_id AND gatd.language_id = '1' ) WHERE 1=1 AND ga.attribute_type_id = '1' AND ga.status = 1 AND ga.attribute_parent_id = 0 ORDER BY ga.sort_order ASC LIMIT 0,1000 in /usr/local/www/.../store2/core/database/amysqli.php on line 109


Version 1.2.10

When clicking "options" in admin.

My database was changed to Mysqli (Amysqli)

Also trying to go to Global Attributes :

2017-05-10 12:23:56 - database error: AbanteCart core v.1.2.10 SQL Error: Unknown column 'gad.placeholder' in 'field list'
Error No: 1054
SQL: SELECT ga.*, gad.name, gad.error_text, gad.placeholder, gatd.type_name
FROM abc_global_attributes ga
LEFT JOIN abc_global_attributes_descriptions gad
ON ( ga.attribute_id = gad.attribute_id AND gad.language_id = '1' )
LEFT JOIN abc_global_attributes_type_descriptions gatd
ON ( gatd.attribute_type_id = ga.attribute_type_id AND gatd.language_id = '1' )
WHERE 1=1 AND ga.attribute_parent_id = '0' ORDER BY ga.sort_order ASC LIMIT 0,10000 in <b>/usr/local/www/.../store2/core/database/amysqli.php</b> on line <b>109</b>
« Last Edit: May 10, 2017, 06:26:45 AM by DocB »

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2048
  • Karma: +319/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Reported this but no reply : Error 1054
« Reply #1 on: May 10, 2017, 07:58:10 AM »
please check this line https://github.com/abantecart/abantecart-src/blob/master/public_html/install/abantecart_database.sql#L12346
To fix you should to go to phpMyAdmin and add column "placeholder" into table global_attributes_descriptions
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

 

Powered by SMFPacks Social Login Mod