Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Database update problems  (Read 3542 times)

0 Members and 1 Guest are viewing this topic.

joejk2

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Database update problems
« on: December 19, 2005, 03:50:53 pm »

Dear All.

I hope I have not missed anything, but I cannot find any solution to my upload problem....

Initially I was able to upload photos by batch add but I am now returned click for details or to reload and this link contains no data.    However, the thumbnails are generated, it is just that nothing is entered into my cpg140_pictures table.  The debug info is below.

As instructed I have then limited to single file uploads and attempted httpd - this gives the error....

No file was uploaded !

If you have really selected a file to upload, check that the server allows file uploads...

File: /home/fhlinux204/a/angryfruit.co.uk/user/htdocs/db_input.php - Line: 300


... although the files are uploaded to my usperpics/10001 folder.  Debug info below.
 
I have tried recreating my edit directory, I have added the define('SILLY_SAFE_MODE', 1); to my config.inc.php.  I don't think permissions are an issue since the thumbnails are happily created. 

I have created a guest account (username - guest password - tseug) with upload rights to www.angryfruit.co.uk.


Many thanks for some great software and any help you can offer,


joe



The debug info is as follows...

For Batch Add

USER:
------------------
Array
(
    [ID] => 7ed14ff4d5f827ca3c1a8513e805f053
    [am] => 1
    [lang] => english
)

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

        )

    [disk_max] => 1024
    [disk_min] => 1024
    [can_rate_pictures] => 1
    [can_send_ecards] => 1
    [ufc_max] => 0
    [ufc_min] => 0
    [custom_user_upload] => 0
    [num_file_upload] => 0
    [num_URI_upload] => 0
    [can_post_comments] => 1
    [can_upload_pictures] => 1
    [can_create_albums] => 0
    [has_admin_access] => 1
    [pub_upl_need_approval] => 1
    [priv_upl_need_approval] => 0
    [group_name] => Administrators
    [upload_form_config] => 0
    [group_quota] => 1024
    [can_see_all_albums] => 1
    [group_id] => 1
)

==========================
Queries:
------------------
Array
(
   
  • => SELECT extension, mime, content, player FROM cpg140_filetypes; (0.002s)
  • [1] => select * from cpg140_plugins order by priority asc; (0.002s)
        [2] => delete from `angryfruit1`.cpg140_sessions where time<1134999488 and remember=0; (0.003s)
        [3] => delete from `angryfruit1`.cpg140_sessions where time<1133793488; (0.005s)
        [4] => select user_id from `angryfruit1`.cpg140_sessions where session_id=md5("44c1037f31ca269b3ff9188ad8e22e8f14b0fd21fd5d7f45b0862163173c8331"); (0.005s)
        [5] => select user_id as id, user_password as password from `angryfruit1`.cpg140_users where user_id=1 (0.005s)
        [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 `angryfruit1`.cpg140_users AS u INNER JOIN `angryfruit1`.cpg140_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0.005s)
        [7] => SELECT user_group_list FROM `angryfruit1`.cpg140_users AS u WHERE user_id='1' and user_group_list <> ''; (0.004s)
        [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.005s)
        [9] => SELECT group_name FROM  cpg140_usergroups WHERE group_id= 1 (0.004s)
        [10] => update `angryfruit1`.cpg140_sessions set time='1135003088' where session_id=md5('44c1037f31ca269b3ff9188ad8e22e8f14b0fd21fd5d7f45b0862163173c8331'); (0.005s)
        [11] => SELECT user_favpics FROM cpg140_favpics WHERE user_id = 1 (0.001s)
        [12] => DELETE FROM cpg140_banned WHERE expiry < '2005-12-19 14:38:08' (0.001s)
        [13] => SELECT * FROM cpg140_banned WHERE (ip_addr='62.254.128.5' OR ip_addr='81.103.192.81' OR user_id=1) AND brute_force=0 (0.001s)
        [14] => SELECT aid, title FROM cpg140_albums WHERE 1 (0.001s)
        [15] => SELECT COUNT(*) FROM cpg140_pictures WHERE approved = 'NO' (0.001s)
    )

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

==========================
POST :
------------------
Array
(
    [d0000] => 4
    [album_lb_id_i0000] => d0000
    [picfile_i0000] => cGljdHVyZXMvMjAwM19BcHJpbC8uZGlyZWN0b3J5
    [pics] => Array
        (
           
  • => i0001
  • [1] => i0002
            )

       
[album_lb_id_i0001] => d0000
    [picfile_i0001] => cGljdHVyZXMvMjAwM19BcHJpbC9FbGVjdHJpY19zY3JlZHJpdmVyMS5qcGc=
    [album_lb_id_i0002] => d0000
    [picfile_i0002] => cGljdHVyZXMvMjAwM19BcHJpbC9FbGVjdHJpY19zY3Jld2RyaXZlcjIuanBn
    [album_lb_id_i0003] => d0000
    [picfile_i0003] => cGljdHVyZXMvMjAwM19BcHJpbC9rZXN0cmVscy5qcGc=
    [insert] => Insert selected files
)

