page truly messed up after upgrade attempt.

[jl01]

since some minutes ago i succesfully used coppermine 1.1.1. i tried the upgrade following the documentation. the only thing that was strange at this point was this statement appearing at the top of the upgrade page:


t we have so far. $temp = $tokens[$i] . $delimiter; // save memory.. $tokens[$i] = ""; // Do we have a complete statement yet? $complete_stmt = false; for ($j = $i + 1; (!$complete_stmt && ($j < $token_count)); $j++) { // This is the total number of single quotes in the token. $total_quotes = preg_match_all("/'/", $tokens[$j], $matches); // Counts single quotes that are preceded by an odd number of backslashes, // which means they're escaped quotes. $escaped_quotes = preg_match_all("/(?


nevertheless the update executed and told me:

Coppermine is now upgraded and ready to roll.


problem is, since then my gallery looks like that:

http://scherbenreich.de/coppermine/

anybody has an idea what i did wrong?

[Casper]

First, have you made sure that you uploaded the new themes completely.  it looks like some files may be missing.  Try deleting the old ones (except any custom one) and reuploading at least the 'classic' theme.  If you are using a custom theme, that will require updating as per the instructions in the docs folder.
I would suggest you try re-uploading all the files again, in case one has become corrupted.

Also. you are getting a critical error, about the groups table not containing the anonymous group.
If you have access to your database, use a tool such as phpmyadmin to insert the anonymous group in the groups table.  Just copy the settings from registered users for now, you can change them later.

[jl01]

w00t! ok. Thanks!  after your tremendously fast answer i made a first step to a working gallery. something in my custom skin was messed up. i replaced it with the default one and the update script executed. now the page is still messed up, but looks a bit better...

no images, unable to log in and loads of that:

Notice: Undefined index: allowed_img_types in /www/htdocs/v083138/coppermine/include/media.functions.inc.php on line 3

http://scherbenreich.de/coppermine/

at least its recognizeble as a coppermine gallery. any tips for that? ist the database messed up? shall i drop the new tables and run update again? or is it bad karma?

thanks!

[Casper]

In your first post, you said you were upgrading from version 1.1.1.  Did you follow the instructions in the docs for this version, or the upgrade from version 1.

I see from your update.php that it has added to your database with table prefixes cpg132_.  That should not be happening, as your prefix will be something like cpg11d_.

Did you change anything in your database, or the code, before the update.  Did you change anything in your include/config.inc.php?

[twiz]

Hope you know of this issue..

[Casper]

@twiz,

what issue    I am trying to help jl01 with a problem which I have not seen before, what issue do you have, and is it related to his problem?

[jl01]

thanks for answering, casper! true, it created new tables. but i am perfectly shure that i did not change the database neither i changed any config file. all id did was exactly this step by step:

3.2 Upgrading from releases of version 1.1

    * Backup your include/config.inc.php file, your anycontent.php file and your "albums" directoy.
    * Unpack the archive
    * If the file install.php exists in the root directory, delete it.
    * Upload all of the new files and directories
    * CHMOD the albums directory and all subfolders once more to 755 or 777 (depending on your server config)
    * Call the upgrade script http://yousitename/coppermine_dir/update.php
    * Your upgrade should be complete.

my first post described the condition after that. later i tried to analyse my problem a bit further. after removing my custom theme something changed but it did not get any better. i switched to the database and saw that new tables were created wearing a new versions prefix. the script did not generate all tables with the new prefix. those new folders contained none of my data from the old gallery. i dropped the "new prefix" tables and tried to update again with the same result.

after that i decide to try what happens when i install the new gallery. that worked fine.

so; how can i continue to use the data from my old tables? i have the feeling something went terribly wrong, and i desperatly hope that it not me... ;-)

[jl01]

just guessing: could it help to "correct" the data in config.inc.php to use the old database tables?

guessing for the reason of this mess: according to the upgrade instruction, the install php from the new version should still exist after uploading the new files to the server. even if  i removed the old one, a new install.php would be there fro the new package. could this be the reason for my upgrade fatale? (in this case i learned that i should THINK not only read and follow...)

[Casper]

Are yousure you ran update.php, and not upgrade-1.0-to-1.3.2.php.  

Make sure your include/config.inc.php shows your original prefix, not cpg132_.

If that was the reason, just run update.php again.  If not  edit the file update.sql, and replace every instance of 'CPG_' with 'youroriginalprefix_', then run update.php again.

Edit, did you run install.php during this.  Having install.php on the server will not be a problem as long as the install.lock still exists in the include folder.

[jl01]

hallo casper!

ok. i think i nearly got it. coppermine is up and running but still behaves strange. it writes a whole bunch of strange statements

{ $params = array('{CELL_WIDTH}' => $cell_width, '{LINK_TGT}' => "index.php?cat={$thumb['cat']}", '{THUMB}' => $thumb['image'], '{CAPTION}' => $thumb['caption'], '{ADMIN_MENU}' => '' ); } echo template_eval($thumb_cell, $params); if ((($i % $thumbcols) == 0) && ($i < count($thumb_list))) { echo $row_separator; } } for (;($i % $thumbcols); $i++) { echo $empty_cell; } echo $footer; if ($display_tabs) { $params = array('{THUMB_COLS}' => $thumbcols, '{TABS}' => $tabs_html ); echo template_eval($tabs, $params); } endtable(); echo $spacer; } // Added to display flim_strip function theme_display_film_strip(&$thumb_list, $nbThumb ....  etc etc etc and so forth and so on....

at the top of the page, while the rest of the gallery behaves normal. all the users and pictures are back and in order...

although i am aready very happy with your help, fixing this would make me truly happy.



talking about the reason... i would imagine that the install.lock was not present. dont ask me why. i remember after updating install.php poped up somewhere automaticly. i thought this would be normal....

regards!

jörg

[jl01]

i can belive it! it works! the page directed to some modified skin again! i changed that and it works! now i am happy! thanks a lot for the great and fast support!