Previous Thread
Next Thread
Print Thread
Hop To
possible bug?
#263692 03/29/2020 5:18 AM
Joined: Jun 2006
Posts: 760
Likes: 5
Morgan Offline OP
Old Hand
OP Offline
Old Hand
Joined: Jun 2006
Posts: 760
Likes: 5
Noticed this error log, could it be a bug?
Thanks
Morgan


Sat, Mar 21 2020 14:57:18 +0000
Script: xxxxx/xxxxx/xxxxx/scripts/postlist.inc.php - Line: 496
SELECT
t1.TOPIC_ID, t1.POST_ID, t2.USER_DISPLAY_NAME, t1.TOPIC_CREATED_TIME, t1.TOPIC_LAST_REPLY_TIME, t1.TOPIC_SUBJECT,
t1.TOPIC_STATUS, t1.TOPIC_IS_APPROVED, t1.TOPIC_ICON, t1.TOPIC_VIEWS, t1.TOPIC_REPLIES, t1.TOPIC_TOTAL_RATES,
t1.TOPIC_RATING, t3.USER_NAME_COLOR, t2.USER_MEMBERSHIP_LEVEL, t1.USER_ID, t1.TOPIC_IS_STICKY, t1.TOPIC_LAST_POSTER_ID,
t1.TOPIC_LAST_POSTER_NAME, t1.TOPIC_LAST_POST_ID, t1.TOPIC_IS_EVENT, t1.TOPIC_HAS_FILE, t1.TOPIC_HAS_POLL, t1.TOPIC_POSTER_NAME, t1.TOPIC_THUMBNAIL, t4.POST_BODY, t3.USER_GROUP_IMAGES
FROM
ubbt_TOPICS AS t1
LEFT JOIN ubbt_USERS AS t2 ON t1.USER_ID = t2.USER_ID
LEFT JOIN ubbt_USER_PROFILE AS t3 ON t1.USER_ID = t3.USER_ID
LEFT JOIN ubbt_POSTS AS t4 ON t1.POST_ID = t4.POST_ID
WHERE
t1.FORUM_ID = 1
AND t1.TOPIC_IS_STICKY = '0'

AND t1.TOPIC_IS_APPROVED = '1'
ORDER BY t1.TOPIC_LAST_REPLY_TIME desc
LIMIT 3.0302802803E+14, 26
- 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 '3.0302802803E+14, 26' at line 17


Morgan Johansson
BritBike Forum
http://www.britbike.com/forums/ubbthreads.php
Re: possible bug?
Morgan #263713 04/02/2020 1:24 PM
Joined: Dec 2003
Posts: 6,130
Likes: 20
Offline
Joined: Dec 2003
Posts: 6,130
Likes: 20
Getting the same error but for maria
Below is one of several of the same error
Quote
Script: /home/sundan21/public_html/forum/scripts/postlist.inc.php - Line: 496
SELECT
t1.TOPIC_ID, t1.POST_ID, t2.USER_DISPLAY_NAME, t1.TOPIC_CREATED_TIME, t1.TOPIC_LAST_REPLY_TIME, t1.TOPIC_SUBJECT,
t1.TOPIC_STATUS, t1.TOPIC_IS_APPROVED, t1.TOPIC_ICON, t1.TOPIC_VIEWS, t1.TOPIC_REPLIES, t1.TOPIC_TOTAL_RATES,
t1.TOPIC_RATING, t3.USER_NAME_COLOR, t2.USER_MEMBERSHIP_LEVEL, t1.USER_ID, t1.TOPIC_IS_STICKY, t1.TOPIC_LAST_POSTER_ID,
t1.TOPIC_LAST_POSTER_NAME, t1.TOPIC_LAST_POST_ID, t1.TOPIC_IS_EVENT, t1.TOPIC_HAS_FILE, t1.TOPIC_HAS_POLL, t1.TOPIC_POSTER_NAME, t1.TOPIC_THUMBNAIL, t4.POST_BODY, t3.USER_GROUP_IMAGES
FROM
ubbt_TOPICS AS t1
LEFT JOIN ubbt_USERS AS t2 ON t1.USER_ID = t2.USER_ID
LEFT JOIN ubbt_USER_PROFILE AS t3 ON t1.USER_ID = t3.USER_ID
LEFT JOIN ubbt_POSTS AS t4 ON t1.POST_ID = t4.POST_ID
WHERE
t1.FORUM_ID = 46
AND t1.TOPIC_IS_STICKY = '0'

AND t1.TOPIC_IS_APPROVED = '1'
ORDER BY t1.TOPIC_LAST_REPLY_TIME desc
LIMIT 1.81816816818E+14, 16
- You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1.81816816818E+14, 16' at line 17

Using v7.7.4
Web Server Apache
PHP Version 7.2.24
MYSQL Version 10.2.31-MariaDB-log
tables set to utf8mb4_general_ci using the included tool

Last edited by Ruben; 04/02/2020 1:29 PM.

Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: possible bug?
Morgan #263714 04/02/2020 3:22 PM
Joined: Jun 2006
Posts: 15,924
Likes: 21
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,924
Likes: 21
These don't seem like legitimate requests; I say that as the "limit" is "1.81816816818E+14" which is throwing the error... It'd appear that invalid data is being passed as the page number in user requests...
Valid: https://www.ubbcentral.com/forums/ubbthreads.php/forums/3/1/bug-reports
Invalid: https://www.ubbcentral.com/forums/ubbthreads.php/forums/3/1.54/bug-reports (see the .)
Invalid: https://www.ubbcentral.com/forums/ubbthreads.php/forums/3/1238762837698623849762345/bug-reports (see the absurdly long page number)

Do you have legitimate users reporting problems with viewing forums, or are you simply just pulling information from SQL logs?

Its entirely possible that this is some bot that sees that the page id is fetched via a URL and is pinging every conceivable page for content, and at some point it gets such a high number that it begins generating errors...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: possible bug?
Morgan #263715 04/02/2020 4:05 PM
Joined: Dec 2003
Posts: 6,130
Likes: 20
Offline
Joined: Dec 2003
Posts: 6,130
Likes: 20
My data comes from the log without a user associated with them
The value in the limit is different on some errors logged
Oh they did occur over 12 seconds for 5 of them some were 1 second apart.

The only complaint with members is the long initial posting time which is excessively long like 60 seconds or more at times.
But that is another story

Last edited by Ruben; 04/02/2020 4:09 PM. Reason: Added Comment

Blue Man Group
There is no such thing as stupid questions. Just stupid answers

Link Copied to Clipboard
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Ubb 7.7.4 Gallery problems
by jjjjj - 05/25/2020 2:35 PM
7.7.4 error after php upgrade to php 7.0
by Ruben - 05/25/2020 1:10 PM
7.7.4 move group all, fails with a error
by Ruben - 05/24/2020 3:07 PM
Grid lines in forum topics list
by Steve C - 05/23/2020 12:09 PM
Who's Online Now
0 members (), 90 guests, and 43 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Amusing Terain Scenics
Amusing Terain Scenics
by isaac, August 19
Sky places
Sky places
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 7.7.4