Quote:
Originally Posted by Sunka
Hi NLP-er...
Now something to have fun with this night 
2 errors 
(sorry for my english language, but I am shure that you will understand me what I am trying to say)- Yesterday, my server automaticly ban my IP because high traffic on cron job for tags...I
mannualy decrese number of threads to scan in 1 loop (I do not remember how much, but half of default value)
This is my forum stats:- Threads: 1,701
- Posts: 14,399
- Today (tonight) I have upgraded my forum from v3.8.3 to v3.8.4 and database error come because of something in database related with this MOD. I have to uninstall this MOD, to at least finnish update of my forum! So, till you correct problems, I am sorry, but I have to not install this MOD again.
This is error which show during upgrade to v3.8.4
Step 1) Import latest options (Step 1 of 5)
Code:
Database error in vBulletin 3.8.4:
Invalid SQL:
INSERT INTO setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder,
advanced, volatile, validationcode, blacklist, product)
VALUES
(
'threadtagging',
'tagging',
'1',
'1',
'boolean',
'yesno',
10,
0,
1,
'',
0,
'vbulletin'
),
(
'tagminlen',
'tagging',
'3',
'3',
'integer',
'',
20,
0,
1,
'',
0,
'vbulletin'
),
(
'tagmaxlen',
'tagging',
'25',
'25',
'integer',
'',
30,
0,
1,
'',
0,
'vbulletin'
),
(
'tagbadwords',
'tagging',
'',
'',
'free',
'textarea',
31,
0,
1,
'',
0,
'vbulletin'
),
(
'taggoodwords',
'tagging',
'',
'',
'free',
'textarea',
32,
0,
1,
'',
0,
'vbulletin'
),
(
'tagdelimiter',
'tagging',
'',
'',
'free',
'',
35,
0,
1,
'',
0,
'vbulletin'
),
(
'tagmaxthread',
'tagging',
'25',
'25',
'integer',
'',
40,
0,
1,
'',
0,
'vbulletin'
),
(
'tagmaxstarter',
'tagging',
'5',
'5',
'integer',
'',
50,
0,
1,
'',
0,
'vbulletin'
),
(
'tagmaxuser',
'tagging',
'3',
'2',
'integer',
'',
60,
0,
1,
'',
0,
'vbulletin'
),
(
'tagforcelower',
'tagging',
'1',
'1',
'boolean',
'yesno',
70,
0,
1,
'',
0,
'vbulletin'
),
(
'tagcloud_tags',
'tagging',
'70',
'70',
'integer',
'',
400,
0,
1,
'',
0,
'vbulletin'
),
(
'tagcloud_levels',
'tagging',
'5',
'5',
'integer',
'',
410,
0,
1,
'',
0,
'vbulletin'
),
(
'tagcloud_cachetime',
'tagging',
'30',
'30',
'integer',
'',
420,
0,
1,
'',
0,
'vbulletin'
),
(
'tagcloud_usagehistory',
'tagging',
'365',
'365',
'integer',
'',
425,
0,
1,
'',
0,
'vbulletin'
),
(
'tagcloud_usergroup',
'tagging',
'2',
'2',
'integer',
'usergroupextra\r\n-1|live_permission_check\r\n0|no_permission_check',
427,
0,
1,
'',
0,
'vbulletin'
),
(
'tagcloud_searchcloud',
'tagging',
'1',
'1',
'boolean',
'yesno',
440,
0,
1,
'',
0,
'vbulletin'
),
(
'tagcloud_searchhistory',
'tagging',
'30',
'30',
'integer',
'',
450,
0,
1,
'',
0,
'vbulletin'
);
MySQL Error : Duplicate entry 'tagminlen' for key 1
Error Number : 1062
Request Date : Wednesday, August 12th 2009 @ 12:36:02 AM
Error Date : Wednesday, August 12th 2009 @ 12:36:03 AM
Script : ********
Referrer : **********
IP Address : *********
Username :
Classname : vB_Database
MySQL Version : 5.0.81-community-log
|
Ok. I know what is gooing on and already have solution - not good for users, so I wait for response from vB staff.
The reason is bacause this mod is using aliases to native vB settings - thanks that you can configure everything in one place.
Unfortunatelly it seems that when you make alias vB just updates setting values in DB so it will be only in one place. This is still ok, but... But during update vB inserts all settings without IGNORE and thats why we have problems with updates vB when this mod is installed.
I can just remove aliases - it will be possible to update vB, but you will have to look options for min, max tag length and max thread tags in other place (definied by vB).
Right now I'm still wayting for response from vB staff is it possible to use settings aliases or vB is too limited for that.
So solution will be very soon. Please be patience  If you uninstall this mod you will loose whole tags propositions history. It's not harmful but can cost you some additional clicking for propositions disapproval. If you feel that can wait 1-3 hours then just wait for new release
|
More Information