? Success

User tests: Successful: Unsuccessful:

avatar zero-24
zero-24
2 Jul 2014

Tracker

http://joomlacode.org/gf/project/joomla/tracker/?action=TrackerItemEdit&tracker_item_id=33916&start=0

How to test

  1. Install a clean joomla
  2. add a extra table with a # as the first letter (e.g. #_helpdesk_categories)
  3. Access the System Information (BE --> System --> System Information)
  4. You get a SQL error like

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 '' at line 1 SQL=SHOW FULL COLUMNS FROM #_helpdesk_categories

  1. apply patch
  2. test again

joomla-bugs.de Referenze

http://www.joomla-bugs.de/forum/index.php?topic=608

avatar zero-24 zero-24 - open - 2 Jul 2014
avatar zero-24 zero-24 - change - 2 Jul 2014
Title
Update mysqli.php
[#33916] Update mysqli.php
avatar zero-24 zero-24 - change - 2 Jul 2014
Title
[#33916] Update mysqli.php
Possible SQL error on the collation test 
avatar pe7er
pe7er - comment - 11 Jul 2014

@test

I was able to reproduce the error by creating a new table called #_test & retrieving the System Information:
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 '' at line 1 SQL=SHOW FULL COLUMNS FROM #_test

After applying the test, the error was gone...

avatar BjornElsing
BjornElsing - comment - 11 Jul 2014

@test

Was able to reproduce the error, the patch fixed this.

avatar Bakual Bakual - change - 11 Jul 2014
Title
Possible SQL error on the collation test 
Possible SQL error on the collation test
Status New Closed
Closed_Date 0000-00-00 00:00:00 2014-07-11 13:41:44
avatar Bakual Bakual - change - 11 Jul 2014
Title
Possible SQL error on the collation test
[#33916] Possible SQL error on the collation test
avatar Bakual Bakual - close - 11 Jul 2014
avatar Bakual Bakual - close - 11 Jul 2014
avatar zero-24 zero-24 - change - 11 Jul 2014
Title
Possible SQL error on the collation test 
[#33916] Possible SQL error on the collation test
avatar vdespa
vdespa - comment - 11 Jul 2014

I've refactored the getCollation() method in #3886

avatar zero-24 zero-24 - head_ref_deleted - 14 Jul 2014

Add a Comment

Login with GitHub to post a comment