Welcome to Geeklog, Anonymous Tuesday, December 10 2024 @ 11:58 am EST

Geeklog Forums

STORY_DELETE_ON_EXPIRE


Status: offline

deek

Forum User
Junior
Registered: 06/03/05
Posts: 34
I have installed a geeklog before but this time I have been having some trouble. I installed everything just fine and the SQL database has been populated. When I try to go to the root page I get a SQL error. When I check the log I see this.
Text Formatted Code

Mon Dec 19 17:10:56 2005 - 1054: Unknown column 'STORY_DELETE_ON_EXPIRE' in 'where clause'. SQL in question: SELECT sid,tid,title,expire,statuscode FROM gl_stories WHERE (expire <= NOW()) AND (statuscode = STORY_DELETE_ON_EXPIRE)

 


I could not seem to find a similar posting on the boards. Anyone have any idea?
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
That is a constant defined in config.php. Make sure you're using a config.php that matches your version of Geeklog.

bye, Dirk
 Quote

sp

Anonymous
worried
I have just done a clean install (my 1st), and get the same error:


Text Formatted Code
 more ../../geeklog/logs/error.log
*** dummy entry ***
Tue 06 Jun 2006 13:07:00 PDT - 1054: Unknown column 'STORY_DELETE_ON_EXPIRE' in 'where clause'. SQL in
 question: SELECT sid,tid,title,expire,statuscode FROM gl_stories WHERE (expire <= NOW()) AND (statusc
ode = STORY_DELETE_ON_EXPIRE)
Tue 06 Jun 2006 13:07:53 PDT - 1054: Unknown column 'STORY_DELETE_ON_EXPIRE' in 'where clause'. SQL in
 question: SELECT sid,tid,title,expire,statuscode FROM gl_stories WHERE (expire <= NOW()) AND (statusc
ode = STORY_DELETE_ON_EXPIRE)
Tue 06 Jun 2006 13:11:49 PDT - 1054: Unknown column 'STORY_DELETE_ON_EXPIRE' in 'where clause'. SQL in
 question: SELECT sid,tid,title,expire,statuscode FROM gl_stories WHERE (expire <= NOW()) AND (statusc
ode = STORY_DELETE_ON_EXPIRE)
 



I would imagine that I am using the correct version of config.php, as I downlaoded the tarball of geeklog.net Can someone help me

Any help would be muchly appreciated!! Banging your head
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Check your config.php for parse errors (you may have to switch error messages on first, as explained here).

bye, Dirk
 Quote

sp

Anonymous
done, can't see any probs with config. Turned on error reporting, log is now:

Text Formatted Code
> more error.log
*** dummy entry ***
Tue 06 Jun 2006 16:25:21 PDT - num plugin menu items in header = 2
Tue 06 Jun 2006 16:25:23 PDT - _BLOCK_TEMPLATE[section_block] = blockheader-left.thtml,blockfooter-left.thtml
Tue 06 Jun 2006 16:25:23 PDT - Block template for the header of section_block is: blockheader-left.thtml
Tue 06 Jun 2006 16:25:23 PDT - _BLOCK_TEMPLATE[section_block] = blockheader-left.thtml,blockfooter-left.thtml
Tue 06 Jun 2006 16:25:23 PDT - Block template for the footer of section_block is: blockfooter-left.thtml
Tue 06 Jun 2006 16:25:23 PDT - _BLOCK_TEMPLATE[user_block] = blockheader-left.thtml,blockfooter-left.thtml
Tue 06 Jun 2006 16:25:23 PDT - Block template for the header of user_block is: blockheader-left.thtml
Tue 06 Jun 2006 16:25:23 PDT - _BLOCK_TEMPLATE[user_block] = blockheader-left.thtml,blockfooter-left.thtml
Tue 06 Jun 2006 16:25:21 PDT - Block template for the footer of user_block is: blockfooter-left.thtml
Tue 06 Jun 2006 16:25:21 PDT - _BLOCK_TEMPLATE[events_block] = blockheader-left.thtml,blockfooter-left.thtml
Tue 06 Jun 2006 16:25:23 PDT - Block template for the header of events_block is: blockheader-left.thtml
Tue 06 Jun 2006 16:25:23 PDT - _BLOCK_TEMPLATE[events_block] = blockheader-left.thtml,blockfooter-left.thtml
Tue 06 Jun 2006 16:25:23 PDT - Block template for the footer of events_block is: blockfooter-left.thtml
Tue 06 Jun 2006 16:25:23 PDT - 1054: Unknown column 'STORY_DELETE_ON_EXPIRE' in 'where clause'. SQL in question: SELE
CT sid,tid,title,expire,statuscode FROM gl_stories WHERE (expire <= NOW()) AND (statuscode = STORY_DELETE_ON_EXPIRE)
Tue 06 Jun 2006 16:25:23 PDT - _BLOCK_TEMPLATE[_msg_block] = blockheader-message.thtml,blockfooter-message.thtml
Tue 06 Jun 2006 16:25:23 PDT - Block template for the header of _msg_block is: blockheader-message.thtml
Tue 06 Jun 2006 16:25:23 PDT - _BLOCK_TEMPLATE[_msg_block] = blockheader-message.thtml,blockfooter-message.thtml
Tue 06 Jun 2006 16:25:23 PDT - Block template for the footer of _msg_block is: blockfooter-message.thtml

 


P.S. thanx for helping on this.
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Not sure what you switched on there - I was talking about PHP's error messages, not some advanced logging option in Geeklog.

STORY_DELETE_ON_EXPIRE is a constant, defined in config.php. PHP should replace it with its value (11) in those SQL requests. Undefined constants will come out as text strings (as in your case), which is why I'm assuming it's having a problem with them - a parse error in config.php being the most likely cause.

bye, Dirk
 Quote

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