Welcome to Geeklog, Anonymous Saturday, November 23 2024 @ 04:48 pm EST
Geeklog Forums
More DB (MySQL) woes -- Call Stack included
Status: offline
chris
Forum User
Newbie
Registered: 01/30/17
Posts: 11
Location:the terminal / console
OK. I've been working with a copy of GL I downloaded from the
GitHub repo yesterday (main branch). I had been experiencing
problems database related, that I was later able to resolve
( 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).
Which returned the following:
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.
From the error log mentioned in the error above:
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
Anyway, I do not this should be considered the expected output for a Language query.
Any insight, greatly appreciated.
--Chris
P.S. This copy of GL is using MySQL 5.5.40
GitHub repo yesterday (main branch). I had been experiencing
problems database related, that I was later able to resolve
( 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).
Which returned the following:
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.
From the error log mentioned in the error above:
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
Anyway, I do not this should be considered the expected output for a Language query.
Any insight, greatly appreciated.
--Chris
P.S. This copy of GL is using MySQL 5.5.40
18
17
Quote
Status: offline
Laugh
Site Admin
Admin
Registered: 09/27/05
Posts: 1470
Location:Canada
You found a bug!
That search should return any matching language override that is in the list below. I have added the issue to our tracker: https://github.com/Geeklog-Core/geeklog/issues/753
One of the Geeklog Core Developers.
That search should return any matching language override that is in the list below. I have added the issue to our tracker: https://github.com/Geeklog-Core/geeklog/issues/753
One of the Geeklog Core Developers.
18
19
Quote
Status: offline
chris
Forum User
Newbie
Registered: 01/30/17
Posts: 11
Location:the terminal / console
Thanks Laugh!
Well, I finished a new GL install. This time 2.1.2b2. Everything
seems to work. Just to see if there was any improvement in this area.
I performed the same search, for simply "en" (no quotes).
It returned -- yep, you guessed it:
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/to/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)
}
Looks pretty much identical, to me.
Not harping on this, or anything. Just thought I'd mention it. In case
it helped in some way.
Thanks again, Laugh!
--Chris
Well, I finished a new GL install. This time 2.1.2b2. Everything
seems to work. Just to see if there was any improvement in this area.
I performed the same search, for simply "en" (no quotes).
It returned -- yep, you guessed it:
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/to/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)
}
Looks pretty much identical, to me.
Not harping on this, or anything. Just thought I'd mention it. In case
it helped in some way.
Thanks again, Laugh!
--Chris
17
14
Quote
All times are EST. The time is now 04:48 pm.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content