forum.coppermine-gallery.net
Support => cpg1.4.x Support => Older/other versions => cpg1.4 upgrading => Topic started by: johnny-b on March 17, 2008, 09:22:21 pm
-
before i was running an older version of coppermine, i don't realy know anymore wich one it was but i am thinking the 1.4.10
Yesterday a was getting an error message when i wanted to log in to mij coppermine photo gallery:
Template error
Failed to find block 'file_line'(#(<!-- BEGIN file_line -->)(.*?)(<!-- END file_line -->)#s) in :
<tr>
<td class="tableb" align="center">
<font size="3"><b>{MESSAGE}</b></font>
<br /><br />
</td>
</tr>
* Then now at this moment i have updated it with coppermine 1.4.16 but still i am getting the error message and can not log in what so ever! ???
normally i have it badged with phpbb, but i did got it unbadged before i upgraded it because i have another coppermine installed on another database that still works, throughout that link i got it unbadged.
but the one that is not working at this moment is: http://www.idc-quest.com/fotogallery/index.php
Please can someone help me as soon as possible? :D
-
I don't see a error plus apparently the site is closed and only accesible when you have a account.
tip: it's bridged and not badged ;)
Cheers
Hein
-
I don't see a error plus apparently the site is closed and only accesible when you have a account.
tip: it's bridged and not badged ;)
Cheers
Hein
The error only accurs when you log in, and yes it is only accesible by an account
after login you see the error message.
i have an account you can use that you can see the error message with:
username: idc-promo
password: idc-promo
the coppermine is also not bridged
-
little correcting in upper account:
username: idc-promo
password: idc-enter
-
Enable debug mode.
-
Enable debug mode.
well that is the main problem, i can't log in!
i already got ridd of the error message bij copying a index.php file from another installed coppermine version into this one,
but unfortionatly when i try to log in this time, immediatly it comes back with the login screen and it does not show it's logged in.
so how do i get ridd of the problem? without loosing any date on comments etc.
-
http://coppermine-gallery.net/tutorial/debug_mode.php
-
http://coppermine-gallery.net/tutorial/debug_mode.php
Well I turned on the Debug mode, but weard to say, this morning i got back the original template error after i want to login!
the dump in de debug screen tels this:
USER:
------------------
Array
(
[ID] => b4078c6b82b125b01cf915b33e4562fb
[am] => 1
[lang] => dutch
)
==========================
USER DATA:
------------------
Array
(
[user_id] => 0
[user_name] => Guest
[groups] => Array
(
[0] => 3
)
[group_quota] => 0
[can_rate_pictures] => 1
[can_send_ecards] => 0
[can_post_comments] => 0
[can_upload_pictures] => 0
[can_create_albums] => 0
[pub_upl_need_approval] => 1
[priv_upl_need_approval] => 1
[upload_form_config] => 0
[num_file_upload] => 5
[num_URI_upload] => 3
[custom_user_upload] => 0
[disk_max] => 0
[disk_min] => 0
[ufc_max] => 0
[ufc_min] => 0
[has_admin_access] => 0
[group_name] => Anonymous
[can_see_all_albums] => 0
[group_id] => 3
)
==========================
Queries:
------------------
Array
(
[0] => SELECT extension, mime, content, player FROM cpgfoto_filetypes; (0.001s)
[1] => select * from cpgfoto_plugins order by priority asc; (0.001s)
[2] => delete from `idcfoto`.cpgfoto_sessions where time<1205827927 and remember=0; (0.006s)
[3] => delete from `idcfoto`.cpgfoto_sessions where time<1204621927; (0s)
[4] => select user_id from `idcfoto`.cpgfoto_sessions where session_id=md5("e47491d8ed4114c73bbe1da22505e777d977b7f88135fcf32e70adfd41f4ea8d"); (0.002s)
[5] => SELECT session_id FROM `idcfoto`.cpgfoto_sessions WHERE session_id=MD5('6d2c8eae3f92e03ccc0397ec6d7a4440d977b7f88135fcf32e70adfd41f4ea8d') (0.001s)
[6] => insert into `idcfoto`.cpgfoto_sessions (session_id, user_id, time, remember) values ("f043a2e42d3433647325f16b594027be", 0, "1205831527", 0); (0s)
[7] => 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 cpgfoto_usergroups WHERE group_id in (3) (0.001s)
[8] => SELECT group_name FROM cpgfoto_usergroups WHERE group_id= 3 (0.002s)
[9] => update `idcfoto`.cpgfoto_sessions set time='1205831527' where session_id=md5('6d2c8eae3f92e03ccc0397ec6d7a4440d977b7f88135fcf32e70adfd41f4ea8d'); (0s)
[10] => DELETE FROM cpgfoto_banned WHERE expiry < '2008-03-18 10:12:07' (0.001s)
[11] => SELECT * FROM cpgfoto_banned WHERE (ip_addr='82.172.67.25' OR ip_addr='82.172.67.25' OR user_id=0) AND brute_force=0 (0.008s)
[12] => SELECT aid FROM cpgfoto_albums WHERE visibility != '0' AND visibility !='10000' AND visibility NOT IN (3) (0.015s)
)
==========================
GET :
------------------
Array
(
)
==========================
POST :
------------------
Array
(
)
==========================
Page generated in 0.497 seconds - 13 queries in 0.038 seconds - Album set : ; Meta set: ;
[/b]
What can i do?
-
This is the error message
mySQL error: Table 'p' is marked as crashed and should be repaired
So the solution is to repair the pictures table using phpmyadmin.
http://forum.coppermine-gallery.net/index.php/topic,10409.0.html
-
This is the error message
mySQL error: Table 'p' is marked as crashed and should be repaired
So the solution is to repair the pictures table using phpmyadmin.
http://forum.coppermine-gallery.net/index.php/topic,10409.0.html
Indeed When i look in to my MySQL application it tels me the upper error, unfortionatly i don't know how to repair it.
id did look in to the other topic but i could not get it right.
i don't use phpmyadmin only an application called SQLyog to look in to my database
but i don't realy know how to repair it in that program.
-
It doesn't matter what you use. Just run the repair query manually.
REPAIR TABLE cpgfoto_pictures;
-
It doesn't matter what you use. Just run the repair query manually.
REPAIR TABLE cpgfoto_pictures;
Nibbler, thanx for the support.
What i did was the following:
in the coppermine database is repaired the: REPAIR TABLE cpgfoto_pictures;
after i done this i whore still having problems with logging in.
i replaced the hole folder structure in the albums folder (exept the folders where the picture's are in)
i repaired the:
- cpgfoto_albums;
- cpgfoto_users;
- cpgfoto_sessions;
Table's in de database
Now the CPG 1.4.16 works perfect :D