FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » Query Failed
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Query Failed [message #298] Thu, 31 January 2002 13:21 Go to next message
ill_brain is currently offline  ill_brain   Germany
Messages: 1
Registered: January 2002
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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
Re: Query Failed [message #300 is a reply to message #298] Thu, 31 January 2002 15: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
add to buddy list
ignore all messages by this user
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
Re: Query Failed [message #344 is a reply to message #298] Wed, 06 February 2002 04:24 Go to previous messageGo to next message
smac is currently offline  smac   United States
Messages: 4
Registered: February 2002
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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
Re: Query Failed [message #345 is a reply to message #344] Wed, 06 February 2002 11: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
add to buddy list
ignore all messages by this user
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
Re: Query Failed [message #346 is a reply to message #298] Wed, 06 February 2002 12:24 Go to previous messageGo to next message
smac is currently offline  smac   United States
Messages: 4
Registered: February 2002
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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 566 times)
Re: Query Failed [message #347 is a reply to message #346] Wed, 06 February 2002 13: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
add to buddy list
ignore all messages by this user
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
Re: Query Failed [message #351 is a reply to message #298] Wed, 06 February 2002 14:30 Go to previous messageGo to next message
smac is currently offline  smac   United States
Messages: 4
Registered: February 2002
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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.
Re: Query Failed [message #352 is a reply to message #351] Wed, 06 February 2002 14: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
add to buddy list
ignore all messages by this user
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
Re: Query Failed [message #353 is a reply to message #352] Wed, 06 February 2002 15:22 Go to previous messageGo to next message
smac is currently offline  smac   United States
Messages: 4
Registered: February 2002
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
No Problem
Re: Query Failed [message #354 is a reply to message #353] Wed, 06 February 2002 15: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
add to buddy list
ignore all messages by this user
smac wrote on Wed, 06 February 2002 3:22 PM

No Problem


Okie, I'm there now...


FUDforum Core Developer
Re: Query Failed [message #355 is a reply to message #298] Wed, 06 February 2002 21:21 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
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
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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: Mon Oct 23 15:03:46 EDT 2017

Total time taken to generate the page: 0.00799 seconds