Upgraded to 0.9 now "Complete the installation"

[thetitan]

I when through the upgrade process and was able to load the interface and view my data and edit files and setting. Then all of a sudden my I received a message that my session had expired. When I went back to the front to login again I am shown the "Complete the installation" page. I don't know why. I can't get around it and when I enter the same administrator, email, password and company info that I had entered in version 0.8 I receive the following error:

Query failed with message 'Duplicate entry '10000000' for key 1'

What do I need to modify to get back to being able to log in?

[cabeza]

Hi titan,
 Strange behaviour you are having ... could you give some more info so we can reproduce it.
Thanks,
Marcos

[thetitan]

I was running version 0.8 on CentOS 5 system.

I downloaded version 0.9. Unzipped it and then uploaded it to the server overwriting everything. I restored the config data in the config file, then I started the upgrade process. I experienced the problem described here. After fixing the characters, I restored the DB and went through the upgrade process. No error. After that the above took place.

[thetitan]

I have pinpointed the problem.

I restored from a back up back to 0.8. Everything was working fine so I upgrade to v0.9. After the upgrade everything worked great. I when to update the company profile. There are 2 web addresses fields. One is called homepage and it holds the web address which was used in the previous version. The second field is called webaddress and it is empty. When you enter data in it and save that's when you are taken to the complete installation page.

That's what happened the first time around. Now that it happened again on the same page it reminded me of the first time it happened. There is a bug on the company profile page.

[ignacio]

Great! Thanks for your help!

If someone else goes through this, in order to avoid the "complete installation" screen from showing, you have to edit a value in your OpenGoo database. What you have to do is, in the 'og_companies' table, set the column 'client_of_id' of your company (the company with id 1) to 0, which in SQL is:

Code: [Select]

UPDATE `og_companies` SET `client_of_id` = 0 WHERE `id` = 1
Note that you may have a different table prefix in your installation than 'og_'.

We'll solve this bug for next release.

Thanks again thetitan!

[thetitan]

You are welcome, and take you for the temporally DB solution.

I have encountered a permissions issue. I have posted about it here.