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: Coppermine critical error  (Read 4212 times)

0 Members and 1 Guest are viewing this topic.

Infernal

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 63
  • 13371357
    • Add Fun
Coppermine critical error
« on: November 13, 2007, 08:38:47 am »

Ok hello and thanks for giving me some of your time
I am a huge fan of coppermine...i love it it always worked for me well except now

Error link gallery is the coppermine folder
http://www.add-fun.com/gallery/index.php

error message

There was an error while processing a database query.



File:
gallery/include/functions.inc.php - Line: 249



COde from debug mode unde the error message

<code>
While executing query "SELECT * FROM cpg1411_pictures WHERE approved = 'YES'  ORDER BY RAND() LIMIT 12" on 0

mySQL error: Incorrect key file for table '/tmp/#sql_2115_0.MYI'; try to repair it
</code>


Long debug code that we should post on problems

<code>
USER:
------------------
Array
(
    [ID] => 34536684a31d982b98c63011f720faba
    [am] => 1
    [lang] => english
    [search] => Array
        (
            [search] => c
        )

)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_name] => -Censored-
    [groups] => Array
        (
           
  • => 1

        )

    [disk_max] => 0
    [disk_min] => 0
    [can_rate_pictures] => 1
    [can_send_ecards] => 1
    [ufc_max] => 3
    [ufc_min] => 3
    [custom_user_upload] => 0
    [num_file_upload] => 5
    [num_URI_upload] => 3
    [can_post_comments] => 1
    [can_upload_pictures] => 1
    [can_create_albums] => 1
    [has_admin_access] => 1
    [pub_upl_need_approval] => 0
    [priv_upl_need_approval] => 0
    [group_name] => Administrators
    [upload_form_config] => 3
    [group_quota] => 0
    [can_see_all_albums] => 1
    [group_id] => 1
)

==========================
Queries:
------------------
Array
(
   
  • => SELECT extension, mime, content, player FROM cpg1411_filetypes; (0s)
  • [1] => select * from cpg1411_plugins order by priority asc; (0s)
        [2] => delete from `addghe2_addict54`.cpg1411_sessions where time<1194935387 and remember=0; (0s)
        [3] => delete from `addghe2_addict54`.cpg1411_sessions where time<1193729387; (0s)
        [4] => select user_id from `addghe2_addict54`.cpg1411_sessions where session_id=md5("604549c91c7f22765ec29cb19f78fd0b8c5ee5140b5012d51f6c8aa3f193f5b2"); (0s)
        [5] => select user_id as id, user_password as password from `addghe2_addict54`.cpg1411_users where user_id=1 (0s)
        [6] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.user_group+100 AS group_id FROM `addghe2_addict54`.cpg1411_users AS u INNER JOIN `addghe2_addict54`.cpg1411_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0s)
        [7] => SELECT user_group_list FROM `addghe2_addict54`.cpg1411_users AS u WHERE user_id='1' and user_group_list <> ''; (0s)
        [8] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as  priv_upl_need_approval FROM cpg1411_usergroups WHERE group_id in (1) (0s)
        [9] => SELECT group_name FROM  cpg1411_usergroups WHERE group_id= 1 (0s)
        [10] => update `addghe2_addict54`.cpg1411_sessions set time='1194938987' where session_id=md5('604549c91c7f22765ec29cb19f78fd0b8c5ee5140b5012d51f6c8aa3f193f5b2'); (0s)
        [11] => SELECT user_favpics FROM cpg1411_favpics WHERE user_id = 1 (0.002s)
        [12] => DELETE FROM cpg1411_banned WHERE expiry < '2007-11-13 07:29:47' (0.001s)
        [13] => SELECT * FROM cpg1411_banned WHERE (ip_addr='82.77.137.33' OR ip_addr='82.77.137.33' OR user_id=1) AND brute_force=0 (0s)
        [14] => SELECT cid, name, description, thumb FROM cpg1411_categories WHERE parent = '0'  ORDER BY pos (0s)
        [15] => SELECT aid FROM cpg1411_albums as a WHERE category>=10000 (0s)
        [16] => SELECT count(*) FROM cpg1411_pictures as p, cpg1411_albums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000 (0s)
        [17] => SELECT cid, name, description, thumb FROM cpg1411_categories WHERE parent = '1'  ORDER BY pos (0s)
        [18] => SELECT aid FROM cpg1411_albums as a WHERE category = '0' (0s)
        [19] => SELECT count(*) FROM cpg1411_albums as a WHERE 1 (0s)
        [20] => SELECT count(*) FROM cpg1411_pictures as p LEFT JOIN cpg1411_albums as a ON a.aid=p.aid WHERE 1 AND approved='YES' (0.01s)
        [21] => SELECT count(*) FROM cpg1411_comments as c LEFT JOIN cpg1411_pictures as p ON c.pid=p.pid LEFT JOIN cpg1411_albums as a ON a.aid=p.aid WHERE 1 (0.001s)
        [22] => SELECT count(*) FROM cpg1411_categories WHERE 1 (0s)
        [23] => SELECT sum(hits) FROM cpg1411_pictures as p LEFT JOIN cpg1411_albums as a ON p.aid=a.aid WHERE 1 (0.022s)
        [24] => SELECT COUNT(*) FROM cpg1411_pictures WHERE approved = 'NO' (0.005s)
        [25] => SELECT count(*) FROM cpg1411_albums as a WHERE category = '0' (0s)
        [26] => SELECT a.aid, a.title, a.description, category, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg1411_albums as a LEFT JOIN cpg1411_pictures as p ON a.thumb=p.pid WHERE category=0 ORDER BY a.pos LIMIT 0,1 (0s)
        [27] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg1411_albums AS a  LEFT JOIN cpg1411_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (1)GROUP BY a.aid (0.021s)
        [28] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg1411_pictures WHERE pid='12960' (0s)
        [29] => SELECT COUNT(*) from cpg1411_pictures WHERE approved = 'YES'  (0.005s)
        [30] => SELECT * FROM cpg1411_pictures WHERE approved = 'YES'  ORDER BY RAND() LIMIT 12 (0.143s)
    )

    ==========================
    GET :
    ------------------
    Array
    (
       
[cat] => 0
)

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

