Home »
FUDforum Development »
Bug Reports »
v2.3.5 bug in import datadump
 v2.3.5 bug in import datadump [message #7679] |
Tue, 10 December 2002 05:04  |
AutoHost
Messages: 99
Registered: October 2002
Karma: 0
|
Member |
|
|
Installed 2.3.5 fresh on machine B, made sure that the FUD mysql table prefix was the same as machine A.
Able to log into B just fine.
On machine A, did a 'Make forum data dump'.
Moved .tar.gz file to machine B.
(NOTE: on machine A, I have added another table to the FUD database, and added a column to the users table. I have also created another theme, and modified several /adm/ files. The apache user on machine A is not the same name as apache user on machine B.)
On machine B, chown .tar.gz file to user that apache runs under, and did an 'import forum data'.
Got multiple errors "cannot create directory" for all the directories of the new theme I had made on machine A.
Also got error that the rank_pts table I had created on machine A was not found on machine B. It did show the INSERT command.
After all that, the rank_pts table did not get created on machine B, the user table is now completely EMPTY, and the new column in the user table is not there.
Looks like (on machine B), after a fresh install, I'll have to create the new theme with same name as new theme on machine A, manually create new table with correct field names, and manually add new column to FUD's user table.
This implies that the 'Import forum data' option ONLY works with the default theme, and ONLY if no new FUD database tables have been created or modified.
Unless the above problems are the result of the the apache user name not being the same between the two machines, then it seems that the Import process needs some more work.
Ron Miller
Stars! AutoHost
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Fri Feb 21 11:48:36 GMT 2025
Total time taken to generate the page: 0.03562 seconds
Calendar
Search
Help
Members
Register
Login
Home
. In order for it to work properly when you've made mods to the table structure or added new tables you should've created appropriate .sql files inside sql/mysql/ and modified any existing table structure with the same changes as the ones you've done in MySQL. Then when you've made the datadump the table structure from .sql, which is used to create tables would've been read in correct and a proper data dump would have been created. 
]