Image Won't Upload After DB Move? Image Won't Upload After DB Move?
 

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

Main Menu

Image Won't Upload After DB Move?

Started by technogecko, March 28, 2005, 05:02:06 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

technogecko

I had coppermine working perfectly for over a year until just recently. The server died and I sucessfully dumped and reimported the mysql database over to a new machine after reinstalling coppermine. Everything works and the photos are all there, however when I try and upload a file it dosen't appear to work correctly.

I select the file from my machine and hit upload - it completes successfully...
1 uploads were successful.

So then I hit continue and it asks me to pick the album to place it in as well as the file title, description, etc. However, the image does not appear in the upper left corner. The file,
"/albums/edit/preview_317ac1ab.JPG" indeed does not exist as shown below:

[root@geckobox edit]# pwd
/www/cbr1100xx/photos/albums/edit
[root@geckobox edit]# ls
index.html  mHTTP_temp_9164ffd9.JPG


The debug info is below:

USER:
------------------
Array
(
    [ID] => 821cfedfa6bd824a228f3911d627034c
    [am] => 1
    [liv] => Array
        (
            [0] => 1266
            [1] => 1264
            [2] => 1262
            [3] => 546
            [4] => 314
        )

)

==========================
USER DATA:
------------------
Array
(
    [0] => 1562
    [user_id] => 1562
    [1] => TechnoGecko
    [user_name] => TechnoGecko
    [2] => 1
    [user_level] => 1
    [groups] => Array
        (
            [0] => 1
            [1] => 2
        )

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

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content FROM cpg132_filetypes;
    [1] => SELECT user_id, username as user_name, user_level FROM `cbrforums`.phpbb_sessions INNER JOIN `cbrforums`.phpbb_users ON session_user_id = user_id WHERE session_id='0e55c98056d67223af642d1a7c1039ab' AND session_user_id ='1562' AND user_active='1'
    [2] => SELECT (ug.group_id + 5) as group_id FROM `cbrforums`.phpbb_user_group as ug LEFT JOIN `cbrforums`.phpbb_groups as g ON ug.group_id = g.group_id WHERE user_id = 1562 AND user_pending = 0 AND group_single_user = 0
    [3] => 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 cpg132_usergroups WHERE group_id in (1,2)
    [4] => SELECT group_name FROM  cpg132_usergroups WHERE group_id= 1
    [5] => DELETE FROM cpg132_banned WHERE expiry < 1111978679
    [6] => SELECT * FROM cpg132_banned WHERE ip_addr='150.135.143.159' OR ip_addr='150.135.143.159' OR user_id=1562
)

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

==========================
POST :
------------------
Array
(
    [unique_ID] => 9ceedc8e
    [control] => phase_2
)

==========================
VERSION INFO :
------------------
PHP version: 4.3.9 - OK
------------------
mySQL version: 4.1.7
------------------
Coppermine version: 1.3.2
==========================
Module: gd
------------------
module doesn't exist
==========================
Module: mysql
------------------
Active Persistent Links 0
Active Links 2
Client API version 4.1.7
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.2.1.2
Linked Version 1.2.1.2
==========================
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 | 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 | 2M | 2M
post_max_size | 8M | 8M
==========================
Page generated in 0.078 seconds - 7 queries in 0.004 seconds - Album set :


Imagemagick is installed corrrectly

[root@geckobox edit]# whereis convert
convert: /usr/bin/convert /usr/local/bin/convert


[root@geckobox edit]# /usr/local/bin/convert
Version: ImageMagick 6.2.1 03/27/05 Q16 http://www.imagemagick.org
Copyright: Copyright (C) 1999-2005 ImageMagick Studio LLC


It's been a long time since I've had to make any changes to coppermine since it always worked perfectly, so I could be wrong but I'm fairly sure that the GD libs dont have to be installed for php if you're using ImageMagick correct?

Any advice/suggestions appreciated. Thanks for your time!

Jason

technogecko

Still no luck getting this to work. Any Mods care to comment? I'd appreciate any suggestions you have.

Thanks again,

Jason

Aqua-Passion


Joachim Müller

then take a look at the sticky threads on this sub-board and the usual reply supporters give when people ask for support on upload issues. We already have to say the same thing over and over again, I won't repeat it here.

Aqua-Passion

ok apres avoir lu une bonne cinquantaines de post j'ai trouve la solution merci

Joachim Müller

please post in English on this board here. There's only one sub-board where onon-English postings are welcome - the "Language Specific Support" board. There's a francophone sub-board as well. However, I'm glad you were able to solve this.