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
|