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: [Solved]: gallery moved to a new server  (Read 2790 times)

0 Members and 1 Guest are viewing this topic.

EC

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 36
    • Fotonicamente
[Solved]: gallery moved to a new server
« on: July 25, 2008, 12:00:32 pm »

Hi,
I've just moved my coppermine gallery (version 1.4.18 (stable), bridged with phpBB3) from an hosting to a new ones. here is the gallery (www.fotonicamente.it)
I've moved all the files and the database content.
It seems most went well, but not everything.
When I try to upload a file I obtain the error (in italian)

L'album/file selezionato non esiste !

File: /web/htdocs/www.fotonicamente.it/home/Gallery/include/functions.inc.php - Linea: 1363

(that is the line    default : // Invalid meta album

        cpg_die(ERROR, $lang_errors['non_exist_ap'], __FILE__, __LINE__);)

instead of the previuos redirect to displayimage. but the files was upload successfully!! users don't know and continue trying to upload again.
One more problem I had is linked to minicms plugins.
It gives an error if I try to open a new topic in the index.php page, while it is ok, if I do it from admin CMS.
and the error is

Contenuto inesistente

File: /web/htdocs/www.fotonicamente.it/home/Gallery/plugins/minicms/cms_edit.php - Linea: 94

Thanks a lot for helping
Elena

Here there are the info obtained in debug mode

Code: [Select]
USER:
------------------
Array
(
    [ID] => 7017c4c36a2e86ceedb5124f69f6c345
    [am] => 1
    [liv] => Array
        (
        )

)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 2
    [user_name] => fotonicamente
    [group_name] => Administrators
    [groups] => Array
        (
            [0] => 2
            [1] => 1
        )

    [disk_max] => 2000000
    [disk_min] => 2000000
    [can_rate_pictures] => 1
    [can_send_ecards] => 1
    [ufc_max] => 0
    [ufc_min] => 0
    [custom_user_upload] => 0
    [num_file_upload] => 1
    [num_URI_upload] => 0
    [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
    [upload_form_config] => 0
    [group_quota] => 2000000
    [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] => SELECT * FROM cpg14x_plugins (0s)
    [3] => SELECT * FROM cpg14x_mod_slider (0s)
    [4] => SELECT * FROM cpg14x_bridge (0s)
    [5] => SET NAMES 'utf8' (0s)
    [6] => SELECT
config_name,
config_value
FROM
`Sql205968_1`.phpbb_config
WHERE
config_name IN ('cookie_name', 'session_length', 'allow_autologin', 'max_autologin_time') (0s)
    [7] => SELECT
u.*, s.*
FROM
`Sql205968_1`.phpbb_users u,
`Sql205968_1`.phpbb_sessions s
WHERE
u.user_id = s.session_user_id AND
u.user_type != 2 AND
u.user_type != 1 AND
s.session_id = '098509a9a703e38b805d829cb66948e9' (0.001s)
    [8] => SELECT
*
FROM
`Sql205968_1`.phpbb_user_group ug,
`Sql205968_1`.phpbb_acl_groups ag,
`Sql205968_1`.phpbb_acl_roles_data ard,
`Sql205968_1`.phpbb_acl_options ao
WHERE
ug.user_id = 2 AND
ug.group_id = ag.group_id AND
ag.auth_role_id = ard.role_id AND
ard.auth_setting = 1 AND
ard.auth_option_id = ao.auth_option_id AND
(ao.auth_option = 'a_cpgadmin' OR ao.auth_option = 'm_cpgadmin') (0s)
    [9] => SELECT
*
FROM
`Sql205968_1`.phpbb_user_group ug,
`Sql205968_1`.phpbb_acl_groups ag,
`Sql205968_1`.phpbb_acl_options ao
WHERE
ug.user_id = 2 AND
ug.group_id = ag.group_id AND
ag.auth_option_id = ao.auth_option_id AND
ag.auth_setting = 1 AND
(ao.auth_option = 'a_cpgadmin' OR ao.auth_option = 'm_cpgadmin') (0s)
    [10] => SELECT
        group_name
        FROM
        `Sql205968_1`.phpbb_groups
        WHERE
        group_id = 5 (0s)
    [11] => 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 (2,1) (0s)
    [12] => SELECT group_name FROM  cpg14x_usergroups WHERE group_id= 1 (0s)
    [13] => SELECT user_favpics FROM cpg14x_favpics WHERE user_id = 2 (0s)
    [14] => DELETE FROM cpg14x_mod_online WHERE last_action < NOW() - INTERVAL 10 MINUTE (0s)
    [15] => REPLACE INTO cpg14x_mod_online (user_id, user_name, user_ip, last_action) VALUES ('2', 'fotonicamente', '193.205.74.131', NOW()) (0s)
    [16] => SELECT * FROM cpg14x_copperad_config (0s)
    [17] => SHOW TABLES LIKE 'cpg14x_cms_config' (0.001s)
    [18] => SELECT * FROM cpg14x_cms_config (0s)
    [19] => DELETE FROM cpg14x_banned WHERE expiry < '2008-07-25 11:53:08' (0s)
    [20] => SELECT * FROM cpg14x_banned WHERE (ip_addr='193.205.74.131' OR ip_addr='193.205.74.131' OR user_id=2) AND brute_force=0 (0s)
    [21] => SELECT COUNT(*) FROM cpg14x_pictures WHERE approved = 'NO' (0s)
)

