• Welcome to the Chevereto User Community!

    Here, users from all over the world come together to learn, share, and collaborate on everything related to Chevereto. It's a place to exchange ideas, ask questions, and help improve the software.

    Please keep in mind:

    • This community is user-driven. Always be polite and respectful to others.
    • Support development by purchasing a Chevereto license, which also gives you priority support.
    • Go further by joining the Community Subscription for even faster response times and to help sustain this space

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