https://www.icyphoenix.com/viewtopic.php?f=26&t=957
-----------------------------------
GeekyGirl
Thu 18 Jan, 2007 13:55

FAP SUPPORT - Problems After Moving To A New Host
-----------------------------------
I finally have access to my web after moving to a new host.  I restored my phpbb database files and uploaded all the related files to the forum folder.  The forum has a few kinks that I'm working on but overall seems in good shape.  The FAP is another story - when I try to access it, I get the following error:

Could not query Album config information

DEBUG MODE

SQL Error : 1146 Table 'scrapuni_p_bb1.phpbb_album_config' doesn't exist

SELECT * FROM phpbb_album_config

Line : 46
File : album_common.php

As part of the preparation for this move, I not only backuped the database from within phpbb admin but also did a complete dump of all my MySQL databases to my hard drive as well.  But when I try to import that data, my access is denied due to the change in the localhost information.

I have lost everything for the album?


-----------------------------------
Artie
Thu 18 Jan, 2007 18:05

Re: Problems After Moving To A New Host
-----------------------------------
If you have all the album database structure, data, and the contents of the album upload directories ..... there is no reason why you can't get it back like it was. 

[quote="GeekyGirl"]But when I try to import that data, my access is denied due to the change in the localhost information. [/quote]

Is this using phpMyAdmin ? Have you contacted your host about this.


-----------------------------------
GeekyGirl
Thu 18 Jan, 2007 22:35

Re: Problems After Moving To A New Host
-----------------------------------
[quote user="Artie" post="7700"]If you have all the album database structure, data, and the contents of the album upload directories ..... there is no reason why you can't get it back like it was. 

[quote="GeekyGirl"]But when I try to import that data, my access is denied due to the change in the localhost information. [/quote]

Is this using phpMyAdmin ? Have you contacted your host about this.[/quote]

I'm hoping I backed up all the data.  I did a backup within phpbb using the normal backup and then just did a complete dump of all databases so I assumed I had captured all the data.

It is using phpMyAdmin - I can access my databases and work with the current data but because the backup data has a different host and username attached to it, it won't let me perform the import.

I am also experiencing problems with phpbb itself because I can't access the admin panel at all now and am getting login errors.  This move has not been a good one in any way!  I just hope I can recoup some of my creations so I don't have to rebuild everything.


-----------------------------------
Artie
Thu 18 Jan, 2007 22:59

Re: Problems After Moving To A New Host
-----------------------------------
[quote user="GeekyGirl" post="7713"]I did a backup within phpbb using the normal backup and then just did a complete dump of all databases so I assumed I had captured all the data.[/quote]

Was this dump done using phpMyAdmin ?


-----------------------------------
GeekyGirl
Fri 19 Jan, 2007 00:38

Re: Problems After Moving To A New Host
-----------------------------------
yes, i used the export feature and exported all into one file.


-----------------------------------
Artie
Fri 19 Jan, 2007 00:55

Re: Problems After Moving To A New Host
-----------------------------------
I don't understand the problem you are having with importing the data, unless the table prefix is different. There should be no host nor username association to the sql dump.

You can open the sql dump in a text editor and copy the needed table creations and inserts (changing the prefix, if needed), then insert them manually via phpMyAdmin >> SQL


-----------------------------------
lefty74
Fri 19 Jan, 2007 01:12

Re: Problems After Moving To A New Host
-----------------------------------
Just a note, when I copied/pasted a backup into SQL once it screwed up characters like äöü etc. so instead of copying/pasting now, I split up the backup file in smaller files and keep them under the upload limit.


Geeky Girl, did you check that phpbb_album_config is in your backup file?


-----------------------------------
GeekyGirl
Fri 19 Jan, 2007 01:15

Re: Problems After Moving To A New Host
-----------------------------------
Before you replied, I decided to look at the dump file and discovered a few things...

1. The servername was listed so I changed all occurrences to the new server name.
2. There is an ftp username and password.  I can't change the pasword because it is encrypted and cannot create the user because it starts with the servername of the old server.
3.  All the album data is there - Yippee!

