Reinstalling EE1.5 on a new server

[MikeCaine]

Due to a server crashing and still being down six days later I'm having to change host and reinstall my gallery

I've a backup from a couple of months ago that I'm having to work with

What I've done so far is ftp all of the php files and photo directories over to the new server.

When I try to use phpMyAdmin to reinstall the 300MB sql backup file it times out on me, as I suspected it might.

Obviously if I go to "mygallery"/input I get the following error

"Could not retrieve authorization data, can not proceed.
Perhaps 'ee_admin' table is missing (wrong EE database version)? Is database online?"

This seems to rule out a slow reinstall of the database file

My brain is that fuzzy from the hassle of the past week I can't think what to do next

I suppose getting basic working install of the gallery would then let me upload the sql database backup file but I can't think how to do that without doing a clean install and them having to reupload megabytes of photo files

Any help much appreciated

Regards

Mike "my brian hurts" Caine

[MikeCaine]

OK, what I'm now going to try to do is rename the current gallery folder and try a fresh install. Once I get the admin page up I'll then try a database restore and if that seems to woek I'll try copying the photos from the renamed gallery on the server to the new gallery and see if that works

Anyone placing bets?

[jeronimo]

I think you have to name all the directory's the same way as on the old system. Otherwice you will probably run in to error's.

Good luck!

[Pekka]

What app made the database backup ? EE Backup?
300MB: how many photos did you have there? I'm asking because it sounds like the backup either has very large messages/uncookied tables or some non-EE tables, too. 300MB database is about 80-100,000 individual photos.

[MikeCaine]

Yes, it was EE Backup, but I think I have uncookied data in there :-(

Everything seemed to going fine for a while until I got -


Forbidden

You don't have permission to access /gallery/input/backup/slow_restore.php on this server.

Additionally, a 403 Forbidden error was encountered while trying to use an ErrorDocument to handle the request.

Which has me a bit stumped for now

When / If the databse installe OK I was hoping to copy the photo folders back over. Would that then work OK, or am I missing something?

Regards

Mike

[Pekka]

Forbidden

You don't have permission to access /gallery/input/backup/slow_restore.php on this server.

Additionally, a 403 Forbidden error was encountered while trying to use an ErrorDocument to handle the request.

Which has me a bit stumped for now

This could be
- file permissions: use 644 for php files and check that ftp has set correct group and user for the php files.
- on some servers .htaccess file causes 500 error.

When / If the databse installe OK I was hoping to copy the photo folders back over. Would that then work OK, or am I missing something?

If the server is same and you use same folders for EE and photos then it should run as before right after database restore.

[Pekka]

Oh, I noticed you did change servers. This means after restore (when you get to editor) you need to set up new ftp folder (do all tests) and set new imagemagick path and profile settings. Then change paths to reflect new setup.

[MikeCaine]

Do I have to do all of the path / resize bits again?

I had hoped these were all stored in the sql backup file. Are they stored elsewhere? I'm juts trying to get my head around what info is stored where and what I have to do before I can try to restore the backup again.

Does it matter if I don't get all of my resize methods and descriptions exactly the same as before. Will restoring the database overwrite these settings with what I had before?

I might have to try again tomorrow and I'm not thinking too straight at the moment due to tiredness

Regards

Mike

[MikeCaine]

I've done ftp test, GD tests OK and then set up sizes and paths.

Tried a slow restore again but still get

Forbidden

You don't have permission to access /gallery/input/backup/slow_restore.php on this server.

Additionally, a 403 Forbidden error was encountered while trying to use an ErrorDocument to handle the request.

as before.

All php files seem to be 644 and althought there's a .htaccess file in root there isn't one in /gallery

Not too sure where to go from here

[Pekka]

NOTE: Do all the setups AFTER the restore (it will override all your settings).

And you do not have to do paths and resize methods again, just EDIT them.

Why the slow restore gives errors: the message "You don't have permission to access..." must be correct. What the reason is is another matter. Try browsing to gallery/input/backup/slow_restore.php directly, it should give a blank page or then a message like

"Notice: Undefined variable: file_to_restore in C:\htdocs\photography-on-the.net\gallery\admin\backup\slow_restore.php on line 244"

Does it give the permission error when you browse to it directly?

[MikeCaine]

Does it give the permission error when you browse to it directly?

I just get a blank page

<html><head>
</head><body>


</body></html>

When I try to access the admin page I get

Warning: mysql_data_seek(): Offset 0 is invalid for MySQL result index 7 (or the query data is unbuffered) in /home/mikeuca/public_html/gallery/language.php on line 108

a few times above the login box and then neither the default admin/pass or my previous login / password work.

Looks like I'll have to do a fresh install again

Can I PM you my details and see if you can spot what I'm doing wrong?

Would be more than happy to make a donation to get this gallery working again.

[MikeCaine]

OK, I've tried again

This time all seemed to be going well until



NEXT SQL COMMAND:
--------------------------------------------------
INSERT INTO `ee_uncookied` VALUES ('1', '}RQrƒ <�¿‘¤æ·mr‚€A}
S’ç\0ƘӇtèäGž»¸ì®ð‚~’*{õ—qËþ1VUË-¨7ôIO�)=W!i%ž#WyʽgÛ…ì Ë¥z\'^{ä–uñ �*?¤ÁYŠí<æÔ@gŸŽ?ßÙá#è‘�¥Ú•‰ó`]øêQŸL«ÌK0Àu+˜Æ9Q_û6
´¸Y&“]´–ádÇÉFúóVL§Æd1�¼A³ƒžO*ÑwÀ ¶Ròrø¬‘9oñïoVøŸ¸NªYöý»r‚Ÿ‹„™«üv„�E}¸', '1')
--------------------------------------------------

