forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: Katya on March 26, 2008, 02:42:24 pm

Title: [Solved]: database query - ERROR
Post by: Katya 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?
Title: Re: database query - ERROR
Post by: Katya on March 26, 2008, 02:48:59 pm: Link: http://www.eva-longoria.net.ru/gallery/
Title: Re: database query - ERROR
Post by: Katya 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'(#()(.*?)()#s) in :

<tr>
<td class="tableb" align="center">
<font size="3"><b>{MESSAGE}</b></font>

<br /><br />
</td>
</tr>
Title: Re: database query - ERROR
Post by: Nibbler on March 26, 2008, 02:56:21 pm: Same as your last thread.

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

Debug mode.
Title: Re: database query - ERROR
Post by: Katya 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'(#()(.*?)()#s) in :

<tr>
<td class="tableb" align="center">
<font size="3"><b>{MESSAGE}</b></font>

<br /><br />
</td>
</tr>
Title: Re: database query - ERROR
Post by: Katya 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'(#()(.*?)()#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?
Title: Re: database query - ERROR
Post by: Katya on March 26, 2008, 04:12:31 pm: Now i see that:

Template error
Failed to find block 'log_ecards'(#()(.*?)()#s) in :

<div align="center">
<table cellpadding="0" cellspacing="1">
<tr>

<td class="admin_menu" id="admin_menu_anim"><a href="editpics.php?mode=upload_approval" title="{UPL_APP_TITLE}">{UPL_APP_LNK}</a></td>

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

<td class="admin_menu"><a href="{DOCUMENTATION_HREF}" title="{DOCUMENTATION_TITLE}" target="cpg_documentation">{DOCUMENTATION_LNK}</a></td>

</tr>
</table>
</div>
Title: Re: database query - ERROR
Post by: Katya 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
Title: Re: database query - ERROR
Post by: Katya 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
Title: Re: database query - ERROR
Post by: Nibbler 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.
Title: Re: database query - ERROR
Post by: Katya on March 26, 2008, 05:42:28 pm: How? I run REPAIR TABLE `eva_longoria_net_ru`.sessions in phpmyadmin.
but this error again
Title: Re: database query - ERROR
Post by: Nibbler 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
Title: Re: database query - ERROR
Post by: Katya 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?
Title: Re: database query - ERROR
Post by: Nibbler on March 26, 2008, 06:24:51 pm: One question per thread. Closing.