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

[Dave Hall]

Brian Johnson <address@hidden> wrote:

> 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
> 

It was just a column added to the table.  I don't know what apps have
changed their prefs data - but I suspect there are a few.

The errors below are caused by the tables already existing in the db. 
Drop this db, restore from backup and try again would be my advice.

Cheers

Dave

> 
> 
> 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
> >
> 
> 
> 
> _______________________________________________
> Phpgroupware-developers mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>

dave.hall.vcf
Description: Card for <dave.hall@mbox.com.au>