Album will not move into a Category

[Hagrid]

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:

Code Select Expand

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

[Joachim Müller]

http://forum.coppermine-gallery.net/index.php/topic,55415.msg270616.html#msg270616

[Hagrid]

OK, there obviously isn't a quick and simple answer,  the gallery is at

http://www.kangabear.com

The album which is hanging where it is is called Mt Baker, WA

User: testuser
pswd: helpforum

Cheers

Hagrid

[Joachim Müller]

Please PM me an admin account

[Joachim Müller]

I get a "403 forbidden" error when submitting the form http://www.kangabear.com/cpg1419/modifyalb.php?album=4 that sends me to http://www.kangabear.com/cpg1419/db_input.php
So I played a bit around, noticing that the only unusual thing is the fact that the album dsecription is very long, so I truncated it. Submitting the form then worked as expected. I haven't looked into the code to figure out what the reason might be (limitations of the form field length maybe). Anyway, here's the full text of the album description that I wasn't able to add back in:

At 3,285 m, Mount Baker, an active glaciated stratovolcano in the Cascade Volcanic Arc and the Cascades of Washington State in the United States, lies just across the border from Canada. It is best visible from the higher grounds of the Fraser Valley east of Vancouver, and from as far as Vancouver Island. It is the fourth highest mountain in Washington State. It is also one of the snowiest places in the world; in 1999, Mount Baker Ski Area, located on a subsidiary peak, set the world record for snowfall in a single season 2,896 cm (28m!!! fair dinkum). The photos here were taken on two trips, the first on 6 June '08, still mostly under snow and closed roads, the next on 23 July '08.

I was able to move the album itself into the proper category, using the admin details you PMed me. I will move this thread to the bugs board to make sure this doesn't get forgotten - maybe another dev can shed some light and this issue sounds familiar to him/her.

[Hagrid]

Thanks for your time and solution!

While the bug solution may now be someone else's headache, I do feel certain elation from the fact that it wasn't my screw up ... as often is the case.

Cheers

Hagrid

[Joachim Müller]

Taking a closer look at this issue I was able to shed some light on this and I must confess that my initial advice was wrong: you appear to have over-edited your site, so the problem actually lies on your end: there is a number of files missing on your server. The file that is being missed in relation to your issue is http://www.kangabear.com/cpg1419/script.js
Restore that file. Take a look at versioncheck to figure out what other files are missing.
Moving this thread back from the bugs board to the regular support board.

[Nibbler]

It's scripts.js and it is there. Even if it was missing I don't see how it would cause this.

[Joachim Müller]

It's scripts.js and it is there. Even if it was missing I don't see how it would cause this.

scripts.js in cpg1.5.x contains code that keeps you from entering more text into the textarea than you're supposed to, that's why I refered to it, but I stand corrected: you're right - scripts.js for cpg1.4.x doesn't contain that code.