Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: [Solved]: database query - ERROR  (Read 3476 times)

0 Members and 1 Guest are viewing this topic.

Katya

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 76
[Solved]: database query - ERROR
« on: March 26, 2008, 02:42:24 pm »

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?
« Last Edit: March 26, 2008, 06:25:02 pm by Nibbler »
Logged

Katya

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 76
Re: database query - ERROR
« Reply #1 on: March 26, 2008, 02:48:59 pm »

Logged

Katya

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 76
Re: database query - ERROR
« Reply #2 on: March 26, 2008, 02:53:24 pm »

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>

Logged

Nibbler

  • Guest
Re: database query - ERROR
« Reply #3 on: March 26, 2008, 02:56:21 pm »

Logged

Katya

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 76
Re: database query - ERROR
« Reply #4 on: March 26, 2008, 03:06:19 pm »

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>


Logged

Katya

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 76
Re: database query - ERROR
« Reply #5 on: March 26, 2008, 03:35:13 pm »

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?
Logged

Katya

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 76
Re: database query - ERROR
« Reply #6 on: March 26, 2008, 04:12:31 pm »

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>

Logged

Katya

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 76
Re: database query - ERROR
« Reply #7 on: March 26, 2008, 05:32:26 pm »

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
Logged

Katya

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 76
Re: database query - ERROR
« Reply #8 on: March 26, 2008, 05:36:07 pm »

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
Logged

Nibbler

  • Guest
Re: database query - ERROR
« Reply #9 on: March 26, 2008, 05:38:23 pm »

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

Katya

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 76
Re: database query - ERROR
« Reply #10 on: March 26, 2008, 05:42:28 pm »

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

Nibbler

  • Guest
Re: database query - ERROR
« Reply #11 on: March 26, 2008, 05:46:41 pm »

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

Code: [Select]
REPAIR TABLE `eva_longoria_net_ru`.pictures
Logged

Katya

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 76
Re: database query - ERROR
« Reply #12 on: March 26, 2008, 05:52:24 pm »

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?
Logged

Nibbler

  • Guest
Re: database query - ERROR
« Reply #13 on: March 26, 2008, 06:24:51 pm »

One question per thread. Closing.
Logged
Pages: [1]   Go Up
 

Page created in 0.019 seconds with 20 queries.