Newbie batch add problem Newbie batch add problem
 

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Main Menu

Newbie batch add problem

Started by dss, November 09, 2006, 11:53:26 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

dss

Hi,

I'm a newbie to this application which was installed through psoft's software with an install button. That went easy and I've created some categories and tried to batch add what I've ftp into the albums folder. When I clicked on my album I got question marks rather then what I assume is supposed to be thumbnails on the right side. Here is what notices I got below that: /include/functions.inc.php
Warning line 2911: cannot yet handle MBCS in html_entity_decode()!
Notice line 2661: Undefined variable: i
/searchnew.php
Notice line 100: Undefined variable: sel_album

I had forgotten the 1st time to pick a category and got NA which shows me it's working to a degree.
Next I picked a category and On next screen I still had question marks under the Result column.
I tried clicking on the question marks and got: Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 5760 bytes) in /hsphere/local/home/photos/winevalleyphoto.com/photos/include/picmgmt.inc.php on line 259
Pleas Help!
Here is the Dubug Info: USER:
------------------
Array
(
    [ID] => 360ad2eb0886d08de8f2235f4e0b79b7
    [am] => 1
    [lang] => english
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_name] => admin
    [groups] => Array
        (
           
  • => 1
            )

        [disk_max] => 2024
        [disk_min] => 2024
        [can_rate_pictures] => 1
        [can_send_ecards] => 1
        [ufc_max] => 3
        [ufc_min] => 3
        [custom_user_upload] => 0
        [num_file_upload] => 4
        [num_URI_upload] => 2
        [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] => 2024
        [can_see_all_albums] => 1
        [group_id] => 1
    )

    ==========================
    Queries:
    ------------------
    Array
    (
       
  • => SELECT extension, mime, content, player FROM cpg140_filetypes; (0.005s)
        [1] => select * from cpg140_plugins order by priority asc; (0.002s)
        [2] => delete from `photos_coppermine`.cpg140_sessions where time<1163106250 and remember=0; (0.002s)
        [3] => delete from `photos_coppermine`.cpg140_sessions where time<1161900250; (0.002s)
        [4] => select user_id from `photos_coppermine`.cpg140_sessions where session_id=md5("537a5ec7cdddde249983283b3f21d62be7b038af6f1a3f2a360315d1339d95e4"); (0.002s)
        [5] => select user_id as id, user_password as password from `photos_coppermine`.cpg140_users where user_id=1 (0.002s)
        [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 `photos_coppermine`.cpg140_users AS u INNER JOIN `photos_coppermine`.cpg140_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0.002s)
        [7] => SELECT user_group_list FROM `photos_coppermine`.cpg140_users AS u WHERE user_id='1' and user_group_list <> ''; (0.002s)
        [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 cpg140_usergroups WHERE group_id in (1) (0.003s)
        [9] => SELECT group_name FROM  cpg140_usergroups WHERE group_id= 1 (0.002s)
        [10] => update `photos_coppermine`.cpg140_sessions set time='1163109850' where session_id=md5('537a5ec7cdddde249983283b3f21d62be7b038af6f1a3f2a360315d1339d95e4'); (0.002s)
        [11] => SELECT user_favpics FROM cpg140_favpics WHERE user_id = 1 (0.002s)
        [12] => DELETE FROM cpg140_banned WHERE expiry < '2006-11-09 22:04:10' (0.002s)
        [13] => SELECT * FROM cpg140_banned WHERE (ip_addr='24.23.36.95' OR ip_addr='24.23.36.95' OR user_id=1) AND brute_force=0 (0.002s)
        [14] => SELECT aid, title FROM cpg140_albums WHERE 1 (0.002s)
        [15] => SELECT COUNT(*) FROM cpg140_pictures WHERE approved = 'NO' (0.002s)
    )

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

    ==========================
    POST :
    ------------------
    Array
    (
        [d0000] => 2
        [pics] => Array
            (
               
  • => i0000
                [1] => i0001
                [2] => i0002
                [3] => i0003
                [4] => i0004
                [5] => i0005
            )

        [album_lb_id_i0000] => d0000
        [picfile_i0000] => U2hvd3MvYXJ0X3dhbGsuanBn
        [album_lb_id_i0001] => d0000
        [picfile_i0001] => U2hvd3MvYXJ0X3dhbGsyLmpwZw==
        [album_lb_id_i0002] => d0000
        [picfile_i0002] => U2hvd3MvYXJ0X3dhbGszLmpwZw==
        [album_lb_id_i0003] => d0000
        [picfile_i0003] => U2hvd3MvYXJ0X3dhbGs0LmpwZw==
        [album_lb_id_i0004] => d0000
        [picfile_i0004] => U2hvd3MvYXJ0X3dhbGs1LmpwZw==
        [album_lb_id_i0005] => d0000
        [picfile_i0005] => U2hvd3MvYXJ0X3dhbGs2LmpwZw==
        [album_lb_id_i0006] => d0000
        [picfile_i0006] => U2hvd3MvZWdncGxhbnRfZmVzdGl2YWwuanBn
        [album_lb_id_i0007] => d0000
        [picfile_i0007] => U2hvd3MvZWdncGxhbnRfZmVzdGl2YWwyLmpwZw==
        [album_lb_id_i0008] => d0000
        [picfile_i0008] => U2hvd3MvZWdncGxhbnRfZmVzdGl2YWwzLmpwZw==
        [album_lb_id_i0009] => d0000
        [picfile_i0009] => U2hvd3Mvc2VyZW5pdHlfc3BhLmpwZw==
        [album_lb_id_i0010] => d0000
        [picfile_i0010] => U2hvd3Mvc2VyZW5pdHlfc3BhMi5qcGc=
        [album_lb_id_i0011] => d0000
        [picfile_i0011] => U2hvd3Mvc2VyZW5pdHlfc3BhMy5qcGc=
        [album_lb_id_i0012] => d0000
        [picfile_i0012] => U2hvd3Mvc2VyZW5pdHlfc3BhNC5qcGc=
        [album_lb_id_i0013] => d0000
        [picfile_i0013] => U2hvd3Mvc2VyZW5pdHlfc3BhNS5qcGc=
        [album_lb_id_i0014] => d0000
        [picfile_i0014] => U2hvd3Mvc2VyZW5pdHlfc3BhNi5qcGc=
        [album_lb_id_i0015] => d0000
        [picfile_i0015] => U2hvd3Mvc2VyZW5pdHlfc3BhNy5qcGc=
        [album_lb_id_i0016] => d0000
        [picfile_i0016] => U2hvd3Mvc2VyZW5pdHlfc3BhOC5qcGc=
        [insert] => Insert selected files
    )

    ==========================
    VERSION INFO :
    ------------------
    PHP version: 4.4.4 - OK
    ------------------
    mySQL version: 4.1.21-log
    ------------------
    Coppermine version: 1.4.4(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.15
    MYSQL_MODULE_TYPE external
    MYSQL_SOCKET /var/lib/mysql/mysql.sock
    MYSQL_INCLUDE -I/usr/include/mysql
    MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient 
    ==========================
    Module: zlib
    ------------------
    ZLib Support enabled
    Compiled Version 1.2.3
    Linked Version 1.2.1.2
    ==========================
    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 | .:/hsphere/shared/apache/libexec/php4ext/php/ | .:/hsphere/shared/apache/libexec/php4ext/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 | 40 | 40
    max_input_time | 60 | 60
    upload_max_filesize | 2M | 2M
    post_max_size | 8M | 8M
    ==========================
    Page generated in 0.168 seconds - 16 queries in 0.036 seconds - Album set : ; Meta set: ;

Bruce

You made Categories ... but did you make at least one Album inside a Category? You can't upload to a Category - has to be an album.

Did you make a directory for uploads at your FTP to upload your batch to?

dss

Hi Bruce,
Thanks for your reply!
Yes I ftp "Shows" and "Aioli" directories to the root of "Albums".
Those directories had 17 & 25 .jpg's in them. I had created a couple
albums before I could really tell what was going on.

Then as I mentioned "batch add files" actually allowed me to choose
"Shows" and I checked only 6 .jpg's (yet they were represented by
question marks) then per my mistake of not selecting from the pull
down got "NA" in the "result" column. I then did it again. I never got
"OK", "DP", or "PB". I got "Adding new files to the gallery" and those
same question marks under the result column.

kegobeer

Are you using UTF-8?  If so, try switching to a non UTF-8 character set.  The "cannot yet handle MBCS in html_entity_decode" error is because your version of PHP doesn't handle UTF-8 very well in the html_entity_decode function.

Google for "cannot yet handle MBCS in html_entity_decode".
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots

Joachim Müller

Before doing anything else: we don't recommend auto-installers - they are outdated and buggy. You have cpg1.4.4, which has known flaws. Upgrading to the most recent version (currently cpg1.4.10) is mandatory. Please read the documentation as well and do as suggested there, and leave notices_display off unless you're a coder.

dss

Thanks so much for all your suggestions!

I left earlier today after my last reply to Bruce,
but when I did I ftp'd another folder of pict's made
smaller (800x533) as opposed to the 1440x960.jpg's.
They worked, so I resized the original ones I had up,
down to the smaller size and now they work;-)

