Attempting to upgrade from Infocentral 1.2.6
Brought to you by:
srmcatee
Menu
▾
▴
I see that lehe0011 posted a similar request for help in February, but I'm making this a separate thread because I'm having a slightly different problem.
After making backups of everything, I downloaded OSC and set it up in a new directory on the webserver.
I ran the SQL files:
Upgrade-from-1.2.x.sql
and
Upgrade-from-1.2.x_1.3.0.sql
(even only running one or the other of these files produces no joy)
I then changed all of the settings that were appropriate to change in Include/Config.php.
Now, I can log into OSC, but I'm immediately presented with an SQL error. Forgive me for not posting the exact query, but I'm not onsite. Essentially, the cause of the error was that $chu_Church_ID is undefined.
I ran a find|grep in the most recent release (I also have breakage with the CVS checkout I pulled the night before last) and the only place that the variable $chu_Church_ID gets set is from a value in the Session cookie.
I looked at the church_chu table, and it was empty, so I created an entry for "My Church" with the chu_church_ID set to 1.
Still no change in the error message.
So, I tried forcing the value of $chu_Church_ID to 1 in Include/Config.php.... That produced very different breakage.
Does anyone have a suggestion?
I'm tempted to try doing a fresh install with a brand new database and then attempt to migrate the data over, once I've convinced myself that I have a functional install.... But I don't particularly relish that idea.
Melstav,
Try the attached code. I thought I had checked in the alter script to bring an infocentral database up to OSC. But it appears not so.
Let me know if you have any problems with this script. If its good I'll check it into cvs.
Thanks and sorry for the delayed answer. I've been relocating and disconnected from the Internet.
Steve
My bad. I thought I could attach files in the forum. It appears I cannot. I uploaded the script to patches. Please download there.
Steve
There was much rejoicing.
I ran the new update sql file against the restored infocentral database, and now OSC appears to operate correctly.
Although, I have a question.... (let me preface by stating that I have NOT gone poking around any of the internals)
Why set chu_Church_ID to 9 in all of the tables (except church_chu) when the only church in church_chu has chu_Church_ID set to 1?
Thanks.
Barry
I was trying to see if anythign would break if I did not set to 1. Also, I was going to go back and change the setting to a variable to make it easier to convert and customize your results.
Just have not had the time yet.
Let me know if I can be of any further assistance.
Steve.