bbAntiSpam: Discuss how to stop web spam

The forum is retired.

bbAntiSpam Forum Index - Textual Confirmation - "Wrong answer to the Textual Confirmation question.&quo

Author Message
Gerth
Guest





Posted: Wed Jul 11, 2007 2:02 pm    Post subject: "Wrong answer to the Textual Confirmation question.&quo  

I set everything up how it is suppose to be, I inserted the info into my mySQL server and everything. But when I try to make an account no matter what I put in the answer field (even the right answer), it says that the answer is wrong...

I did notice, however, I get this error when I try to change the question that I originally inserted into the mySQL DB:

Code:
Could not insert question/answer pair!

DEBUG MODE

SQL Error : 1054 Unknown column 'answers' in 'field list'

INSERT INTO phpbb_textual_confirmation(question,answers) VALUES('What is 1336+1?','1337')

Line : 113
File : admin_tc.php
Gerth
Guest





Posted: Wed Jul 11, 2007 2:15 pm    Post subject:  

If you need to test it, the forums address is http://forums.guildanxiety.com

Thanks,
Gerth
admin
Site Admin


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

Posted: Thu Jul 12, 2007 2:31 am    Post subject:  

Quote:
SQL Error : 1054 Unknown column 'answers' in 'field list'

Some things went wrong while creating the textual confirmation table: there is no column "answers". Delete the table and re-create it using the db_update script: http://bbantispam.com/forum/viewtopic.php?t=69.
_________________
Oleg Parashchenko, bbAntiSpam
Do you love our tools? Please sponsor further development!
Gerth
Guest





Posted: Thu Jul 12, 2007 8:42 am    Post subject:  

Awesome, thanks man! I wasn't able to do it at first, but then I realized that I forgot to delete my original mySQL DB. After I deleted it, it worked perfectly and I was able to create a new confirm question/answer.

Thanks,
Gerth
admin
Site Admin


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

Posted: Fri Jul 13, 2007 2:17 am    Post subject:  

Nice to hear it! Hope you'll like absence of spam.
_________________
Oleg Parashchenko, bbAntiSpam
Do you love our tools? Please sponsor further development!

Ok.