Database error in vBulletin 4.2.2:
Invalid SQL:
SELECT
cms_article.contentid,
cms_article.pagetext AS message,
cms_node.nodeid,
cms_node.url,
cms_node.publishdate,
cms_nodeinfo.title,
cms_article.previewimage,
thread.replycount
FROM cms_article AS cms_article
INNER JOIN cms_node AS cms_node ON ( cms_node.contentid = cms_article.contentid )
INNER JOIN cms_nodeinfo AS cms_nodeinfo ON ( cms_nodeinfo.nodeid = cms_node.nodeid )
LEFT JOIN cms_nodecategory AS cms_nodecategory ON ( cms_node.nodeid = cms_nodecategory.nodeid )
LEFT JOIN cms_category AS cms_category ON (cms_nodecategory.categoryid = cms_category.categoryid )
LEFT JOIN thread AS thread ON ( cms_nodeinfo.associatedthreadid = thread.threadid )
WHERE 1=1
AND cms_node.setpublish =1
AND cms_node.publishdate <= 1396456087
AND cms_node.publicpreview =1
ORDER BY nodeinfo.viewcount DESC
LIMIT 10;
MySQL Error : Unknown column 'nodeinfo.viewcount' in 'order clause'
Error Number : 1054
Request Date : Thursday, April 3rd 2014 @ 03:28:07 AM
Error Date : Thursday, April 3rd 2014 @ 03:28:07 AM
Script :
Toorak Times - Socially Aware - Feature Writers
Referrer :
Toorak Times - Socially Aware - St KIlda featured to Pharrell William's joyous song "Happy"
IP Address : 220.244.250.7
Username : Mick Pacholli (Admin)
Classname : vB_Database
MySQL Version : 5.0.96-community-log
Database error in vBulletin 4.2.2:
Invalid SQL:
SELECT
cms_article.contentid,
cms_article.pagetext AS message,
cms_node.nodeid,
cms_node.url,
cms_node.publishdate,
cms_nodeinfo.title,
cms_article.previewimage,
thread.replycount
FROM cms_article AS cms_article
INNER JOIN cms_node AS cms_node ON ( cms_node.contentid = cms_article.contentid )
INNER JOIN cms_nodeinfo AS cms_nodeinfo ON ( cms_nodeinfo.nodeid = cms_node.nodeid )
LEFT JOIN cms_nodecategory AS cms_nodecategory ON ( cms_node.nodeid = cms_nodecategory.nodeid )
LEFT JOIN cms_category AS cms_category ON (cms_nodecategory.categoryid = cms_category.categoryid )
LEFT JOIN thread AS thread ON ( cms_nodeinfo.associatedthreadid = thread.threadid )
WHERE 1=1
AND cms_node.setpublish =1
AND cms_node.publishdate <= 1396458368
AND cms_node.publicpreview =1
ORDER BY nodeinfo.viewcount DESC
LIMIT 10;
MySQL Error : Unknown column 'nodeinfo.viewcount' in 'order clause'
Error Number : 1054
Request Date : Thursday, April 3rd 2014 @ 04:06:08 AM
Error Date : Thursday, April 3rd 2014 @ 04:06:08 AM
Script :
Toorak Times Database Error
Referrer :
IP Address : 157.55.33.109
Username : Unregistered
Classname : vB_Database
MySQL Version :
There seem to be a lot of versions of this mate.
Database error in vBulletin 4.2.2:
Invalid SQL:
SELECT
cms_article.contentid,
cms_article.pagetext AS message,
cms_node.nodeid,
cms_node.url,
cms_node.publishdate,
cms_nodeinfo.title,
cms_article.previewimage,
thread.replycount
FROM cms_article AS cms_article
INNER JOIN cms_node AS cms_node ON ( cms_node.contentid = cms_article.contentid )
INNER JOIN cms_nodeinfo AS cms_nodeinfo ON ( cms_nodeinfo.nodeid = cms_node.nodeid )
LEFT JOIN cms_nodecategory AS cms_nodecategory ON ( cms_node.nodeid = cms_nodecategory.nodeid )
LEFT JOIN cms_category AS cms_category ON (cms_nodecategory.categoryid = cms_category.categoryid )
LEFT JOIN thread AS thread ON ( cms_nodeinfo.associatedthreadid = thread.threadid )
WHERE 1=1
AND cms_node.setpublish =1
AND cms_node.publishdate <= 1396458308
AND cms_node.publicpreview =1
ORDER BY nodeinfo.viewcount DESC
LIMIT 10;
MySQL Error : Unknown column 'nodeinfo.viewcount' in 'order clause'
Error Number : 1054
Request Date : Thursday, April 3rd 2014 @ 04:05:08 AM
Error Date : Thursday, April 3rd 2014 @ 04:05:08 AM
Script :
Toorak Times Database Error
Referrer :
IP Address : 157.55.33.109
Username : Unregistered
Classname : vB_Database
MySQL Version :