From admin CP, find a user, from the drop-down menu near the top for that user, do 'find posts by user' and you get
Quote:
Warning: strpos() [function.strpos]: Empty delimiter in [path]/includes/functions_search.php on line 829
Warning: strpos() [function.strpos]: Empty delimiter in [path]/includes/functions_search.php on line 829
|
--------------- Added [DATE]1223994206[/DATE] at [TIME]1223994206[/TIME] ---------------
I am also getting a couple of database errors per minute which look like this:
Quote:
Database error in vBulletin 3.7.2:
Invalid SQL:
INSERT INTO search
(userid, titleonly, ipaddress, personal, query, searchuser, forumchoice, /*prefixchoice,*/ sortby, sortorder, searchtime, showposts, orderedids, dateline, searchterms, displayterms, searchhash, completed)
VALUES
(199144,
0,
'82.45.64.35',
1,
'',
'',
'',
'post.dateline',
'DESC',
0.41381, 1,
'7910162,7909683,7901421,7897556,7897435,7893091,7 891793,7891237,7890849,7890831,7890681,7883569,788 3453,7883405,7879058,7879034,7878857,7878747,78787 01,7873052,7873025,7872710,7872139,7870002,7869307 ,7865412,7865397,7858431,7855677,7854580,7854561,7 854552,7850714,7850693,7849703,7849688,7849004,784 8755,7848736,7848689,7841987,7841959,7841885,78413 84,7841345,7834603,7833936,7833119,7832472,7832123 ,7832111,7827946,7827737,7825843,7825294,7825061,7 824531,7824480,7824437,7822528,7820735,7818312,781 3687,7813676,7810657,7805266,7805174,7805125,78024 52,7793552,7789673,7786793,7786728,7786477,7782994 ,7782960,7781194,7778313,7773823,7773802,7772909,7 772858,7772774,7771517,7769068,7768999,7768966,776 5669,7764148,7764145,7764140,7764128,7764121,77641 14,7764111,7758989,7758968,7749807,7743705,7737046 ,7736969,7732475,7731262,7731233,7731188,7726538,7 726485,7720900,7720785,7720776,7720637,7720591,772 0531,7720440,7720289,7711014,7710978,7708282,77080 17,7707792,7701848,7701797,7698239!
,7698089,7694948,7694687,7694620,7694595,7694518,7 694495,7688325,7688277,7687918,7687759,7687660,768 7625,7684177,7676849,7671353,7660707,7657314,76560 13,7655765,7652852,7647751,7647741,7647460,7647453 ,7647396,7645990,7644340,7642598,7642102,7642011,7 641985,7639370,7639367,7638532,7635655,7635552,763 0940,7629198,7628772,7627899,7627725,7626677,76258 96,7625789,7625778,7623074,7623051,7618844,7618819 ,7618798,7618753,7618718,7615635,7614744,7613102,7 611940,7611906,7609673,7609187,7608659,7607236,760 6473,7605869,7605585,7605558,7605534,7605440,75980 45,7598029,7597878,7597560,7597466,7597393,7595869 ,7595668,7593681,7591317,7589223,7589076,7589063,7 589047,7589030,7588341,7587985,7587606,7586505,758 1381,7581368,7581226,7580732,7580720,7580687,75806 78,7580628,7580580,7574523,7573417,7573332,7573302 ,7570499,7570479,7570475,7570404,7566942,7566921,7 562532,7562417,7562406,7562310,7562212,7561992,756 1600,7561591,7561275,7561232,7561209,7561098,75607 16,7560686,7560315,7559990,7559864,755!
9818,7559679,7559664,7559637,7559531,7552998,75513 79,7550063,7549983,7
549968,7549938,7542743,7542408,7541111,7541097,754 1084,7540205,7540199,7540152,7539856,7539838,75398 02,7539754,7529899,7529880,7529867,7529514,7529478 ,7529415,7529341,7529310,7529249,7529241,7529231,7 528448,7526898,7520976,7520378,7520366,7519948,751 9917,7517303,7517259,7516412,7514267,7513816,75121 22,7511965,7506440,7506431,7506429,7506361,7506348 ,7498172,7498144,7497922,7497541,7497510,7497479,7 495560,7495546,7492065,7491901,7491881,7491869,748 6804,7486783,7486768,7486720,7484166,7484157,74835 47,7483525,7483439,7483430,7482868,7482845,7482831 ,7480220,7480186,7480169,7478760,7476151,7475535,7 475530,7473277,7473249,7473017,7472970,7472940,747 2927,7472913,7472906,7472901,7472893,7461283,74599 90,7459938,7459905,7450408,7448863,7445663,7445648 ,7445616,7445587,7445523,7445087,7445047,7445035,7 444995,7444974,7444963,7444946,7443716,7443704,744 3157,7443134,7442854,7441626,7441502,7439405,74390 61,7439056,7438995,7433513,7433466,7433449,7433438 ,7433420,7430835,7430827,7430812,743076!
2,7430750,7430646,7428899,7426674,7426379,7425996, 7424770,7424739,7424727,7423765,7423747,7423731,74 23676,7423671,7423664,7418334,7418322,7418311,7418 208,7418196,7414469,7414431,7414416,7404690,740464 6,7404622,7404599,7404485,7404448,7402360,7402340, 7402219,7401855,7401838,7401829,7401820,7401818,74 01804,7401790,7401772,7401761,7401752,7401085,7398 252,7398246,7398027,7397717,7395856,7395842,739569 4,7395676,7395675,7395635,7395580,7395564,7391565, 7385480,7385460,7384731,7384632,7384584,7384529,73 84500,7384486,7384475,7382921,7378980,7378900,7378 058,7377876,7370600,7370470,7370438,7368364,736833 9,7368298,7366974,7366863,7366852,7363126,7363116, 7363104,7363096,7363056,7363048,7363047,7363040,73 63033,7361440,7361420,7359385,7357792,7357784,7356 178,7356104,7355478,7355242,7355214,7353450,735122 1,7351183,7351169,7351154,7351093,7351059,7350646, 7350602,7350565,7347493,7345110,7344986,7344941,73 44921,7344901,7343615,7343606,7337949,7337926,7337 907,7337823,7337783',
1223993854,
'a:25:{s:5:\"query\";N;s:10:\"searchuser\";N;s:9:\ "exactname\";N;s:11:\"starteronly\";i:0;s:3:\"tag\ ";N;s:11:\"forumchoice\";a:0:{}s:12:\"prefixchoice \";N;s:11:\"childforums\";i:0;s:9:\"titleonly\";b: 0;s:9:\"showposts\";b:1;s:10:\"searchdate\";N;s:11 :\"beforeafter\";N;s:6:\"sortby\";N;s:9:\"sortorde r\";N;s:9:\"replyless\";N;s:10:\"replylimit\";N;s: 14:\"searchthreadid\";i:0;s:9:\"saveprefs\";N;s:11 :\"quicksearch\";N;s:10:\"searchtype\";i:1;s:7:\"e xclude\";N;s:7:\"nocache\";N;s:4:\"ajax\";i:0;s:11 :\"humanverify\";N;s:6:\"userid\";i:199144;}',
'a:8:{s:5:\"words\";a:1:{i:0;N;}s:9:\"highlight\"; a:1:{i:0;s:0:\"\";}s:6:\"common\";a:0:{}s:5:\"user s\";a:1:{i:199144;s:6:\"Yemeth\";}s:6:\"forums\";a :0:{}s:8:\"prefixes\";a:0:{}s:3:\"tag\";s:0:\"\";s :7:\"options\";a:3:{s:11:\"starteronly\";i:0;s:11: \"childforums\";i:0;s:6:\"action\";s:7:\"process\" ;}}',
'2ebb9cb46ee5005c200207e9e3343161',
1)
### SAVE ORDERED IDS TO SEARCH CACHE ###;
MySQL Error : Duplicate entry '2ebb9cb46ee5005c200207e9e3343161-post.dateline-DESC' for key 2
Error Number : 1062
Request Date : Tuesday, October 14th 2008 @ 03:17:33 PM
Error Date : Tuesday, October 14th 2008 @ 03:17:34 PM
Script : http://www.avforums.com/forums/searc...duser&u=199144
Referrer : http://www.avforums.com/forums/xbox-...-oct-08-a.html
IP Address : 82.45.64.35
Username : Yemeth
Classname : vB_Database_Slave
MySQL Version :
|
--------------- Added [DATE]1224000005[/DATE] at [TIME]1224000005[/TIME] ---------------
Looks like the code is doing an insert onto the slave server causing the duplicate record error. Is this a bug in the code?
This is very urgent as we are having several database errors per minute.
--------------- Added [DATE]1224007861[/DATE] at [TIME]1224007861[/TIME] ---------------
There is also an error when running this:
http://www.avforums.com/forums/searc...duser&userid=1
(the my posts link in the menu)
which gives
Quote:
Warning: strpos() [function.strpos]: Empty delimiter in [path]/includes/functions_search.php on line 829
Warning: strpos() [function.strpos]: Empty delimiter in [path]/includes/functions_search.php on line 829
Warning: strpos() [function.strpos]: Empty delimiter in [path]/includes/functions_search.php on line 829
Warning: strpos() [function.strpos]: Empty delimiter in [path]/includes/functions_search.php on line 829
Warning: strpos() [function.strpos]: Empty delimiter in [path]/includes/functions_search.php on line 829
Warning: strpos() [function.strpos]: Empty delimiter in [path]/includes/functions_search.php on line 829
|
|
10-14-2008, 08:35 AM
Threaded Mode