some pics return "does not exist", some are fine

[ashsimmonds]

hello, for some reason a lot of the pics on my gallery come back with the dreaded "The selected album/file does not exist !" error when you go directly to their ID URL, but i can't find a pattern to it as some of them are fine.

here's one that's broken:
---> http://aussieexotics.com/drivers/displayimage-989.html

and here's one that's fine:
---> http://aussieexotics.com/drivers/displayimage-999.html

i have the search-engine friendly stuff going, but this error has been there before that (ie. using displayimage.php?id=-989 or whatever) so is nothing to do with it.  also, my gallery is bridged with SMF.

if it's any help, nearly all of these pics have been brought in from an old system whereby i as admin uploaded them and then used phpmyadmin to change the owner given there's no option within CPG to modify ownership/move pics/albums etc.

[ashsimmonds]

here's the error code for the one that's busted:

Code Select Expand


USER:
------------------
Array
(
    [ID] => 61a9b252503ced57836da9e4a04fec90
    [am] => 1
    [lang] => english
    [liv] => Array
        (
            [0] => 1013
        )

    [search] => Array
        (
            [search] => horse
            [album] => search
            [title] => on
            [newer_than] =>
            [caption] => on
            [older_than] =>
            [keywords] => on
            [type] => AND
            [params] => Array
                (
                    [title] => on
                    [caption] => on
                    [keywords] => on
                )

        )

    [sort] => nd
    [lap] => 1
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 2
    [user_name] => ashsimmonds
    [groups] => Array
        (
            [0] => 1
            [1] => 9
            [2] => 13
            [3] => 14
            [4] => 16
        )

    [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] => 3
    [num_URI_upload] => 5
    [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 cpg1410_filetypes; (0s)
    [1] => select * from cpg1410_plugins order by priority asc; (0s)
    [2] => SELECT * FROM cpg1410_bridge (0s)
    [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 cpg1410_usergroups WHERE group_id in (1,9,13,14,16) (0s)
    [4] => SELECT group_name FROM  cpg1410_usergroups WHERE group_id= 1 (0s)
    [5] => SELECT user_favpics FROM cpg1410_favpics WHERE user_id = 2 (0s)
    [6] => DELETE FROM cpg1410_banned WHERE expiry < '2007-07-11 00:42:44' (0s)
    [7] => SELECT * FROM cpg1410_banned WHERE (ip_addr='121.45.83.105' OR ip_addr='121.45.83.105' OR user_id=2) AND brute_force=0 (0s)
    [8] => SELECT aid from cpg1410_pictures WHERE pid='989'  LIMIT 1 (0s)
    [9] => SELECT title,keyword from cpg1410_albums WHERE aid='29' (0s)
    [10] => SELECT COUNT(*) from cpg1410_pictures WHERE ((aid='29'  ) )   (0s)
    [11] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid, keywords, title, caption,hits,owner_id,owner_name from cpg1410_pictures WHERE ((aid='29'  ) )   ORDER BY filename DESC  (0.001s)
    [12] => SELECT title,keyword from cpg1410_albums WHERE aid='29' (0s)
    [13] => SELECT COUNT(*) from cpg1410_pictures WHERE ((aid='29'  ) )   (0s)
    [14] => SELECT * from cpg1410_pictures WHERE ((aid='29'  ) )   ORDER BY filename DESC  LIMIT 18 ,1 (0.003s)
    [15] => SELECT title, comments, votes, category, aid FROM cpg1410_albums WHERE aid='29' LIMIT 1 (0s)
    [16] => SELECT memberName as user_name FROM `aussieex_smf`.smf_members WHERE ID_MEMBER = '5' (0s)
    [17] => SELECT cid, name, parent FROM cpg1410_categories WHERE cid = '1' (0s)
    [18] => SELECT COUNT(*) FROM cpg1410_pictures WHERE approved = 'NO' (0s)
)

==========================
GET :
------------------
Array
(
    [pos] => -989
    [isplayimage-989] =>
    [action] => drivers
)

==========================
POST :
------------------
Array
(
)

==========================
VERSION INFO :
------------------
PHP version: 5.2.0 - OK
------------------
mySQL version: 5.0.27-standard
------------------
Coppermine version: 1.4.10(stable)
==========================
Module: GD
------------------
GD Version: bundled (2.0.28 compatible)
FreeType Support:
T1Lib Support:
GIF Read Support: 1
GIF Create Support: 1
JPG Support: 1
PNG Support: 1
WBMP Support: 1
XPM Support: 1
XBM Support: 1
JIS-mapped Japanese Font Support:

==========================
Module: mysql
------------------
MySQL Supportenabled
Active Persistent Links 1
Active Links 2
Client API version 5.0.27
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -lmysqlclient 
==========================
Module: zlib
------------------
ZLib Support enabled
Stream Wrapper support compress.zlib://
Stream Filter support zlib.inflate, zlib.deflate
Compiled Version 1.2.1.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/lib/php | .:/usr/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 | 5M | 5M
post_max_size | 8M | 8M
==========================
Page generated in 0.205 seconds - 19 queries in 0.004 seconds - Album set : ; Meta set: ;


[ashsimmonds]

ok, after much trial and tribulation i think i've found a correlation between the ones that werk and those that don't...

the ones that werk DO NOT have an intermediate picture whereas the ones that are stuffed DO have an intermediate picture.

so for eg say my intermediate size is 700px and a user uploads a 640px image, the direct URL link werks fine for that image.  however if they upload a 1200px picture which has an intermediate image generated, the direct URL is borked.

[ashsimmonds]

i just did another test to confirm... i edited the database so that the image width/height properties in the db were below the intermediate pic thresh-hold, once i did this, the direct URL werks just fine, so it's something to do with intermediate pic sizes in the database.

here's a link to the one that i changed the size of the image in the database:
---> http://aussieexotics.com/drivers/displayimage-990.html

if you check the properties of the pic, you'll notice it's actually 2560x1706 and not 640x480 as displayed because of how it's now listed in the db.

[ashsimmonds]

any ideas?

[Joachim Müller]

Turn off the SEF_URL plugin if you have issues with it.

[ashsimmonds]

Turn off the SEF_URL plugin if you have issues with it.

as i said, it has nothing to do with that.  was happening long before that was enabled.

[Joachim Müller]

here's one that's broken:
---> http://aussieexotics.com/drivers/displayimage-989.html

Post a deep link to the parent category of that album and describe what link to click to see the error message you report.

[ashsimmonds]

Post a deep link to the parent category of that album and describe what link to click to see the error message you report.

it doesn't matter which one, the point is *any* image which has an intermediate image - ie. original is larger than the intermediate setting - fails.  any image which is smaller than the intermediate setting werks fine.


in this case, the parent category is:
---> http://aussieexotics.com/drivers/thumbnails-29.html


here's two different images from that gallery:

this one werks because the uploaded image is smaller than the intermediate size:
---> http://aussieexotics.com/drivers/displayimage-735.html

this one doesn't because the uploaded image is LARGER than the intermediate size:
---> http://aussieexotics.com/drivers/displayimage-738.html

you can get to it through the link which shows the album + pic #, but it's mostly useless because that number is dependent on the specific user's sort setting.
---> http://aussieexotics.com/drivers/displayimage-29-3.html

[Joachim Müller]

How could an intermediate image exist for a file where the uploaded pic is smaller than the intermediate-sized image? That's nonsense: if a file is being uploaded that is smaller (in terms of dimensions) than what you have specified for the dimensions of the intermediate image, no intermediate image is being created at all.
As suggested: turn the SEF_URLs plugin off. Upgrade to the most recent version (you have cpg1.4.10, while the most recent stable release is cpg1.4.12). Make sure that your "Click here to show links"-hack isn't the culprit for any unexpected behaviour.

[ashsimmonds]

How could an intermediate image exist for a file where the uploaded pic is smaller than the intermediate-sized image? That's nonsense: if a file is being uploaded that is smaller (in terms of dimensions) than what you have specified for the dimensions of the intermediate image, no intermediate image is being created at all.

huh?  of course not.  i'm saying that images uploaded which are smaller than the intermediate setting size do NOT have a problem, it is only the ones which are LARGER than the intermediate size which cause it to die.  not sure how i can say it clearer.

As suggested: turn the SEF_URLs plugin off. Upgrade to the most recent version (you have cpg1.4.10, while the most recent stable release is cpg1.4.12). Make sure that your "Click here to show links"-hack isn't the culprit for any unexpected behaviour.

it was before the click to show links, and has nothing to do with SEF stuff.  never mind i'll figger it out later.  danke.