Critical error - Sql syntax

[dj_jojo]

when i try to select a category to show albums the gallery returns critical error :S

While executing query "SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg134_albums as a LEFT JOIN cpg134_pictures as p ON a.thumb=p.pid WHERE category=8 ORDER BY a.posLIMIT 0,1" on 0

mySQL error: 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 '0,1' at line 1

any suggestions and help.
Regards
D.

[Abbas Ali]

The problem is

a.posLIMIT

in the query. There should be a space between a.pos and LIMIT i.e. it should be

a.pos LIMIT

Did you modified any files? If so then correct the query in that file.

[dj_jojo]

hmm.. no i have only changed some of the Language files..... i'll try to overwrite functions file.


do you have any clue about which file could be causing the error beside the functions file?


regards
Dragan

[Nibbler]

It's in index.php here:

Code Select Expand


    $sql = 'SELECT a.aid, a.title, a.description, visibility, filepath, '.
           'filename, url_prefix, pwidth, pheight '.
           'FROM '.$CONFIG['TABLE_ALBUMS'].' as a '.
           'LEFT JOIN '.$CONFIG['TABLE_PICTURES'].' as p '.
           'ON a.thumb=p.pid '.
           'WHERE category='.$cat.$album_filter.
           ' ORDER BY a.pos '.
           $limit;


Should be easy to fix, just add in a space.

[dj_jojo]

 

well done boys    ; you have both earned a bottle of beer 

muchos gracias

Regards
D.