forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 install => Topic started by: junglejim42 on October 22, 2015, 12:03:03 pm

Title: what was my database settings
Post by: junglejim42 on October 22, 2015, 12:03:03 pm

Hi
I have just changed hosts, unfortunately I cannot remember the database name I used.  I cannot access mysql on my server to get a list of databases.  I have phpmyadmin but without the database name, I'm stuck.  is there any files in the coppermine directory that would tell me what the database name is when i installed it.

many thanks

Title: Re: what was my database settings
Post by: phill104 on October 22, 2015, 12:11:13 pm

include/config.inc.php should hold your old database details. You need to copy your database from your old host to your new host then edit these details to point to your new db.

What version of CPG are you using? You have posted in a board dedicated to CPG1.4.x which has not been supported for a long time. If you are using this version then once you have your db sorted you will need to update to the new CPG1.5.x line.

Title: Re: what was my database settings
Post by: junglejim42 on October 22, 2015, 12:17:27 pm

ver 1.4.19   yes it is old but was working fine

Title: Re: what was my database settings
Post by: junglejim42 on October 22, 2015, 12:19:19 pm

Thank you so much..  spelling error when creating the database. I am in

Title: Re: what was my database settings
Post by: junglejim42 on October 22, 2015, 12:55:09 pm

next prob:
Database downloaded from old host.    ok
database uploaded to new host...........ok

edited config.inc.php to include new localhost settings, database name and username........ok

it works, However, I get the following error message at the top of the screen repeated some 50 times

Notice: Undefined offset: 8192 in /home/cluster-sites/2/r/romft.com/public_html/coppermine/include/debugger.inc.php on line 112

Title: Re: what was my database settings
Post by: phill104 on October 22, 2015, 01:13:50 pm

Sorry, but we no longer support this version and have not done for a number of years. Why you may ask? Well we know it has a number of security issues as well as a few other issues. One of those issues is the one you are reporting, this is an incompatibility with your version of PHP. We have fixed this already, but in the CPG 1.5.x line so upgrading will not only protect you from being hacked but will also fix this error and probably a few more that will crop up due to the later version of PHP on your new host.

Title: Re: what was my database settings
Post by: junglejim42 on October 22, 2015, 01:15:41 pm

currently in debug mode.  The only noticable thing from below that i can see has caused the error message is MYSQL.  my old host was ver 4, new host is 5.  will upgrading coppermine fix the problem.

and while I was typing all this you answered the question

again many thanks


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

==========================
USER DATA:
------------------
Array
(
    [user_id] => 8
    [user_name] => the_po_stoker
    [groups] => Array
        (
           

• => 2
[1] => 101
            [2] => 109
        )

    [disk_max] => 1024
    [disk_min] => 0
   

[can_rate_pictures] => 1
    [can_send_ecards] => 1
    [ufc_max] => 3
    [ufc_min] => 3
    [custom_user_upload] => 0
    [num_file_upload] => 10
    [num_URI_upload] => 3
    [can_post_comments] => 1
    [can_upload_pictures] => 1
    [can_create_albums] => 0
    [has_admin_access] => 1
    [pub_upl_need_approval] => 0
    [priv_upl_need_approval] => 0
    [group_name] => Registered
    [upload_form_config] => 3
    [group_quota] => 0
    [can_see_all_albums] => 1
    [group_id] => 2
)

==========================
Queries:
------------------
Array
(
   

• => SELECT extension, mime, content, player FROM cpg_filetypes; (0.002s)
[1] => select * from cpg_plugins order by priority asc; (0.002s)
    [2] => SELECT * FROM cpg_bridge (0.007s)
    [3] => 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 cpg_usergroups WHERE group_id in (2,101,109) (0.002s)
    [4] => SELECT group_name FROM  cpg_usergroups WHERE group_id= 2 (0.001s)
    [5] => SELECT user_favpics FROM cpg_favpics WHERE user_id = 8 (0.001s)
    [6] => DELETE FROM cpg_banned WHERE expiry < '2015-10-22 11:08:26' (0.001s)
    [7] => SELECT * FROM cpg_banned WHERE (ip_addr='82.32.219.60' OR ip_addr='82.32.219.60' OR user_id=8) AND brute_force=0 (0.001s)
    [8] => SELECT COUNT(*) FROM cpg_pictures WHERE approved = 'NO' (0.005s)
    [9] => SELECT value FROM cpg_config WHERE name = 'theme' (0.001s)
)

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

[coppermine] =>
    [admin_php] =>
)

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

==========================
VERSION INFO :
------------------
PHP version: 5.4.45 - OK
------------------
mySQL version: 10.0.14-MariaDB - your mySQL version isn't good enough! Minimum requirements: 3.23.23
------------------
Coppermine version: 1.4.19(stable)
==========================
Module: GD
------------------
GD Version: bundled (2.1.0 compatible)
FreeType Support: 1
FreeType Linkage: with freetype
T1Lib Support: 1
GIF Read Support: 1
GIF Create Support: 1
JPEG Support: 1
PNG Support: 1
WBMP Support: 1
XPM Support: 1
XBM Support: 1
JIS-mapped Japanese Font Support:

==========================

Notice: Undefined offset: 8192 in /home/cluster-sites/2/r/romft.com/public_html/coppermine/include/debugger.inc.php on line 112
Module: mysql
------------------
MySQL Supportenabled
Active Persistent Links 0
Active Links 2
Client API version mysqlnd 5.0.10 - 20111026 - $Id: c85105d7c6f7d70d609bb4c000257868a40840ab $
==========================

Notice: Undefined offset: 8192 in /home/cluster-sites/2/r/romft.com/public_html/coppermine/include/debugger.inc.php on line 112
Module: zlib
------------------
ZLib Supportenabled
Stream Wrapper compress.zlib://
Stream Filter zlib.inflate, zlib.deflate
Compiled Version 1.2.3
Linked Version 1.2.3
==========================
Server restrictions (safe mode)?
------------------
Directive | Local Value | Master Value
sql.safe_mode | Off | Off |  |  |  |  |  |  |  |
sql.safe_mode | Off | Off
disable_functions | no value | no value
file_uploads | On | On
include_path | .:/usr/share/pear54:/usr/share/php | .:/usr/share/pear54:/usr/share/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 | 30 | 30
max_input_time | 60 | 60
upload_max_filesize | 64M | 64M
post_max_size | 64M | 64M
==========================
Page generated in 0.36 seconds - 10 queries in 0.023 seconds - Album set : ; Meta set: ;

Title: Re: what was my database settings
Post by: junglejim42 on October 22, 2015, 01:45:33 pm

All working
 again Many thanks for your help