I change server and I did an upgrade and now it is a mess
You should have taken one step at a time
some photos got lost some do not want to display
Well, happens if you failed to transfer the pics from the old server to the new one. Take
http://www.albumefoto.com/displayimage.php?pos=-14931 as an example: the image
http://www.albumefoto.com/albums/userpics/20080621_IMG_010717.JPG that is being displayed on that page simply doesn't exist. Make sure that you have performed a full backup on the old server. Make sure to have uploaded the full backup to the new server. What else could I say?
My sql table is a mess some tables have a different extension is that supposed to be like that???
No, definitely not. Doesn't happen if you upgrade as suggested in our docs. Happens if you don't do as suggested. Take a look at include/config.inc.php with a plain text editor: you can find out about the table prefix there. It should be safe to delete all tables that contain a different table prefix (using a third-party tool like phpMyAdmin). Just to be sure: make a backup first!
None of the issues you have (missing pics, wasted database) are to be expected if you do as suggested in the docs. Subsequently, they exist because you have made a mistake. Since we can't tell what mistake you made we can hardly advise anything except saying: do things properly.
Joachim
P.S. Additionally (although not related to your issues) you should remove the vanity icon from your custom theme - you don't deserve it because your custom theme doesn't validate - see
http://validator.w3.org/check?uri=http%3A%2F%2Fwww.albumefoto.com%2F . Go to coppermine's config -> Themes settings -> Show the vanity block on themes that are defined as XHTML and CSS compliant -> No
Even better though would be to review your custom theme and make it validate...
P.P.S. Supporters are much more inclined to look into your issues in detail if you play by the rules. Among the rules is the policy that says "resolve your threads". You had
another thread that you failed to resolve...
P.P.P.S. Not related to initial install - moving thread accordingly.