PROBLEM: Can not go on.
COMMAND WAS REJECTED:

INSERT INTO `ee_uncookied` VALUES ('1', '}RQrƒ <�¿‘¤æ·mr‚€A} S’ç\0ƘӇtèäGž»¸ì®ð‚~’*{õ—qËþ1VUË-¨7ôIO�)=W!i%ž#WyʽgÛ…ì Ë¥z\'^{ä–uñ �*?¤ÁYŠí<æÔ@gŸŽ?ßÙá#è‘�¥Ú•‰ó`]øêQŸL«ÌK0Àu+˜Æ9Q_û6 ´¸Y&“]´–ádÇÉFúóVL§Æd1�¼A³ƒžO*ÑwÀ ¶Ròrø¬‘9oñïoVøŸ¸NªYöý»r‚Ÿ‹„™«üv„�E}¸', '1')

PLEASE CHECK FIRST THAT THE CHOSEN READING DELIMITER (|EE|BACKUP|) IS CORRECT.

One possible reason for this error could be that the backup set you are trying to restore has commands like 'UNION' (near line above) which are only available in later version of MySQL. In this case, if you are aware of the implications of altering table creation parameters, you can try saving the backup set as a file and editing out the unsuitable commands before restoring it to this MySQL.

There is also a remote possibility that this error is caused by EE Backup's file parser. In that case check that there are no ')|EE|BACKUP| delimiter character blocks in the middle of a command. NOTE: EE Backup's file restore is compatible ONLY for sql backup files created with EE Backup.


Is it feasable to edit out all of the uncookied data from the backup file by hand?

Would that stop the above error?

[Pekka]

Is it feasable to edit out all of the uncookied data from the backup file by hand?

Would that stop the above error?

Yes. You can remove all INSERT commands for ee_uncookied and ee_messages tables from backup file.

[MikeCaine]

I think it's working OK again now.

Just going through some of the setting and I wish my old site was up so I could compare some of the settings

What did fix.sql do?

[MikeCaine]

Also, on another html page that contains the snippets code I have the following errors

Notice: Undefined variable: orlist in /home/mikeuca/public_html/gallery/snippets.php on line 222

Notice: Undefined variable: orlist in /home/mikeuca/public_html/gallery/snippets.php on line 310

Notice: Undefined variable: exlorlist in /home/mikeuca/public_html/gallery/snippets.php on line 312

Not too sure how to fix them

[Pekka]

Also, on another html page that contains the snippets code I have the following errors

Notice: Undefined variable: orlist in /home/mikeuca/public_html/gallery/snippets.php on line 222

Notice: Undefined variable: orlist in /home/mikeuca/public_html/gallery/snippets.php on line 310

Notice: Undefined variable: exlorlist in /home/mikeuca/public_html/gallery/snippets.php on line 312

Not too sure how to fix them

See http://photography-on-the.net/forum/showthread.php?t=28760

[Pekka]

I think it's working OK again now.

Just going through some of the setting and I wish my old site was up so I could compare some of the settings

What did fix.sql do?

fix.sql deletes and recreates ee_message and ee_uncookied tables and kicks them alive.

[MikeCaine]

See http://photography-on-the.net/forum/showthread.php?t=28760

Great, thanks - I re uploaded my backup of snippets.php and all seems OK now, error message has gone