Cannot batch add WMV Files

[zany_brainy]

I just upgraded from CPG 1.2.1 to CPG 1.3.2
Everything seems to work fine, except I cannot add WMV/MPG files using the batch add mode or upload mode

In the Upload File I got the file uploaded successfully message but could not place it in an album

Script called without the required parameter(s).

File: /usr/local/apache/htdocs/www/XXXSITENAMEXX/www/members/gallery/upload.php - Line: 2082

Debug code is below

Code Select Expand

USER:
------------------
Array
(
   [ID] => f324cc29ee805f4b73e54384f9569b6c
   [am] => 1
   [liv] => Array
       (
           [0] => 228
           [1] => 77
           [2] => 4007
           [3] => 254
           [4] => 4065
       )

   [lap] => 25
   [uid] => 1
)

==========================
USER DATA:
------------------
Array
(
   [user_id] => 1
   [user_group] => 1
   [user_active] => YES
   [user_name] => admin
   [user_password] => ********
   [user_lastvisit] => 2005-01-05 01:48:27
   [user_regdate] => 2004-04-16 14:07:22
   [user_group_list] =>
   [user_email] =>
   [user_website] =>
   [user_location] =>
   [user_interests] =>
   [user_occupation] =>
   [user_actkey] =>
   [user_favpics] =>
   [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] => 0
   [has_admin_access] => 1
   [pub_upl_need_approval] => 0
   [priv_upl_need_approval] => 0
   [group_name] => Unregistered / Not Logged In
   [upload_form_config] => 3
   [group_quota] => 0
   [can_see_all_albums] => 1
   [group_id] => 1
   [groups] => Array
       (
           [1] => 1
       )

)

