adam/Piwigo
1
0 Fork 0
mirror of https://github.com/Piwigo/Piwigo.git synced 2026-10-30 21:52:00 +01:00
Code Issues 657 Packages Projects Releases Wiki Activity

[user comments] $conf['comments_page_nb_comments'] = 'all' breaks comments admin page #254

New Issue
Open
opened 2026-10-04 23:49:15 +02:00 by adam · 0 comments
adam commented 2026-10-04 23:49:15 +02:00
Owner
Copy link
Copy source

Reported by plg on 26 Mar 2014 23:10

$conf['comments_page_nb_comments'] = 'all' produces:

Warning: [mysql error 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 'all' at line 18

SELECT
c.id,
c.image_id,
c.date,
c.author,
username AS username,
c.content,
i.path,
i.representative_ext,
validated
FROM comments AS c
INNER JOIN images AS i
ON i.id = c.image_id
LEFT JOIN users AS u
ON u.id = c.author_id
WHERE 1=1 AND validated='false'
ORDER BY c.date DESC
LIMIT 0, all
; in include/dblayer/functions_mysqli.inc.php on line 798

Piwigo Bugtracker #3064

**Reported by plg on 26 Mar 2014 23:10** $conf[&#039;comments_page_nb_comments&#039;] = &#039;all&#039; produces: Warning: [mysql error 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 &#039;all&#039; at line 18 SELECT c.id, c.image_id, c.date, c.author, username AS username, c.content, i.path, i.representative_ext, validated FROM comments AS c INNER JOIN images AS i ON i.id = c.image_id LEFT JOIN users AS u ON u.id = c.author_id WHERE 1=1 AND validated=&#039;false&#039; ORDER BY c.date DESC LIMIT 0, all ; in include/dblayer/functions_mysqli.inc.php on line 798 [Piwigo Bugtracker #3064](http://piwigo.org/bugs/view.php?id=3064) <!-- github-sync-id:97226772 -->
Sign in to join this conversation.
No Branch/Tag Specified
Labels
No items
No labels
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
adam (Adam Wojcieszonek)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: adam/Piwigo#254