forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 install => Topic started by: rumbaya on February 11, 2006, 03:00:13 am

Title: Restore database after crash
Post by: rumbaya on February 11, 2006, 03:00:13 am

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

Title: Re: Restore database after crash
Post by: Joachim Müller on February 11, 2006, 10:27:03 am

http://forum.coppermine-gallery.net/index.php?topic=10409.0

Title: Re: Restore database after crash
Post by: rumbaya on February 11, 2006, 12:26:59 pm

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.

Title: Re: Restore database after crash
Post by: Nibbler on February 11, 2006, 01:52:26 pm

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

MySQL error code 138: Unsupported extension used for table

Title: Re: Restore database after crash
Post by: rumbaya on February 12, 2006, 02:48:50 pm

Many thanks Nibbler, you got it  :D

I was using MySQL 4.0 instead of 4.1

Coppermine works well now

Title: Re: Restore database after crash
Post by: Cafeine on February 14, 2006, 03:37:45 am

Almost same problem here (http://forum.coppermine-gallery.net/index.php?topic=27858.0), but with error 130. Any help welcome... Thanks !

Title: Re: Restore database after crash
Post by: Joachim Müller on February 14, 2006, 07:38:44 am

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

Title: Re: Restore database after crash
Post by: Nibbler on February 14, 2006, 02:16:31 pm

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