Welcome to Geeklog, Anonymous Monday, September 26 2022 @ 03:00 am EDT

Geeklog Forums

Forum trouble after update

Page navigation


caio

Anonymous
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
 Quote

Status: offline

Blaine

Forum User
Moderator
Registered: 07/16/02
Posts: 1232
Location:Canada
What is the complete SQL statement in your error.log file?
Geeklog components by PortalParts -- www.portalparts.com
 Quote

Status: offline

caio

Forum User
Newbie
Registered: 10/05/02
Posts: 10
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
 Quote

Status: offline

Blaine

Forum User
Moderator
Registered: 07/16/02
Posts: 1232
Location:Canada
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
 Quote

caio

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

 Quote

caio

Anonymous
caffeinated
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

caio

Anonymous
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

caio

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

Status: offline

Blaine

Forum User
Moderator
Registered: 07/16/02
Posts: 1232
Location:Canada
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
 Quote

Status: offline

caio

Forum User
Newbie
Registered: 10/05/02
Posts: 10
Here we go now...

Text Formatted Code
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!
 Quote

Status: offline

Blaine

Forum User
Moderator
Registered: 07/16/02
Posts: 1232
Location:Canada
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
 Quote

Status: offline

caio

Forum User
Newbie
Registered: 10/05/02
Posts: 10
Geeklog version 1.3.7sr1.
And FORUM version 2.3.1 (upgraded from an older version, can't remember wich)

Cheers,
 Quote

Status: offline

caio

Forum User
Newbie
Registered: 10/05/02
Posts: 10
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 DCool

Thanks for your time and energy!!
 Quote

Status: offline

Blaine

Forum User
Moderator
Registered: 07/16/02
Posts: 1232
Location:Canada
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
 Quote

caio

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

caio

Anonymous
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:

Text Formatted Code
COM_errorLog( $retval->toString(), 1 );
 


What am I missing now?
 Quote

caio

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

 Quote

caio

Anonymous
excited
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
 Quote

caio

Anonymous
stressed
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!
 Quote

caio

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

my advice: RTFM!

 Quote

Page navigation

All times are EDT. The time is now 03:00 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