bbAntiSpam: Discuss how to stop web spam

The forum is retired.

bbAntiSpam Forum Index - Textual Confirmation - could not install textual confirmation

Author Message
Anh
Guest





Posted: Tue Mar 13, 2007 5:10 pm    Post subject: could not install textual confirmation  

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
Guest





Posted: Wed Mar 14, 2007 3:13 am    Post subject:  

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
Site Admin


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

Posted: Wed Mar 14, 2007 3:33 am    Post subject:  

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
Guest





Posted: Wed Mar 14, 2007 1:07 pm    Post subject:  

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
Site Admin


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

Posted: Thu Mar 15, 2007 3:15 am    Post subject:  

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

Error: Access denied for user 'yscr_bbC_cT'@'localhost' to database 'phpbb_3'
...

It's very strange, and I have no idea how it could be so.

The best way is to contact your hoster support and ask to execute the SQL on your behalf.

As an alternative, you can try to install the New Administration Version: http://bbantispam.com/forum/viewtopic.php?t=271
_________________
Oleg Parashchenko, bbAntiSpam
Do you love our tools? Please sponsor further development!

Ok.