coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: robbiewwf on October 03, 2007, 01:46:55 PM

Title: Gallery Just Stopped Working!
Post by: robbiewwf on October 03, 2007, 01:46:55 PM
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.
Title: Re: Gallery Just Stopped Working!
Post by: Nibbler on October 03, 2007, 02:04:05 PM
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.
Title: Re: Gallery Just Stopped Working!
Post by: robbiewwf on October 03, 2007, 03:00:56 PM
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.
Title: Re: Gallery Just Stopped Working!
Post by: Joachim Müller on October 03, 2007, 05:31:00 PM
Quote from: robbiewwf on October 03, 2007, 03:00:56 PM
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.

Quote from: robbiewwf on October 03, 2007, 01:46:55 PMSomebody 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.
Title: Re: Gallery Just Stopped Working!
Post by: robbiewwf on October 03, 2007, 05:57:02 PM
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.
Title: Re: Gallery Just Stopped Working!
Post by: Nibbler on October 03, 2007, 06:06:10 PM
http://coppermine-gallery.net/tutorial/debug_mode.php
Title: Re: Gallery Just Stopped Working!
Post by: robbiewwf on October 04, 2007, 03:05:51 AM
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.
Title: Re: Gallery Just Stopped Working!
Post by: Joachim Müller on October 04, 2007, 08:15:08 AM
Typical Error: Can't open file: 'cpg131_pictures.MYI'. (errno: 145) (http://forum.coppermine-gallery.net/index.php?topic=10409.0)
Title: Re: Gallery Just Stopped Working!
Post by: robbiewwf on October 04, 2007, 02:47:05 PM
So is there anything I can do to fix the gallery, or is it pretty much screwed!?!?

Rob.
Title: Re: Gallery Just Stopped Working!
Post by: Hein Traag on October 04, 2007, 02:56:15 PM
QuoteThe solution:

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