[MOGmartin]

Originally Posted by WxP

Database error in vBulletin 4.0.2:

Invalid SQL:

SELECT
MAX(st.date_clicked) max_d, sd.founded, t.term_value, st.position

FROM seoqueries_terms_stats st

LEFT JOIN seoqueries_data sd
ON st.stid = sd.stid
AND st.page_type = sd.page_type

LEFT JOIN seoqueries_terms t
ON sd.stid = t.stid

WHERE
st.page_type = 'index'
AND
t.ban = 0

GROUP BY
st.stid

ORDER BY
#max_d DESC,
#sd.founded DESC,
sd.founded DESC,
t.term_value ASC;

MySQL Error : Unknown column 't.ban' in 'where clause'
Error Number : 1054
Request Date : Tuesday, February 23rd 2010 @ 09:48:41 AM
Error Date : Tuesday, February 23rd 2010 @ 09:48:41 AM
Script : http://www.forumivirtual.com/***/seo...statistic_home
Referrer : http://www.forumivirtual.com/*/index.php?do=nav
Classname : vB_Database
MySQL Version : 5.1.30

thanks for letting me know, Ive not upgraded to 4.0.2 yet, I will check it out this weekend