| Match | Count | SQL | Script |
| SELECT * FROM wanttobuy as A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID AND (A.tags LIKE '%Forexexpert%' OR A.skills LIKE '%Forexexpert%') | 1 | SELECT COUNT(A.wantid) AS total
FROM wanttobuy as A,
categories_wanttobuy B,
seoclerks.members C
WHERE A.active = 1 AND
A.category = B.CATID AND
A.USERID = C.USERID
AND (A.tags LIKE '%Forexexpert%' OR A.skills LIKE '%Forexexpert%') | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID AND (A.tags LIKE '%Forexexpert%' OR A.skills LIKE '%Forexexpert%') ORDER BY A.lastgigedit desc LIMIT 0,40 | 1 | SELECT A.*, B.seo, B.name as categoryname, C.username, C.userlevel, C.lastlogin, C.ip, C.profilepicture
FROM wanttobuy A,
categories_wanttobuy B,
seoclerks.members C
WHERE
A.active = 1 AND
A.category = B.CATID AND
A.USERID = C.USERID
AND (A.tags LIKE '%Forexexpert%' OR A.skills LIKE '%Forexexpert%')
ORDER BY A.lastgigedit desc
LIMIT 0,40 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM wantbids WHERE active=1 AND wantid='31177' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='31177' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM categories | 1 | SELECT * FROM categories | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache() |
| select * from categories_software order by name asc | 1 | select * from categories_software order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetSoftwareCategories() |
| select * from categories_wanttobuy order by name asc | 1 | select * from categories_wanttobuy order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_wantcategories() |
| select * from categories_wanttotrade order by name asc | 1 | select * from categories_wanttotrade order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories() |
| count(*) | sql1 | error_msg |
|---|---|---|
| 1 | INSERT INTO seoclerks.moderator_log (dateline, USERID, editid, type, actiontext, postdata, ipaddress, script, querystring, agent, reason, front_end_mod)
VALUES (UNIX_TIMESTAMP(NOW()), , 666645, 'identity Document Reject', 'identity Document Rejected', 'a:1:{s:4:"lang";s:0:"";}', '', 'cronAIAnalyzeMemDocs.php', '', '', 'Subject: Your identity document "" was rejected on Body: Hi We are sorry to inform you that your identification document has been rejected. Please review the reason for rejection below and resubmit at https://rtest.seoclerks.com/settings/files/identity. Reason for rejection: The file or image you uploaded is broken or corrupt and we are unable to process it. Please try again ensuring the file is not corrupt and is in a supported format.', 1) |
ERROR: 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 ' 666645, 'identity Document Reject', 'identity Document Rejected', 'a:1:{s:4:...' at line 2 rtest.seoclerks.comcronAIAnalyzeMemDocs.php |
| Load | Count | SQL | Max | Min |
