Restore database after crash Restore database after crash
 

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Main Menu

Restore database after crash

Started by rumbaya, February 11, 2006, 03:00:13 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

rumbaya

Hi there,

I have to reinstall a new system after a disk crash (an old IBM 15 Go, RIP).
Nothing funny, but everything seems to works well, except my coppermine gallery  :-[

I have
-re-installed the same OS, Debian Sarge
-Installed and configured PHP4 and MySQL
-Restored /var/lib/mysql folder (with the coppermine database)
-Restored /var/www folder (with coppermine directory, and all the pictures)
-Applied permissions on files

When i go to my coppermine page with my browser, i got this error :

Template error
Failed to find block 'file_line'(#(<!-- BEGIN file_line -->)(.*?)(<!-- END file_line -->)#s) in :
        <tr>
                <td class="tableb" align="center">
                        <font size="3"><b>{MESSAGE}</b></font>
                        <br /><br />
                </td>
        </tr>


in MySQL i can access all the tables except 'cpg135_pictures' (i'm using coppermine 1.43 but field name is still the one from first install).
Error is #1016 - Can't open file: 'cpg135_pictures.MYI'. (errno: 138)

Any idea ?
TIA

Joachim Müller


rumbaya

I have tried to repair the table but it was unsuccessful
I think the problem is MySQL related, but i cannot figure out what.

Anyway, thanks for your help.

Nibbler

Check that you are using the same version of mysql now that you had before.

MySQL error code 138: Unsupported extension used for table


rumbaya

Many thanks Nibbler, you got it  :D

I was using MySQL 4.0 instead of 4.1

Coppermine works well now

Cafeine

Almost same problem here, but with error 130. Any help welcome... Thanks !

Joachim Müller

What's the actual error message? Paste it into your posting exactly as it appears.

Nibbler

Please don't crosspost, that it is a different error.