[Solved]: database query - ERROR

[Katya]

Omg, today i add some new pictures, but now i see database error:

There was an error while processing a database query

How I can correct it?

[Katya]

Link: http://www.eva-longoria.net.ru/gallery/

[Katya]

I login how admin, but can't view gallery too, i see only it:

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>

[Nibbler]

Same as your last thread.

http://forum.coppermine-gallery.net/index.php/topic,50701.0.html

Debug mode.

[Katya]

No, it's not Fatal error. What i need done?
I see in my gallery only that:
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>

[Katya]

No one help?

I see it: There was an error while processing a database query

when i use debug_mode tutorial and now i have it:

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>




how i correct it? I can't working with gallery anymore?

[Katya]

Now i see that:

Template error
Failed to find block 'log_ecards'(#(<!-- BEGIN log_ecards -->)(.*?)(<!-- END log_ecards -->)#s) in :

                <div align="center">
                <table cellpadding="0" cellspacing="1">
                        <tr>
<!-- BEGIN admin_approval -->
                                <td class="admin_menu" id="admin_menu_anim"><a href="editpics.php?mode=upload_approval" title="{UPL_APP_TITLE}">{UPL_APP_LNK}</a></td>
<!-- END admin_approval -->
                                <td class="admin_menu"><a href="admin.php" title="{ADMIN_TITLE}">{ADMIN_LNK}</a></td>
                                <td class="admin_menu"><a href="catmgr.php" title="{CATEGORIES_TITLE}">{CATEGORIES_LNK}</a></td>
                                <td class="admin_menu"><a href="albmgr.php{CATL}" title="{ALBUMS_TITLE}">{ALBUMS_LNK}</a></td>
                                <td class="admin_menu"><a href="groupmgr.php" title="{GROUPS_TITLE}">{GROUPS_LNK}</a></td>
                                <td class="admin_menu"><a href="usermgr.php" title="{USERS_TITLE}">{USERS_LNK}</a></td>
                                <td class="admin_menu"><a href="banning.php" title="{BAN_TITLE}">{BAN_LNK}</a></td>
                                <td class="admin_menu"><a href="reviewcom.php" title="{COMMENTS_TITLE}">{COMMENTS_LNK}</a></td>

                                <td class="admin_menu"><a href="picmgr.php" title="{PICTURES_TITLE}">{PICTURES_LNK}</a></td>
                                <td class="admin_menu"><a href="searchnew.php" title="{SEARCHNEW_TITLE}">{SEARCHNEW_LNK}</a></td>
                                <td class="admin_menu"><a href="util.php" title="{UTIL_TITLE}">{UTIL_LNK}</a></td>
                                <td class="admin_menu"><a href="profile.php?op=edit_profile" title="{MY_PROF_TITLE}">{MY_PROF_LNK}</a></td>
<!-- BEGIN documentation -->
                                <td class="admin_menu"><a href="{DOCUMENTATION_HREF}" title="{DOCUMENTATION_TITLE}" target="cpg_documentation">{DOCUMENTATION_LNK}</a></td>
<!-- END documentation -->
                        </tr>
                </table>
                </div>

[Katya]

Now i try to correct it and done it:

mySQL error: Table './eva_longoria_net_ru/pictures' is marked as crashed and should be repaired
While executing query "SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000" on 0

Please anyone - help me please

[Katya]

My error now:

While executing query "SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000" on 0

mySQL error: Table './eva_longoria_net_ru/pictures' is marked as crashed and should be repaired

File: /usr/home/vshosts/hosts/u3100/eva-longoria.net.ru/www/gallery/include/functions.inc.php - Line: 249

[Nibbler]

It's the same issue you had before just with the pictures table instead of the sessions table. Repair it.

[Katya]

How? I run  REPAIR TABLE `eva_longoria_net_ru`.sessions in phpmyadmin.
but this error again

[Nibbler]

It is the pictures table that is not working, so the pictures table you need to repair.

Code Select Expand

REPAIR TABLE `eva_longoria_net_ru`.pictures

[Katya]

Thanks so much, guys! You are the best! Can you please say me why this error again and again in the gallery? How i finally correct it?

And once again question - can i update version of my gallery that she looked like this gallery: http://www.evalongoriafan.net/gallery/
I mean Stramn theme, but i don't now how i can update it and my gallery saving after update?

[Nibbler]

One question per thread. Closing.