Welcome to Geeklog, Anonymous Thursday, March 28 2024 @ 07:09 am EDT

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:
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. Frown

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. Cool

Any insight, greatly appreciated.

--Chris

P.S. This copy of GL is using MySQL 5.5.40
 Quote

Status: offline

Laugh

Site Admin
Admin
Registered: 09/27/05
Posts: 1468
Location:Canada
You found a bug! Big Grin

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.
 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:
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. Smile

Thanks again, Laugh!

--Chris
 Quote

Status: offline

Laugh

Site Admin
Admin
Registered: 09/27/05
Posts: 1468
Location:Canada
It's fixed in the repo now but the download will not be updated. We will have a new beta or release candidate out soon with the latest fixes.
One of the Geeklog Core Developers.
 Quote

Status: offline

chris

Forum User
Newbie
Registered: 01/30/17
Posts: 11
Location:the terminal / console
Excellent! I eagerly await it's release.

Thanks, for all your time on this!

--Chris
 Quote

All times are EDT. The time is now 07:09 am.

  • 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