==========================
VERSION INFO :
------------------
PHP version: 5.2.3 - OK
------------------
mySQL version: 5.0.27-standard
------------------
Coppermine version: 1.4.12(stable)
==========================
Module: GD
------------------
GD Version: bundled (2.0.34 compatible)
FreeType Support: 1
FreeType Linkage: with freetype
T1Lib Support:
GIF Read Support: 1
GIF Create Support: 1
JPG Support: 1
PNG Support: 1
WBMP Support: 1
XPM Support: 1
XBM Support: 1
JIS-mapped Japanese Font Support:

==========================
Module: mysql
------------------
MySQL Supportenabled
Active Persistent Links 0
Active Links 1
Client API version 5.0.27
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -lmysqlclient 
==========================
Module: zlib
------------------
ZLib Support enabled
Stream Wrapper support compress.zlib://
Stream Filter support zlib.inflate, zlib.deflate
Compiled Version 1.2.1.2
Linked Version 1.2.3
==========================
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/lib/php:/usr/local/lib/php | .:/usr/lib/php:/usr/local/lib/php
open_basedir | no value | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | no value | no value
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 | 8M | 8M
post_max_size | 8M | 8M
==========================
Page generated in 0.28 seconds - 31 queries in 0.21 seconds - Album set : ; Meta set: ;

</code>




Hope you can help
Thanks and have a good day
« Last Edit: November 13, 2007, 07:05:21 pm by GauGau »
Logged

François Keller

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: fr
  • Offline Offline
  • Gender: Male
  • Posts: 9094
  • aka Frantz
    • Ma galerie
Re: Coppermine critical error
« Reply #1 on: November 13, 2007, 08:46:40 am »

Hi
Quote
While executing query "SELECT * FROM cpg1411_pictures WHERE approved = 'YES'  ORDER BY RAND() LIMIT 12" on 0

mySQL error: Incorrect key file for table '/tmp/#sql_2115_0.MYI'; try to repair it
repair your cpg1411_pictures via phpmyadmin or similar toll
Logged
Avez vous lu la DOC ? la FAQ ? et cherché sur le forum avant de poster ?
Did you read the DOC ? the FAQ ? and search the board before posting ?
Mon Blog

Infernal

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 63
  • 13371357
    • Add Fun
