Welcome to Geeklog, Anonymous Wednesday, April 24 2024 @ 04:40 am EDT

Geeklog Forums

Static Pages - SQL Error


James

Anonymous
confused
Hello, I'm running 1.5.2. When trying to create a new Static page, we're getting a SQL error. I've checked the error logs on the server, and I'm not seeing anything SQL related.

These are the first Static Pages we've tried to create, and the site was updated from 1.4 to 1.5.2 about a year ago, with some gracious help from Blaine. All of my other plugins seem to be working perfectly, all other functionality is working...the issue seems specific to Static Pages.

Where should I begin to track this issue down? I've looked through all of the plugin code, and nothing is jumping out at me.

Thanks for any insight.

 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Did you check Geeklog's error.log file? The SQL error should be in there.

bye, Dirk
 Quote

James

Anonymous
awake
No I didn't. Thanks Dirk.

Looks like the staticpages table is missing a column: commentcode

I'll try adding it and see what happens.

I'll add it as an integer...should I set a default value?
 Quote

James

Anonymous
:banana:

Thanks Dirk. As usual, you are indeed the man.
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by: James

Looks like the staticpages table is missing a column: commentcode

I'll try adding it and see what happens.

I'll add it as an integer...should I set a default value?


Looks like something went wrong with the update for that plugin. The definition of the missing column is
Text Formatted Code
commentcode tinyint(4) NOT NULL default '0'

bye, Dirk
 Quote

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