Re: [phpslash-users] (no subject)

[Matthew L. <lei...@ma...>]

Dear Pietro,

Change "time" to "psl_story.date_available."  Does that work?

--Matt

On Dec 3, 2003, at 4:29 PM, pietro wrote:

> 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/
> _______________________________________________
> phpslash-users mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpslash-users