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: Typical Error: Can't open file: 'cpg131_pictures.MYI'. (errno: 145)  (Read 79228 times)

0 Members and 1 Guest are viewing this topic.

kegobeer

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 4637
  • Beer - it does a body good!
    • The Kazebeer Family Website

The error:

Can't open file: 'cpg131_pictures.MYI'. (errno: 145)

The problem:

Your table is corrupted.

The solution:

Use your website's Control Panel to repair the table, or use phpMyAdmin to execute this sql query: repair table cpg131_pictures
(Replace cpg131_pictures with your table name)
« Last Edit: May 15, 2006, 08:00:33 am by GauGau »
Logged
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots

AssyMassy

  • Coppermine newbie
  • Offline Offline
  • Posts: 1
Re: Typical Error: Can't open file: 'cpg131_pictures.MYI'. (errno: 145)
« Reply #1 on: June 20, 2005, 01:07:45 pm »

I had the same problem, and I tried youre solution. I did the sql-query "repair table cpg_pictures" but all i got is the same error mesage agein. he can't open th e file so he can't repair the file.'
I do noticed that it was the only table with the message "in use" what does that mean?

Any ideas on what to do next?
I have hardly any experience with this kind of stuf so I hope it doesn't become to technical for my
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Typical Error: Can't open file: 'cpg131_pictures.MYI'. (errno: 145)
« Reply #2 on: June 26, 2005, 11:32:49 am »

ask your webhost for support, this issue is not directly related to coppermine.
Logged

blueginko

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: Typical Error: Can't open file: 'cpg131_pictures.MYI'. (errno: 145)
« Reply #3 on: July 19, 2005, 11:16:24 pm »

Check your user.  Mine had a name like O'Keefe.  Guess what threw the code???  Yup, someone didn't check names for apostrophes.  Renaming that user to Okeefe did the trick.  Interestingly, the user had no trouble regestering.  Can't promis you the same luck.   

With all go one
Blue
Logged

nasir100

  • Coppermine newbie
  • Offline Offline
  • Posts: 1
Re: Typical Error: Can't open file: 'cpg131_pictures.MYI'. (errno: 145)
« Reply #4 on: September 06, 2005, 02:46:59 am »

hi i have the same error

There was an error while processing a database query


and when i check pictures table and i found this erorr

Problems with indexes of table `amooorah_pictures`
 More than one INDEX key was created for column `aid`


the phpadmin can't repair the erorr i think it's a bug in the programing ?
Logged

kegobeer

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 4637
  • Beer - it does a body good!
    • The Kazebeer Family Website
Re: Typical Error: Can't open file: 'cpg131_pictures.MYI'. (errno: 145)
« Reply #5 on: September 06, 2005, 06:19:57 am »

You only posted the generic error message, which does not tell you anything about the table being corrupted.  Without the actual error message you are guessing.  Did you actually see "Can't open file: 'cpg131_pictures.MYI'. (errno: 145)" displayed in the debug output?

There is no "bug in the programming."  If there were such a problem, I'm certain we would've been flooded with similar error messages.  To my knowledge, you are the first.  A google for "More than one INDEX key was created for column" turns up many similar issues, none related at all to Coppermine, which leads me to believe this was caused by some sort of MySQL server hiccup.  None of those similar issues had anything to do with a corrupted table error (145).

You need to post detailed information about your server setup, Coppermine version, etc.
Logged
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Typical Error: Can't open file: 'cpg131_pictures.MYI'. (errno: 145)
« Reply #6 on: September 06, 2005, 07:21:51 am »

You need to post detailed information about your server setup, Coppermine version, etc.
If you do so, post on the support board that corresponds to your version of coppermine, not to a sticky thread that is not related.
Logged

ProNet

  • Coppermine newbie
  • Offline Offline
  • Posts: 9
Re: Typical Error: Can't open file: 'cpg131_pictures.MYI'. (errno: 145)
« Reply #7 on: October 14, 2005, 11:08:10 pm »

Hello
same problem i have when trying to upload pictures, getting "There was an error while processing a database query"
tried to repair table , but what you mean by
Quote
(Replace cpg131_pictures with your table name)

what table name ? I'm not good at php
Logged

Nibbler

  • Guest
Re: Typical Error: Can't open file: 'cpg131_pictures.MYI'. (errno: 145)
« Reply #8 on: October 14, 2005, 11:12:49 pm »

