Posted on: 08/15/04 02:17pm
By: Anonymous (caio)
After I upgraded my forum plugin for geeklog to the latest version, everyone gets this error after trying to post a message (all topics):
"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 'WHERE (type = 'forum') AND (date
It's like the forum forgot the rest of the error? Anyway looks like a database thing. I have followed all the steps to upgrade, but then again we're all human.
Appreciating all suggestions!!
My site is 809k.com
Forum trouble after update
Posted on: 08/15/04 02:39pm
By: Blaine
What is the complete SQL statement in your error.log file?
Forum trouble after update
Posted on: 08/18/04 02:16am
By: caio
Here it goes:
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 'ORDER BY date ASC LIMIT 100' at line 1 SQL in question: SELECT *,unix_timestamp(date) AS nice_date FROM gl_comments WHERE sid = '' AND pid = ORDER BY date ASC LIMIT 100
Thank you Blaine
Forum trouble after update
Posted on: 08/18/04 06:05pm
By: Blaine
That may not be the correct SQL error as it is referring to the gl_comments table. Stories/Articles and some plugins like the filemgmt plugin use the comments table but the forum does not.
Forum trouble after update
Posted on: 08/19/04 09:19am
By: Anonymous (caio)
I'm pretty sure it is the right error, since I deleted the old error.log file and put an empty one before attempting to post the message on the forum. After that, it was the only message on the log file.
It keeps repeating every time one tries to post:
Wed Aug 18 22:05:43 2004 - 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 'WHERE (type = 'forum') AND (date
This is the error, kkeeps repeating.
Now I notice that it's not showing the line number or the FROM variable.
Forum trouble after update
Posted on: 08/19/04 09:22am
By: Anonymous (caio)
Forget the previous error, I missed a few characters at the end. Here it is now:
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 'WHERE (type = 'forum') AND (date
Forum trouble after update
Posted on: 08/19/04 09:24am
By: Anonymous (caio)
I'm sorry Blaine, looks like the forum is cutting out
"
is what goes after "AND (date "
[QUOTE BY= caio] Forget the previous error, I missed a few characters at the end. Here it is now:
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 'WHERE (type = 'forum') AND (date
[/QUOTE]
Forum trouble after update
Posted on: 08/19/04 01:38pm
By: Anonymous (caio)
The deal is it's the same error. Do you think it's because I'm running an earlier version of Geeklog?
Forum trouble after update
Posted on: 08/19/04 03:26pm
By: Blaine
Your current error is releated to the forum but you have not posted the complete error as it appears in the error.log file.
The message that appears on the screen is not the complete error.
Also you can include the error message in code tags to prevent the forum form interpretting the quotes. Use the code button when posting the message.
Forum trouble after update
Posted on: 08/25/04 03:30pm
By: caio
Here we go now...
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 'WHERE (type = 'forum') AND (date < unix_timestamp() - 0)' at li SQL in question: DELETE FROM WHERE (type = 'forum') AND (date < unix_timestamp() - 0)
Thanks for your suggestions!
Forum trouble after update
Posted on: 08/25/04 03:46pm
By: Blaine
Hum .. well the TABLE name is missing in that SQL statment but I can not find any SQL call close to that in all of the plugin code.
What version of the plugin and geeklog are you running?
Forum trouble after update
Posted on: 08/28/04 06:03pm
By: caio
Geeklog version 1.3.7sr1.
And FORUM version 2.3.1 (upgraded from an older version, can't remember wich)
Cheers,
Forum trouble after update
Posted on: 08/28/04 06:07pm
By: caio
By the way, that's the error I get in the error.log (without the TABLE name as you say,) now I'm thinking perhaps the upgrade script I ran when upgrading failed to create the new tables (I think this version had some new tables or did some changes to the D
Thanks for your time and energy!!
Forum trouble after update
Posted on: 08/28/04 06:17pm
By: Blaine
Ok - well that version of GL is pretty old. I'm guessing 2+ years old 1.3.10 is about to be released
The archive is for 1.3.9 and works on 1.3.8 but I've done no testing on 1.3.7.
Forum trouble after update
Posted on: 09/08/04 07:06pm
By: Anonymous (caio)
Because the site [809k] is around 2 yrs old... and I dont remember upgrading the main system
I'd better get the new version (when it's out) and try to fix everything then!
Forum trouble after update
Posted on: 11/10/04 10:06am
By: Anonymous (caio)
Hello I'm back now upgraded to 1.3.9
But now i'm getting this:
Fatal error: Call to a member function on a non-object in /path-to-public-html-goes-here/lib-common.php on line 3268
And that line, in the lib-common file, says:
COM_errorLog( $retval->toString(), 1 );
What am I missing now?
Forum trouble after update
Posted on: 11/10/04 10:09am
By: Anonymous (caio)
It's me again. I have another question, since I already upgraded the database to this version, and I still have the older geeklog installation in the server, can I turn that one back on and keep working like that? Or will the database changes affect the whole deal? I'm a bit worried now...
Forum trouble after update
Posted on: 11/10/04 03:37pm
By: Anonymous (caio)
guys... I think I did it... on my own!
i managed to make it work (please don't ask me how) by changing a few settings in the config.php
Just when I thought I was dead!!
I love geeklog and these emoticons too
Forum trouble after update
Posted on: 11/10/04 11:02pm
By: Anonymous (caio)
Now the Gallery's style is now messed up. Not showing the layout at all. I must dig deeper to find this solution. Any ideas will be appreciated!
Forum trouble after update
Posted on: 11/11/04 03:04am
By: Anonymous (caio)
And now after a day full of struggle I managed to make everything work every so smoothly again. Thanks to Geeklog ...
my advice: RTFM!
Forum trouble after update
Posted on: 11/17/04 10:55am
By: caio
Sorry for all the spam
Just want to congratulate the makers of geeklog and all things in it.. it's an amazing system and the best part is it's open source. I _finally_ managed to upgrade everything successfully (even the Gallery) and it's all working wonders now hehe...
And thanks