Re: [Tikiwiki-devel] 1.8to1.9 upgrade sql error

[Damian P. <da...@da...>]

On Wed, Jul 20, 2005 at 08:03:00AM +0200, bertrand Gugger wrote:
> Damian Parker wrote:
> 
> >On a rare occasion I was actually sat watching the 1.8to1.9.sql
> >run through and I notice these errors:
> > 
> >
> I check quite each time I'm running it ... you no ?
> 
> >ERROR 1061 at line 274: Duplicate key name 'tagcategory'
> >ERROR 1061 at line 275: Duplicate key name 'taglabel'
> >ERROR 1064 at line 297: You have an error in your SQL syntax.
> >Check the manual
> >that corresponds to your MySQL server version for the right
> >syntax to use near '
> >taglabel='New Web' AND taginsert='#\r\n#Start of web interface
> >ERROR 1064 at line 299: You have an error in your SQL syntax.
> >Check the manual
> >that corresponds to your MySQL server version for the right
> >syntax to use near '
> >taglabel='New Outputformat' AND taginsert='OUTPUTFORMAT\r\n NAM
> >ERROR 1050 at line 307: Table 'tiki_sheet_layout' already exists
> >ERROR 1060 at line 319: Duplicate column name 'lang'
> >
> >This is from various db's on a multi-tiki installation  Line 1064
> >seems to be a toggg area about group wiki history options
> > 
> >
> You are really a bad guy: such loose accusations :(
> Please check what your are telling.
> http://cvs.sourceforge.net/viewcvs.py/tikiwiki/tiki/db/tiki_1.8to1.9.sql?r1=1.79.2.145&r2=1.79.2.146&only_with_tag=BRANCH-1-9
> Where the hell you find me there ?
> It's in your mind.
> You are really a bad guy, you ignore the word community.
> 
> Btw, instead of bad gossips, why you did not correct it ?
> I did it now ... so you can accusate me next time, lol :
> 
> CIA-12 toggg BRANCH-1-9 * tiki/db/tiki_1.8to1.9.sql:
> CIA-12 Missing clause WHERE in 2 delete quicktags,
> CIA-12 NO ! Damian , that was not me but amette, your accusations are 
> really bad


snipped from the upgrade.sql

# 2005-04-24 toggg: view wiki history copied for groups
DROP TABLE IF EXISTS temp_users_grouppermissions;
CREATE TABLE temp_users_grouppermissions (
  groupName varchar(255) NOT NULL default '',
  permName varchar(30) NOT NULL default '',
  value char(1) default '',
  PRIMARY KEY  (groupName(30),permName)
) TYPE=MyISAM;
INSERT into temp_users_grouppermissions SELECT groupName,
        'tiki_p_wiki_view_history', value FROM
        users_grouppermissions WHERE permName='tiki_p_view';
        INSERT into users_grouppermissions SELECT * FROM
        temp_users_grouppermissions;
        DROP TABLE temp_users_grouppermissions;
        

assumption taken from the comment above.  


Notice the words "seems" to be a toggg area.  not a statement but
a query about its author.


-- 


Damian Parker
Damosoft - TikiWiki Support, Development and Training
http://www.damosoft.co.uk / http://tikihost.net / http://tikiwiki.info
Telephone - 0845 004 3923  IAXtel - 700-168-0333  FWD - 72453
Full Online Support Tracking at - http://support.damosoft.net
*** http://free.tikihost.net - FREE TikiWiki hosting options!! ***