Need to reconnect Coppermine to Mysql?

[gene-photog]

I had a working Fedora Core 3 install with Coppermine....the Coppermine was on a RAID disk setup.

I had to reinstall the operating system from stratch....while the RAID was disconnected.
The install was to another disk...so I still have the working (somewhat) install.

I have the Web server working and Mysql, php etc what I don't know is how to reinstall/reconnect the Coppermine.

This is the error I get when I try to access via the web http://gene-photo.homeip.net/photos_dir/index.php?:
Fatal error :
There was an error while processing a database query

Any help in getting this working again would be appericated,
Gene

[Tranz]

Make sure include/config.inc.php has the correct info.

[Joachim Müller]

enable debug_mode and post the actual error message (not the debug output).

[gene-photog]

Checked the incude/config.inc.php it looked ok with cating it out...

Haven't figure out how to turn on debug yet...

Also could this be related to using PHP 5.0.4 and Zend engine 2.0.4?

I am using Coppermine 1.3.3.

Thanks again for the help,
Gene

[Joachim Müller]

enable debug_mode in coppermine's config (at the very bottom) - as suggested in the documentation that comes with coppermine and is available online as well (link at top of page). A search would have told you so as well.
BTW: you should upgrade to cpg1.3.4

[gene-photog]

I am not trying to be dense here, but don't I have to have Coppermine running to get to the admin mode to turn on debuging.

This may be something simple...that I don't understand about setup....or re-setup.

Note I am using PHP 5.04, Zend Engine V2.0.4-dev with Zend extension manager V1.0.8, with Zend Optimizer v2.5.10.

I can't get anything but the message I quoted above.

Thanks again,
Gene
BTW I will upgrade as soon as I have Coppermine atleast running again.

[Joachim Müller]

use a tool like phpMyAdmin to directly access your database, browse coppermine's config table, set debug_mode from "0" to "1" there manually - this should have the same effect as enabling debug mode in coppermine's config.

[gene-photog]

That maybe part of the problem...when I use phpmyadmin I don't see anything that looks like cpg.

Under databases I see mysql(15), phpmyadmin(7), and test (-)....


Under mysql  is see:

  columns_priv
  db
  func
  help_category
  help_keyword
  help_relation
  help_topic
  host
  tables_priv
  time_zone
  time_zone_leap_second
  time_zone_name
  time_zone_transition
  time_zone_transition_type
  user

Thus my initial question....how do I tell Mysql about Coppermine and vise-a-versa.

Thanks again,
Gene

[gene-photog]

Here is what the mysql looked like on the system that was working...

mysql 

  columns_priv
  cpg133_albums
  cpg133_banned
  cpg133_categories
  cpg133_comments
  cpg133_config
  cpg133_ecards
  cpg133_exif
  cpg133_filetypes
  cpg133_pictures
  cpg133_temp_data
  cpg133_usergroups
  cpg133_users
  cpg133_votes
  db
  func
  host
  tables_priv
  user


So how to I make the corrections?

Thanks in advance,
Gene

[Nibbler]

You need to dump the cpg133_ tables from the old server and then import them into a database on the new server. You can do this with phpmyadmin if available, command line mysql if not.

[gene-photog]

Thanks for all the help...I think I am almost there....I got the mysql imported.

Was able to turn on debug mode...see server here: http://gene-photo.homeip.net/photos_dir

Can't login....login window has red message about "Warning your browser does not accept script's cookies[/color]"  althought this worked with this browser before....when I try to login it just repeats login screen.

USER:
------------------
Array
(
    [ID] => 9401d40f001bbaed995010fa255ddbd9
    [am] => 1
)