Use the prefix you chose during installation instead of cpg131_
Logged

ProNet

  • Coppermine newbie
  • Offline Offline
  • Posts: 9
Re: Typical Error: Can't open file: 'cpg131_pictures.MYI'. (errno: 145)
« Reply #9 on: October 15, 2005, 12:00:01 am »

I have not changed that, using cpg135_
Logged

ProNet

  • Coppermine newbie
  • Offline Offline
  • Posts: 9
Re: Typical Error: Can't open file: 'cpg131_pictures.MYI'. (errno: 145)
« Reply #10 on: October 15, 2005, 12:07:26 am »

sorry I mean cpg153_
Logged

ProNet

  • Coppermine newbie
  • Offline Offline
  • Posts: 9
Re: Typical Error: Can't open file: 'cpg131_pictures.MYI'. (errno: 145)
« Reply #11 on: October 15, 2005, 12:31:22 am »

what do you think about this I found in pictures table

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

kegobeer

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 4637
  • Beer - it does a body good!
    • The Kazebeer Family Website
Re: Typical Error: Can't open file: 'cpg131_pictures.MYI'. (errno: 145)
« Reply #12 on: October 15, 2005, 12:46:44 am »

Do not post unrelated issues on a sticky thread.
Logged
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots

TheHope

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: Typical Error: Can't open file: 'cpg131_pictures.MYI'. (errno: 145)
« Reply #13 on: March 08, 2006, 11:45:28 pm »

Hi,
I have a same problem, but i don't know how to fix it.

Please! Can somebody tell me how to solve this problem?

Thanks,:)

p.s, i have no idea to work whith mysql


-------------------------------------------------------------------------------------------------------

Critical error
There was an error while processing a database query.

While executing query "SELECT count(*) FROM cpg130_pictures as p, cpg130_albums as a WHERE p.aid = a.aid AND category >= 10000" on 0
mySQL error: Can't open file: 'cpg130_pictures.MYI' (errno: 145)


Code: [Select]
USER:
------------------
Array
(
    [ID] => ...........
    [am] => 1
)

==========================
USER DATA:
------------------
Array
(
    [0] => 19
    [user_id] => 19
    [1] => 1
    [user_group] => 1
    [2] => YES
    [user_active] => YES
    [3] => ..........
    [user_name] => ......
    [4] => ...........
    [user_password] => .........
    [5] => 2006-03-08 18:01:24
    [user_lastvisit] => 2006-03-08 18:01:24
    [6] => 2005-02-14 03:39:42
    [user_regdate] => 2005-02-14 03:39:42
    [7] => 2
    [user_lang] => 2
    [8] =>
    [user_email] =>
    [9] =>
    [user_website] =>
    [10] =>
    [user_location] =>
    [11] =>
    [user_interests] =>
    [12] =>
    [user_occupation] =>
    [13] =>
    [user_actkey] =>
    [14] => 1
    [group_id] => 1
    [15] => Administrator
    [group_name] => Administrator
    [16] => 0
    [group_quota] => 0
    [17] => 1
    [has_admin_access] => 1
    [18] => 1
    [can_rate_pictures] => 1
    [19] => 1
    [can_send_ecards] => 1
    [20] => 1
    [can_post_comments] => 1
    [21] => 1
    [can_upload_pictures] => 1
    [22] => 1
    [can_create_albums] => 1
    [23] => 0
    [pub_upl_need_approval] => 0
    [24] => 0
    [priv_upl_need_approval] => 0
    [25] => 3
    [upload_form_config] => 3
    [26] => 0
    [custom_user_upload] => 0
    [27] => 7
    [num_file_upload] => 7
    [28] => 7
    [num_URI_upload] => 7
)

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content FROM cpg130_filetypes;
    [1] => SELECT * FROM cpg130_users, cpg130_usergroups WHERE user_group = group_id AND user_id='19'AND user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = '..................'
    [2] => DELETE FROM cpg130_banned WHERE expiry < 1141837289
    [3] => SELECT * FROM cpg130_banned WHERE ip_addr='................' OR ip_addr='..........' OR user_id=19
    [4] => SELECT cid, name, description, thumb FROM cpg130_categories WHERE parent = ''  ORDER BY pos
    [5] => SELECT aid FROM cpg130_albums as a WHERE category>=10000
    [6] => SELECT count(*) FROM cpg130_pictures as p, cpg130_albums as a WHERE p.aid = a.aid AND category >= 10000
)

