[Abe1]

Originally Posted by scorpsy

Does anyone know why I am getting this error & how I can fix it I know it is in my database but I can't find it anywhere. I love this hack

Database error in vBulletin 3.6.1:

Invalid SQL:

INSERT INTO setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, validationcode, blacklist, product)
VALUES
(
'post_thanks_on_off',
'post_thanks',
'0',
'1',
'boolean',
'yesno',
10,
0,
1,
'',
0,
'post_thanks'
),
(
'post_thanks_forum_off',
'post_thanks',
'',
'',
'free',
'',
20,
0,
1,
'',
0,
'post_thanks'
),
(
'post_thanks_forum_first_all',
'post_thanks',
'0',
'0',
'boolean',
'yesno',
30,
0,
1,
'',
0,
'post_thanks'
),
(
'post_thanks_forum_first',
'post_thanks',
'',
'',
'free',
'',
40,
0,
1,
'',
0,
'post_thanks'
),
(
'post_thanks_date_all',
'post_thanks',
'1',
'1',
'boolean',
'yesno',
50,
0,
1,
'',
0,
'post_thanks'
),
(
'post_thanks_date_forum',
'post_thanks',
'',
'',
'free',
'',
60,
0,
1,
'',
0,
'post_thanks'
),
(
'post_thanks_usergroup_using',
'post_thanks',
'',
'',
'free',
'',
70,
0,
1,
'',
0,
'post_thanks'
),
(
'post_thanks_user_useing',
'post_thanks',
'',
'',
'free',
'',
80,
0,
1,
'',
0,
'post_thanks'
),
(
'post_thanks_reputation',
'post_thanks',
'0',
'0',
'number',
'',
90,
0,
1,
'',
0,
'post_thanks'
),
(
'post_thanks_post_count',
'post_thanks',
'0',
'0',
'boolean',
'yesno',
100,
0,
1,
'',
0,
'post_thanks'
),
(
'post_thanks_delete_own',
'post_thanks',
'1',
'1',
'boolean',
'yesno',
110,
0,
1,
'',
0,
'post_thanks'
),
(
'post_thanks_poster_button',
'post_thanks',
'0',
'0',
'boolean',
'yesno',
130,
0,
1,
'',
0,
'post_thanks'
);

MySQL Error : Duplicate entry 'post_thanks_on_off' for key 1
Error Number : 1062
Date : Saturday, September 16th 2006 @ 03:08:33 PM

Are going from vb3.0 -> vb3.6?

There are 4 quaries you must run first. You can find them in the vb3.5 version download.