I have been in the process of developing a website for the past two months and one of our features is our photo album. We're up to 786 photos but we keep on running into a problem.
I tried searching these forums but couldn't find anything that helped my problem so I hope I can get the advice I'm seeking for. My domain and hosting are signed up with www.web.com.
The problem is once I upload photos it will go to the screen "Successful Uploads - - 10 uploads were successful. - - Please click 'Continue' to add the files to albums." But once I click continue nothing happens.
I emailed web.com with this problem and they said to increase mysql "quota" size. I increased it by double even though it said 0.0 MB was being used.
If anyone can help I would be extremely grateful. My staff and I have put so much time, work, and effort into this site and this coppermine/mysql problems needs to be fixed.
First, as an admin you shouldn't be using the web uploads - you should read the batch add instructions in the documentation.
Second, what do you mean "nothing happens"? Blank page? Page just sits there?
Third, switch to single file uploads, enable debug mode, and try uploading a single image. You should also create a test user and post the username/password here with the url of your site. Not an admin account, just a standard user account.
1.) I will take your advice. I just read the online manual about that and will begin that method once this problem is fixed.
2.) Once I select continue the loading bar will show up at the bottom right toolbar and then just dispear.
3.) I created the user: test, password: testuser, domain is www.images-pointxtreme.com . Debug mode for everyone or just admin?
Everyone if you want me to attempt an upload, or you can do it for just the admin and then do the single file upload yourself and post the error message. Make sure you change the Upload form configuration in the groups panel for registered and/or admin to single file upload.
Quote from: error message
USER:
------------------
Array
(
[ID] => 1aa07f2cec8eee7df93e48ed9d342b94
[am] => 1
[lap] => 1
[liv] => Array
(
- => 805
[1] => 800
[2] => 799
[3] => 773
[4] => 806
)
[search] => ###Kiddie
)
==========================
USER DATA:
------------------
Array
(
[user_id] => 1
[user_group] => 1
[user_active] => YES
[user_name] => pointxtreme
[user_password] => ********
[user_lastvisit] => 2005-05-31 17:27:57
[user_regdate] => 2005-05-04 16:00:18
[user_group_list] =>
[user_email] =>
[user_website] =>
[user_location] =>
[user_interests] =>
[user_occupation] =>
[user_actkey] =>
[disk_max] => 2147483647
[disk_min] => 2147483647
[can_rate_pictures] => 1
[can_send_ecards] => 1
[ufc_max] => 3
[ufc_min] => 3
[custom_user_upload] => 0
[num_file_upload] => 1
[num_URI_upload] => 1
[can_post_comments] => 1
[can_upload_pictures] => 1
[can_create_albums] => 1
[has_admin_access] => 1
[pub_upl_need_approval] => 1
[priv_upl_need_approval] => 1
[group_name] => Administrators
[upload_form_config] => 3
[group_quota] => 2147483647
[can_see_all_albums] => 1
[group_id] => 1
[groups] => Array
(
[1] => 1
)
)
==========================
Queries:
------------------
Array
(
- => SELECT extension, mime, content FROM cpg133_filetypes;
[1] => SELECT * FROM cpg133_users WHERE user_id='1'AND user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = '7e93ee6862e46cc701ce40c48b304590'
[2] => 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 cpg133_usergroups WHERE group_id in (1)
[3] => SELECT group_name FROM cpg133_usergroups WHERE group_id= 1
[4] => DELETE FROM cpg133_banned WHERE expiry < '2005-06-07 15:29:53'
[5] => SELECT * FROM cpg133_banned WHERE ip_addr='68.9.47.254' OR ip_addr='68.9.47.254' OR user_id=1
[6] => SELECT aid, title FROM cpg133_albums WHERE category < 10000 ORDER BY title
[7] => SELECT aid, title FROM cpg133_albums WHERE category='10001' ORDER BY title
[8] => SELECT encoded_string FROM cpg133_temp_data WHERE unique_ID = '75c847e7'
[9] => UPDATE cpg133_temp_data SET encoded_string = 'YTowOnt9' WHERE unique_ID = '75c847e7'
[10] => SELECT category FROM cpg133_albums WHERE aid='142'
[11] => INSERT INTO cpg133_pictures (pid, aid, filepath, filename, filesize, total_filesize, pwidth, pheight, ctime, owner_id, owner_name, title, caption, keywords, approved, user1, user2, user3, user4, pic_raw_ip, pic_hdr_ip) VALUES ('', '142', 'userpics/10001/', 'sunday 013~0.jpg', '172443', '180412', '616', '816', '1118172594', '1', 'pointxtreme','', '', '', 'YES', '', '', '', '', '68.9.47.254', '68.9.47.254')
[12] => DELETE FROM cpg133_temp_data WHERE unique_ID = '75c847e7'
)
==========================
GET :
------------------
Array
(
)
==========================
POST :
------------------
Array
(
[album] => 142
[title] =>
[caption] =>
[keywords] =>
[control] => phase_2
[unique_ID] => 75c847e7
)
==========================
VERSION INFO :
------------------
PHP version: 4.3.11 - OK
------------------
mySQL version: 4.0.23a
------------------
Coppermine version: 1.3.3
==========================
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 4.0.21
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /tmp/mysql.sock
MYSQL_INCLUDE -I/usr/local/include/mysql
MYSQL_LIBS -L/usr/local/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/local/lib/php | .:/usr/local/lib/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 | 30 | 30
max_input_time | -1 | -1
upload_max_filesize | 8M | 8M
post_max_size | 8M | 8M
==========================
Page generated in 0.246 seconds - 13 queries in 0.01 seconds - Album set :
That's debug output - we need the actual error message, like an ImageMagick error message, some sort of upload error message, etc. I also tried going to your site, but "www.images-pointxtreme.com could not be found"
www.images.pointxtreme.com
www.pointxtreme.com is my site and the images is a sub-domain, sorry about that.
You didn't switch to single file uploads like I requested. Please do so, otherwise I can't help you.
http://coppermine.sourceforge.net/tutorial/uploads/troubleshooting.php