Portal Forums Calendar Active Threads
Previous Thread
Next Thread
Print Thread
Hop To
MYSQL errors and getting logged out all the time.
#228414 08/18/2009 3:21 AM
Joined: Jul 2007
Posts: 70
Rangiora, North Canterbury, Ne...
NewZealandNZ
Offline
journeyman
NewZealandNZ
journeyman
Offline
Joined: Jul 2007
Posts: 70
Rangiora, North Canterbury, Ne...
Hello Team

Not sure if these errors are making my problem.

Users are complaining that they are getting logged out every now and again.

Is there are setting I need to edit?


SQL Query
[ERROR][Tue, Aug 18 2009 01:13:50 +1200] [] [] Script: /usr/wwwwww/name/newzealandnz/scripts/activetopics.inc.php - Line: 139 
			select	count(t1.TOPIC_ID)
			from	ubbt_TOPICS as t1,
				ubbt_FORUMS as t2
			where	t1.TOPIC_LAST_REPLY_TIME > 1250428430
				and t1.FORUM_ID in ()
				and t1.FORUM_ID = t2.FORUM_ID
				and t2.FORUM_ACTIVE_POSTS = 1
				and t1.TOPIC_IS_APPROVED = 1
				and t1.TOPIC_STATUS <> 'M'
		 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
				and t1.FORUM_ID = t2.FORUM_ID
				and t2.FORUM_ACTIVE_POSTS = 1
				and t1' at line 5
[ERROR][Tue, Aug 18 2009 01:14:35 +1200] [] [] Script: /usr/wwwwww/name/newzealandnz/scripts/activetopics.inc.php - Line: 139 
			select	count(t1.POST_ID)
			from	ubbt_POSTS as t1,
				ubbt_TOPICS as t2,
				ubbt_FORUMS as t3
			where	t1.POST_POSTED_TIME > 1250342075
				and t1.TOPIC_ID = t2.TOPIC_ID
				and t3.FORUM_ACTIVE_POSTS = 1
				and t2.FORUM_ID in ()
				and t2.FORUM_ID = t3.FORUM_ID
				and t1.POST_IS_APPROVED = 1
				and t2.TOPIC_STATUS <> 'M'
		 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
				and t2.FORUM_ID = t3.FORUM_ID
				and t1.POST_IS_APPROVED = 1
				and t2.T' at line 8
[ERROR][Tue, Aug 18 2009 07:35:54 +1200] [] [] Script: /usr/wwwwww/name/newzealandnz/scripts/activetopics.inc.php - Line: 139 
			select	count(t1.POST_ID)
			from	ubbt_POSTS as t1,
				ubbt_TOPICS as t2,
				ubbt_FORUMS as t3
			where	t1.POST_POSTED_TIME > 1249932954
				and t1.TOPIC_ID = t2.TOPIC_ID
				and t3.FORUM_ACTIVE_POSTS = 1
				and t2.FORUM_ID in ()
				and t2.FORUM_ID = t3.FORUM_ID
				and t1.POST_IS_APPROVED = 1
				and t2.TOPIC_STATUS <> 'M'
		 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
				and t2.FORUM_ID = t3.FORUM_ID
				and t1.POST_IS_APPROVED = 1
				and t2.T' at line 8
[ERROR][Tue, Aug 18 2009 07:36:30 +1200] [] [] Script: /usr/wwwwww/name/newzealandnz/scripts/activetopics.inc.php - Line: 139 
			select	count(t1.POST_ID)
			from	ubbt_POSTS as t1,
				ubbt_TOPICS as t2,
				ubbt_FORUMS as t3
			where	t1.POST_POSTED_TIME > 1249932990
				and t1.TOPIC_ID = t2.TOPIC_ID
				and t3.FORUM_ACTIVE_POSTS = 1
				and t2.FORUM_ID in ()
				and t2.FORUM_ID = t3.FORUM_ID
				and t1.POST_IS_APPROVED = 1
				and t2.TOPIC_STATUS <> 'M'
		 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
				and t2.FORUM_ID = t3.FORUM_ID
				and t1.POST_IS_APPROVED = 1
				and t2.T' at line 8
