security_question

All new MODs released in our MOD Database will be announced in here. All support for released MODs needs to take place in here. No new MODs will be accepted into the MOD Database for phpBB2
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.
TCB2
Registered User
Posts: 4
Joined: Fri Jul 06, 2007 2:24 am

Re: security_question

Post by TCB2 » Fri Jul 06, 2007 3:40 pm

Thanks, that did it, and now it's working perfectly!

WRCNO1
Registered User
Posts: 2
Joined: Thu Jul 05, 2007 9:55 pm

Re: security_question

Post by WRCNO1 » Fri Jul 06, 2007 7:46 pm

Hello, i sorted out my earlier problem, but no i got a new 1 :? ... This is a commands i tried to add to sql:

INSERT INTO phpbb_config(config_name,config_value) VALUES('securityquestion','How many days in a year?');;
INSERT INTO phpbb_config(config_name,config_value) VALUES('securityanswer','365');


And on a stage 3 it pops up with an error:


SQL PROCESSING HALTED

An error was encountered while processing the SQL commands. Further SQL processing has been halted. You may choose to complete the MOD installation anyway and perform the SQL commands manually yourself. However, at this point EM cannot guarantee the MOD will work correctly so you are best off seeking support from the Author before continuing further.

The failed line was:

INSERT INTO phpbb_config(config_name,config_value) VALUES('securityquestion','How many days in a year?');;


SQL ERROR: 1062
Duplicate entry 'securityquestion' for key 1



I tried to insert command manually, but its a same problem it says
"Duplicate entry 'securityquestion' for key 1"

How can i sort this out? Thank you

James N
Registered User
Posts: 1737
Joined: Sat May 20, 2006 12:57 pm
Contact:

Re: security_question

Post by James N » Fri Jul 06, 2007 7:57 pm

The SQL is alread there. Look in your config table and the last 2 entries will be for this MOD (or look at the configeration part of the admin panel and the Q&A will be there)

dutchct
Registered User
Posts: 7
Joined: Wed Feb 22, 2006 7:39 pm

Re: security_question

Post by dutchct » Fri Jul 06, 2007 9:00 pm

sorry guys, another sql question..

I've got

Code: Select all

INSERT INTO phpbb_config (config_name, config_value) VALUES ('securityquestion','How many days in a year?');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('securityanswer','365');
entered into my database, but the question isn't showing up in my admin panel. I can find the entries in phpMyadmin and when I try to enter them again, predictably tells me about a duplicate.

Any suggestions?

dutchct
Registered User
Posts: 7
Joined: Wed Feb 22, 2006 7:39 pm

Re: security_question

Post by dutchct » Fri Jul 06, 2007 9:22 pm

Ok, I have it figured out:

for some reason in my database i have a bunch of weird tables, of course phpbb_xxx, but i also have phpb2_xxx, phpb3_xxx, phpb4_xxx and phpb2_4xxx.

I added the entry to all the config tables for each and its good now.

stokerpiller
Registered User
Posts: 1934
Joined: Wed Feb 28, 2007 8:06 pm

Re: security_question

Post by stokerpiller » Fri Jul 06, 2007 11:16 pm

This one looks nice :)

But it would be even more nice if you where able to use severable possible answers.
Myvipcode does that.
Is it possible in this mod?
I am done with phpBB

James N
Registered User
Posts: 1737
Joined: Sat May 20, 2006 12:57 pm
Contact:

Re: security_question

Post by James N » Sat Jul 07, 2007 7:30 am

Glad you got it sorted dutchct
stokerpiller wrote:This one looks nice :)

But it would be even more nice if you where able to use severable possible answers.
Myvipcode does that.
Is it possible in this mod?
No its it as it would make it more complicated than it is now.

FWIW I have had this MOD on my forum in various stages of development for around 10 months and never had a spambot join.

stokerpiller
Registered User
Posts: 1934
Joined: Wed Feb 28, 2007 8:06 pm

Re: security_question

Post by stokerpiller » Sat Jul 07, 2007 7:46 am

It is a great mod.

What I meant was that not all people is good at spelling.

Lets say that the question is:
In which month do we celebrate Christmas?

Possible answers:
december, December, desember, Desember etc.
I am done with phpBB

James N
Registered User
Posts: 1737
Joined: Sat May 20, 2006 12:57 pm
Contact:

Re: security_question

Post by James N » Sat Jul 07, 2007 8:03 am

I get your point, but allowing for every eventuality would be imposable (also non English speakers might put the answer in their own language :lol: )

If you make the question relevant to your forum (eg if the forum is about a game, the Q could be 'Name the game that this forum is for' ) That way everyone should get it right

rasin
Registered User
Posts: 9
Joined: Thu Oct 27, 2005 12:51 pm

Re: security_question

Post by rasin » Sat Jul 07, 2007 11:44 pm

hi guys done everything that supposed to and when trying to inject sql i get these errors

SQL query:

INSERT INTO phpbb_config( config_name, config_value )
VALUES (

'securityquestion', 'How many days in a year?'
);