Re: Coppermine critical error
« Reply #2 on: November 13, 2007, 08:51:37 am »

i tryed using my cpanel repair from the sql area and it just tells me everything is ok and i still get the error
i even deleted the extra aid as i found of the forums
sadly for myself i can't seem to find a phpmyadmin repair option
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Coppermine critical error
« Reply #3 on: November 13, 2007, 02:07:30 pm »

Using phpMyAdmin: in the left frame, click on the database name or select the database from the dropdown (if you have multiple databases available). In the main frame of phpMyAdmin, you should now see an overview page of all tables that reside within the database you previously selected. Tick (select) the table(s) that are reported to be crashed (cpg1411_pictures in your case). Scroll down to the bottom of the page and pick from the dropdown list that is labelled "with selected" the command "repair table".
If you can't do that, ask your webhsot for support.
This is not related to coppermine, but mysql database management. Repairing a crashed database table has been discussed frequently on this forum (you should have performed a search before posting). Also please don't post debug_output in the future unless a supporter explicitely asks for it.
Logged

Infernal

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 63
  • 13371357
    • Add Fun
Re: Coppermine critical error
« Reply #4 on: November 13, 2007, 02:07:31 pm »

.cpg1411_albums                    OK
.cpg1411_banned                    OK
.cpg1411_bridge                    OK
.cpg1411_categories                OK
.cpg1411_comments                  OK
.cpg1411_config                    OK
.cpg1411_dict                      OK
.cpg1411_ecards                    OK
.cpg1411_exif                      OK
.cpg1411_favpics                   OK
.cpg1411_filetypes                 OK
.cpg1411_hit_stats                 OK
.cpg1411_pictures                  OK
.cpg1411_plugins                   OK
.cpg1411_sessions                  OK
.cpg1411_temp_data                 OK
.cpg1411_usergroups                OK
.cpg1411_users                     OK
.cpg1411_vote_stats                OK
.cpg1411_votes                     OK
I always get this that all databases are ok
please some more help
Logged

Infernal

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 63
  • 13371357
    • Add Fun
Re: Coppermine critical error
« Reply #5 on: November 13, 2007, 02:11:22 pm »

While executing query "SELECT * FROM cpg1411_pictures WHERE approved = 'YES'  ORDER BY RAND() LIMIT 12" on 0

mySQL error: Incorrect key file for table '/tmp/#sql_4632_0.MYI'; try to repair it

did so and now i just get another error

i messaged my hosting they told me to ask the providers


thank you for the help
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Coppermine critical error
« Reply #6 on: November 13, 2007, 04:07:10 pm »

i messaged my hosting they told me to ask the providers
They told you what? They told you to ask the developers of the application :o? Are you sure? If the webhost sees such a message and says that it's the application's fault then I strongly suggest looking for another webhost?

did so and now i just get another error
The fatal error you get is just that: it is fatal, that's why the script halts and doesn't do anything else but displaying the error message - the script dies. If you then perform the repair, it's very likely that you will see other fatal error messages about other tables that are crashed as well. That's possible because coppermine didn't even attempt to run queries against those other tables before - the first fatal error makes the script grind to a halt. Repair the other broken tables the same way you repaired the first table.

It's even possible that the tables are crashed beyond repair. In this case, you'll have to use your backup (if you have one).
Logged

Nibbler

  • Guest
Re: Coppermine critical error
« Reply #7 on: November 13, 2007, 04:53:22 pm »

It's not the pictures table that is broken - read the message. The table that is broken is the temporary table created by mysql while running the query. Only your webhost can address this; my guess would be lack of space on /tmp. Disable the random meta album in config as a workaround.
Logged

Infernal

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 63
  • 13371357
    • Add Fun
Re: Coppermine critical error
« Reply #8 on: November 13, 2007, 05:00:08 pm »

yes it's exactly what nibbler posted
i read up a lot more on this
my database is all fine and i read about everything bout coppermine databases you have on the forum
mine works perfectly but this temp table is not done because of space

my host is midphase which promises me 99999 databases so i will raise hell if they do not fix this very soon
i will try and take out random


thanks a lot for the help...i will post the outcome of this
Logged
Pages: [1]   Go Up
 

Page created in 0.024 seconds with 20 queries.