Re: [Phpgroupware-developers] 0.9.14.007 --> 0.9.14.512 Upgrade

[Bob Crandell]

Ok, start of another test.

Stopped mysql, copied data, started mysql.
Go to /phpgr16/setup/index.php
Click on Configuration.
Make sure path is pointing to test data.
Click on Upgrade.  Message says:
Application no longer exists.  It doesn't say what application.

Now I step through the applications that need to be installed or upgraded.  
When I
get to Site Manager, it says:
Projects Translations Upgraded.Updating sitemgr to a multilingual architecture 
with
existing site language enFixing column names.Database error: Invalid SQL: CREATE
TABLE phpgw_sitemgr_modules (module_id int(11) auto_increment not null NOT NULL,
app_name varchar(25), module_name varchar(25), description varchar(255), PRIMARY
KEY(module_id))
MySQL Error: 1050 (Table 'phpgw_sitemgr_modules' already exists)
Database error: Invalid SQL: CREATE TABLE phpgw_sitemgr_content (block_id 
int(11)
auto_increment not null NOT NULL, area varchar(50), cat_id int, page_id int,
module_id int NOT NULL, arguments text, sort_order int, view int, actif 
smallint,
PRIMARY KEY(block_id))
MySQL Error: 1050 (Table 'phpgw_sitemgr_content' already exists)
Database error: Invalid SQL: CREATE TABLE phpgw_sitemgr_content_lang (block_id
int(11) auto_increment not null NOT NULL, lang varchar(2) NOT NULL, 
arguments_lang
text, title varchar(255), PRIMARY KEY(block_id,lang))
MySQL Error: 1050 (Table 'phpgw_sitemgr_content_lang' already exists)
Database error: Invalid SQL: CREATE TABLE phpgw_sitemgr_active_modules (area
varchar(50) NOT NULL, cat_id int NOT NULL, module_id int(11) auto_increment not 
null
NOT NULL, PRIMARY KEY(area,cat_id,module_id))
MySQL Error: 1050 (Table 'phpgw_sitemgr_active_modules' already exists)
Database error: Invalid SQL: CREATE TABLE phpgw_sitemgr_properties (area 
varchar(50)
NOT NULL, cat_id int NOT NULL, module_id int NOT NULL, properties text, PRIMARY
KEY(area,cat_id,module_id))
MySQL Error: 1050 (Table 'phpgw_sitemgr_properties' already exists)
Fixing column names.Database error: Invalid SQL: ALTER TABLE 
phpgw_sitemgr_content
CHANGE view viewable int
MySQL Error: 1054 (Unknown column 'view' in 'phpgw_sitemgr_content')
Database error: Invalid SQL: ALTER TABLE phpgw_sitemgr_modules DROP COLUMN 
app_name
MySQL Error: 1091 (Can't DROP 'app_name'. Check that column/key exists)

No other applications have a problem.

Now I log in as Admin this time instead of as me.
Go to Forced Preferences.
Make some changes.
Click Save.
Logout.
Login as Admin.
Go to Forced Preferences.
None of the changes are there.

Sigh.  Have a nice day.
Bob

Brian Johnson (address@hidden) wrote:
>
>not that I know of
>
>
>
>Chris Weiss (address@hidden) wrote:
>>
>> uh, did the format of the prefs table change for .16?
>>
>> Brian Johnson (address@hidden) wrote:
>> >
>> > Do you have a backup of the phpgw_preferences table?
>> >
>> > Try installing that copy, logging admin off, logging back on, and see what 
>> > it
>> > does.
>> >
>> > Then go to prefs (as admin) and try changing the email prefs.  Logoff, 
>> > logon,
>> > report situation.
>> >
>> > Then same for addressbook prefs.
>> >
>> > I suspect it is one of those two apps but we need to find out which
>> >
>> >
>> >
>> >
>> > Bob Crandell (address@hidden) wrote:
>> > >
>> > > Ok, the addressbook upgrades correctly.  Preferences don't stick though. 
>> > >  I
>> > > looks like trying to set preferences for email resets the rest of the
>> > > preferences.  Now what it resets it to varies.  I haven't figured out 
>> > > what
>> > > determines what preferences get reset to.  Sometimes it's Default, 
>> > > sometimes
>> > > it's Verdilak.
>> > >
>> > > This doesn't happen on a fresh install.
>> > >
>> > > I hope I explained this well enough.
>> > >
>> > > Thanks
>> > > Bob
>> > >
>> > > Alex Borges (address@hidden) wrote:
>> > > >
>> > > > They should work now.... It can do some crazy stuff to the addressbook
>> > > > but only on organizations.... try it out, and report problems. We have
>> > > > fixer scripts for certain scenarios
>> > > >
>> > > > El lun, 02-02-2004 a las 15:58, Bob Crandell escribió:
>> > > > > Hi,
>> > > > >
>> > > > > I have one site using version 0.9.14.512 and they are happy.  Now I'm
thinking
>> > it's
>> > > > > getting time to upgrade all the existing version 0.9.14.007 ones.  I
tested it a
>> > > > > month or so ago and it went well except for the addressbook.  It has 
>> > > > > all the
>> > > > > addressed in it but they seem scrambled.  Has this been brought to 
>> > > > > your
>> attention
>> > > > > before?  Is there a process developed to upgrade?
>> > > > >
>> > > > > Thanks
>> > > > > Bob
>> > > > >
>> > > > > --
>> > > > > Assured Computing
>> > > > > When you need to be sure.
>> > > > > address@hidden
>> > > > > www.assuredcomp.com
>> > > > > Voice - 541-868-0331
>> > > > > FAX - 541-463-1627
>> > > > > Eugene, Oregon
>> > > > >
>> > > > >
>> > > > >
>> > > > >
>> > > > > _______________________________________________
>> > > > > Phpgroupware-developers mailing list
>> > > > > address@hidden
>> > > > > http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>> > > > >
>> > > >
>> > > >
>> > > >
>> > > > _______________________________________________
>> > > > Phpgroupware-developers mailing list
>> > > > address@hidden
>> > > > http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>> > > >
>> > >
>> > >
>> > >
>> > > _______________________________________________
>> > > Phpgroupware-developers mailing list
>> > > address@hidden
>> > > http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>> > >
>> >
>> >
>> >
>> > _______________________________________________
>> > Phpgroupware-developers mailing list
>> > address@hidden
>> > http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>> >
>>
>>
>>
>> _______________________________________________
>> Phpgroupware-developers mailing list
>> address@hidden
>> http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>>
>
>
>
>_______________________________________________
>Phpgroupware-developers mailing list
>address@hidden
>http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>
>

--
Assured Computing
When you need to be sure.
address@hidden
www.assuredcomp.com
Voice - 541-868-0331
FAX - 541-463-1627
Eugene, Oregon