Geeklog Forums

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

What is the complete SQL statement in your error.log file?

---

Geeklog components by PortalParts -- www.portalparts.com

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

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.

---

Geeklog components by PortalParts -- www.portalparts.com

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.

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

I'm sorry Blaine, looks like the forum is cutting out

"
is what goes after "AND (date "

The deal is it's the same error. Do you think it's because I'm running an earlier version of Geeklog?

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.

---

Geeklog components by PortalParts -- www.portalparts.com

Here we go now...


Thanks for your suggestions!

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?

---

Geeklog components by PortalParts -- www.portalparts.com

Geeklog version 1.3.7sr1.
And FORUM version 2.3.1 (upgraded from an older version, can't remember wich)

Cheers,

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!!

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.

---

Geeklog components by PortalParts -- www.portalparts.com

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!

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:



What am I missing now?

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...

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

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!

And now after a day full of struggle I managed to make everything work every so smoothly again. Thanks to Geeklog ...

my advice: RTFM!