Server or Client Side?

[dazeffect]

I am trying to add photos to no avail... So far i have:

1) installed and successfully setup CPG
2) created a category
3) created an album within the category
4) created a folder on the ftp within the albums folder and set the CHMOD to 777
5) uploaded my photos to that folder
6) logged into CPG as admin and went to batch add pictures
7) selected the directory
8) it starts to display the thumbnails ok
9) there are ticks in the boxes
10) i then select the folder to "put" the pictures into, click insert
11) and as the script is adding the images, the image (in the result column) does not appear (its an image not found place holder)
12) if you then click on "album list" and goto the folder, all you can see is a greyed out image. the pictures did not add.
13) if i then goto the FTP, i can see the script HAS actually added the "normal" & "thumb" images of the original photo.


So it appears the script is working and creating the thumbnails, however it fails to add them to the photo gallery.

I have

* Coppermine V1.2.1
* PHP v4.3.3
* Apache 1.3.29
* GD 2.0.15 (all enabled)

any help & ideas please...

[dazeffect]

UPDATE

if you click on one of the broken images in the results column, it takes me to a "critical error" page with the message

"There was an error while processing a database query"


I have doubled checked and trippled checked and the database config file is ok.... any ideas please

[hyperion]

Activate debug mode.

[dazeffect]

UPDATE

This is the info from the DEBUG, im afraid i dont understand this code? Does it highlight whats wrong?

Code Select Expand

USER:
Array
(
    [ID] => 3c4d60112eb81aa2194c410d61f568aa
    [am] => 1
    [liv] => Array
        (
            [0] => 877
        )

)

 
 
USER DATA:
Array
(
    [0] => 1
    [user_id] => 1
    [1] => 1
    [user_group] => 1
    [2] => YES
    [user_active] => YES
    [3] => *********
    [user_name] => *******
    [4] => *********
    [5] => 0000-00-00 00:00:00
    [user_lastvisit] => 0000-00-00 00:00:00
    [6] => 0000-00-00 00:00:00
    [user_regdate] => 0000-00-00 00:00:00
    [7] =>
    [user_lang] =>
    [8] =>
    [user_email] =>
    [9] =>
    [user_website] =>
    [10] =>
    [user_location] =>
    [11] =>
    [user_interests] =>
    [12] =>
    [user_occupation] =>
    [13] =>
    [user_actkey] =>
    [14] => 1
    [group_id] => 1
    [15] => Administrators
    [group_name] => Administrators
    [16] => 0
    [group_quota] => 0
    [17] => 1
    [has_admin_access] => 1
    [18] => 1
    [can_rate_pictures] => 1
    [19] => 1
    [can_send_ecards] => 1
    [20] => 1
    [can_post_comments] => 1
    [21] => 1
    [can_upload_pictures] => 1
    [22] => 1
    [can_create_albums] => 1
    [23] => 0
    [pub_upl_need_approval] => 0
    [24] => 0
    [priv_upl_need_approval] => 0
)

 
 
