bbAntiSpam: Discuss how to stop web spam

[Anh]

I manually edited the php files and copied them to my server. However, I didn't know how to SQL this part.
#
#-----[ SQL ]------------------------------------------
#
CREATE TABLE phpbb_textual_confirmation (
id INTEGER NOT NULL AUTO_INCREMENT,
question TEXT NOT NULL,
answers TEXT NOT NULL,
PRIMARY KEY (id)
);
INSERT INTO phpbb_textual_confirmation(question,answers) VALUES ('Are you human?', 'yes\nja\noui');
INSERT INTO phpbb_textual_confirmation(question,answers) VALUES ('Say hello', 'hello\nhi\nhallo');

This is the reason that the table doesn't exist. I had to do everything manually because I couldn't install easyMOD. Is there a way to create that table and put it on the server? Id so, could you show me how to do it and show me the directory to put it?

Below is my error message.

------------------
Could not insert question/answer pair!

DEBUG MODE

SQL Error : 1146 Table 'phpbb_3.TEXTUAL_CONFIRMATION_TABLE' doesn't exist

INSERT INTO TEXTUAL_CONFIRMATION_TABLE(question,answers) VALUES('Spell 10?','Ten')

Line : 113
File : admin_tc.php
-------------------



Thank you very much.

[Anh]

I got this error message when executing the SQL.

CREATE TABLE phpbb_textual_confirmation ( id INTEGER NOT NULL AUTO_INCREMENT, question TEXT NOT NULL, answers TEXT NOT NULL, PRIMARY KEY (id) );

Error: Access denied for user 'yscr_bbC_cT'@'localhost' to database 'phpbb_3'
INSERT INTO phpbb_textual_confirmation(question,answers) VALUES('Are you human?','yes\nja\noui');

Error: Table 'phpbb_3.phpbb_textual_confirmation' doesn't exist
INSERT INTO phpbb_textual_confirmation(question,answers) VALUES('Say hello','hello\nhi\nhallo');

Error: Table 'phpbb_3.phpbb_textual_confirmation' doesn't exist

[admin]

Hello, I think this will help: http://bbantispam.com/forum/viewtopic.php?t=69
_________________
Oleg Parashchenko, bbAntiSpam
Do you love our tools? Please sponsor further development!

[Anh]

Thanks. But that's the error message I got after running SQL using the db_update.php trick.

I don't know what is wrong with the "user" thing. I logged on as admin.

[admin]

Do you mean that running "db_update.php" produces following error messages?