Advanced search  

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

Pages: [1]   Go Down

Author Topic: Restore database after crash  (Read 5203 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: 47843
  • 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: 47843
  • 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.023 seconds with 20 queries.