Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP

Loading…

Page module crashes #781

Closed
macik opened this Issue · 0 comments

2 participants

@macik
Collaborator

Page module crashes with:

Fatal error: SQL error 42000: Syntax error or access violation: 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 5

#0  cot_diefatal(SQL error 42000: Syntax error or access violation: 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 5) called at [\system\database.php:449]
#1  CotDB->query(SELECT p.*, u.* 
        FROM cot_pages as p 
        LEFT JOIN cot_users AS u ON u.user_id=p.page_ownerid
        WHERE (page_state=0 OR page_state=2) AND page_cat='news'
        ORDER BY page_id asc LIMIT 0, , Array ()) called at [\modules\page\inc\page.list.php:153]
#2  require_once(\page\inc\page.list.php) called at [\modules\page\page.php:43]
#3  require_once(\modules\page\page.php) called at [\index.php:96]

if Administrator makes mistake and not specified 'max row per page' limit (admin→extension→pages→structure→category)

Needed this line
```$cfg['page']['maxrowsperpage'] = $cfg['page']['maxrowsperpage']>0 ? $cfg['page']['maxrowsperpage'] : 0;


before line 146 in page.list.php
@esclkm esclkm was assigned
@esclkm esclkm referenced this issue from a commit
@esclkm esclkm fixed #784, #781, #792 6815b2f
@esclkm esclkm closed this
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.