forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: tinorebel on February 23, 2008, 08:32:48 pm

Title: [Solved]: MySQL Problem: cant open table
Post by: tinorebel on February 23, 2008, 08:32:48 pm
Hy to all coppermine supporters.
I have been using cpg for my photostock since 3 years and never had any problems with MySQL.
Since yesterday I had almost 5000 pictures organized in 300 albums with keywords and descriptions.... I was running on cpg  1.4.6 with some plug ins such as easy rss, mini csm and album search.

Yesterday suddently my gallery started giving strange errors, thumbs where not displaying any more and messages obout msql problem.
I had a look to mysql with phpadmin and found that Picture table was having problems (was unable to optimize the table)

Now my gallery hase disappeared almost compleatly, just an error msg:

Code: [Select]
Template error
Failed to find block 'output_buffer'(#(<!-- BEGIN output_buffer -->)(.*?)(<!-- END output_buffer -->)#s) in :
        <tr>
                <td class="tableb" align="center">
                        <font size="3"><b>{MESSAGE}</b></font>
<!-- BEGIN file_line -->
                        <br />
                        <br />
                        {FILE_TXT}{FILE} - {LINE_TXT}{LINE}
<!-- END file_line -->

                        <br /><br />
                </td>
        </tr>

Could anybody give me a clue on what happened?, if there is a chance to recover my database? an of course.... what could I do to try to recover it?
Should I try to backup? Should I try to upgrade?? ??? ???
Many thanks to anyone who can give some help, i'm quite lost at the moment....
Title: Re: MySQL Problem: cant open table
Post by: Joachim Müller on February 23, 2008, 08:56:10 pm
Has been asked and answered before - the search feature (http://forum.coppermine-gallery.net/index.php?action=search) is your friend. Here are the results for a search for "BEGIN output_buffer" (http://forum.coppermine-gallery.net/index.php?action=search2;search=BEGIN%20output_buffer). They contain the answer.
Title: Re: MySQL Problem: cant open table
Post by: tinorebel on February 23, 2008, 09:08:32 pm
you are right Joachim, sorry.... my apologize.