i was using this hack before when was my forum 3.0.7... i upgrade my forum to 3.5.0 and my members really wanted this hack back and i trying install this hack but it says
Quote:
Database error in vBulletin 3.5.0:
Invalid SQL:
INSERT INTO *******
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)
VALUES
(
'post_thanks_on_off',
'post_thanks',
'1',
'1',
'boolean',
'yesno',
10,
0,
1,
'post_thanks'
),
(
'post_thanks_forum_off',
'post_thanks',
'',
'',
'free',
'',
20,
0,
1,
'post_thanks'
),
(
'post_thanks_forum_first_all',
'post_thanks',
'0',
'0',
'boolean',
'yesno',
30,
0,
1,
'post_thanks'
),
(
'post_thanks_forum_first',
'post_thanks',
'',
'',
'free',
'',
40,
0,
1,
'post_thanks'
),
(
'post_thanks_date_all',
'post_thanks',
'1',
'1',
'boolean',
'yesno',
50,
0,
1,
'post_thanks'
),
(
'post_thanks_date_forum',
'post_thanks',
'',
'',
'free',
'',
60,
0,
1,
'post_thanks'
),
(
'post_thanks_usergroup_using',
'post_thanks',
'',
'',
'free',
'',
70,
0,
1,
'post_thanks'
),
(
'post_thanks_user_useing',
'post_thanks',
'',
'',
'free',
'',
80,
0,
1,
'post_thanks'
),
(
'post_thanks_reputation',
'post_thanks',
'3',
'0',
'number',
'',
90,
0,
1,
'post_thanks'
),
(
'post_thanks_post_count',
'post_thanks',
'1',
'0',
'boolean',
'yesno',
100,
0,
1,
'post_thanks'
),
(
'post_thanks_delete_own',
'post_thanks',
'1',
'1',
'boolean',
'yesno',
110,
0,
1,
'post_thanks'
);
MySQL Error : Duplicate entry 'post_thanks_on_off' for key 1
Error Number : 1062
Date : Friday, November 18th 2005 @ 04:46:07 PM
Script : http://www.***net/forum/admincp/plugin.php
Referrer : http://www.***.net/forum/admincp/plu...?do=productadd
IP Address : 88.111.******
Username : crazyb0y
Classname : vb_database
|
i trying your query things
Quote:
DELETE FROM `setting` WHERE `grouptitle` = 'post_thanks' AND `product` = '';
DELETE FROM `settinggroup` WHERE `grouptitle` = 'post_thanks' AND `product` = '';
DELETE FROM `phrase` WHERE `varname` LIKE '%post_thanks%' AND `product` = '';
DELETE FROM `template` WHERE `title` LIKE '%post_thanks%' AND `product` = '';
|
but it says
An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table '***_****.setting' doesn't exist
please help me i need this hack cos my members doesnt share things anymore without this hack 
thank you
|