• Welcome to the Chevereto user community!

    Here users from all over the world gather around to learn the latest about Chevereto and contribute with ideas to improve the software.

    Please keep in mind:

    • 😌 This community is user driven. Be polite with other users.
    • 👉 Is required to purchase a Chevereto license to participate in this community (doesn't apply to Pre-sales).
    • 💸 Purchase a Pro Subscription to get access to active software support and faster ticket response times.

Fatal error [42000]: SQLSTATE when using Random

Status
Not open for further replies.

denully

Chevereto Member
Some times when i use the Random link, like 1 out of 5 times, it hits this error:

Fatal error [42000]: SQLSTATE[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 ') AND (album_privacy = 'public' OR album_privacy IS NULL) ORDER BY RAND() LIMIT ' at line 1
Triggered in /lib/G/classes/class.db.php at line 174

Stack trace:
#0 /lib/G/classes/class.db.php(174): PDOStatement->execute()
#1 /lib/G/classes/class.db.php(191): G\DB->exec()
#2 /app/routes/route.index.php(60): G\DB->fetchSingle()
#3 /lib/G/classes/class.handler.php(204): G\Handler->{closure}(G\Handler)
#4 /lib/G/classes/class.handler.php(100): G\Handler->processRequest()
#5 /app/loader.php(178): G\Handler->__construct(Array)
#6 /index.php(21): include_once('........l/app/loader.php')

suggestions ? :)
 
Status
Not open for further replies.
Back
Top