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
Make sure include/config.inc.php has the correct info.
enable debug_mode and post the actual error message (not the debug output).
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
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
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.
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.
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
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
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.
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
You are running PHP5 so you need to enable long arrays in your php.ini and restart the server process.
Thanks for all the help!....it is working!!!!!!!!!
Gene :D