MySQL said:

#1062 - Duplicate entry 'securityquestion' for key 1

SQL query:

SELECT *
FROM Array
WHERE CONCAT_WS( "-", config_name, config_value ) = "securityquestion"
ORDER BY config_name, config_value
LIMIT 0 , 30

MySQL said:

#1146 - Table 'www****_phpb1.Array' doesn't exist

any ideas on how to solve this wee little problem regards rasin

User avatar
Tom C
Registered User
Posts: 23
Joined: Sun Jul 08, 2007 3:05 am
Location: Cleveland, OH (USA)

Re: security_question

Post by Tom C » Sun Jul 08, 2007 3:40 am

Good job. Installed with EasyMod no problem. Refreshed the ACP page, clicked Configuration, and there it was. Very nice. Thank you. :)

P.S., I only added one word from the default:

How many days in a year?
to
How many days in a leap year?

That'll keep the Bots busy! :D
Image

James N
Registered User
Posts: 1737
Joined: Sat May 20, 2006 12:57 pm
Contact:

Re: security_question

Post by James N » Sun Jul 08, 2007 7:49 am

rasin wrote:hi guys done everything that supposed to and when trying to inject sql i get these errors

SQL query:

INSERT INTO phpbb_config( config_name, config_value )
VALUES (

'securityquestion', 'How many days in a year?'
);



MySQL said:

#1062 - Duplicate entry 'securityquestion' for key 1

SQL query:

SELECT *
FROM Array
WHERE CONCAT_WS( "-", config_name, config_value ) = "securityquestion"
ORDER BY config_name, config_value
LIMIT 0 , 30

MySQL said:

#1146 - Table 'www****_phpb1.Array' doesn't exist

any ideas on how to solve this wee little problem regards rasin
Check your config section of the database. Is the Q&A there? The 'Duplicate Entry' note implies it is

runegirlie
Registered User
Posts: 173
Joined: Sun Jul 31, 2005 6:08 pm

Re: security_question

Post by runegirlie » Sun Jul 08, 2007 7:54 am

James N wrote:If you ignore lines 215 - 228 of my MOD then the profile fields will be left alone, but the rest will install and work as described
Sure enough! Thanks much .. yet another fine security mod to keep those little bas$!%@s from posting porn on my forum :)

rasin
Registered User
Posts: 9
Joined: Thu Oct 27, 2005 12:51 pm

Re: security_question

Post by rasin » Sun Jul 08, 2007 10:26 am

James N wrote:
rasin wrote:hi guys done everything that supposed to and when trying to inject sql i get these errors

SQL query:

INSERT INTO phpbb_config( config_name, config_value )
VALUES (

'securityquestion', 'How many days in a year?'
);



MySQL said:

#1062 - Duplicate entry 'securityquestion' for key 1

SQL query:

SELECT *
FROM Array
WHERE CONCAT_WS( "-", config_name, config_value ) = "securityquestion"
ORDER BY config_name, config_value
LIMIT 0 , 30

MySQL said:

#1146 - Table 'www****_phpb1.Array' doesn't exist

any ideas on how to solve this wee little problem regards rasin
Check your config section of the database. Is the Q&A there? The 'Duplicate Entry' note implies it is
thanks for the reply heres what is in the config in the database

Host: localhost
Database: www****_phpb1
Generation Time: Jul 08, 2007 at 06:18 AM
Generated by: phpMyAdmin 2.9.0.2 / MySQL 4.1.21-standard
SQL query: SELECT * FROM `phpbb_config` LIMIT 0, 30 ;
Rows: 30

config_name config_value
config_id 1
board_disable 0
sitename :: Sn!per 7 Clan ::
site_desc :: Dynamic Fighting Force ::
cookie_name phpbb2mysql
cookie_path /
cookie_domain sniper7clan.com
cookie_secure 0
session_length 3600
allow_html 0
allow_html_tags b,i,u,pre,q
allow_bbcode 1
allow_smilies 1
allow_sig 1
allow_namechange 1
allow_theme_create 0
allow_avatar_local 1
allow_avatar_remote 1
allow_avatar_upload 1
enable_confirm 0
allow_autologin 1
max_autologin_time 0
override_user_style 1
posts_per_page 15
topics_per_page 50
hot_threshold 25
max_poll_options 10
max_sig_chars 255
max_inbox_privmsgs 50
max_sentbox_privmsgs 25

i dont see any option here or in the admin section of the forums i am also using a forum template from surreal media will this be causing the problem my site is http://www.sniper7clan.comthankz inadvance
rasin

James N
Registered User
Posts: 1737
Joined: Sat May 20, 2006 12:57 pm
Contact:

Re: security_question

Post by James N » Sun Jul 08, 2007 10:38 am

Thats just the first page. You need to go to page three.

And although your template will not be causing the SQL problem, it might not show the SQ Q&A correctly. Switch to subSilver and see if its there and let me know

Post Reply

Return to “[2.0.x] MOD Database Releases”