You are not logged in.

#1 2006-02-08 23:47:17

ozar
Member
From: USA
Registered: 2005-02-18
Posts: 1,686

Alert: website errors

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

#2 2006-02-13 02:19:56

ozar
Member
From: USA
Registered: 2005-02-18
Posts: 1,686

Re: Alert: website errors

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

#3 2006-02-13 03:10:26

Dusty
Schwag Merchant
From: Medicine Hat, Alberta, Canada
Registered: 2004-01-18
Posts: 5,986
Website

Offline

#4 2006-02-13 05:13:21

iphitus
Forum Fellow
From: Melbourne, Australia
Registered: 2004-10-09
Posts: 4,927

Re: Alert: website errors

Ditto. looks like the board needs a bit o maintenance smile

iphitus

Offline

#5 2006-02-13 05:27:01

Dusty
Schwag Merchant
From: Medicine Hat, Alberta, Canada
Registered: 2004-01-18
Posts: 5,986
Website

Offline

#6 2006-02-13 08:05:01

Jacek Poplawski
Member
From: Poland
Registered: 2006-01-10
Posts: 736
Website

Re: Alert: website errors

Same here sad
But I am happy that it works at all, I was scared yesterday  yikes

Offline

#7 2006-02-13 14:55:39

dtw
Forum Fellow
From: UK
Registered: 2004-08-03
Posts: 4,439
Website

Re: Alert: website errors

Who can fix this?  I know I can't so who can?  Judd?

Offline

#8 2006-02-13 15:19:39

_Gandalf_
Member
Registered: 2006-01-12
Posts: 735

Re: Alert: website errors

dibblethewrecker wrote:

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 ...)

Offline

#9 2006-02-13 15:58:34

Moo-Crumpus
Member
From: Hessen / Germany
Registered: 2003-12-01
Posts: 1,487

Re: Alert: website errors

with MySQL-Admin, you could just repair the table ...


Frumpus addict
[mu'.krum.pus], [frum.pus]

Offline

#10 2006-02-13 16:56:14

Dusty
Schwag Merchant
From: Medicine Hat, Alberta, Canada
Registered: 2004-01-18
Posts: 5,986
Website

Re: Alert: website errors

dibblethewrecker wrote:

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

#11 2006-02-13 20:07:34

ozar
Member
From: USA
Registered: 2005-02-18
Posts: 1,686

Re: Alert: website errors

Dusty wrote:

Donations wouldn't hurt in speeding up this process. 8-)

Dusty

hehe... calls for donations shuts everyone up in a hurry, doesn't it?  wink

Anyway, glad it's working again.   8)


oz

Offline

Board footer

Powered by FluxBB