==========================
GET :
------------------
Array
(
)

==========================
POST :
------------------
Array
(
)

==========================
VERSION INFO :
------------------
PHP version: 4.4.1 - OK
------------------
mySQL version: 4.1.15
==========================
Module: gd
------------------
GD Support enabled
GD Version bundled (2.0.28 compatible)
FreeType Support enabled
FreeType Linkage with freetype
GIF Read Support enabled
GIF Create Support enabled
JPG Support enabled
PNG Support enabled
WBMP Support enabled
XBM Support enabled
==========================
Module: mysql
------------------
Active Persistent Links 0
Active Links 1
Client API version 3.23.58
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient 
==========================
Module: zlib
------------------
ZLib Support enabled
Compiled Version 1.1.4
Linked Version 1.1.4
==========================
Server restrictions (safe mode)?
------------------
Directive | Local Value | Master Value
safe_mode | Off | Off
safe_mode_exec_dir | no value | no value
safe_mode_gid | Off | Off
safe_mode_include_dir | no value | no value
safe_mode_exec_dir | no value | no value
sql.safe_mode | Off | Off
disable_functions | no value | no value
file_uploads | On | On
include_path | .:/usr/share/pear | .:/usr/share/pear
open_basedir | /home/httpd/vhosts/zeriyt.com/httpdocs:/tmp | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | me@localhost.com | me@localhost.com
sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
SMTP | localhost | localhost
smtp_port | 25 | 25
==========================
Size and Time
------------------
Directive | Local Value | Master Value
max_execution_time | 30 | 30
max_input_time | 60 | 60
upload_max_filesize | 2M | 2M
post_max_size | 8M | 8M
==========================
Page generated in 0.732 seconds - 7 queries in 0.226 seconds - Album set :



Logged

kegobeer

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 4637
  • Beer - it does a body good!
    • The Kazebeer Family Website
Re: Typical Error: Can't open file: 'cpg131_pictures.MYI'. (errno: 145)
« Reply #14 on: March 09, 2006, 01:24:43 am »

Re-read the first post in this thread.  It clearly explains how to fix the problem.
Logged
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots

TheHope

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: Typical Error: Can't open file: 'cpg131_pictures.MYI'. (errno: 145)
« Reply #15 on: March 09, 2006, 02:21:40 am »

kegobeer,
Thanks for replying :)

I have read it, but i don't know which folder/directory is "the table" - (and how to repair it). :(


? :)
« Last Edit: March 09, 2006, 02:44:09 am by zeriyt »
Logged

kegobeer

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 4637
  • Beer - it does a body good!
    • The Kazebeer Family Website
Re: Typical Error: Can't open file: 'cpg131_pictures.MYI'. (errno: 145)
« Reply #16 on: March 09, 2006, 03:21:20 am »

Have you looked at your website's control panel application?
Logged
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots

TheHope

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: Typical Error: Can't open file: 'cpg131_pictures.MYI'. (errno: 145)
« Reply #17 on: March 09, 2006, 03:42:46 am »

I guess i will find it. :)
Because i was looking at directories..lol

Thanks again!
Logged

joemac

  • Coppermine newbie
  • Offline Offline
  • Posts: 5
Re: Typical Error: Can't open file: 'cpg131_pictures.MYI'. (errno: 145)
« Reply #18 on: February 03, 2007, 05:39:39 am »

The error:

Can't open file: 'cpg131_pictures.MYI'. (errno: 145)

The problem:

Your table is corrupted.

The solution:

Use your website's Control Panel to repair the table, or use phpMyAdmin to execute this sql query: repair table cpg131_pictures
(Replace cpg131_pictures with your table name)



I had the identical error above and went in and attempted to repair the table.  This fixed all of the errors but unfortunately also fixed the table such that none of the images are viewable in any of the albums.  The only thing I can think of doing now is to restore the pictures table from a backup version from a few days ago.

If you do get this error and attempt to repair you could encounter a similar fate. :'(
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Typical Error: Can't open file: 'cpg131_pictures.MYI'. (errno: 145)
« Reply #19 on: February 03, 2007, 05:15:57 pm »

There's no guarantee that repair will succeed no matter what. If a table is broken beyond repair, the repair command can't fix things. Not related to coppermine.
Locking
Logged
Pages: [1]   Go Up
 

Page created in 0.022 seconds with 20 queries.