Gallery Just Stopped Working!

[robbiewwf]

Hi Everyone,

I have had this problem before, where Coppermine Gallery just stopped working one day, I get this black text on a white page instead of the gallery...

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>


Somebody suggested that I empty the MySQL Tables, which I did (Even though I had NO IDea what I was doing!) and still nothing sorted it...

The solution I had the this problem the first time was to just delete the gallery and start again, but I have thousands of photos and it seems like a whoel lot of bother to start again, anybody got any solutions?!?

Thanks,
Rob.

[Nibbler]

http://coppermine-gallery.net/tutorial/debug_mode.php

Post a link to your gallery.

If you emptied the tables then you have deleted all your data and broken Coppermine, so I hope you made a backup.

[robbiewwf]

Here's the direct link to the gallery...

http://www.punk-wrestling.com/coppermine/index.php

Basically what I done the last time was deleted coppermine, except for my albums folder, so I just re-installed everything and already had all the photos still uploaded, but it's the trouble of going through adding EVERYTHING again.

Do you recommend just re-installing?!?

I had an older version anyways, 1.4.9 I think

Rob.

[Joachim Müller]

Basically what I done the last time was deleted coppermine, except for my albums folder, so I just re-installed everything and already had all the photos still uploaded, but it's the trouble of going through adding EVERYTHING again.

Do you recommend just re-installing?!?

Re-installing is not a bright idea, nor will there be any benefit in deleting coppermine except the albums folder and starting over.

Somebody suggested that I empty the MySQL Tables, which I did (Even though I had NO IDea what I was doing!) and still nothing sorted it...

That somebody must have been a moron (or had no idea what he suggested), or you misunderstood the instructions. Deleting the database is never a bright idea unless you really know what you're doing. Post a link to the page where you read that piece of advice.

[robbiewwf]

It was just a friend that told me to empty the tables... I'm not too good at Databases, so I just done what she told me, wasn't posted anywhere, just told me to do that.

So basically my gallery is gone at this stage yes?!?

Rob.

[Nibbler]

http://coppermine-gallery.net/tutorial/debug_mode.php

[robbiewwf]

Thanks, I got this error message after doing the debug mode...

While executing query "SELECT count(*) FROM cpg149_pictures as p LEFT JOIN cpg149_albums as a ON a.aid=p.aid WHERE 1 AND approved='YES'" on 0

mySQL error: Can't open file: 'cpg149_pictures.MYI'. (errno: 145)


Rob.

[Joachim Müller]

Typical Error: Can't open file: 'cpg131_pictures.MYI'. (errno: 145)

[robbiewwf]

So is there anything I can do to fix the gallery, or is it pretty much screwed!?!?

Rob.

[Hein Traag]

The solution:

Use your website's Control Panel to repair the table, or use phpMyAdmin to execute this sql query: repair table cpg131_pictures