Internet Explorer
Internet Explorer is not supported. Please upgrade to a more modern browser.
NamelessMC
strange DB.php error : syntax to use near ''200''
Started by dcnigma
Hey all,
I having some issues but can't find the source of the problem
Just get this error alot in my fatal-log.log
Anyone a idea how to fix it?
Spoiler
MariaDB server version for the right syntax to use near ''200'' at line 1
[2023-07-16, 20:34:52] /XAMPP/xamppfiles/htdocs/core/classes/Database/DB.php(253): SQLSTATE[42000]: Syntax error or access violation: 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 ''200'' at line 1
[2023-07-16, 20:35:52]/XAMPP/xamppfiles/htdocs/core/classes/Database/DB.php(253): SQLSTATE[42000]: Syntax error or access violation: 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 ''200'' at line 1
DB.php(253): SQLSTATE[42000]: Syntax error or access violation: 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 ''200'' at line 1
Hi,
Can you take a screenshot of the full error page please?
Hi,
Here is the log:
https://pastebin.com/zZrZfRrQ
but after some searching I found a post about values not correct in sql so I looked for 200 and I changed it to 150 for websend_settings
| max_displayed_records | 150 |
the logs stopped giving me "200" but now its "150" so I guess that its Websend...
I tried to get Websend 1.1.2 working again, I comment out a few lines in supercrafter100 version and after that it worked. I used to get a php error when I opend the Events screen, after my edit it worked again.
But I recently moved everything to antoher server, I exported my sql db and re-import it.
Everything is working now only the log of websend stays empty. Before the move it was working..