forum.coppermine-gallery.net
Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: Kerrie on October 13, 2007, 03:01:38 am
-
Ok, boy am i stressing. I do a website for a pro wrestler, and we have been using Coppermine for almost a year.
We have had no problems up until now. I dont have a clue why it is messed up now as i havent even touched any of the files, the last thing i did while it was working was Uploaded some pictures to the gallery.. i checked it today and now it doesnt work ( it was working for the last few days after i uploaded pics as well)
I have looked all over the net to try and find How to fix this problem. I dont want to restart over as i have many pics, and important dates marked on folders, and Credit to other people for certain pics.. It would be impossible to gain back all that info i had on the gallery.. Can anyone help?? http://www.ken-kennedy.com/Gallery/
Kind regards
- Kerrie
-
Enable debug mode - http://coppermine-gallery.net/tutorial/debug_mode.php - and post the mysql error message you get.
-
Thankyou for getting back to me so fast, i downloaded that program and uploaded it to my hosting.. but for some reason its giving me this error. So i have no idea why that isnt working.. I should note, on my hosting account i have 4 other gallerys for other websites that are working fine.
Welcome to phpMyAdmin 2.11.1
Probably reason of this is that you did not create configuration file. You might want to use setup script to create one.
Error
MySQL said:
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
-
It means that you don't have correctly install phpmyadmin
- you need to create configuration file!
- ask your hosting about any mysql tool
maybe this (http://forum.coppermine-gallery.net/index.php?topic=33629.0) could help you I'm not sure , it depends on your mysql server error but try it
just upload provided file to your gallery root and run it by browser
-
Thanks for helping guys, i owe that first :). Still trying to get the problem fixed but im glad you are assisting.
I downloaded the support file and uploaded it.. and this are some of the errors im getting.
USER:
------------------
Array
(
[ID] => 1fb805ca0466ed7e7ae86ed35912ec73
[am] => 1
[lang] => english
[liv] => Array
(
- => 2405
[1] => 2429
[2] => 2417
)
)
==========================
USER DATA:
------------------
Array
(
[user_id] => 108
[user_name] => testuser
[user_password] => 098f6bcd4621d373cade4e832627b4f6
)
==========================
Queries:
------------------
Array
(
- => SELECT extension, mime, content, player FROM cpg1410_filetypes; (0s)
[1] => select * from cpg1410_plugins order by priority asc; (0.009s)
[2] => delete from `KenKennedy`.cpg1410_sessions where time delete from `KenKennedy`.cpg1410_sessions where time select user_id from `KenKennedy`.cpg1410_sessions where session_id=md5("37fe6fa55ba60d25c5ad30704d3661be3bc7f21f4e5a51590cfe5586beb5fb7b"); (0.002s)
[5] => select user_id as id, user_password as password from `KenKennedy`.cpg1410_users where user_id=0 (0.001s)
[6] => 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 cpg1410_usergroups WHERE group_id in (3) (0.001s)
[7] => SELECT group_name FROM cpg1410_usergroups WHERE group_id= 3 (0.001s)
[8] => update `KenKennedy`.cpg1410_sessions set time='1192285791' where session_id=md5('37fe6fa55ba60d25c5ad30704d3661be3bc7f21f4e5a51590cfe5586beb5fb7b'); (0.536s)
[9] => DELETE FROM cpg1410_banned WHERE expiry < '2007-10-13 14:29:52' (0.245s)
[10] => SELECT * FROM cpg1410_banned WHERE (ip_addr='123.2.140.152' OR ip_addr='123.2.140.152' OR user_id=0) AND brute_force=0 (0s)
[11] => SELECT aid FROM cpg1410_albums WHERE visibility != '0' AND visibility !='10000' AND visibility NOT IN (3) (0s)
[12] => SELECT user_id, user_name, user_password FROM `KenKennedy`.cpg1410_users WHERE user_name = 'testuser' AND BINARY user_password = '098f6bcd4621d373cade4e832627b4f6' AND user_active = 'YES' (0.017s)
[13] => UPDATE `KenKennedy`.cpg1410_users SET user_lastvisit = NOW() WHERE user_name = 'testuser' AND BINARY user_password = '098f6bcd4621d373cade4e832627b4f6' AND user_active = 'YES' (0.163s)
[14] => update `KenKennedy`.cpg1410_sessions set user_id=108 where session_id=md5('37fe6fa55ba60d25c5ad30704d3661be3bc7f21f4e5a51590cfe5586beb5fb7b'); (0.374s)
)
==========================
GET :
------------------
Array
(
[referer] => support.php
)
==========================
POST :
------------------
Array
(
[username] => testuser
[password] => test
[submitted] => Login
)
==========================
Page generated in 3.512 seconds - 15 queries in 3.419 seconds - Album set : AND aid NOT IN (32,101) ; Meta set: ;
While executing query "SELECT count(*) FROM cpg1410_pictures as p, cpg1410_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 2 and a.aid NOT IN (32,101) " on 0
mySQL error: Table 'p' is marked as crashed and should be repaired
While executing query "SELECT aid, pid, filename FROM cpg1410_pictures WHERE aid = 0 ORDER BY position ASC, pid" on 0
mySQL error: Table 'cpg1410_pictures' is marked as crashed and should be repaired
Im not an expert with MySql but ive managed to get 6 gallerys up in the past and this is my first problem with coppermine.Im hoping i can get that PHPmyadmin program to work.. i cant find the install, or setup files.. well they wont work. I guess i have to create another mysql database for it first? is there a page thats similar to Coppermine with setting up the username database name etc for Phpmyadmin.. if i make any sense at all lol?
I really really appriciate all the help.. if worse comes to worst i could try and reinstall coppermine i just dont want to lose all my folders and dates/names etc
-
Should also note, that when i tried to do a backup with my gallery today while it wasnt working i got this error
mysqldump: Got error: 1194: Table 'cpg1410_pictures' is marked as crashed and should be repaired when using LOCK TABLES
Have i lost everything?
-
After messing around, i worked out that Godaddy already have phpmyadmin in there mysql.. And was able to google and work out how to repair the gallery. So Thanks for everyone trying to help me. Now the problem is solved thankyou!
-
I'm glad that you solve your issue ,probably by running repair table from phpmyadmin
you need to delete support.php from gallery root as well