While executing query "SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, u.bio, u.user_timezone, u.user_occ, u.user_interests, u.user_session_time, u.user_allow_viewonline, u.user_level, p.*, pt.post_text, pt.post_subject FROM df_bbposts p, df_users u, df_bbposts_text pt
WHERE p.topic_id = 31
AND pt.post_id = p.post_id
AND u.user_id = p.poster_id
ORDER BY p.post_time ASC
LIMIT -1, 1"
the following error occured: 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 '-1, 1' at line 7
In: /data/WWW1/htdocs/urban-zone/htdocs/modules/Forums/viewtopic.php on line: 319
User id: 1
Pretty much always from bots by the looks of it, but it was happening in v9.2 and still happens in v9.3.
The error is caused by line 63 in modules/Forums/viewtopic.php
I have df.org sql errors mailed to me and I can say it never happened to us, weird, no such behaviour has been seen here.
Those are not real bots, it's users toolbars or installable deamons crawling the web for the Chinese company.
Hostnames are also fake as all Baidu bots IP's fails hostname verification such as a inverse dns query (iquery, obsolete as per rfc), forward dns query, or briefly ip -> hostname -> ip.
Does respect robot.txt, but logs are infested by this user-agent.
.:: I met php the 03 December 2003 :: Unforgettable day! ::.
Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
CloudLinux / Apache 2.4 LSAPI / MySQLi 5.6 / PHP 5.6 / DCVS
Joined: Jun 29, 2004
Unfortunately I've deleted previous emails and obviously not had any since I applied the fix, but I don't think it was the same bot every time, I just never bothered reporting it before because it was always bots.
Would it help if I undo the fix so some more errors are generated, so I can let you know bot / IP details?