Critical Error: mySQL error 127

[Tamir]

Hello!
Thx for having this support board.

here's a link to my photogallery: http://picommunity.melanie-c.org/gallery/index.php

i uploaded the files to the server and set up the entire script yestarday,
it worked fine when i uploaded some file menually, but today i uploaded a huge amount of photos through the FTP and did a "batch" add, and also i've added a lot of new albums..
now when i try to open some of the albums or pictures through the thumbs, it gives the following error (With debug turned on: )

Critical error

There was an error while processing a database query.

While executing query "SELECT msg_id, msg_author, msg_body, UNIX_TIMESTAMP(msg_date) AS msg_date, author_id, author_md5_id, msg_raw_ip, msg_hdr_ip FROM defaultcomments WHERE pid='134' ORDER BY msg_id ASC" on 0

mySQL error: Got error 127 from table handler

 File: /home/virtual/site121/fst/var/www/html/picommunity/gallery/include/functions.inc.php - Line: 105



Notice: Constant SMILIES_PHP already defined in /home/virtual/site121/fst/var/www/html/picommunity/gallery/include/smilies.inc.php on line 20


Debug info
USER:
Array
(
    [ID] => 2a0275d689d1a2787d5f40d829163092
    [am] => 1
    [liv] => Array
        (
           

• => 109
[1] => 91
            [2] => 37
            [3] => 96
            [4] => 134
        )

    [lap] => 1
)

 
GET :
Array
(
    [album] => lastup
    [cat] =>
    [pos] => 4
)

 
POST :
Array
(
)

____________________________________________________

besides that the advanced debug mode phpinfo page says:

Advanced debug info (phpinfo)
PHP version: 4.3.3


mySQL version: 4.0.17-standard

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

Image Lib(s)
gd
GD Support  enabled  
GD Version  bundled (2.0.15 compatible)  
FreeType Support  enabled  
FreeType Linkage  with freetype  
GIF Read Support  enabled  
JPG Support  enabled  
PNG Support  enabled  
WBMP Support  enabled  
XBM Support  enabled  
 
Server restrictions (safe mode)?
Directive Local Value Master Value
safe_mode On 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 .:/php/includes:/usr/share/php .:/php/includes:/usr/share/php
open_basedir no value 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 60 60
max_input_time 60 60
upload_max_filesize 2M 2M
post_max_size 8M 8M

Debug info
USER:
Array
(
    [ID] => 2a0275d689d1a2787d5f40d829163092
    [am] => 1
    [liv] => Array
        (
           

• => 109
[1] => 91
            [2] => 37
            [3] => 96
            [4] => 134
        )

    [lap] => 1
)

 
GET :
Array
(
)

 
POST :
Array
(
)

 
Page generated in 0.058 seconds - 3 queries in 0.001 seconds - Album set :  

Hope you can help me.



my other question is - how can users post pictures in albums I started? it seems to stop 'em!


Tamir

[Casper]

First of all, when you uploaded by ftp, did you put the images in albums/userpics, or albums/new_folder_you_created.

The userpics folder is for use only by the program to store images uploaded by members via the upload facility.

You should create your directory structure within albums, but not in userpics, and ftp into there.

second, when new albums are created, the default is that visitors cannot upload to them.  To change it so users can upload, click on the properties box, next to each album, and set 'visitors can upload' to yes.

As you have already created many albums, it may be quicker and easier for you to do this in the database.

Next time, please only one question per thread.

[Tamir]

i uploaded to the folder of the program.. i didn't know...
what should i do now? just remove the files with each properties option of each album? would it fix the errors?

thanks you.

[Tamir]

As you have already created many albums, it may be quicker and easier for you to do this in the database.

how? :oops:

thanks angain, and sorry for posting 2 questions in one thread.

[Tamir]

