# /var/www/slims9/lib/Opac.php:346^ mysqli_sql_exception {#86 #message: "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 '-20' at line 1" #code: 1064 #file: "/var/www/slims9/lib/contents/librarian.inc.php" #line: 45 #sqlstate: "42000" : { { include … ›// query librarian data
›$librarian_q = $dbs->query('SELECT * FROM user WHERE user_type IN (1,2) ORDER BY user_type DESC LIMIT 20 OFFSET ' . $offset);
›if ($librarian_q->num_rows > 0) {
} { SLiMS\Opac->loadFileContent() … › ›include LIB . 'contents/' . $this->path . '.inc.php';
›$this->matchPath = true;
: { "/var/www/slims9/lib/contents/librarian.inc.php" } } { SLiMS\Opac->handle(string $path) … ›->loadPluginPath() // Plugin first
›->loadFileContent() // or from lib/contents/
›->loadDbContent() // or from database
} { {closure} … ›$Opac->onWeb(function($Opac){
›$Opac->handle('p')->orWelcome();
›})->onCli();
} { SLiMS\Opac->onWeb(Closure $callback) … ›{
›if (!isCli()) $callback($this);
›return $this;
} { ›// Path process or show welcome page
›$Opac->onWeb(function($Opac){
›$Opac->handle('p')->orWelcome();
} } }
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 '-20' at line 1