security_question

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

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

WRCNO1 · 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 · 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 · 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 · 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 · 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?

James N · 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 · 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.

James N · 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

)

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 · 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

Tom C · 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!

James N · 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 · 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 · 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 · 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

advertisements