OK. I've been working with a copy of GL I downloaded from the
GitHub repo yesterday (main branch). I had been experiencing
( MY fault, not the MySQL ver/DB ).
Anyway. Today I attempted to configure the Language option(s)
w/i the admin CP. I submitted a search query on "en" (no quotes).
Text Formatted Code
An error has occurred:
(This text is only displayed to users in the group 'Root')
E_USER_ERROR(256) - An SQL error has occurred. Please see error.log for details. @ /my/path/to/system/databases/mysqli.class.php line 459
Call Stack
# Function File Line
1 trigger_error /my/path/tp/system/databases/mysqli.class.php 459
2 dbQuery /my/path/to/system/lib-database.php 216
3 DB_query /my/path/to/system/lib-admin.php 476
4 ADMIN_list /my/path/to/system/classes/language.class.php 322
5 adminShowList /my/path/to/admin/language.php 73
array(3) {
["sql"]=>
string(85) "SELECT * FROM gl_language_items AND () GROUP BY id, var_name, language, name, value "
["ignore_errors"]=>
int(0)
["result"]=>
bool(false)
}
Sorry. The editor allows the lines above to wrap.
Text Formatted Code
1064: 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 'AND () GROUP BY id, var_name, language, name, value' at line 1 in /my/path/to/system/lib-admin.php:476. SQL in question: SELECT * FROM gl_language_items AND () GROUP BY id, var_name, language, name, value
this should be considered the expected output for a Language query.
P.S. This copy of GL is using MySQL 5.5.40