#65 missing date?

closed
nobody
index (20)
5
2000-12-27
2000-12-24
Anonymous
No

I get this error on the initial slash page. I believe I have everything set up, although I'm still checking.

Database error:

Invalid SQL: SELECT psl_story.story_id,
psl_story.title,
date_format(psl_story.time, "%W %M %d %h %i %p") AS dateformat,
psl_story.intro_text,
psl_story.body_text,
psl_story.dept,
psl_story.hits,
psl_author.author_name,
psl_author.url,
psl_topic.image,
psl_topic.width,
psl_topic.height,
psl_topic.alt_text,
psl_topic.topic_name,
psl_topic.topic_id,
psl_commentcount.count as cmtcount FROM psl_story,
psl_author,
psl_topic,
psl_topic_lut,
psl_commentcount WHERE psl_story.story_id = psl_commentcount.count_id
AND psl_story.user_id = psl_author.author_id
AND psl_story.story_id = psl_topic_lut.story_id
AND psl_topic_lut.topic_id = psl_topic.topic_id AND psl_story.story_id = psl_section_lut.story_id
AND psl_section_lut.section_id = psl_section.section_id
AND psl_section.section_name = '' AND psl_story.story_id = psl_topic_lut.story_id
AND psl_topic_lut.topic_id = psl_topic.topic_id
AND psl_topic.topic_name = '' AND psl_author.author_name = '' AND >= to_days(time) AND ((psl_story.title LIKE '%%')
OR (psl_story.intro_text LIKE '%%')
OR (psl_story.body_text LIKE '%%')) ORDER BY time DESC LIMIT 0, 20

MySQL Error: 1064 (You have an error in your SQL syntax near '>= to_days(time) AND ((psl_story.title LIKE '%%') OR (psl_' at line 27)
Please contact the webmaster and report the exact error message.
Session halted.

Discussion

  • Joe Stewart

    Joe Stewart - 2000-12-26

    This problem has been fixed since the release of RC-3.
    Story.class and Block_render_query.class need to be updated from CVS.

    You could probably choose not to show any "query" type blocks and everything would display OK.

     
  • Ajay Sharma

    Ajay Sharma - 2000-12-27
    • status: open --> closed
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks