CiviCRM Community Forums (archive)

Hello,  I am having a hard time upgrading to 4.4.3

This is what I have done so far.
 - Backed up the old database
 - Installed Civicrm in the new Jomla 3.0  Succesfully (no old data yet)
- Created a new database with the current 4.4.3 structure from the systems /sql folder
- Created a structure dump of the custom table so 3.4.4 version
- Uploaded the structure from custom tables into the new database
- created a data dump of the old database 3.3.4
- imported that data dump into the new database,
and that is where I am getting probles where the structure is different.  It is hitting the very first table with actual data (civicrm_activity) and apparently there is a column that is missing in the new structure, so it is failing when it wants to dump that field.

I have read the http://wiki.civicrm.org/confluence/display/CRMDOC/Ensuring+Schema+Integrity+on+Upgrades

But now sure how this can work, if I am uploading old structure  data into the new one.  what am i missing?

Help apreciated, please.

Thank you, I read wrong the first time arround, I got a bit further but ran into problems again.

I did the installation in joomla 3.1  successfully, it then asked to do the upgrade, I clicked yes and this is the error I got:

Sorry but we are not able to provide this at the moment.
DB Error: no such field
Return to home page.

 
Any new insights are appreciated

Jenny

Thank you for your response, How do I do this through the back end? When I try to go to the CRM COmponent, I get this error:  Fatal DB error, exiting, seems like your schema does not have civicrm_setting table.  I guess that is because that is a new table that did not exist before, but because my upgrade is failing it is not creating the table.

 SO I cannot do it through the admin,  I must do it through the back end.

Thank you for your help. 

I am sorry, I am a bit lost.

My current version is 3.4.4 and joomla 1.5

I installed a new clean joomla 3.0 and followed the isntructions on this page http://wiki.civicrm.org/confluence/display/CRMDOC/Upgrade+Joomla+Sites+to+4.4
and followed instructions to the tee.

ANd got the errors described bellow, I also did the Schema integrity process.

If I go back to the old CiviCRM code 3.4.4  it says is not compatible with joomla 3.0  so I am not sure if reverting to the old code will give me other errors. 

Sorry, but just want to confirm that I understood.

Jenny