Welcome to Geeklog, Anonymous Saturday, August 31 2024 @ 11:43 pm EDT
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.
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?
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?
12
8
Quote
sp
Anonymous
![worried worried](https://www.geeklog.net/forum/image_set/moods/worried.gif)
I have just done a clean install (my 1st), and get the same error:
*** 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
Any help would be muchly appreciated!!
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 Can someone help me](http://www.geeklog.net/images/smiles/help.gif)
Any help would be muchly appreciated!!
![Banging your head Banging your head](http://www.geeklog.net/images/smiles/banghead.gif)
10
10
Quote
sp
Anonymous
done, can't see any probs with config. Turned on error reporting, log is now:
*** 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.
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.
6
8
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
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
11
9
Quote
All times are EDT. The time is now 11:43 pm.
- 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