Intermittent error when creating a new album

[David Jackie Armstrong]

Has anyone seen this error before, where a user found they were unable to create a new album. Appears to be intermittent as the album was created successfully on a later attempt.

Regards,

David Armstrong

Database server
Server: Localhost via UNIX socket
Server type: MariaDB
Server connection: SSL is not being used Documentation
Server version: 10.3.38-MariaDB-cll-lve - MariaDB Server
Protocol version: 10
User: oldtoysa@localhost
Server charset: cp1252 West European (latin1)

Web server
cpsrvd 11.110.0.5
Database client version: libmysql - mysqlnd 8.1.16
PHP extension: mysqli Documentation curl Documentation mbstring Documentation
PHP version: 8.1.16

2023-08-06 09:38:09 +01:00 --- error: mysqli_sql_exception [ 1064 ]: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'IS NULL' at line 3

/home/oldtoysa/public_html/gallery315/system/libraries/Database_Mysqli.php [ 74 ]
#0 /home/oldtoysa/public_html/gallery315/system/libraries/Database_Mysqli.php(74): mysqli->query()
#1 /home/oldtoysa/public_html/gallery315/system/libraries/Database.php(272): Database_Mysqli_Core->query_execute()
#2 /home/oldtoysa/public_html/gallery315/modules/gallery/libraries/MY_Database.php(48): Database_Core->query()
#3 /home/oldtoysa/public_html/gallery315/system/libraries/Database_Builder.php(973): Database->query()
#4 /home/oldtoysa/public_html/gallery315/system/libraries/Database_Builder.php(933): Database_Builder_Core->execute()
#5 /home/oldtoysa/public_html/gallery315/system/libraries/ORM.php(1150): Database_Builder_Core->count_records()
#6 /home/oldtoysa/public_html/gallery315/modules/gallery/helpers/item.php(370): ORM_Core->count_all()
#7 /home/oldtoysa/public_html/gallery315/modules/gallery/controllers/albums.php(42): item_Core::get_position()
#8 [internal function]: Albums_Controller->show()
#9 /home/oldtoysa/public_html/gallery315/system/core/Kohana.php(302): ReflectionMethod->invokeArgs()
#10 /home/oldtoysa/public_html/gallery315/system/core/Event.php(208): Kohana_Core::instance()
#11 /home/oldtoysa/public_html/gallery315/application/Bootstrap.php(67): Event_Core::run()
#12 /home/oldtoysa/public_html/gallery315/index.php(124): require('/home/oldtoysa/...')
#13 {main}