Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: [Solved]: database query - ERROR  (Read 4003 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.022 seconds with 19 queries.