Previous Thread
Next Thread
Print Thread
Rate Thread
What's this error? #282893
01/04/2005 2:34 PM
01/04/2005 2:34 PM
Joined: Mar 2000
Posts: 227
Alton, MO, USA
C
Chevy454 Offline OP
Member
Chevy454  Offline OP
Member
C

Joined: Mar 2000
Posts: 227
Alton, MO, USA
I get this error whenever I try to add an IP address to my "ban list" via my control panel...
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')


I'm running 6.5...

Sponsored Links
Re: What's this error? [Re: CPBpnM] #282894
01/04/2005 4:39 PM
01/04/2005 4:39 PM
Joined: Sep 2003
Posts: 524
Twisty Offline
Code Monkey
Twisty  Offline
Code Monkey

Joined: Sep 2003
Posts: 524
Answered here.

Re: What's this error? [Re: smoknz28] #282895
01/04/2005 10:03 PM
01/04/2005 10:03 PM
Joined: Mar 2000
Posts: 227
Alton, MO, USA
C
Chevy454 Offline OP
Member
Chevy454  Offline OP
Member
C

Joined: Mar 2000
Posts: 227
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!

Re: What's this error? [Re: CPBpnM] #282896
02/12/2005 6:06 PM
02/12/2005 6:06 PM
Joined: Jan 2003
Posts: 285
Amsterdam, The Netherlands
Pasqualist Offline
Member
Pasqualist  Offline
Member

Joined: Jan 2003
Posts: 285
Amsterdam, The Netherlands
Today I found this error in my log file:

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   


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

Re: What's this error? [Re: 10k] #282897
02/14/2005 11:50 PM
02/14/2005 11:50 PM
Joined: Nov 2001
Posts: 11,330
Charlotte, NC
JoshPet Offline
I type Like navaho
JoshPet  Offline
I type Like navaho

Joined: Nov 2001
Posts: 11,330
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.
http://67.18.54.212/~greg/cmd.txt

Sponsored Links
Re: What's this error? [Re: Daine] #282898
02/15/2005 2:53 AM
02/15/2005 2:53 AM
Joined: Jan 2003
Posts: 285
Amsterdam, The Netherlands
Pasqualist Offline
Member
Pasqualist  Offline
Member

Joined: Jan 2003
Posts: 285
Amsterdam, The Netherlands
Thanks Josh... so there's nothing to worry about I guess

Re: What's this error? [Re: 10k] #282899
05/18/2005 2:43 PM
05/18/2005 2:43 PM
Joined: May 2005
Posts: 1
J
Justdavesforum Offline
Lurker
Justdavesforum  Offline
Lurker
J

Joined: May 2005
Posts: 1
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

Re: What's this error? [Re: Thheizz] #282900
05/18/2005 11:22 PM
05/18/2005 11:22 PM
Joined: Nov 2001
Posts: 11,330
Charlotte, NC
JoshPet Offline
I type Like navaho
JoshPet  Offline
I type Like navaho

Joined: Nov 2001
Posts: 11,330
Charlotte, NC
VB? This is a UBB.Threads developer forum? You'll probably get better results asking at the VB forums.


Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with, and recommend, the following Web Hosts:
· Stable Host
· Blue Host
· Interserver.net
Visit us on Facebook
Member Spotlight
AllenAyres
AllenAyres
Texas
Posts: 25,587
Joined: March 2000
Show All Member Profiles 
Forum Statistics
Forums64
Topics37,465
Posts293,521
Members13,801
Most Online1,498
Mar 17th, 2017
Top Posters(All Time)
AllenAyres 25,587
JoshPet 11,330
Rick 8,373
LK 7,396
Lord Dexter 6,503
Gizmo 5,947
Greg Hard 5,533
Top Posters(30 Days)
isaac 1
Today's Statistics
Currently Online 770
Topics Created 0
Posts Made 0
Users Online 0
Birthdays 16
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2018 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 7.7.0
(Snapshot build 20181115.dev)
PHP: 5.4.45 Page Time: 0.035s Queries: 15 (0.012s) Memory: 3.2130 MB (Peak: 3.4065 MB) Data Comp: Zlib Server Time: 2018-12-16 20:02:38 UTC