The secure CMS.

Welcome to Geeklog, Anonymous Sunday, December 22 2024 @ 11:51 pm EST

Geeklog Forums

1064: You have an error in your SQL syntax near 'SET rdfupdated = '2002-09-23 17:45:58''

 New Topic  Post Reply
 09/23/02 08:51am (Read 1,699 times)  

erZwo

Anonymous
Hi! After upgrading to geeklog version 1.3.6 i am getting that error, if the (PHP) News block from www.squatty.com is enabled: 1064: You have an error in your SQL syntax near 'SET rdfupdated = '2002-09-23 17:45:58'' at line 1 First the errors were in some news feeds but now there's no information where to look at, even the time increases with every hit then. I tried to delete the newsblock table and reinstalled it without success. I also started the MySQL server successless ... Any Hints? Thx, Miklas
 Quote
 09/23/02 10:41am  
Status: offline

squatty

Forum User
Full Member
Registered: 01/21/02
Posts: 269
Sounds like your lib-database.php is missing the follwoing: $_TABLES['newsblock'] = $_DB_table_prefix . 'newsblock';
In a world without walls and fences, who needs Windows and Gates?
 Quote
 09/23/02 10:57am  

erZwo

Anonymous
Ok, it's fixed ... Wink
 Quote
 09/23/02 04:33pm  
Status: offline

twistedfreak

Forum User
Junior
Registered: 05/08/02
Posts: 29
Sorry, This really has nothing to do with your query but on the XSilver theme this blocks title being so long really messes up the block sizes for the whole page. I suppose there should be away of limiting the Title length to a number of characters.
 Quote
 11/15/02 11:44am  

euripedes

Anonymous
I have a similar error after upgrading...

1064: You have an error in your SQL syntax near 'SET `timestamp` = '20021115143137',`cache` = '

I tried your solution but it didn't fix the problem.

 Quote
 11/25/02 05:28pm  

Anonymous

Anonymous
That's because it has something to do with your MySQL (or whatever SQL database you use) set up. I suggest you talk to your host. Or if you have phpMyAdmin, try to figure it out.
 Quote
 New Topic  Post Reply
All times are EST. The time is now 11:51 pm.
  • 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