So, can I just delete that information all together?


-----------------------------------
GeekyGirl
Fri 19 Jan, 2007 01:24

Re: Problems After Moving To A New Host
-----------------------------------
Ok, I isolated just the album tables and was able to get the loaded.

Now when I try to access the album, I get the following error:

Couldn't access list of Album Categories

DEBUG MODE

SQL Error : 1054 Unknown column 'c.cat_user_id' in 'where clause'

SELECT c.*, COUNT(p.pic_id) AS count, '' AS username FROM phpbb_album_cat AS c LEFT JOIN phpbb_album AS p ON c.cat_id = p.pic_cat_id WHERE cat_id <> 0 AND c.cat_user_id = 0 GROUP BY cat_id ORDER BY cat_order ASC

Line : 135
File : album_hierarchy_sql.php

I can't enter the Admin panel because I get the error that the web page cannot be found so I can't make any changes to the album through this channel.


-----------------------------------
lefty74
Fri 19 Jan, 2007 01:39

Re: Problems After Moving To A New Host
-----------------------------------
When you go to phpMyAdmin and look at the phpbb_album_cat table, there should be a field called cat_user_id. Can you see that? If not, then something must have gone with the upload.


-----------------------------------
GeekyGirl
Fri 19 Jan, 2007 01:42

Re: Problems After Moving To A New Host
-----------------------------------
[quote user="lefty74" post="7728"]When you go to phpMyAdmin and look at the phpbb_album_cat table, there should be a field called cat_user_id. Can you see that? If not, then something must have gone with the upload.[/quote]

I have a cat_id and it seems that all the categories are listed correctly.


-----------------------------------
Artie
Fri 19 Jan, 2007 03:19

Re: Problems After Moving To A New Host
-----------------------------------
You did not mention that your album on the other server was not FAP, but Smartors.  :roll: 

By the errors you are now getting I assume you have uploaded the FAP files as an attempt at upgrading from Smartor.

Now that you have your database restored with the Smartor Album tables you need to run the fap_install.php
This will update the tables for FAP......you will get a few error warnings such as "Could not drop ..... Table already exist" ... most can be ignored.

Be sure you have followed all upgrade instructions.

[code linenumbers=false]## Upgrading from Smartor Album or older FAP or combination of Smartor Album and some Album Mods
## =======================================
## 
## If you are upgrading from older versions of Smartor Album or FAP, you should first uninstall
## the modifications listed in the installation files of those mods, and then apply the ones listed here.
## There is no need to remove the SQL part, since you can use "fap_install.php" to upgrade from any version.
## Just remember that if you are upgrading from older Album version, you may need to run even the
## Personal Galleries migration step from "fap_install.php", just after having installed FAP.[/code]


-----------------------------------
GeekyGirl
Fri 19 Jan, 2007 03:24

Re: Problems After Moving To A New Host
-----------------------------------
That's my problem...I had one forum with smartors but then I did a test forum starting with a fresh install of FAP.  I backed up both but I must have gotten the two phpbb backups mixed up.

I had problems with the smartor version so is it better to start with a fresh clean install of php and go from there?


-----------------------------------
GeekyGirl
Mon 22 Jan, 2007 01:31

Re: Problems After Moving To A New Host
-----------------------------------
Here's an update...

I discovered that all the problems I was having was problems with my host.  There was an ftp problem that was corrupting any files I uploaded, there were problems with the install of the phpbb and the list goes on.

So after several attempts to work with the tech support and getting nowhere, I had to move to a new host all over again.

Things are working smoothly now.  I have the album restored and working - all except the personal galleries which I have updated that information in my post specifically about that.

Thanks for all your help!!! You were better than the hosting company's tech support by far!!


-----------------------------------
Artie
Mon 22 Jan, 2007 18:44

Re: Problems After Moving To A New Host
-----------------------------------
Glad to hear you have things going your way now  :mricy:


