FUDforum: Bug Reports » Problem with persistant connections

Home » FUDforum Development » Bug Reports » Problem with persistant connections

Show: Today's Messages :: Polls :: Message Navigator

Problem with persistant connections [message #5263]

Sun, 25 August 2002 13:30

nEVeRmOre

Messages: 17
Registered: August 2002
Location: Dallas, Texas, USA

Karma: 0

Junior Member

I get the following error when I have persistant connections enabled and so do most of my users in testing:

query failed: %( SELECT fud21_announce.subject, fud21_announce.text FROM fud21_announce INNER JOIN fud21_ann_forums ON fud21_announce.id=fud21_ann_forums.ann_id AND fud21_ann_forums.forum_id=1 WHERE fud21_announce.date_started<='20020825' AND fud21_announce.date_ended>='20020825' )% because %( Unknown column 'fud21_annoug_bodate_started' in 'where clause' )%

Can you think of anything which might be causing this?

Report message to a moderator

Re: Problem with persistant connections [message #5266 is a reply to message #5263]

Sun, 25 August 2002 16:20

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

What version of MySQL are you running, the query itself is fine, the error is quite wrong, since the field mentioned in the error is not even in the query...

FUDforum Core Developer

Report message to a moderator

Re: Problem with persistant connections [message #5278 is a reply to message #5263]

Mon, 26 August 2002 13:05

nEVeRmOre

Messages: 17
Registered: August 2002
Location: Dallas, Texas, USA

Karma: 0

Junior Member

mysql-max-3.23.52-win

Report message to a moderator

Re: Problem with persistant connections [message #5279 is a reply to message #5278]

Mon, 26 August 2002 13:20

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Does running the
SELECT fud21_announce.subject, fud21_announce.text FROM fud21_announce INNER JOIN fud21_ann_forums ON fud21_announce.id=fud21_ann_forums.ann_id AND fud21_ann_forums.forum_id=1 WHERE fud21_announce.date_started<='20020825' AND fud21_announce.date_ended>='20020825'

query manually work correctly?

FUDforum Core Developer

Report message to a moderator

Previous Topic:	second code tag ignored
Next Topic:	illegible message

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 03:07:20 GMT 2024

Total time taken to generate the page: 0.02430 seconds