#1 2009-09-24 9:50 pm

CrimsonSprite

Member

Registered: 2009-09-24

Posts: 2

SQL Error

Thank you so much for creating this SQL query for the phpbb forum.  I imported the query, but I'm getting an error. 

SQL query:

INSERT IGNORE INTO `phpbb_banlist`
VALUES (
'', '', '1dbc9af', 'NULL'
)

MySQL said: Documentation
#1136 - Column count doesn't match value count at row 1

Could you please tell me how to correct this so I can finish running the query?

Thank you.

sford999

Member

Registered: 2009-04-24

Posts: 8

Re: SQL Error

Thats not even the correct format for an MYSQL "INSERT"

It should be something like this:

INSERT INTO `table_name` (column_1, column_2, column_3) VALUES ('value_1', 'value_2', 'value_3');

CrimsonSprite

Member

Registered: 2009-09-24

Posts: 2

Re: SQL Error

How can I fix this?  I downloaded the SQL file provided by this site.

Mitch

Member

From: Brooklyn, NY

Registered: 2009-02-25

Posts: 8

Re: SQL Error

I'm having the same problem anyone?

diabolic.bg

Member

From: Bulgaria, Eastern Europe

Registered: 2008-11-03

Posts: 589

Website

Re: SQL Error

Much simpler to install ZB Block and he will verify all addresses that are trying to register or loggin without touching your DB.

http://www.spambotsecurity.com/zbblock.php

---

Funiest jokes and pics

Mitch

Member

From: Brooklyn, NY

Registered: 2009-02-25

Posts: 8

Re: SQL Error

Thanks for the suggestion but rather use this works great so far.
getting back on topic this is the error I get

SQL query:

-- Now banned IPs
INSERT IGNORE INTO `phpbb_banlist`
VALUES (
'', '', '1dbc9af', 'NULL'
);

MySQL said: Documentation
#1136 - Column count doesn't match value count at row 1

this is the line of sql code it gets stuck on first query: for
-- Now banned IPs

INSERT IGNORE INTO `phpbb_banlist` VALUES ('', '', '1dbc9af', 'NULL');

diabolic.bg

Member

From: Bulgaria, Eastern Europe

Registered: 2008-11-03

Posts: 589

Website

Re: SQL Error

Thanks for the suggestion but rather use this works great so far.
getting back on topic this is the error I get

SQL query:

-- Now banned IPs
INSERT IGNORE INTO `phpbb_banlist`
VALUES (
'', '', '1dbc9af', 'NULL'
);

MySQL said: Documentation
#1136 - Column count doesn't match value count at row 1

this is the line of sql code it gets stuck on first query: for
-- Now banned IPs

INSERT IGNORE INTO `phpbb_banlist` VALUES ('', '', '1dbc9af', 'NULL');

Do you have a MySQL backup? If yes, restore your table from backup.

---

Funiest jokes and pics

Mitch

Member

From: Brooklyn, NY

Registered: 2009-02-25

Posts: 8

Re: SQL Error

Will that fix it?
Should I reload it?

Edited:
I deleted the table restored same problem
I even deleted table banlist and restored banlist from a new copy of phpbb3.05 and same error. also with copys from my other forums.

not happy at the moment had to delete 5 spammers in the last hour.

On my other forums (phpbb3) I use a mod that uses the code from stop forums spam and spamBot and resulted in 0 spammers and 0 Bots.
on the forum I have the problem with can't use those mods because the site is a Styles site and I would have to do 60 edits for the forum and keep a spare copy of the style for downloads so that means I would have to edit 2 copy's of 60 styles everytime there is a change to the styles.

Last edited by Mitch (2009-10-10 12:53 am)

diabolic.bg

Member

From: Bulgaria, Eastern Europe

Registered: 2008-11-03

Posts: 589

Website

Re: SQL Error

P.S. SpambotSecurity.com is also a stylesheeted site.

Fallout Vault BG and Vic-land are stylesheeted sites too.

---

Funiest jokes and pics

Mitch

Member

From: Brooklyn, NY

Registered: 2009-02-25

Posts: 8

Re: SQL Error

Thanks for the sugestions
For now i would rather fix the SQL
I can't beleave no one else is having this problem I tried it on a new install of phpBB3.05 and same problem exists.

zaphod

Jägermonster

From: USA

Registered: 2008-11-22

Posts: 2,985

Website

Re: SQL Error

Oh, sorry, I thought someone had attacked your site, and performed an scramble of your MySQL data via injection.

You are just having problems importing.

If it had been a MySQL injection attack, then my script that diabolic has been pushing, would have helped. But in this case, I see both diabolic and I mis-understood, my appologies. I will attempt to delete my previous posts.

Zap

---

Get Protected, Stay Protected...
With ZB Block, GNU/GPL Freeware Anti-Spam/Anti-Hack protection for your php based website.

Little boxes in the server farm, little boxes running php...

Mitch

Member

From: Brooklyn, NY

Registered: 2009-02-25

Posts: 8

Re: SQL Error

don't delete it might help someone else

Mitch

Member

From: Brooklyn, NY

Registered: 2009-02-25

Posts: 8

Re: SQL Error

The person that provided the SQL to insert the spammer list into our phpBB3 forums can you Please help us with this error?