[Solved]: Coppermine Template error (Still after updating to 1.4.16)

[johnny-b]

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?

[Hein Traag]

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

[johnny-b]

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

[johnny-b]

little correcting in upper account:

username: idc-promo
password: idc-enter

[Nibbler]

Enable debug mode.

[johnny-b]

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.

[Nibbler]

http://coppermine-gallery.net/tutorial/debug_mode.php

[johnny-b]

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:

Code Select Expand

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?

[Nibbler]

This is the error message

Code Select Expand


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

[johnny-b]

This is the error message

Code Select Expand


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.

[Nibbler]

It doesn't matter what you use. Just run the repair query manually.

Code Select Expand

REPAIR TABLE cpgfoto_pictures;

[johnny-b]

It doesn't matter what you use. Just run the repair query manually.

Code Select Expand

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