bbAntiSpam: Discuss how to stop web spam

The forum is retired.

bbAntiSpam Forum Index - Textual Confirmation - Can anyone help with an error?

Author Message
charlie seligman



Joined: 08 Aug 2007
Posts: 1
Posted: Wed Aug 08, 2007 11:12 am    Post subject: Can anyone help with an error?  
Hi there,

I have installed the Textual Confirmation mod (and created the new SQL table), but when I try and add a question in the admin section of my forum, I receive the following error (also the question box does not appear on the registration screen?):

Could not insert question/answer pair!

DEBUG MODE

SQL Error : 1146 Table 'DSSC.textual_confirmation' doesn't exist

INSERT INTO textual_confirmation(question,answers) VALUES('What is A','b')

Line : 113
File : admin_tc.php

Can anyone help?

All the best,

Charlie
admin
Site Admin


Joined: 18 Apr 2006
Posts: 805
Location: Saint-Petersburg, Russia
Posted: Fri Aug 10, 2007 1:56 am    Post subject:  
For some reason, creation of the table went wrong. Try again using a helper script: http://bbantispam.com/forum/viewtopic.php?t=69.
_________________
Oleg Parashchenko, bbAntiSpam
Do you love our tools? Please sponsor further development!
Dark_Odin
Guest
Posted: Tue Sep 11, 2007 12:09 am    Post subject:  
I tried using the SQL query and using the helper script and I still get the error mentioned above.

Any idea as to why it isn't working?

(Oh, If it's important, the table prefixes in mySQL databases aren't the default (phpbb). They are a different prefix (forum). I dunno if that matters, but I think it might, just not sure how to fix it...)
Dark_Odin
Guest
Posted: Tue Sep 11, 2007 4:52 pm    Post subject:  
Oh and feel free to email me if you like (darkodin (at) enmaruguild.com).

Thanks.
admin
Site Admin


Joined: 18 Apr 2006
Posts: 805
Location: Saint-Petersburg, Russia
Posted: Wed Sep 12, 2007 2:10 am    Post subject:  
The SQL-script knows about prefixes. But you should run it after changing the file "includes/constants.php". Please change the file and execute the script.
_________________
Oleg Parashchenko, bbAntiSpam
Do you love our tools? Please sponsor further development!
Dark_Odin
Guest
Posted: Wed Sep 12, 2007 7:13 pm    Post subject:  
Hmmm, I verified that the includes/constants line was in there and I'm still getting the same error:

Quote:
Could not insert question/answer pair!

DEBUG MODE

SQL Error : 1146 Table 'enmaruguild_forum.forum_textual_confirmation' doesn't exist

INSERT INTO forum_textual_confirmation(question,answers) VALUES('Test','test')

Line : 113
File : admin_tc.php
Dark_Odin
Guest
Posted: Wed Sep 12, 2007 7:46 pm    Post subject:  
Well I got it to work.

When I saw the error, I decided to try my theory and it fixed it. For whatever reason, it didn't like my table prefixes. so I edited my SQL query to look like this:

Quote:
CREATE TABLE forum_textual_confirmation (
id INTEGER NOT NULL AUTO_INCREMENT,
question TEXT NOT NULL,
answers TEXT NOT NULL,
PRIMARY KEY (id)
);
INSERT INTO forum_textual_confirmation(question,answers) VALUES ('Are you human?', 'yes\nja\noui');
INSERT INTO forum_textual_confirmation(question,answers) VALUES ('Say hello', 'hello\nhi\nhallo');


Just replaced phpbb (the old prefix) with my table prefix (forum).

Works great now, nice mod!
admin
Site Admin


Joined: 18 Apr 2006
Posts: 805
Location: Saint-Petersburg, Russia
Posted: Thu Sep 13, 2007 2:16 am    Post subject:  
I'm happy to hear everything is ok now, and I'm sorry I didn't suggest to change the prefix: I decided you used the sql-script "updated.php" instead of running the queries manually.
_________________
Oleg Parashchenko, bbAntiSpam
Do you love our tools? Please sponsor further development!
Guest
Posted: Sat Oct 06, 2007 2:53 pm    Post subject:  
errrrrrr.... i hane had the same problem in the past,
now. i work out because of this post. Smile
admin
Site Admin


Joined: 18 Apr 2006
Posts: 805
Location: Saint-Petersburg, Russia
Posted: Sun Oct 07, 2007 2:29 am    Post subject:  
Quote:
i work out because of this post.

I'm happy to hear it!
_________________
Oleg Parashchenko, bbAntiSpam
Do you love our tools? Please sponsor further development!

Ok.