FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » FUDforum Development » Bug Reports » Query Failed
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Query Failed [message #298] Thu, 31 January 2002 18:21 Go to next message
ill_brain is currently offline  ill_brain   Germany
Messages: 1
Registered: January 2002
Karma: 0
Junior Member
hallo,

i use fudforum 1.10
and i become the following error:

Query Failed: INSERT INTO fud_ses( ses_id, time_sec, data, user_id, sys_id) VALUES ( 'df24ddee40d10aaecb6e0e608866644f', 1012501411, '00000001 anon000000011', 0, '980d69cec927b7567156373aa7b541f4' )
Reason:
From: /forum/index.php

did everyone know what can i do

Report message to a moderator

Re: Query Failed [message #300 is a reply to message #298] Thu, 31 January 2002 20:25 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
ill_brain wrote on Thu, 31 January 2002 1:21 PM

hallo,

i use fudforum 1.10
and i become the following error:

Query Failed: INSERT INTO fud_ses( ses_id, time_sec, data, user_id, sys_id) VALUES ( 'df24ddee40d10aaecb6e0e608866644f', 1012501411, '00000001 anon000000011', 0, '980d69cec927b7567156373aa7b541f4' )
Reason:
From: /forum/index.php

did everyone know what can i do



Is this a persistent error, which occurs every time an anonymous user logs on to the forum?

Did you originally use version 1.0 and then upgraded to 1.1.0? If so, could you give me the md5 of the cookies.inc file or simply attach it to your reply.

FUDforum Core Developer

Report message to a moderator

Re: Query Failed [message #344 is a reply to message #298] Wed, 06 February 2002 09:24 Go to previous messageGo to next message
smac is currently offline  smac   United States
Messages: 4
Registered: February 2002
Karma: 0
Junior Member
I just downloaded FUD_Forum 1.1.1 and installed into my web account that runs MySQL and php. I am trying to get it working and it seems everything got setup correctly however I am geting a :
Query Failed: INSERT INTO fud_ses( ses_id, time_sec, data, user_id, sys_id) VALUES ( '32e2080ed6812129230e44fe24e5756e', 1012985339, '00000001 anon000000011', 0, 'ad4c45fc483b86b40c7f19af136bd0b7' )

error as I bring up the forum - index.php page. Could you help me out. THanks

Report message to a moderator

Re: Query Failed [message #345 is a reply to message #344] Wed, 06 February 2002 16:19 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
smac wrote on Wed, 06 February 2002 4:24 AM

I just downloaded FUD_Forum 1.1.1 and installed into my web account that runs MySQL and php. I am trying to get it working and it seems everything got setup correctly however I am geting a :
Query Failed: INSERT INTO fud_ses( ses_id, time_sec, data, user_id, sys_id) VALUES ( '32e2080ed6812129230e44fe24e5756e', 1012985339, '00000001 anon000000011', 0, 'ad4c45fc483b86b40c7f19af136bd0b7' )

error as I bring up the forum - index.php page. Could you help me out. THanks


Few questions if you don't mind:

1) Are you getting this error when browsing the forum as anonymous user? (not logged in).

2) Which MySQL & PHP version you are using?

3) Could you give me the md5sum of the cookies.inc file or attach it to your reply please?

Thanks.

FUDforum Core Developer

Report message to a moderator

Re: Query Failed [message #346 is a reply to message #298] Wed, 06 February 2002 17:24 Go to previous messageGo to next message
smac is currently offline  smac   United States
Messages: 4
Registered: February 2002
Karma: 0
Junior Member
1. Yes. If I go the forum as anonymous that is the error I get. I have tried to login but the login page also gives me the same error - www.anvil.ws/forum/index.php and www.anvil.ws/forum/login.php

2. You can check out the version of php... Im running by going to www.anvil.ws/test.php - that should bring up a page with the phpinfo. As for MySQL I'm running 3.23.21

3. See attached file


Thanks for your help! Razz
  • Attachment: cookies.inc
    (Size: 7.40KB, Downloaded 1110 times)

Report message to a moderator

Re: Query Failed [message #347 is a reply to message #346] Wed, 06 February 2002 18:07 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
smac wrote on Wed, 06 February 2002 12:24 PM

1. Yes. If I go the forum as anonymous that is the error I get. I have tried to login but the login page also gives me the same error - www.anvil.ws/forum/index.php and www.anvil.ws/forum/login.php

2. You can check out the version of php... Im running by going to www.anvil.ws/test.php - that should bring up a page with the phpinfo. As for MySQL I'm running 3.23.21

3. See attached file


Thanks for your help! Razz


I am trying to replicate this problem right now.

In the mean while, could you please run a short test for me please. Open the cookies.inc file, and find the line which says:

$this->user_id = sprintf("%u", $anon_id);

change it to:

$this->user_id = sprintf("%u", $anon_id);
echo "UID: '".$this->user_id."'<br>n";


Then try to access the index.php page, it may output a line which says UID: followed by a number. Please paste this line in your reply, or if you do not see such a line tell me.

Thanks. I

FUDforum Core Developer

Report message to a moderator

Re: Query Failed [message #351 is a reply to message #298] Wed, 06 February 2002 19:30 Go to previous messageGo to next message
smac is currently offline  smac   United States
Messages: 4
Registered: February 2002
Karma: 0
Junior Member
I replaced:

$this->user_id = sprintf("%u", $anon_id);

with

$this->user_id = sprintf("%u", $anon_id);
echo "UID: '".$this->user_id."'<br>n";

in the cookies.inc file in the save_sec function. When I went back to the website there was no change in the error message I got. I refreshed the page several times with no luck.

One other strange thing that happened is that as I refreshed the page I got a new error:

Warning: Unexpected character in input: '' (ASCII=92) state=1 in GLOBALS.php on line 73

Like someone added a back into the GLOBALS.php file. I'm not sure if that is suppose to happen or not. Hope this helps.

Report message to a moderator

Re: Query Failed [message #352 is a reply to message #351] Wed, 06 February 2002 19:33 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
smac wrote on Wed, 06 February 2002 2:30 PM

I replaced:

$this->user_id = sprintf("%u", $anon_id);

with

$this->user_id = sprintf("%u", $anon_id);
echo "UID: '".$this->user_id."'<br>n";

in the cookies.inc file in the save_sec function. When I went back to the website there was no change in the error message I got. I refreshed the page several times with no luck.

One other strange thing that happened is that as I refreshed the page I got a new error:

Warning: Unexpected character in input: '' (ASCII=92) state=1 in GLOBALS.php on line 73

Like someone added a back into the GLOBALS.php file. I'm not sure if that is suppose to happen or not. Hope this helps.



Could you possibly join irc.openprojects.net port 6667 channel #fudforum on IRC.

It'll make it easier for me to debug this problem if I can talk to you realtime.

Also, does the php warning appear if you comment out the line you've added based on my request?

FUDforum Core Developer

Report message to a moderator

Re: Query Failed [message #353 is a reply to message #352] Wed, 06 February 2002 20:22 Go to previous messageGo to next message
smac is currently offline  smac   United States
Messages: 4
Registered: February 2002
Karma: 0
Junior Member
No Problem

Report message to a moderator

Re: Query Failed [message #354 is a reply to message #353] Wed, 06 February 2002 20:24 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
smac wrote on Wed, 06 February 2002 3:22 PM

No Problem


Okie, I'm there now...

FUDforum Core Developer

Report message to a moderator

Re: Query Failed [message #355 is a reply to message #298] Thu, 07 February 2002 02:21 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
This bug has been resolved and a patched version of the affected file (cookies.inc) will be avaliable in the next stable release.

If you need the patched file, contact me via PM or email and I'll send you the file.

FUDforum Core Developer

Report message to a moderator

  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: GOLBALS.php & Custom_avatars won't delete
Next Topic: Win2K - Fixes to install 1.1.1
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 03 18:45:38 GMT 2024

Total time taken to generate the page: 0.03452 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.1.3.
Copyright ©2001-2023 FUDforum Bulletin Board Software