Hi there, I've read TFM three times, I've searched this board, but see nothing to shed some light on the problem.
I had about ten albums with about 100 pics each. Then I decided to actually put these into categories. I've created a few categories and subcategories and managed without problems assigning albums to all albums. All but one. One album refuses to be assigned anywhere and remains in "No category" category. I've tried renaming it, I've tried to put it into a different category, I've tried running 'delete orphan comments', I've deleted ALL the comments in the album, I've changed the CHMOD on db_input.php to 777 (even though it worked fine for all the other albums), yet the darn thing won't budge. I am the sole creator and admin of the site, I have created the albums, I have created the categories. Since there is nothing visible unless you are registered, I am not posting the web page address here ...yet.
Debug reported the following:
USER:
------------------
Array
(
[ID] => 13d0f5a9b3bc9da9d510abd6d5d1bbf4
[am] => 1
[lang] => english_gb
[theme] => kangabirch
[liv] => Array
(
[0] => 546
[1] => 543
[2] => 544
)
[sort] => pa
[lap] => 1
)
==========================
USER DATA:
------------------
Array
(
[user_id] => 1
[user_name] => XXXXXX
[groups] => Array
(
[0] => 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
(
[0] => SELECT extension, mime, content, player FROM cpg14x_filetypes; (0s)
[1] => select * from cpg14x_plugins order by priority asc; (0s)
[2] => delete from `werewolf_photobase`.cpg14x_sessions where time<1222964571 and remember=0; (0s)
[3] => delete from `werewolf_photobase`.cpg14x_sessions where time<1221758571; (0s)
[4] => select user_id from `werewolf_photobase`.cpg14x_sessions where session_id = 'f8e0d8756acd95e3f0566df9a93dfc30' (0s)
[5] => select user_id as id, user_password as password from `werewolf_photobase`.cpg14x_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 `werewolf_photobase`.cpg14x_users AS u INNER JOIN `werewolf_photobase`.cpg14x_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0s)
[7] => SELECT user_group_list FROM `werewolf_photobase`.cpg14x_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 cpg14x_usergroups WHERE group_id in (1) (0s)
[9] => SELECT group_name FROM cpg14x_usergroups WHERE group_id= 1 (0s)
[10] => update `werewolf_photobase`.cpg14x_sessions set time='1222968171' where session_id = 'f8e0d8756acd95e3f0566df9a93dfc30' (0s)
[11] => SELECT user_favpics FROM cpg14x_favpics WHERE user_id = 1 (0s)
[12] => DELETE FROM cpg14x_banned WHERE expiry < '2008-10-02 10:22:51' (0s)
[13] => SELECT * FROM cpg14x_banned WHERE (ip_addr='75.157.28.248' OR ip_addr='75.157.28.248' OR user_id=1) AND brute_force=0 (0s)
[14] => SELECT * FROM cpg14x_albums WHERE aid='4' (0s)
[15] => SELECT COUNT(*) FROM cpg14x_pictures WHERE approved = 'NO' (0s)
[16] => SELECT aid, title FROM cpg14x_albums WHERE category < '10000' ORDER BY title (0.001s)
[17] => SELECT aid, CONCAT('(', user_name, ') ', a.title) AS title
FROM cpg14x_albums AS a
INNER JOIN `werewolf_photobase`.cpg14x_users AS u
ON category = (10000 + user_id)
ORDER BY title (0.001s)
[18] => SELECT cid, name, description FROM cpg14x_categories WHERE parent = '0' AND cid != 1 ORDER BY pos (0s)
[19] => SELECT cid, name, description FROM cpg14x_categories WHERE parent = '2' AND cid != 1 ORDER BY pos (0s)
[20] => SELECT cid, name, description FROM cpg14x_categories WHERE parent = '5' AND cid != 1 ORDER BY pos (0s)
[21] => SELECT cid, name, description FROM cpg14x_categories WHERE parent = '6' AND cid != 1 ORDER BY pos (0s)
[22] => SELECT cid, name, description FROM cpg14x_categories WHERE parent = '3' AND cid != 1 ORDER BY pos (0s)
[23] => SELECT cid, name, description FROM cpg14x_categories WHERE parent = '4' AND cid != 1 ORDER BY pos (0s)
[24] => SELECT pid, filepath, filename, url_prefix FROM cpg14x_pictures WHERE aid='4' AND approved='YES' ORDER BY filename (0.001s)
[25] => SELECT group_id, group_name FROM cpg14x_usergroups WHERE 1 (0s)
[26] => SELECT SUM(hits) FROM cpg14x_pictures WHERE aid='4' (0.001s)
[27] => SELECT SUM(votes) FROM cpg14x_pictures WHERE aid='4' AND votes > 0 (0.001s)
[28] => SELECT COUNT(*) FROM cpg14x_pictures WHERE aid='4' (0.001s)
)
==========================
GET :
------------------
Array
(
[album] => 4
)
==========================
POST :
------------------
Array
(
)
==========================
VERSION INFO :
------------------
PHP version: 4.4.7 - OK
------------------
mySQL version: 5.0.51a-log
------------------
Coppermine version: 1.4.19(stable)
==========================
Module: GD
------------------
GD Version: bundled (2.0.28 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
XBM Support: 1
JIS-mapped Japanese Font Support:
==========================
Module: mysql
------------------
MySQL Supportenabled
Active Persistent Links 0
Active Links 1
Client API version 4.1.11
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/run/mysqld/mysqld.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -lmysqlclient
==========================
Module: zlib
------------------
ZLib Support enabled
Compiled Version 1.2.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/local/lib/php-4.4.7/lib/php | .:/usr/local/lib/php-4.4.7/lib/php
open_basedir | no value | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | wwwuser@cgi.yourhostingaccount.com | wwwuser@cgi.yourhostingaccount.com
sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
SMTP | mail.yourhostingaccount.com | mail.yourhostingaccount.com
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 | 10M | 10M
post_max_size | 11M | 11M
==========================
Page generated in 0.276 seconds - 29 queries in 0.006 seconds - Album set : ; Meta set: ;
Under Notices it offers this ray of sunshine:
/modifyalb.php
* Notice line 580: Undefined variable: comments
When it tries to run, it opens up a page with the following msg:
Forbidden
You don't have permission to access /cpg1419/db_input.php on this server.
If the problem was the same for all the albums and categories, it would be annoying, but consistent. But everything else has worked fine. I did consider reloading the entire album, but since I've spent about four hours with descriptions of more then 100 photos, I am a bit reluctant.
Any ideas will be appreciated.
Cheers