==========================
Queries:
------------------
Array
(
   [0] => SELECT extension, mime, content FROM psg_filetypes;
   [1] => SELECT * FROM psg_users WHERE user_id='1'AND user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = '4b33fa9ec2a9077ed40fda3336b14ee7'
   [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 psg_usergroups WHERE group_id in (1)
   [3] => SELECT group_name FROM  psg_usergroups WHERE group_id= 1
   [4] => DELETE FROM psg_banned WHERE expiry < 1104908346
   [5] => SELECT * FROM psg_banned WHERE ip_addr='69.110.149.148' OR ip_addr='69.110.149.148' OR user_id=1
)

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

==========================
POST :
------------------
Array
(
   [album] => 86
   [title] =>
   [caption] => Sis in law video this time
   [keywords] =>
   [control] => phase_2
   [unique_ID] => 2bd3654a
   [movie_wd] =>
   [movie_ht] =>
)

==========================
VERSION INFO :
------------------
PHP version: 4.3.4 - OK
------------------
mySQL version: 4.0.18-standard
------------------
Coppermine version: 1.3.2
==========================
Module: gd
------------------
GD Support enabled
GD Version bundled (2.0.15 compatible)
GIF Read Support enabled
JPG Support enabled
PNG Support enabled
WBMP Support enabled
XBM Support enabled
JIS-mapped Japanese Font Support enabled
==========================
Module: mysql
------------------
Active Persistent Links 0
Active Links 1
Client API version 3.23.49
MYSQL_MODULE_TYPE builtin
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE no value
MYSQL_LIBS no value
==========================
Module: zlib
------------------
ZLib Support enabled
Compiled Version 1.2.1
Linked Version 1.2.1
==========================
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/php/lib/php | .:/usr/local/php/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 | 50M | 50M
post_max_size | 8M | 8M
==========================
Page generated in 0.108 seconds - 6 queries in 0.004 seconds - Album set :

[Tranz]

post_max_size | 8M | 8M

Might your files be bigger than 8MB?

[zany_brainy]

The error code above was for direct 'file upload' the file was only 3 MB and it uploaded properly. The error occurred when I tried to place it in an album.

Also in the case of Batch Import, the files are already in the server and only need to be added to the database right ?


When I try batch add it gives me <PB> for the files

and here is the debug code

Code Select Expand



USER:
------------------
Array
(
   [ID] => 5adc4e3e0f9b2c69a5057a401ca195b9
   [am] => 1
)

==========================
USER DATA:
------------------
Array
(
   [user_id] => 1
   [user_group] => 1
   [user_active] => YES
   [user_name] => admin
   [user_password] => ********
   [user_lastvisit] => 2005-01-05 03:28:20
   [user_regdate] => 2004-04-16 14:07:22
   [user_group_list] =>
   [user_email] =>
   [user_website] =>
   [user_location] =>
   [user_interests] =>
   [user_occupation] =>
   [user_actkey] =>
   [user_favpics] =>
   [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] => 0
   [has_admin_access] => 1
   [pub_upl_need_approval] => 0
   [priv_upl_need_approval] => 0
   [group_name] => Unregistered / Not Logged In
   [upload_form_config] => 3
   [group_quota] => 0
   [can_see_all_albums] => 1
   [group_id] => 1
   [groups] => Array
       (
           [1] => 1
       )

)

==========================
Queries:
------------------
Array
(
   [0] => SELECT extension, mime, content FROM psg_filetypes;
   [1] => SELECT * FROM psg_users WHERE user_id='1'AND user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = '4b33fa9ec2a9077ed40fda3336b14ee7'
   [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 psg_usergroups WHERE group_id in (1)
   [3] => SELECT group_name FROM  psg_usergroups WHERE group_id= 1
   [4] => DELETE FROM psg_banned WHERE expiry < 1104913739
   [5] => SELECT * FROM psg_banned WHERE ip_addr='68.125.48.186' OR ip_addr='68.125.48.186' OR user_id=1
)

==========================
GET :
------------------
Array
(
   [insert] => 1
)

==========================
POST :
------------------
Array
(
   [d0000] => 259
   [album_lb_id_i0000] => d0000
   [picfile_i0000] => dXNlcnZpZHMvQmFsaml0IEthdXIvYmFsaml0MDEuanBn
   [album_lb_id_i0001] => d0000
   [picfile_i0001] => dXNlcnZpZHMvQmFsaml0IEthdXIvQmFsaml0MS5odG1s
   [album_lb_id_i0002] => d0000
   [picfile_i0002] => dXNlcnZpZHMvQmFsaml0IEthdXIvYmFsaml0X2dldHRpbmdfbmFrZWRfb25fYmVkLmpwZw==
   [pics] => Array
       (
           [0] => i0003
           [1] => i0005
       )

   [album_lb_id_i0003] => d0000
   [picfile_i0003] => dXNlcnZpZHMvQmFsaml0IEthdXIvYmFsaml0X2dldHRpbmdfbmFrZWRfb25fYmVkLndtdg==
   [album_lb_id_i0004] => d0000
   [picfile_i0004] => dXNlcnZpZHMvQmFsaml0IEthdXIvYmFsaml0X211c3RlcmJhdGluZ19pbl90aGVfc2hvd2VyLmpwZw==
   [album_lb_id_i0005] => d0000
   [picfile_i0005] => dXNlcnZpZHMvQmFsaml0IEthdXIvYmFsaml0X211c3RlcmJhdGluZ19pbl90aGVfc2hvd2VyLndtdg==
   [insert] => Insert selected files
)

==========================
VERSION INFO :
------------------
PHP version: 4.3.4 - OK
------------------
mySQL version: 4.0.18-standard
------------------
Coppermine version: 1.3.2
==========================
Module: gd
------------------
GD Support enabled
GD Version bundled (2.0.15 compatible)
GIF Read Support enabled
JPG Support enabled
PNG Support enabled
WBMP Support enabled
XBM Support enabled
JIS-mapped Japanese Font Support enabled
==========================
Module: mysql
------------------
Active Persistent Links 0
Active Links 1
Client API version 3.23.49
MYSQL_MODULE_TYPE builtin
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE no value
MYSQL_LIBS no value
==========================
Module: zlib
------------------
ZLib Support enabled
Compiled Version 1.2.1
Linked Version 1.2.1
==========================
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/php/lib/php | .:/usr/local/php/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 | 50M | 50M
post_max_size | 8M | 8M
==========================
Page generated in 0.175 seconds - 6 queries in 0.004 seconds - Album set :


[zany_brainy]

The file has been uploaded and already resides in the /albums/userpics/110868/
folder, so the error is related to placing video files in albums and not uploading..


Maybe this will help you guys help me identify the problem