Welcome to Geeklog, Anonymous Thursday, January 02 2025 @ 10:45 am EST
Geeklog Forums
Geeklog 1.60sr1 SQL errors
richardbkk
Anonymous
Hello support,
Recently I upgraded to the latest service release 1, from Geeklog 1.60, and found hat the error.log is growing pretty fast.
Tue 04 Aug 2009 12:31:03 ICT - 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 'SET commentcode = '1' WHERE sid = '2005052123402660'' at line 1. SQL in question: UPDATE SET commentcode = '1' WHERE sid = '2005052123402660'
The error.log is actual 250kb with maybe hundreds of lines like this (did not count them).
Did with SR1 changed the MySQL requirement?
We uses PhP 4.4.9 and MySQL 4.1.22-standard.
(Yes we know it is old and needs to be upgraded, but upgrading the server takes a bit longer then we currently have time for...)
Recently I upgraded to the latest service release 1, from Geeklog 1.60, and found hat the error.log is growing pretty fast.
Text Formatted Code
Tue 04 Aug 2009 12:31:03 ICT - 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 'SET commentcode = '1' WHERE sid = '2005052123402660'' at line 1. SQL in question: UPDATE SET commentcode = '1' WHERE sid = '2005052123402660' Tue 04 Aug 2009 12:31:03 ICT - 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 'SET commentcode = '1' WHERE sid = '2005052123402660'' at line 1. SQL in question: UPDATE SET commentcode = '1' WHERE sid = '2005052123402660'
The error.log is actual 250kb with maybe hundreds of lines like this (did not count them).
Did with SR1 changed the MySQL requirement?
We uses PhP 4.4.9 and MySQL 4.1.22-standard.
(Yes we know it is old and needs to be upgraded, but upgrading the server takes a bit longer then we currently have time for...)
9
6
Quote
richardbkk
Anonymous
Happy to know that there is a fix, but do I need to replace the file with that code, do I need add this code, or do I have to search and replace code....
Probably I will figure out what to do, but it is possible that there are less technical users...
Probably I will figure out what to do, but it is possible that there are less technical users...
10
8
Quote
All times are EST. The time is now 10:45 am.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content