==========================
VERSION INFO :
------------------
PHP version: 4.3.10 - OK
------------------
mySQL version: 4.0.25-standard
------------------
Coppermine version: 1.4.2(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.0.24
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
Compiled Version 1.1.4
Linked Version 1.1.4
==========================
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 | shell_exec,exec,system,passthru,popen | shell_exec,exec,system,passthru,popen
file_uploads | On | On
include_path | .:/usr/share/pear | .:/usr/share/pear
open_basedir | /tmp:/usr/share/pear:/home/fhlinux204/a/angryfruit.co.uk/user | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | postmaster@angryfruit.co.uk | 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 | 4M | 4M
post_max_size | 8M | 8M
==========================
Page generated in 0.231 seconds - 16 queries in 0.05 seconds - Album set : ; Meta set: ;


For Single Upload[/u]

No file was uploaded !

If you have really selected a file to upload, check that the server allows file uploads...

File: /home/fhlinux204/a/angryfruit.co.uk/user/htdocs/db_input.php - Line: 300

USER:
------------------
Array
(
    [ID] => 7ed14ff4d5f827ca3c1a8513e805f053
    [am] => 1
    [lang] => english
)

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

        )

    [disk_max] => 1024
    [disk_min] => 1024
    [can_rate_pictures] => 1
    [can_send_ecards] => 1
    [ufc_max] => 0
    [ufc_min] => 0
    [custom_user_upload] => 0
    [num_file_upload] => 0
    [num_URI_upload] => 0
    [can_post_comments] => 1
    [can_upload_pictures] => 1
    [can_create_albums] => 0
    [has_admin_access] => 1
    [pub_upl_need_approval] => 1
    [priv_upl_need_approval] => 0
    [group_name] => Administrators
    [upload_form_config] => 0
    [group_quota] => 1024
    [can_see_all_albums] => 1
    [group_id] => 1
)

==========================
Queries:
------------------
Array
(
   
  • => SELECT extension, mime, content, player FROM cpg140_filetypes; (0.002s)
  • [1] => select * from cpg140_plugins order by priority asc; (0.001s)
        [2] => delete from `angryfruit1`.cpg140_sessions where time<1134999894 and remember=0; (0.001s)
        [3] => delete from `angryfruit1`.cpg140_sessions where time<1133793894; (0.001s)
        [4] => select user_id from `angryfruit1`.cpg140_sessions where session_id=md5("44c1037f31ca269b3ff9188ad8e22e8f14b0fd21fd5d7f45b0862163173c8331"); (0.001s)
        [5] => select user_id as id, user_password as password from `angryfruit1`.cpg140_users where user_id=1 (0.001s)
        [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 `angryfruit1`.cpg140_users AS u INNER JOIN `angryfruit1`.cpg140_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0.001s)
        [7] => SELECT user_group_list FROM `angryfruit1`.cpg140_users AS u WHERE user_id='1' and user_group_list <> ''; (0.001s)
        [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.001s)
        [9] => SELECT group_name FROM  cpg140_usergroups WHERE group_id= 1 (0.001s)
        [10] => update `angryfruit1`.cpg140_sessions set time='1135003494' where session_id=md5('44c1037f31ca269b3ff9188ad8e22e8f14b0fd21fd5d7f45b0862163173c8331'); (0.001s)
        [11] => SELECT user_favpics FROM cpg140_favpics WHERE user_id = 1 (0.001s)
        [12] => DELETE FROM cpg140_banned WHERE expiry < '2005-12-19 14:44:54' (0.001s)
        [13] => SELECT * FROM cpg140_banned WHERE (ip_addr='62.254.128.5' OR ip_addr='81.103.192.81' OR user_id=1) AND brute_force=0 (0.001s)
        [14] => SELECT category FROM cpg140_albums WHERE aid='4' (0.001s)
        [15] => SELECT COUNT(*) FROM cpg140_pictures WHERE approved = 'NO' (0.001s)
    )

    ==========================
    GET :
    ------------------
    Array
    (
    )

    ==========================
    POST :
    ------------------
    Array
    (
       
[album] => 4
    [MAX_FILE_SIZE] => 1048576
    [title] =>
    [caption] =>
    [keywords] =>
    [event] => picture
)

==========================
VERSION INFO :
------------------
PHP version: 4.3.10 - OK
------------------
mySQL version: 4.0.25-standard
------------------
Coppermine version: 1.4.2(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.0.24
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
Compiled Version 1.1.4
Linked Version 1.1.4
==========================
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 | shell_exec,exec,system,passthru,popen | shell_exec,exec,system,passthru,popen
file_uploads | On | On
include_path | .:/usr/share/pear | .:/usr/share/pear
open_basedir | /tmp:/usr/share/pear:/home/fhlinux204/a/angryfruit.co.uk/user | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | postmaster@angryfruit.co.uk | 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 | 4M | 4M
post_max_size | 8M | 8M
==========================
Page generated in 0.143 seconds - 16 queries in 0.017 seconds - Album set : ; Meta set: ;
« Last Edit: December 22, 2005, 01:03:39 pm by GauGau »
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Database update problems
« Reply #1 on: December 20, 2005, 09:21:57 am »

disable admin approval temporarily to let us see any errors.
Logged

joejk2

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: Database update problems
« Reply #2 on: December 20, 2005, 10:01:30 pm »

Done.  Many thanks for your time GauGau.

joe
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Database update problems
« Reply #3 on: December 21, 2005, 02:43:44 am »

everything works as expected for me: http://www.angryfruit.co.uk/thumbnails.php?album=4
Make sure to test with small, known-good jpeg files. You (as admin) should use FTP-upload plus batch-add anyway, especially when uploading videos. Attach the file you got an error message with.
Logged

joejk2

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: Database update problems
« Reply #4 on: December 22, 2005, 12:50:37 pm »

Problem solved - my error for not comprehensively debugging.  The problem is a server time-out whilst trying to create thumbnails and intermediate pictures - this is the source of the Click for details or to reload in the batch add process.

I instead resize my photos on my laptop and then upload. From a linux terminal I use the script

for file in *
do
        sips -Z 400 $file --out normal_$file
        sips -Z 100 $file --out thumb_$file
done


Many thanks for your time GauGau and for a most incredible photo gallery.

joe
Logged
Pages: [1]   Go Up
 

Page created in 0.021 seconds with 19 queries.