I now have 3 Categories with 7 Albums, and 4 albums
now finally have pictures in them. The PROBLEM now
is that when I click on them to see the album(s) it
says something like this for anything non admin I click on:
Not Found

The requested URL /photos/thumbnails-2.html was not found on this server.
or
The requested URL /photos/displayimage-random-0--19.html was not found on this server...

So all I've been able to see in user/admin modes are the thumbnails on the
home and can't go to links like "My gallery" without that problem.

GauGau - I'm just learning there is an update, could you please share with me how to
update this install, and where to get it? Like I said it cam with my server install through
something called "Easy Apps Collection". Can I just replace files through ftp? If I have to
completely delete the whole thing and start over from scratch, then how do I save my titles,
categories, albums and such, with commments and descriptions? Is there a file(s) to save for that.

Thanks again!

Joachim Müller

#6
Quote from: dss on November 10, 2006, 02:02:38 PM
The requested URL /photos/thumbnails-2.html was not found on this server.
or
The requested URL /photos/displayimage-random-0--19.html was not found on this server...
Turn the SEF_URL plugin off then.

Quote from: dss on November 10, 2006, 02:02:38 PM
could you please share with me how to update this install, and where to get it?
As I already told you: you're suppossed to read the documentation - there's a link to it at the top of this page. There's a whole section dedicated to upgrading. You can download the needed package from the downloads section (again: link at the top of this page).

Please do so right now: read the documentation. Do this now, before doing anything else. If upgrading doesn't solve your issues, do exactly as suggested in the upload troubleshooting section of the docs.

dss

Thanks GauGau,

Awsome! Now I see what others are saying. I had done the documentation link but for some reason (probably lacking sleep) I wanted my hand held, butt wiped;-) I did go through that upload troubleshooting that I saw from another post and that didn't fix a thing. It was your SEF_UUL plugin that did the trick. Thanks again!