(no subject)

hi all,

i upgraded my site from 0.65 to 0.70 following all the instructions and
with no errors. but i get the error message when i go t my home page:

Database error:

Invalid SQL: SELECT  psl_story.story_id,
                 psl_story.title,
                 psl_story.date_available AS timestamp,
                 psl_story.intro_text,
                 psl_story.body_text,
                 psl_story.order_no,
                 psl_story.dept,
                 psl_story.hits,
                 psl_story.story_options,
                           psl_author.author_name,
                 psl_author.author_realname,
                 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
1070486260 >= psl_story.date_available ORDER BY
psl_story.order_no DESC, time DESC LIMIT 0, 20


MySQL Error: 1054 (Unknown column 'time' in 'order clause')
Please contact the webmaster and report the exact error message.
Session halted.

i get similar error when i try to reach: Home, Glossary, Archives, Polls,
Mailinglist and About.

i searched the mailinlist archives and saw other people also had this
problem but i couldn't find a solution.

can someone help me?

tia,
pietro.



-------------------------------------------------------
This SF.net email is sponsored by: SF.net Giveback Program.
Does SourceForge.net help you be more productive?  Does it
help you create better code?  SHARE THE LOVE, and help us help
YOU!  Click Here: http://sourceforge.net/donate/