bbAntiSpam: Discuss how to stop web spam

The forum is retired.

bbAntiSpam Forum Index - Textual Confirmation - 1063 Error

Author Message
Team Rival
Guest





Posted: Fri Jun 22, 2007 1:51 pm    Post subject: 1063 Error  

SQL query:

CREATE TABLE `phpbb_textual_confirmation` (

`questions` TEXT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`answers` TEXT NOT NULL AUTO_INCREMENT PRIMARY KEY
) ENGINE = MYISAM

MySQL said:

#1063 - Incorrect column specifier for column 'questions'

I
admin
Site Admin


Joined: 18 Apr 2006
Posts: 805
Location: Saint-Petersburg, Russia

Posted: Sat Jun 23, 2007 1:54 am    Post subject:  

Don't use backticks (`), use apostrophes (').

By the way, you might prefer this way: http://bbantispam.com/forum/viewtopic.php?t=69
_________________
Oleg Parashchenko, bbAntiSpam
Do you love our tools? Please sponsor further development!

Ok.