what was my database settings

[junglejim42]

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

[phill104]

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.

[junglejim42]

ver 1.4.19   yes it is old but was working fine

[junglejim42]

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

[junglejim42]

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

[phill104]

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.

[junglejim42]

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: ;

[junglejim42]

All working
again Many thanks for your help