Welcome to Geeklog, Anonymous Tuesday, December 24 2024 @ 09:02 am EST

Geeklog Forums

forum centerblock causing mysql error


Status: offline

vadertech

Forum User
Full Member
Registered: 05/26/03
Posts: 329
Yesterday I noticed that 2 GL websites i'm running both started giving the error "An SQL error has occured. Please see error.log for details."

Both error.log files shows:

Thu Mar 24 15:56:29 2005 - 1054: Unknown column 'PID' in 'where clause'. SQL in question: SELECT id,forum,name,date,subject,replies,views,uid,pid FROM gl_forum_topic WHERE PID=0 ORDER BY lastupdated DESC

When I disable the forum centerblock on the index page,the website works fine. Re-enable the centerblock and it errors again.

Has anyone seen this before. I'm guessing it is something with my webhost that would cause the problem on both sites but why would all of a sudden the forum centerblock start causing errors?
GeekLog Hosting, Installations and Upgrades - WWW.AWEHOST.COM - Hosting starts @ only $4.95/mo.
 Quote

Status: Banned

machinari

Forum User
Full Member
Registered: 03/22/04
Posts: 1512
perhaps your host made some upgrades to the database server, which now causes case sensitivity in column names. just a guess cuz I have no idea.
 Quote

Status: offline

vadertech

Forum User
Full Member
Registered: 05/26/03
Posts: 329
Quote by machinari: perhaps your host made some upgrades to the database server, which now causes case sensitivity in column names. just a guess cuz I have no idea.


that was something i thought of as well. i capitalized PID but didn't make a difference. I will speak with my host as well and see.
GeekLog Hosting, Installations and Upgrades - WWW.AWEHOST.COM - Hosting starts @ only $4.95/mo.
 Quote

Status: offline

knuff

Forum User
Full Member
Registered: 12/17/04
Posts: 340
Location:Sweden
You don't have Easyfile installed on these sites.

There used to be an issue with the previous version, causing strange behaviours with the forum plugin.

More details can be found here.

Best Regards,
Boris
Vanrillaer.com - our Family Portal
 Quote

Status: offline

vadertech

Forum User
Full Member
Registered: 05/26/03
Posts: 329
Not using easyfile. I am 95% sure it's my host but only 5% sure I can convience them of that.
GeekLog Hosting, Installations and Upgrades - WWW.AWEHOST.COM - Hosting starts @ only $4.95/mo.
 Quote

All times are EST. The time is now 09:02 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