Template Error

[strokesfan]

Hi,
I went on my gallery today to update with some pictures and I got this message:

URL to gallery: http://parisfan.org/pictures/

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>


I put it in debug mode and it showed that error above just the same. I didn't upgrade anything (I already had the latest version of Coppermine running) - all that happened was the server went down and that's the message it's showing. Any help is much much appreciated

[Sami]

You have crashed table , I've got this:

Code Select Expand


While executing query "SELECT count(*) FROM cpg_pictures as p, cpg_albums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000 and a.aid NOT IN (700,958,1068,1071,1092,1128,1206,1337) " on 0

mySQL error: Table './paris_copp1/cpg_pictures' is marked as crashed and should be repaired


Your default theme is water_drop and it's fine if you see template error it should be something wrong on your custom theme
You can clear your cookies or change back to default theme by adding this ?theme=xxx at the end of gallery url something like this:
http://parisfan.org/pictures/?theme=xxx
BTW your main issue is crashed table so repair cpg_pictures with phpmyadmin or simillar mysql tool

[iCoty]

Hello, I am getting a similar error to the one above. I tried your suggestion of using ?theme+xxx but it did not work. Youc an see my page at http:www.virtualaftershock.com/gallery

I believe I was running cpg1.4.10

Any thoughts?

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>

[bossbill]

I spent over 36hrs sorting this problem out over the last couple of days.
its an error in the pictures table of the data base.
once it has crashed the only thing you can do is to upload a backup of your pictures table

if you have an sql dump of your pictures table and open it in an editor
scroll down and you will find an entry like this

KEY `aid_approved` (`aid,approved`),

that is the fault...  it needs to be    KEY `aid_approved` (`aid`,`approved`),

but even after doing that running a check on the table you still get a warning saying...
More than one INDEX key was created for column `aid`

You still get this warning even doing a fresh install of coppermine.

[bossbill]

Just as an update
for those people looking into this
please dont run a repair on your pictures table in phpmyadmin
its running a repair that crashes the table.
I would strongly suggest to backup your database before doing anything
that way if the table does crash you can upload the backup copy.

After making the change i put in the last post i was able to do a repair and optimise the database
without any problems.

I am not an experianced coder, but what i have done has got my gallery back up and running
If you are not sure I would suggest to wait untill a member of the development team here has had time to look into this.

[Joachim Müller]

Hello, I am getting a similar error to the one above.

Don't try to hijack other's threads. Start your own thread instead and stay out of this one.

please dont run a repair on your pictures table in phpmyadmin
its running a repair that crashes the table.

That's nonsense - everybody please ignore this.
I understand that you're trying to help others, but you drew the wrong clonclusions. A crashed table is just that: it is broken. The repair command (no matter if it is issued using phpMyAdmin or directly on the shell) tries to repair the table. It may or may not be capable to repair it. Anyway it's usually too late to back up when a table is already crashed. That's why you're suppossed to perform regular backups before crashes happen.
If an incident like this happens (i.e. if a mysql table crashes), you perform the repair command and hope that it will be capable to fix it. It not, restore the backup that you must have taken earlier.

[bossbill]

yes I was trying to help.
I backup my database regulary,
I also optimise regulary and every so often to make sure
things are ok i run a repair on the database.
it was not untill i ran the repair that my picture table crashed.
it was only then that i knew there was a problem.

the reason i said not to run a repair was for people who have read this
so they would not run a repair and crash their table
untill something or someone came up with a fix.

I did an install of a fresh coppermine gallery and ran a check on the picture table
and got the warning that... More than one INDEX key was created for column `aid`
so something is wrong somewhere.

I was just trying to shed some light on the problem and help others avoid suffering the same problems i had.

[Joachim Müller]

the reason i said not to run a repair was for people who have read this
so they would not run a repair and crash their table
untill something or someone came up with a fix.

Not a coppermine issue, so nothing we could possibly fix.

I did an install of a fresh coppermine gallery and ran a check on the picture table
and got the warning that... More than one INDEX key was created for column `aid`
so something is wrong somewhere.

Why should that be wrong? Different tables, so the aid can occur in all of those tables and can be index of all of them.

[bossbill]

there is a problem somewhere,
what happend was i checked my tables
got that warning then did a repair
thats when the pictures table crashed.
resulting in the error on the first post.
when it happend to me ( which was before it was ever posted here)
I assumed it was just a problem with my database
so set about fixing it myself.

when i signed in here earlier and found this thread
and other people were getting exactly the same error
I decided to post what I had done, and to hopefully stop it happening to others.


This is the last i will say on the matter
My input is obisouly not wanted and apparantly its not a coppermine issue.
I appoligise for trying to help.
Thank you for your replys.

[iCoty]

Don't try to hijack other's threads. Start your own thread instead and stay out of this one.
That's nonsense - everybody please ignore this.

No Problem, my apologies.  

[bossbill]

My appoligies for commenting on this subject again
but I have found another thread concerning
the warning message in phpmyadmin.

More than one INDEX key was created for column `aid`

this is the thread...

http://forum.coppermine-gallery.net/index.php?topic=43471.0

my reason for bringing it up again is

is this a problem and could it be contributing to peoples picture table crashing ?
or is this perfectly ok

Thank you.

[Nibbler]

It's just an unnecessary index, it does no harm.

[bossbill]

ok  thank you.