ok, i deleted all of the pictures i uploaded through FTP, with CPG....
but there is one image - one that i given comment to (a comment that didn't appear) wouldn't get deleted from the database!
it gives the error:

While executing query "DELETE FROM defaultcomments WHERE pid='46'" on 0

mySQL error: Got error 127 from table handler
File: /home/virtual/site121/fst/var/www/html/picommunity/gallery/include/functions.inc.php - Line: 105


---
Debug info
USER:
Array
(
    [ID] => 2a0275d689d1a2787d5f40d829163092
    [am] => 1
    [liv] => Array
        (
           

• => 80
[1] => 116
            [2] => 31
            [3] => 76
            [4] => 46
        )

    [lap] => 2
)

 
GET :
Array
(
    [id] => 46
    [what] => picture
)

 
POST :
Array
(
)

 

:?
sorry for being retard, i'm just too confused..

i'm trying also to remove the entire album of where the pic exist at, but it wouldn't success.

[Casper]

Use coppermine to delete the ones you have batch uploaded, DO NOT just use the ftp to move or delete them.

Once you have done that, you can upload them to folders in cpg/albums/, and then use the batch add facility.

You can use a tool such as phpMyAdmin to run an update to change the settings of all albums to allow uploads.  You will have to run a query on the cpg11d_albums, to change the uploads row to yes.

This all shows the value of reading the docs.

edit.  Use the phpmyadmin to remove the comment and the pic.

[hyperion]

Seems like your comments table may be corrupted. Try repairing it, or remove it and recreate it.

[Tamir]

how can i delete the pic and it's comment through there?!
i can't find anything to do with the actual pi or it's comment....

[Tamir]

Seems like your comments table may be corrupted. Try repairing it, or remove it and recreate it.

that's what i kinda thought i just haven't got a cloue how to.

[hyperion]

Error 127 usually indicates the record file for the table has crashed, but it can also mean the result set exceeded the allowed memory in MySQL. A few hundred rows will not cause the latter unless the memory setting is abnormal, so I'd suspect the former.

The easiest way to go about a repair is to use the tool PHPMyAdmin.  Do you have access to this tool? It is a web interface for your MySQL tables.  It is a third party application, and thus not a part of Coppermine.

Usually, if you are allowed to have a database by your host, you are allowed access to this tool. Call them and ask if it is available if they did not mention it.  The alternative is to run a series of commands manually, so it will be worth your time to check.

Let us know if you have access to this tool. We will go from there.

[Tamir]

i do have access, but i don't get a thing of what's going on there...

can i just backup the albums and categorys and re-install the script?

[Tamir]

Hiya

i went to phpMyAdmin (like i've been asked on http://forum.coppermine-gallery.net/viewforum.php?f=12 ) on the albums, and changed the uploads row to yes, but it's still not allowing upload...

Thanks

[edit GauGau]
next time you refer to a thread you started, post a reply instead of starting a new thread! :x  I merged your new thread with the existing one you started...
[/edit]

[Tamir]

ok...

[Tamir]

ok...

[Tamir]

can somebody help me please? :oops:

[hyperion]

You must learn to patient, Tamir.  Most everyone here works, so it can take some time to solve these things.  

Now that you have access to PHPMyAdmin, you should select the database containing the Coppermine tables.  Then you should select the checkbox to the left of the comments table. There is a drop down menu just below the list of tables. Open it, and click on repair table.

If this fails, you should remove the all Coppermine tables from the database, and you should uninstall Coppermine.  Then you should reinstall it. (This might be the best choice for you.)

Uploading issues are not related to the issue above.  Batch uploading is done by FTPing your files to a directory within /albums, but not within /userpics.  Then you select that directory you created from the list generated by the batch upload feature.

If this is unrelated to your current upload problem, you will have to be more specific.  We can't help if you don't provide details.

[Tamir]

sorry for my impatient

the error is fixed, but the uploading question is not a problem, it's  question...
i want to know how can i let all users upload to any album i created..

Thanks.