Restore database after crash Restore database after crash
 

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

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.