You are not logged in.
Pages: 1
Just wanted to let whomever is in charge of the site know that I've been getting some errors at times when navigating the site:
Could not insert search results
DEBUG MODE
SQL Error : 1062 Duplicate entry '125334296' for key 1
INSERT INTO phpbb_search_results (search_id, session_id, search_array) VALUES(125334296, 'ad51b5125996bfa96f3b9fa0fb8cdb3d', 'a:7:{s:14:"search_results";s:235:"9122, 10553, 14578, 17598, 17936, 18073, 18194, 18206, 18428, 18456, 18471, 18496, 18501, 18519, 18546, 18561, 18588, 18589, 18590, 18609, 18611, 18613, 18620, 18622, 18623, 18625, 18626, 18631, 18633, 18634, 18635, 18636, 18637, 18638";s:17:"total_match_count";i:34;s:12:"split_search";N;s:7:"sort_by";i:0;s:8:"sort_dir";s:4:"DESC";s:12:"show_results";s:6:"topics";s:12:"return_chars";i:200;}')
Line : 714
File : search.php
oz
Offline
Still getting error messages when I try to search for posts since last visit:
Could not delete old search id sessions
DEBUG MODE
SQL Error : 145 Table './phpbb/phpbb_search_results' is marked as crashed and should be repaired
DELETE FROM phpbb_search_results WHERE session_id NOT IN ('24d26da5b10c3be6642d4552f2f4b484', '896e1050c8ab7969b2c66a93b42539b6', '46c45cf45a4a124b05f7d637bf6e06c8', 'f0716a262ba20a6cf090dacb9b88a585', 'f79fae8bcd40094def42984d3dc0b241', 'ccc0eca0e3c78cdefce43d5f7885c7cf', '8ddd88d1cdf62dafbee1a04cb7c4547e', 'e81c70c53610bce3a6cdb17d6e960404', 'f5063252ffb7d50c6ac654b02efa40b7', 'f0e0b53328879544ee310f004fdcca3c', '27a3c2b1daf6e6eebc853d789cf0fb82', '7f1e36a6dddd56dd61eed90e671e0cd2', 'f965ade35ce26b1aeb4356c1d6ca004e', '3a11fda0c5604ab7bcff58c1642db73a', '0de49b4c598e21cc326d11eda759fc2f', '15de515fb88175d370b7db47143f7619', '5ba002924d569913afdb20949287e319', '1ebe3fbdad0e2951a6070360b2a33953', 'c57a070b775701168596299661bacc8c', '26a6d84cd6a643fade35a35747aa4800', 'dab8fef3e68ae06aa95ea68f4c7d375d', '0870246df27825a99ccba75857787213', '4ae74c98de3bc68b80bd426412baacfe', 'f4f6dd0686ca1ae714e49e8a3b47a345', '9003eb203f993fe486a5e3e71f45148f', 'c187f1c3f6d80da56bc4d9e000a1618c', 'ed53177fa58f4a0408140edbe77c8f17', '8d76b2ae6d34c4c48c284fae6cb31ad6', '02bf0acb843aa2533d544724c01f45ee', '07ea8a510ac4d4e9cb9fbf6c04d09d08', 'cf2e48d882c32e5e40fc3bb4a924e5d9', '38415707149d221ae7d7d374e54fc3c0', '9602ac3b6c02e73f7e7f36adec977c0f', '8ee31da2d69bb70234f3d46b4a8b93c1', '45902f15c899de71e649a4a8c2664616', '41eaab05866b9df04885e08de93d8241', '7768dda3c22c670411159b189cca88ea', '467524203c321928a969e4a570fb17ab', 'fd46b78fb22203c7d1effebf8d637016', 'b4f7d039a7d89ac4608e1153a32f4ba9', 'dd0c9349d255a68e990d3a988b54ea19', 'fab0705022884e322099be92355c1f38', '6f791c39183aff47c78cbd849cadae32', '1f33747bc7e95c4a0667b5612ebea26b', '5135196c677f288996117b5b92b2bfb8', '9dcaa1e23a49f3186dcfe2769cee5d16', '199c5acb23dd1a5ff854f21437b3612d', 'b2461c8ff8b838d1e1190175de15bd7f', '5cc7de28bd212ff2ad6b2ad574fa08f4', '5fcc40cc6c5a4fc346d5c1609da9bf88', 'bf08c3c1e0681f60a60a822af4cd544c', 'c9846dd3464207d43d88bf7493abe175', '1c511eb5019159141c1d42c9d7976353', 'f78753668e6605bdd765df77f80aed97', 'c8f696a5991cac66c2fa98a35bbf9f80', '9a3d0ad704c7e35670f7bebcec629e39', '3d274d5f7f54dd85b4afe4be6685416a', 'b864718fe0b6e867d86c7f2713e31092', '4be3b5f698ad139a75762d8b1b375c88', '21690ae4c7653865afb47dd2eca5f55b', '58371a54b819e0e47af5eb8c6422e89d', '3663e1b73d0dad60d6440609ade2f2d6', '2dab01fd5210bd88f34b662c1cc0f9bb', '049711d9d71bfda3f0b7e34fa6a8456f', '6ed98681cad1b2d25d0652f2a3482675', '393880f4f1a53386c106a6ff09b07acf', 'a2d9dbbb81191280b7388f89f0250548', '67d7549045042b98a3de9cd067a517ab', '41e512154b4716fb089dc236db6edbc1', 'ae1fccece5ff4bdc35a73815288294aa', 'bc03522fade2b803b7c7615937f7fbe7', '6d84833fca003ceaaa6266c4698ba1a6', '16ce2ec8912941a6d20b67c0a8801818', 'f4001098830365f16d9287a325d5349f', '5d879a9d822fb0728b8875c8b3b96de5', '4c7487821a8fdbbdcbce2fb9344d93b7', '31078b4fd612789d4201baab48125781', 'c1a3b3ed0506d5fe01b76af1377167c9', '825912de89b508fe78547da083317b41', 'e98cc803f63c6d4c19887432c9223e9a', '0000d97698c99ce084117fd86d03ff63', '6bea1c9dac8c6303cce40d49c6fc8c89', 'ca66b73f3ad605a6c847c9a27a8e338e', 'fbee4977aa2fc2cf769f566fc978ee67', 'b49596a3d5127d4235eb48479ae31d44', 'c47c80d3006d564fba83d6682a0cd1f1', '0bb9c64515d2d434848afc40eb242e0e', 'a3fce3b0b1375bbfbdee93b64b92d63a', '44b6f73dd05a0a9f28310df55abc252d', 'eb3172f0d45f0bb2926be027aa0270ae', 'a0e483c0348f00aed70aab9778f5858d', '5ec320b3e92c87428b2268dd52911a93', '5f4d1599dbf6718a02a6910d7f75ce94', 'bdd8f7c572e22499e032863356a5e2bf', 'ce7c6dedeb38844bb523965a09d2f229', '4d9f3b807369c76319148fd1b36e266b', 'dd97cb469410b1cb4741ce177494cb8f', 'cf3df4918b0d475b03c0e9db07fdcec7', '1e402d8240b2d70ad695fcfcd04351a9', 'bbdfe61df523e3c1ed1848c997be05f0', '6aa876b8e891dc0f27cd4f4b3a15d765', '0bda9f0615850823f2b6992ed908e7a6', 'aa56a0730d489f90fea0d1b2adba4f9c', '53962fd228e42734bb64ad563bcd092b', '5bfa851ea2baa245cd003283488a0b1e', 'cea4a11f4c49458258ed114c333fb056', '126ad620ada13f33097359667304f3cd', 'a57e9f1024e1ad19ea31b7a1d063505f', '6e1c9073c18ac57e1c0e3e598e4d1725', '300fd970cba3abfb719e687985a989a8', '7688de1c4e57749c859369b6e6d453e9', '9d515276095cd56c61b6a9ae7ec779de', '5c50c387a18a9214469c375dbb27aaab', '2d047c8db23b15f63eb0bb37719fcd2c', 'c6a4e2c46be3ebd94375641cd4920743', 'd59dcfb708068b66a984ea54349d3c5a', '7cb3aaf3b783b9156e9899403bd46751', '4685cab96b8d7de9d59a039786aedba7', 'c670d53e67cea3ed7db9ce70f9c9cac7', 'dc80b7556bc4e044eccceec94067de76', '5bd77c9930e0f5ad3e43c15ba1d3f155', '2988554a02e55cb91100ac4e51cd2a0a', '105406cb2c220eb2854aa6eb285722bd')
Line : 663
File : search.php
oz
Offline
yep. hard to miss
Dusty
Offline
Ditto. looks like the board needs a bit o maintenance
iphitus
Offline
its the web servers
Offline
Same here
But I am happy that it works at all, I was scared yesterday
Offline
Who can fix this? I know I can't so who can? Judd?
Offline
Who can fix this? I know I can't so who can? Judd?
Whomever has an access to MySQL, If you have FTP access you can install yourself phpmyadmin, backup and then empty 'phpbb_search_results' table... in case the table was marked as "Table already in use" which i faced on my forum serval times due to crashing... you need to re-create the stucture of this table (drop table; creat table ...)
[My Blog] | [My Repo] | [My AUR Packages]
Offline
with MySQL-Admin, you could just repair the table ...
Frumpus ♥ addict
[mu'.krum.pus], [frum.pus]
Offline
Who can fix this? I know I can't so who can? Judd?
Yeah, that guy... :-) First the servers go out, then when they come up, this error occurs.... happened before. Hopefully will be better when they upgrade the servers. Donations wouldn't hurt in speeding up this process. 8-)
Dusty
Offline
Donations wouldn't hurt in speeding up this process. 8-)
Dusty
hehe... calls for donations shuts everyone up in a hurry, doesn't it?
Anyway, glad it's working again. 8)
oz
Offline
Pages: 1