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

[Brian Johnson]

Dave Hall seems to know about the prefs being changed .. maybe he knows what
they were changed to and can help you more than I can



Bob Crandell (address@hidden) wrote:
>
> 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
> >
> >
>
> FAX - 541-463-1627
> Eugene, Oregon
>
>
>
>
> _______________________________________________
> Phpgroupware-developers mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>