==========================
GET :
------------------
Array
(
    [pos] => 0
)

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

==========================
VERSION INFO :
------------------
PHP version: 5.2.6 - OK
------------------
mySQL version: 5.0.62-log
------------------
Coppermine version: 1.4.18(stable)
==========================
Module: GD
------------------
GD Version: bundled (2.0.34 compatible)
FreeType Support: 1
FreeType Linkage: with freetype
T1Lib Support: 1
GIF Read Support: 1
GIF Create Support: 1
JPG Support: 1
PNG Support: 1
WBMP Support: 1
XPM Support:
XBM Support: 1
JIS-mapped Japanese Font Support:

==========================
Module: mysql
------------------
MySQL Supportenabled
Active Persistent Links 0
Active Links 2
Client API version 5.0.45
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
Stream Wrapper support compress.zlib://
Stream Filter support zlib.inflate, zlib.deflate
Compiled Version 1.2.3
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 | system,popen,dl,passthru,proc_open,shell_exec | system,popen,dl,passthru,proc_open,shell_exec
file_uploads | On | On
include_path | .:/php/lib/php/ | .:/php/lib/php/
open_basedir | no value | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | me@localhost.com | me@localhost.com
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 | 120 | 120
max_input_time | -1 | -1
upload_max_filesize | 18M | 18M
post_max_size | 22M | 22M
==========================
Page generated in 0.267 seconds - 22 queries in 0.002 seconds - Album set : ; Meta set: ;
« Last Edit: July 26, 2008, 03:35:28 pm by Nibbler »
Logged

EC

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 36
    • Fotonicamente
Re: gallery moved to a new server
« Reply #1 on: July 25, 2008, 05:43:36 pm »

I believe is a problem linked to get_meta_album_set_data and get_meta_album_set

and the time of linking php-mysql on new server...

anyone as an idea of how to solve it?

Logged

EC

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 36
    • Fotonicamente
Re: gallery moved to a new server
« Reply #3 on: July 25, 2008, 10:59:32 pm »

Sorry to have posted in the wrong place.
I've already read the links you wrote and did those procedure, and I've put all the info in my message.
I've created a test user

LOGIN: TestUser
PASSWORD: UserTest

Thanks for your help
Logged

EC

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 36
    • Fotonicamente
Re: gallery moved to a new server
« Reply #4 on: July 26, 2008, 08:25:37 am »

I think I've solved, thanks to following link
http://coppermine.svn.sourceforge.net/viewvc/coppermine/trunk/cpg1.4.x/db_input.php?r1=3338&r2=3364
I've modified in my db_input.php
the lines
  //  $pid= mysql_insert_id();
        ///modified after transfer to aruba, thanks to http://coppermine.svn.sourceforge.net/viewvc/coppermine/trunk/cpg1.4.x/db_input.php?r1=3338&r2=3364
        ///         
        $pid= mysql_insert_id($CONFIG['LINK_ID']);
        ///

Could someone confirm me that I did the right thing?
Thanks a lot
elena
Logged

Nibbler

  • Guest
Re: gallery moved to a new server
« Reply #5 on: July 26, 2008, 03:35:20 pm »

Yeah, that's a known issue with the modpack.
Logged
Pages: [1]   Go Up
 

Page created in 0.065 seconds with 20 queries.