| 2.5.2 dump and re-import problem [message #12399] |
Wed, 06 August 2003 21:39  |
rockvilleguy
Messages: 33
Registered: December 2002
Karma: 0
|
Member |
|
|
I'm migrating my forums to a new server. I upgraded my existing forum to 2.5.2 and then did a data dump of it's data. Then I installed 2.5.2 on the new system and tried to do a data import. However all I get is a wait and then the following error:
(db.inc) 1146: Table 'FUDforum.pg_class' doesn't exist
Query: SELECT a.attname FROM pg_class c, pg_attribute a WHERE c.relname = 'fud25_action_log' AND a.attnum > 0 AND a.attrelid = c.oid AND a.attname='id'
Server Version: 4.0.11a-gamma
[Referring Page] http://myhostname.com/adm/admimport.php?rid=19&S=901fcd4ba1c78e88545aa0 2fd23952c8
It does this every time. Help?
|
|
|
|
| Re: 2.5.2 dump and re-import problem [message #12400 is a reply to message #12399] |
Wed, 06 August 2003 22:20  |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
It appears that the import script mis-identified your database type and is thinking it's PostgreSQL. I'll go over the code and see why this may have happened. Did your original forum use PostgreSQL?
FUDforum Core Developer
|
|
|
|
|
|
| Re: 2.5.2 dump and re-import problem [message #12407 is a reply to message #12405] |
Thu, 07 August 2003 00:22 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
I've checked the code and the only way I can see this happening if you've setup your new forum to use PostgreSQL. the __dbtype__ constant that is used is defined inside db.inc and is NEVER redifined in the script. Which means that the db.inc you are using is the one from PostgreSQL.
FUDforum Core Developer
|
|
|
|
| Re: 2.5.2 dump and re-import problem [message #12418 is a reply to message #12407] |
Thu, 07 August 2003 13:52 |
rockvilleguy
Messages: 33
Registered: December 2002
Karma: 0
|
Member |
|
|
I uninstalled my new installation of 2.5.2 and re-installed paying very close attention to the DB settings. On the first page it says MySQL is enabled and PostgreSQL is disabled. I assume that means it will use MySQL since there's no other selector for DB type that I saw. The installation went fine and the test forum that gets created seems to work okay. I can post and browse and all that.
Then I try to do the data import from the old forum and get exactly the same error I did before. So I went into the forums data directory and moved the sql/pgsql directory to pgsql_old so the import code wouldn't use it. When I tried to then import the data again the process completed almost instantly. I logged into the forum and saw that the old forums forums were there with all of the relevant stats but there was no messages or contents in any of them.
So I guess you must be right about it getting mixed up with the pgSQL stuff but I don't know why that is since neither of my Linux boxes have ever even had PostgreSQL installed let alone configured.
Any more tips? Is it possible for me to verify that I have a valid and complete MySQL data dump from my old forum?
[Updated on: Thu, 07 August 2003 13:55] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: 2.5.2 dump and re-import problem [message #12723 is a reply to message #12435] |
Tue, 26 August 2003 18:22 |
 |
andy_scouser
Messages: 76
Registered: June 2003
Karma: 1
|
Member |
|
|
Hi there,
getting the same, after doing the same !
But, also, it does appear everything has imported correctly.
Do you want me to send any logs to assist you prottos.
(admimport.php) 1146: Table 'forum.pg_class' doesn't exist
Query: SELECT a.attname FROM pg_class c, pg_attribute a WHERE c.relname = 'fud25_action_log' AND a.attnum > 0 AND a.attrelid = c.oid AND a.attname='id'
Server Version: 4.0.13-max-log
[Updated on: Tue, 26 August 2003 18:23] Report message to a moderator |
|
|
|
| Re: 2.5.2 dump and re-import problem [message #12783 is a reply to message #12723] |
Sun, 31 August 2003 18:38 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Hmm it would appear the import got confused and thinks you are using PostgreSQL instead of MySQL which you are using. I'll need to see why this may of happened. As long as your forum works you should be ok however.
FUDforum Core Developer
|
|
|
|
| Re: 2.5.2 dump and re-import problem [message #12879 is a reply to message #12399] |
Tue, 16 September 2003 15:18 |
chrwei
Messages: 1
Registered: September 2003
Karma: 0
|
Junior Member |
|
|
i'm also having this problem.
Old server was php4.2.3, mysql and pg support, using MySql or FUD
New server is php 4.3.3, no pg support, using MySQl for FUD
The forum so far seems to mostly work, but several settings in global config were not restored.
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]