[ERROR][Tue, Aug 18 2009 08:33:47 +1200] [] [] Script: /usr/wwwwww/name/newzealandnz/scripts/activetopics.inc.php - Line: 139 
			select	count(t1.TOPIC_ID)
			from	ubbt_TOPICS as t1,
				ubbt_FORUMS as t2
			where	t1.TOPIC_LAST_REPLY_TIME > 1249936427
				and t1.FORUM_ID in ()
				and t1.FORUM_ID = t2.FORUM_ID
				and t2.FORUM_ACTIVE_POSTS = 1
				and t1.TOPIC_IS_APPROVED = 1
				and t1.TOPIC_STATUS <> 'M'
		 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
				and t1.FORUM_ID = t2.FORUM_ID
				and t2.FORUM_ACTIVE_POSTS = 1
				and t1' at line 5
[ERROR][Tue, Aug 18 2009 08:36:40 +1200] [] [] Script: /usr/wwwwww/name/newzealandnz/scripts/activetopics.inc.php - Line: 139 
			select	count(t1.TOPIC_ID)
			from	ubbt_TOPICS as t1,
				ubbt_FORUMS as t2
			where	t1.TOPIC_LAST_REPLY_TIME > 1249936600
				and t1.FORUM_ID in ()
				and t1.FORUM_ID = t2.FORUM_ID
				and t2.FORUM_ACTIVE_POSTS = 1
				and t1.TOPIC_IS_APPROVED = 1
				and t1.TOPIC_STATUS <> 'M'
		 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
				and t1.FORUM_ID = t2.FORUM_ID
				and t2.FORUM_ACTIVE_POSTS = 1
				and t1' at line 5
[ERROR][Tue, Aug 18 2009 09:02:57 +1200] [] [] Script: /usr/wwwwww/name/newzealandnz/scripts/activetopics.inc.php - Line: 139 
			select	count(t1.POST_ID)
			from	ubbt_POSTS as t1,
				ubbt_TOPICS as t2,
				ubbt_FORUMS as t3
			where	t1.POST_POSTED_TIME > 1249938177
				and t1.TOPIC_ID = t2.TOPIC_ID
				and t3.FORUM_ACTIVE_POSTS = 1
				and t2.FORUM_ID in ()
				and t2.FORUM_ID = t3.FORUM_ID
				and t1.POST_IS_APPROVED = 1
				and t2.TOPIC_STATUS <> 'M'
		 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
				and t2.FORUM_ID = t3.FORUM_ID
				and t1.POST_IS_APPROVED = 1
				and t2.T' at line 8
[ERROR][Tue, Aug 18 2009 09:57:23 +1200] [] [] Script: /usr/wwwwww/name/newzealandnz/scripts/activetopics.inc.php - Line: 139 
			select	count(t1.TOPIC_ID)
			from	ubbt_TOPICS as t1,
				ubbt_FORUMS as t2
			where	t1.TOPIC_LAST_REPLY_TIME > 1249941443
				and t1.FORUM_ID in ()
				and t1.FORUM_ID = t2.FORUM_ID
				and t2.FORUM_ACTIVE_POSTS = 1
				and t1.TOPIC_IS_APPROVED = 1
				and t1.TOPIC_STATUS <> 'M'
		 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
				and t1.FORUM_ID = t2.FORUM_ID
				and t2.FORUM_ACTIVE_POSTS = 1
				and t1' at line 5
[ERROR][Tue, Aug 18 2009 10:46:53 +1200] [] [] Script: /usr/wwwwww/name/newzealandnz/scripts/activetopics.inc.php - Line: 139 
			select	count(t1.TOPIC_ID)
			from	ubbt_TOPICS as t1,
				ubbt_FORUMS as t2
			where	t1.TOPIC_LAST_REPLY_TIME > 1249944413
				and t1.FORUM_ID in ()
				and t1.FORUM_ID = t2.FORUM_ID
				and t2.FORUM_ACTIVE_POSTS = 1
				and t1.TOPIC_REPLIES = 0
				and t1.TOPIC_IS_APPROVED = 1
				and t1.TOPIC_STATUS <> 'M'
		 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
				and t1.FORUM_ID = t2.FORUM_ID
				and t2.FORUM_ACTIVE_POSTS = 1
				and t1' at line 5
[ERROR][Tue, Aug 18 2009 15:20:49 +1200] [] [] Script: /usr/wwwwww/name/newzealandnz/scripts/activetopics.inc.php - Line: 139 
			select	count(t1.POST_ID)
			from	ubbt_POSTS as t1,
				ubbt_TOPICS as t2,
				ubbt_FORUMS as t3
			where	t1.POST_POSTED_TIME > 1249960849
				and t1.TOPIC_ID = t2.TOPIC_ID
				and t3.FORUM_ACTIVE_POSTS = 1
				and t2.FORUM_ID in ()
				and t2.FORUM_ID = t3.FORUM_ID
				and t1.POST_IS_APPROVED = 1
				and t2.TOPIC_STATUS <> 'M'
		 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
				and t2.FORUM_ID = t3.FORUM_ID
				and t1.POST_IS_APPROVED = 1
				and t2.T' at line 8
[ERROR][Tue, Aug 18 2009 15:30:45 +1200] [] [] Script: /usr/wwwwww/name/newzealandnz/scripts/activetopics.inc.php - Line: 139 
			select	count(t1.POST_ID)
			from	ubbt_POSTS as t1,
				ubbt_TOPICS as t2,
				ubbt_FORUMS as t3
			where	t1.POST_POSTED_TIME > 1249961445
				and t1.TOPIC_ID = t2.TOPIC_ID
				and t3.FORUM_ACTIVE_POSTS = 1
				and t2.FORUM_ID in ()
				and t2.FORUM_ID = t3.FORUM_ID
				and t1.POST_IS_APPROVED = 1
				and t2.TOPIC_STATUS <> 'M'
		 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
				and t2.FORUM_ID = t3.FORUM_ID
				and t1.POST_IS_APPROVED = 1
				and t2.T' at line 8
[ERROR][Tue, Aug 18 2009 15:51:32 +1200] [] [] Script: /usr/wwwwww/name/newzealandnz/scripts/activetopics.inc.php - Line: 139 
			select	count(t1.TOPIC_ID)
			from	ubbt_TOPICS as t1,
				ubbt_FORUMS as t2
			where	t1.TOPIC_LAST_REPLY_TIME > 1249962692
				and t1.FORUM_ID in ()
				and t1.FORUM_ID = t2.FORUM_ID
				and t2.FORUM_ACTIVE_POSTS = 1
				and t1.TOPIC_IS_APPROVED = 1
				and t1.TOPIC_STATUS <> 'M'
		 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
				and t1.FORUM_ID = t2.FORUM_ID
				and t2.FORUM_ACTIVE_POSTS = 1
				and t1' at line 5

Best Regards

Danny de Hek - Below is our Office Cam Image

[Linked Image from newzealandnz.co.nz]
Re: MYSQL errors and getting logged out all the time.
NewZealandNZ #228415 08/18/2009 4:55 AM
Joined: Jun 2006
Posts: 9,242
Likes: 1
Aberdeen, WA
R
Rick Offline
Former Developer
Rick
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Aberdeen, WA
Hmm, not too sure on the logout issue. Is it happening to everyone, or just some? If it happens to someone consistently, then perhaps they can turn on the setting so they are always prompted whenever a cookie is modified. So as they browse around the forum, when they get logged out they should see the cookie being modified that contains the user id/session and then can post some details on what they were doing at that time.

On the errors you posted, it appears that someone is trying to visit the active topics list but isn't able to view any forums at all, resulting in the error. Which is a bit strange, since even when logged out, this works as normal.
Re: MYSQL errors and getting logged out all the time.
Rick #228418 08/18/2009 7:20 AM
Joined: Jul 2007
Posts: 70
Rangiora, North Canterbury, Ne...
NewZealandNZ
Offline
journeyman
NewZealandNZ
journeyman
Offline
Joined: Jul 2007
Posts: 70
Rangiora, North Canterbury, Ne...
Thank Rick! only me and another guy who live on the site has notice the logging out.

I think there maybe another program shearing the same kind cookie could that be the case?

Best Regards

Danny de Hek - Below is our Office Cam Image

[Linked Image from newzealandnz.co.nz]

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Bots
by Outdoorking - 04/13/2024 5:08 PM
Can you add html to language files?
by Baldeagle - 04/07/2024 2:41 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
This is not a bug, but a suggestion
by Baldeagle - 04/05/2024 11:25 PM
Is UBB.threads still going?
by Aaron101 - 04/01/2022 8:18 AM
Who's Online Now
0 members (), 502 guests, and 178 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Forum Rules · Mark All Read Contact Us · Forum Help · UBBCentral
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)