Advanced search  

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]

Pages: [1]   Go Down

Author Topic: Restore database after crash  (Read 3769 times)

0 Members and 1 Guest are viewing this topic.

rumbaya

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Restore database after crash
« 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
« Last Edit: February 12, 2006, 04:17:05 pm by Nibbler »
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47844
  • aka "GauGau"
    • gaugau.de
Logged

rumbaya

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: Restore database after crash
« Reply #2 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.
Logged

Nibbler

  • Guest
Re: Restore database after crash
« Reply #3 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

Logged

rumbaya

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: Restore database after crash
« Reply #4 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
Logged

Cafeine

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 21
    • Cafzone
Re: Restore database after crash
« Reply #5 on: February 14, 2006, 03:37:45 am »

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

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47844
  • aka "GauGau"
    • gaugau.de
Re: Restore database after crash
« Reply #6 on: February 14, 2006, 07:38:44 am »

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

Nibbler

  • Guest
Re: Restore database after crash
« Reply #7 on: February 14, 2006, 02:16:31 pm »

Please don't crosspost, that it is a different error.
Logged
Pages: [1]   Go Up
 

Page created in 0.016 seconds with 20 queries.