SQL Error : 1016 Can't open file: 'phpbb_search_wordmatch.MY

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
lokirj
Registered User
Posts: 24
Joined: Sun Feb 01, 2004 5:18 pm

SQL Error : 1016 Can't open file: 'phpbb_search_wordmatch.MY

Post by lokirj » Sun Feb 01, 2004 5:26 pm

I saw some topics with this..but dont resolve this problem.
I rapair my table using Phpmyadmin but error back about 10 minutes later.

TABLE: phpbb_search_wordmatch

HOW can i resolve this problem ? version 2.05 have this error ?

Thanks.

================================================
Could not insert new word matches

DEBUG MODE

SQL Error : 1016 Can't open file: 'phpbb_search_wordmatch.MYI'. (errno: 145)

INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) SELECT 55295, word_id, 0 FROM

phpbb_search_wordlist WHERE word_text IN ('fsdf')

Line : 249
File : /home/lokirj/public_html/forums/includes/functions_search.php

================================================

lokirj
Registered User
Posts: 24
Joined: Sun Feb 01, 2004 5:18 pm

Post by lokirj » Sun Feb 01, 2004 6:37 pm

Anyone have a reply for my problem ? :(

arhodes16
Former Team Member
Posts: 1034
Joined: Sun Mar 10, 2002 5:28 pm

Post by arhodes16 » Sun Feb 01, 2004 6:40 pm

All you can do is repair the tables, if it reoccurs regularly you should contact your host as there is most likely a problem with their mySQL server.

lokirj
Registered User
Posts: 24
Joined: Sun Feb 01, 2004 5:18 pm

Post by lokirj » Sun Feb 01, 2004 8:07 pm

How can i update phbb 2.06 to 2.06c ?

What process i need to do ?

User avatar
A_Jelly_Doughnut
Former Team Member
Posts: 34457
Joined: Sat Jan 18, 2003 1:26 am
Location: Where the Rivers Run
Contact:

Post by A_Jelly_Doughnut » Sun Feb 01, 2004 9:23 pm

Just update the changed files: bbcode.php, search.php, groucp.php, and one other...privmsg.php (?) with the updated 2.0.6c files.
A Donut's Blog
"Bach's Prelude (Cello Suite No. 1) is driving Indiana country roads in Autumn" - Ann Kish

lokirj
Registered User
Posts: 24
Joined: Sun Feb 01, 2004 5:18 pm

Post by lokirj » Sun Feb 01, 2004 11:10 pm

Hummm
and the update will resolve my problem ? or not ?

User avatar
A_Jelly_Doughnut
Former Team Member
Posts: 34457
Joined: Sat Jan 18, 2003 1:26 am
Location: Where the Rivers Run
Contact:

Post by A_Jelly_Doughnut » Mon Feb 02, 2004 1:17 am

Most likely not. Arhodes16 gave you all the applicalbe information ;)
A Donut's Blog
"Bach's Prelude (Cello Suite No. 1) is driving Indiana country roads in Autumn" - Ann Kish

lokirj
Registered User
Posts: 24
Joined: Sun Feb 01, 2004 5:18 pm

Post by lokirj » Tue Feb 03, 2004 11:48 am

OK....i will check

lokirj
Registered User
Posts: 24
Joined: Sun Feb 01, 2004 5:18 pm

Post by lokirj » Sat Feb 07, 2004 6:20 pm

My host admin installed new mysql server..
But the error appear again...

Wha is the problem ? :(

in phpmyadmin appear this:

phpbb_search_wordmatch in use

When i repair back to normal...but 10 minutes later ou more back the error. :(

thanks for any help

lokirj
Registered User
Posts: 24
Joined: Sun Feb 01, 2004 5:18 pm

Post by lokirj » Sat Feb 07, 2004 6:24 pm

hummm if i install ver 2.05 this bug over ?

User avatar
A_Jelly_Doughnut
Former Team Member
Posts: 34457
Joined: Sat Jan 18, 2003 1:26 am
Location: Where the Rivers Run
Contact:

Post by A_Jelly_Doughnut » Sat Feb 07, 2004 6:39 pm

A Donut's Blog
"Bach's Prelude (Cello Suite No. 1) is driving Indiana country roads in Autumn" - Ann Kish

lokirj
Registered User
Posts: 24
Joined: Sun Feb 01, 2004 5:18 pm

Post by lokirj » Sat Feb 07, 2004 7:55 pm

OK...
Fix my table....but the error back later again.

:(

What is this ?

User avatar
A_Jelly_Doughnut
Former Team Member
Posts: 34457
Joined: Sat Jan 18, 2003 1:26 am
Location: Where the Rivers Run
Contact:

Post by A_Jelly_Doughnut » Sat Feb 07, 2004 8:11 pm

This is the perfect reason to move web hosts. The problem is caused by overloaded/overcrowded serveders :)
A Donut's Blog
"Bach's Prelude (Cello Suite No. 1) is driving Indiana country roads in Autumn" - Ann Kish

lokirj
Registered User
Posts: 24
Joined: Sun Feb 01, 2004 5:18 pm

Post by lokirj » Sat Feb 07, 2004 8:41 pm

The overloaded/overcrowded cause this error ? why ?

thanks

User avatar
A_Jelly_Doughnut
Former Team Member
Posts: 34457
Joined: Sat Jan 18, 2003 1:26 am
Location: Where the Rivers Run
Contact:

Post by A_Jelly_Doughnut » Sat Feb 07, 2004 9:40 pm

Because mysql gets interrupted with requests, and abandons your table, rendering it useless until it is repaired.
A Donut's Blog
"Bach's Prelude (Cello Suite No. 1) is driving Indiana country roads in Autumn" - Ann Kish

Locked

Return to “2.0.x Support Forum”