Queries:
Array
(
    [0] => SELECT * FROM bg_users, bg_usergroups WHERE user_group = group_id AND user_id='1'AND user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = '4a5eec8f1d335943617ecac50fe0be2c'
    [1] => DELETE FROM bg_banned WHERE expiry < 1078397002
    [2] => SELECT * FROM bg_banned WHERE ip_addr='217.43.196.164' OR ip_addr='217.43.196.164' OR user_id=1
)

 
GET :
Array
(
    [insert] => 1
)

 
POST :
Array
(
    [d0000] => 195
    [pics] => Array
        (
            [0] => i0000
            [1] => i0001
            [2] => i0002
            [3] => i0003
            [4] => i0004
            [5] => i0005
            [6] => i0006
            [7] => i0007
            [8] => i0008
            [9] => i0009
            [10] => i0010
            [11] => i0011
            [12] => i0012
            [13] => i0013
            [14] => i0014
            [15] => i0015
            [16] => i0016
            [17] => i0017
            [18] => i0018
            [19] => i0019
            [20] => i0020
            [21] => i0021
            [22] => i0022
            [23] => i0023
            [24] => i0024
            [25] => i0025
            [26] => i0026
            [27] => i0027
            [28] => i0028
            [29] => i0029
            [30] => i0030
            [31] => i0031
            [32] => i0032
            [33] => i0033
            [34] => i0034
            [35] => i0035
            [36] => i0036
            [37] => i0037
            [38] => i0038
            [39] => i0039
            [40] => i0040
            [41] => i0041
            [42] => i0042
            [43] => i0043
        )

    [album_lb_id_i0000] => d0000
    [picfile_i0000] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwMDkuanBn
    [album_lb_id_i0001] => d0000
    [picfile_i0001] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwMTEuanBn
    [album_lb_id_i0002] => d0000
    [picfile_i0002] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwMTIuanBn
    [album_lb_id_i0003] => d0000
    [picfile_i0003] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwMTQuanBn
    [album_lb_id_i0004] => d0000
    [picfile_i0004] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwMTUuanBn
    [album_lb_id_i0005] => d0000
    [picfile_i0005] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwMTYuanBn
    [album_lb_id_i0006] => d0000
    [picfile_i0006] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwMTcuanBn
    [album_lb_id_i0007] => d0000
    [picfile_i0007] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwMTguanBn
    [album_lb_id_i0008] => d0000
    [picfile_i0008] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwMjMuanBn
    [album_lb_id_i0009] => d0000
    [picfile_i0009] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwMjQuanBn
    [album_lb_id_i0010] => d0000
    [picfile_i0010] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwMjYuanBn
    [album_lb_id_i0011] => d0000
    [picfile_i0011] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwMjcuanBn
    [album_lb_id_i0012] => d0000
    [picfile_i0012] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwMjguanBn
    [album_lb_id_i0013] => d0000
    [picfile_i0013] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwMjkuanBn
    [album_lb_id_i0014] => d0000
    [picfile_i0014] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwMzAuanBn
    [album_lb_id_i0015] => d0000
    [picfile_i0015] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwMzEuanBn
    [album_lb_id_i0016] => d0000
    [picfile_i0016] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwMzIuanBn
    [album_lb_id_i0017] => d0000
    [picfile_i0017] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwMzMuanBn
    [album_lb_id_i0018] => d0000
    [picfile_i0018] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwMzQuanBn
    [album_lb_id_i0019] => d0000
    [picfile_i0019] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwMzYuanBn
    [album_lb_id_i0020] => d0000
    [picfile_i0020] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwMzguanBn
    [album_lb_id_i0021] => d0000
    [picfile_i0021] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwMzkuanBn
    [album_lb_id_i0022] => d0000
    [picfile_i0022] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwNDAuanBn
    [album_lb_id_i0023] => d0000
    [picfile_i0023] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwNDEuanBn
    [album_lb_id_i0024] => d0000
    [picfile_i0024] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwNDIuanBn
    [album_lb_id_i0025] => d0000
    [picfile_i0025] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwNDMuanBn
    [album_lb_id_i0026] => d0000
    [picfile_i0026] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwNDQuanBn
    [album_lb_id_i0027] => d0000
    [picfile_i0027] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwNDUuanBn
    [album_lb_id_i0028] => d0000
    [picfile_i0028] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwNDYuanBn
    [album_lb_id_i0029] => d0000
    [picfile_i0029] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwNDguanBn
    [album_lb_id_i0030] => d0000
    [picfile_i0030] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwNDkuanBn
    [album_lb_id_i0031] => d0000
    [picfile_i0031] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwNTIuanBn
    [album_lb_id_i0032] => d0000
    [picfile_i0032] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwNzAuanBn
    [album_lb_id_i0033] => d0000
    [picfile_i0033] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwNzIuanBn
    [album_lb_id_i0034] => d0000
    [picfile_i0034] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwNzUuanBn
    [album_lb_id_i0035] => d0000
    [picfile_i0035] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwODEuanBn
    [album_lb_id_i0036] => d0000
    [picfile_i0036] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwODIuanBn
    [album_lb_id_i0037] => d0000
    [picfile_i0037] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwODMuanBn
    [album_lb_id_i0038] => d0000
    [picfile_i0038] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwODQuanBn
    [album_lb_id_i0039] => d0000
    [picfile_i0039] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwODUuanBn
    [album_lb_id_i0040] => d0000
    [picfile_i0040] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwOTYuanBn
    [album_lb_id_i0041] => d0000
    [picfile_i0041] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwOTcuanBn
    [album_lb_id_i0042] => d0000
    [picfile_i0042] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwOTguanBn
    [album_lb_id_i0043] => d0000
    [picfile_i0043] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvRGNwXzAwOTkuanBn
    [album_lb_id_i0044] => d0000
    [picfile_i0044] => cG93ZXJob3VzZV91bmRlcnMvMTZfMDFfMDQvVGh1bWJzLmRi
    [insert] => Insert selected pictures
)

 
Page generated in 1.864 seconds - 3 queries in 0.002 seconds - Album set :  
Advanced debug mode (phpinfo)


EDIT (casper)   Your debug info included your admin username and password, which I have editted out for your security.

[Joachim Müller]

leave debug mode enabled and go to the page where you encountered

There was an error while processing a database query

There should be an additional field underneath the error message that says what query exactly went wrong. Please post this very code.

GauGau