iscalio
Joined: 28 Mar 2004
Post Count: 8370
1681589 Potch
0 Soldiers
0 Nation Points
|
Posted: Thu Nov 01, 2007 9:54 pm Post subject: PHP help |
|
|
Does anyone of you know enough PHP to help me? fuji maybe? or Vextor? Anyone?
If someone wants to post or edit in my forum, this error is displayed:
Code: |
Could not delete word list entry
DEBUG MODE
SQL Error : 145 Table './iscalio/phpbb_search_wordlist' is marked as crashed and should be repaired
DELETE FROM phpbb_search_wordlist WHERE word_id IN (85012, 85013, 85014, 85015, 85016, 85017, 85018, 85019, 85020, 85021, 85023, 85024, 85025, 85026, 85027, 85028, 85029, 85030, 85031, 85032, 85033, 85034, 85035, 85036, 85037, 85038, 85039, 85040, 85041, 85042, 85043, 85044, 85045, 85046, 85047, 85048, 85049, 85051, 85052, 85053, 85054, 85055, 85056, 85057, 85058, 85059, 85060, 85061, 85062, 85063, 85064, 85065, 85066, 85067, 85068, 85069, 85070, 85071, 85072, 85073, 85074, 85075, 85076, 85077, 85078, 85079, 85080, 85081, 85082, 85083, 85084, 85085, 85086, 85087, 85088, 85089, 85090, 85092, 85093, 85094, 85095, 85096, 85097, 85098, 85099, 85100, 85101, 85102, 85103, 85104, 85105, 85106, 85107, 85108, 85109, 85110, 85111, 85112, 85113, 85114, 85115, 85116, 85117, 85118, 85119, 85120, 85121, 85122, 85123, 85124, 85125, 85126, 85127, 85128, 85129, 85130, 85131, 85132, 85133, 85134, 85135, 85136, 85137, 85138, 85139, 85140, 85141, 85142, 85143, 85144, 85145, 85146, 85147, 85148, 85149, 85150, 85151, 85152, 85153, 85154, 85155, 85156, 85157, 85158, 85159, 85160, 85161, 85162, 85163, 85164, 85165, 85166, 85167, 85168, 85169, 85170, 85171, 85172, 85173, 85174, 85175, 85176, 85177, 85178, 85179, 85180, 85181, 85182, 85183, 85184, 85185, 85186, 85187, 85188, 85189, 85190, 85192, 85193, 85194, 85195, 85196, 85197, 85198, 85199, 85200, 85201, 85202, 85203, 85204, 85205, 85206, 85207, 85208, 85209, 85210, 85211, 85212, 85213, 85214, 85215, 85216, 85217, 85218, 85219, 85220, 85221, 85222, 85223, 85224, 85225, 85226, 85227, 85228, 85229, 85230, 85232, 85233, 85234, 85235, 85236, 85237, 85238, 85239, 85240, 85241, 85242, 85243, 85244, 85245, 85246, 85247, 85248, 85249, 85250, 85251, 85252, 85253, 85254, 85255, 85256, 85257, 85258, 85259, 85260, 85261, 85262, 85263, 85264, 85265, 85266, 85267, 85268, 85269, 85270, 85271, 85272, 85273, 85274, 85275, 85276, 85277, 85278, 85279, 85280, 85281, 85282, 85283, 85284, 85285, 85286, 85287, 85288, 85289, 85290, 85291, 85292, 85293, 85294, 85295, 85296, 85297, 85298, 85299, 85300, 85301, 85302, 85303, 85304)
Line : 382
File : functions_search.php |
The middle part is of course only an example.
mysqladmin claims that the crashed phpbb_search_wordlist is "in use".
This is what it says when I click on the phpbb_search_wordlist:
If I try to repair it, it says:
Does anyone happen to know how I can fix this?
What would happen if I drop phpbb_search_wordlist?
I tried to run the following script to repair it:
Code: |
<?php
{
header("Location: http://127.0.0.1/");
die();
}
define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'config.php');
// connect to the database server
$db = mysql_connect($dbhost,$dbuser,$dbpasswd);
if (!$db) die("Unable to connect to database!\n");
// select the PHPBB database
mysql_select_db($dbname,$db);
// get a list of tables for this PHPBB
$tablequery = "show tables like '".$table_prefix."%'";
$tablelist = mysql_query($tablequery,$db);
// cycle through them for repair
while ($tar = mysql_fetch_array($tablelist))
{
$tablename = $tar[0];
// output some verbosity for comfort
echo "Now checking and repairing table $tablename ... ";
$repres = mysql_query("REPAIR table $tablename");
$result = mysql_fetch_array($repres);
echo $result['Msg_text'] . "<br>\n";
}
?> |
... but again it didn't work. That's the output:
Code: |
Now checking and repairing table phpbb_auth_access ... OK
Now checking and repairing table phpbb_banlist ... OK
Now checking and repairing table phpbb_categories ... OK
Now checking and repairing table phpbb_config ... OK
Now checking and repairing table phpbb_confirm ... OK
Now checking and repairing table phpbb_disallow ... OK
Now checking and repairing table phpbb_forum_prune ... OK
Now checking and repairing table phpbb_forums ... OK
Now checking and repairing table phpbb_groups ... OK
Now checking and repairing table phpbb_posts ... OK
Now checking and repairing table phpbb_posts_text ... OK
Now checking and repairing table phpbb_privmsgs ... OK
Now checking and repairing table phpbb_privmsgs_text ... OK
Now checking and repairing table phpbb_ranks ... OK
Now checking and repairing table phpbb_search_results ... OK
Now checking and repairing table phpbb_search_wordlist ... Table is already up to date
Now checking and repairing table phpbb_search_wordmatch ... OK
Now checking and repairing table phpbb_sessions ... OK
Now checking and repairing table phpbb_sessions_keys ... OK
Now checking and repairing table phpbb_smilies ... OK
Now checking and repairing table phpbb_themes ... OK
Now checking and repairing table phpbb_themes_name ... OK
Now checking and repairing table phpbb_topics ... OK
Now checking and repairing table phpbb_topics_watch ... OK
Now checking and repairing table phpbb_user_group ... OK
Now checking and repairing table phpbb_users ... OK
Now checking and repairing table phpbb_vote_desc ... OK
Now checking and repairing table phpbb_vote_results ... OK
Now checking and repairing table phpbb_vote_voters ... OK
Now checking and repairing table phpbb_words ... OK
Now checking and repairing table phpbb_xdata_auth ... OK
Now checking and repairing table phpbb_xdata_data ... OK
Now checking and repairing table phpbb_xdata_fields ... OK |
|
|