==========================
USER DATA:
------------------
Array
(
    [disk_max] => 0
    [disk_min] => 0
    [can_rate_pictures] => 0
    [can_send_ecards] => 0
    [ufc_max] => 0
    [ufc_min] => 0
    [custom_user_upload] => 0
    [num_file_upload] => 5
    [num_URI_upload] => 3
    [can_post_comments] => 0
    [can_upload_pictures] => 0
    [can_create_albums] => 0
    [has_admin_access] => 0
    [pub_upl_need_approval] => 1
    [priv_upl_need_approval] => 1
    [group_name] => Anonymous
    [upload_form_config] => 0
    [group_quota] => 0
    [can_see_all_albums] => 0
    [group_id] => 3
    [groups] => Array
        (
           

• => 3
          )
  
  )
  
  ==========================
  Queries:
  ------------------
  Array
  (
     
• => SELECT extension, mime, content FROM cpg133_filetypes;
      [1] => SELECT * FROM cpg133_users WHERE user_id='0'AND user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = '*'
      [2] => 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 cpg133_usergroups WHERE group_id in (3)
      [3] => SELECT group_name FROM  cpg133_usergroups WHERE group_id= 3
      [4] => DELETE FROM cpg133_banned WHERE expiry < '2005-09-09 18:05:32'
      [5] => SELECT * FROM cpg133_banned WHERE ip_addr='0.0.0.0' OR ip_addr='0.0.0.0' OR user_id=0
      [6] => SELECT aid FROM cpg133_albums WHERE visibility != '0' AND visibility !='10000' AND visibility NOT IN (3)
  )
  
  ==========================
  GET :
  ------------------
  
  ==========================
  POST :
  ------------------
  
  ==========================
  Page generated in 0.082 seconds - 7 queries in 0.004 seconds - Album set : AND aid NOT IN (14,6,13,15,16,17,19,22,26,27,28,29)
  
  
  
  
  If I select one of the randon images on the main page I get:
  The selected album/file does not exist !
  
  File: /var/www/html/photos_dir/displayimage.php - Line: 627
  
  Here is the debug for that:
  
  USER:
  ------------------
  Array
  (
      [ID] => 15c4254978958cc4949172851df9920e
      [am] => 1
  )
  
  ==========================
  USER DATA:
  ------------------
  Array
  (
      [disk_max] => 0
      [disk_min] => 0
      [can_rate_pictures] => 0
      [can_send_ecards] => 0
      [ufc_max] => 0
      [ufc_min] => 0
      [custom_user_upload] => 0
      [num_file_upload] => 5
      [num_URI_upload] => 3
      [can_post_comments] => 0
      [can_upload_pictures] => 0
      [can_create_albums] => 0
      [has_admin_access] => 0
      [pub_upl_need_approval] => 1
      [priv_upl_need_approval] => 1
      [group_name] => Anonymous
      [upload_form_config] => 0
      [group_quota] => 0
      [can_see_all_albums] => 0
      [group_id] => 3
      [groups] => Array
          (
             
• => 3
          )
  
  )
  
  ==========================
  Queries:
  ------------------
  Array
  (
     
• => SELECT extension, mime, content FROM cpg133_filetypes;
      [1] => SELECT * FROM cpg133_users WHERE user_id='0'AND user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = '*'
      [2] => 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 cpg133_usergroups WHERE group_id in (3)
      [3] => SELECT group_name FROM  cpg133_usergroups WHERE group_id= 3
      [4] => DELETE FROM cpg133_banned WHERE expiry < '2005-09-09 18:01:24'
      [5] => SELECT * FROM cpg133_banned WHERE ip_addr='0.0.0.0' OR ip_addr='0.0.0.0' OR user_id=0
      [6] => SELECT aid FROM cpg133_albums WHERE visibility != '0' AND visibility !='10000' AND visibility NOT IN (3)
  )
  
  ==========================
  GET :
  ------------------
  
  ==========================
  POST :
  ------------------
  
  ==========================
  Page generated in 0.102 seconds - 7 queries in 0.004 seconds - Album set : AND aid NOT IN (14,6,13,15,16,17,19,22,26,27,28,29)
  
  
  Any suggestions....
  
  Gene
  
  
  
  
  

[Nibbler]

You are running PHP5 so you need to enable long arrays in your php.ini and restart the server process.

[gene-photog]

Thanks for all the help!....it is working!!!!!!!!!

Gene