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