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
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: ;
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?
http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#upload_trouble
http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#upload_support
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
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
Yeah, that's a known issue with the modpack.