Errors when upgrading and moving to new db/site.
Page: 1, 2
Recent posts in this topic
This is what I got:
Start: Config file found and loaded.
DB: Upgrade script has connected to the database.
DB: Failed to execute DB schema transformations. MySQL said: Table 'ac_attached_files' already exists
I was trying to upgrade and move my files from one site to another. I followed the instructions to download and upload the config and public/files. What else should I do to get the db move to the new location.
Help pls!
Thanks
mi2
Start: Config file found and loaded.
DB: Upgrade script has connected to the database.
DB: Failed to execute DB schema transformations. MySQL said: Table 'ac_attached_files' already exists
I was trying to upgrade and move my files from one site to another. I followed the instructions to download and upload the config and public/files. What else should I do to get the db move to the new location.
Help pls!
Thanks
mi2
When you say "move from one site to another", I assume there on the same server, maybe on a different sub-domain account? Or are you simply moving folders?
For you to have got the error "table already exists", your sql database is in place.
Did you go to the upgrade installer "public\upgrade" or main installer "public\install"?
For you to have got the error "table already exists", your sql database is in place.
Did you go to the upgrade installer "public\upgrade" or main installer "public\install"?
If you've already setup aC in the new site, it's likely already populated the DB with the tables (and if you haven't done anything with that install most of the tables are blank anyway.)
If you are trying to duplicate or move all the existing data you could create a backup file of the existing db, and remove the tables of the new database, and load the backup DB file, assuming of course you are going between like versions, .6 -> .6 , .7RC1 -> .7RC1 .. mixing and matching is just gonna mess up aC.
aC would just access the data now in the DB, the DB name, user, pass wouldn't be changed from the current 'new' aC fresh install.
If you are trying to duplicate or move all the existing data you could create a backup file of the existing db, and remove the tables of the new database, and load the backup DB file, assuming of course you are going between like versions, .6 -> .6 , .7RC1 -> .7RC1 .. mixing and matching is just gonna mess up aC.
aC would just access the data now in the DB, the DB name, user, pass wouldn't be changed from the current 'new' aC fresh install.
Ilija Studen
on Oct 6. 2006. 3:59 am
If you are moving existing installation to new location you don't need to execute upgrade script. What you need to do:
1. Move the database.
2. Move the files.
3. Open /config/config.php and update database connection parameters (if they are changed), URL etc.
1. Move the database.
2. Move the files.
3. Open /config/config.php and update database connection parameters (if they are changed), URL etc.
activeCollab team member
This is what I have done on my own:
1. Move the database. -??
2. Move the files. -- DONE
3. Open /config/config.php and update database connection parameters (if they are changed), URL etc. --DONE
I have already installed the .7 in new location, moved he files, did #3 as below. I can't log in, so I followed the instructions here to reset the pw to 123, but still can't get in.
Can I still move & upgrade at the same time? What do I need to do differently? Can you explain more about now to move the database and what's involve?
Thanks
mi2
1. Move the database. -??
2. Move the files. -- DONE
3. Open /config/config.php and update database connection parameters (if they are changed), URL etc. --DONE
I have already installed the .7 in new location, moved he files, did #3 as below. I can't log in, so I followed the instructions here to reset the pw to 123, but still can't get in.
Can I still move & upgrade at the same time? What do I need to do differently? Can you explain more about now to move the database and what's involve?
Thanks
mi2
Again, please confirm if you are on the same server - e.g. are you just moving it to a different directory? or a completely different host?
Reason? Because on the same host/server, you won't need to move/copy the database (which from your original post I'm assuming is true).
"I have already installed the .7 in new location" - Do you mean you have just uploaded the files or have you uploaded and installed activeCollab.
If you've installed activeCollab, then that's the problem. Don't! On a fresh upload of the activeCollab files (from the zip or tar file) to your new location, you should copy the files from /config and /public/files folders. Then run public/upgrade/index.php NOT public/install/index.php.
Full instructions are here:
http://www.activecollab.com/pages/20/releases/activecollab-0.7/upgrade-instructions/
Peter.
Reason? Because on the same host/server, you won't need to move/copy the database (which from your original post I'm assuming is true).
"I have already installed the .7 in new location" - Do you mean you have just uploaded the files or have you uploaded and installed activeCollab.
If you've installed activeCollab, then that's the problem. Don't! On a fresh upload of the activeCollab files (from the zip or tar file) to your new location, you should copy the files from /config and /public/files folders. Then run public/upgrade/index.php NOT public/install/index.php.
Full instructions are here:
http://www.activecollab.com/pages/20/releases/activecollab-0.7/upgrade-instructions/
Peter.
Yes, same server but different DB since I have more than 1 site.
I followed yr notes and then run run public/upgrade/index.php but now it says:
Start: Config file found and loaded.
DB: Upgrade script has connected to the database.
DB: Failed to execute DB schema transformations. MySQL said: Table 'ac_attached_files' already exists
Am I suppose to do this:
Open /config/config.php and update database connection parameters before running the upgrade?
I followed yr notes and then run run public/upgrade/index.php but now it says:
Start: Config file found and loaded.
DB: Upgrade script has connected to the database.
DB: Failed to execute DB schema transformations. MySQL said: Table 'ac_attached_files' already exists
Am I suppose to do this:
Open /config/config.php and update database connection parameters before running the upgrade?
Ilija Studen
on Oct 6. 2006. 12:10 pm
If you are moving your activeCollab installation to another place you should not run the upgrade. Can you start by explaining in details what are you trying to do so we could provide an instructions and help.
activeCollab team member
okay!! This is what I'm trying to do:
move from www.myactivecollab1.com to www.myactivecollab2.com
activecollab1 was .6 in site1 DB
And I hope to have activecollab2 in .7 in site 2 DB
All same server but with separate DB.
Would it be easier if I start fresh and create a new DB(sub?) in site2??
I'm not really a programmer so I'm not sure what other details you need. Please explain or ask me questions so I can answer them and have you try to help me. =)
Thanks
mi2
move from www.myactivecollab1.com to www.myactivecollab2.com
activecollab1 was .6 in site1 DB
And I hope to have activecollab2 in .7 in site 2 DB
All same server but with separate DB.
Would it be easier if I start fresh and create a new DB(sub?) in site2??
I'm not really a programmer so I'm not sure what other details you need. Please explain or ask me questions so I can answer them and have you try to help me. =)
Thanks
mi2
Thanks mi2 for the extra info,
I'm sure ilija can answer you better, but...
You'll need to first get a copy of your database - so you'll need access to phpMyAdmin (or similar) on your server.
Select your activeCollab database from site 1 then select the Export option. I normally export as SQL in a zip file downloaded to my computer.
Then create your new database on site 2. Then select Import in phpMyAdmin which will load in your database.
Then upload all the files for v0.7 rc1 onto site 2.
Copy your old config file and all files in the public/files folder to site 2.
Modify the config file to point to the newly created database on site 2. Also change the site location in the config file.
Run the update script.
Fingers crossed!
I'm sure ilija can answer you better, but...
You'll need to first get a copy of your database - so you'll need access to phpMyAdmin (or similar) on your server.
Select your activeCollab database from site 1 then select the Export option. I normally export as SQL in a zip file downloaded to my computer.
Then create your new database on site 2. Then select Import in phpMyAdmin which will load in your database.
Then upload all the files for v0.7 rc1 onto site 2.
Copy your old config file and all files in the public/files folder to site 2.
Modify the config file to point to the newly created database on site 2. Also change the site location in the config file.
Run the update script.
Fingers crossed!
