Emmanuel Lacour wrote:
> You forgot to read UPGRADING.mysql. It will tell you to upgrade format
> of DB fields as now RT uses full UTF-8 colation.

hm. Indeed I did. Sorry.

However, when I do the :

     mysql -u root -p rt3 < sql.queries

it tells me :

Enter password: 
ERROR 1067 (42000) at line 3: Invalid default value for 'RightName'
zsh: 6183 exit 1     mysql -u root -p rt3 < sql.queries

Line three contains : 

ALTER TABLE ACL MODIFY RightName VARBINARY(25) NOT NULL DEFAULT NULL;

-geir

-- 
**--**--**--**--**--**--**--**--**--**--**--**--**--**--        
Geir Skjotskift, mnemonic AS    Email : [EMAIL PROTECTED]          
Wergelandsveien 25              Cell  : +47 95 10 51 09              
N-0167 Oslo, NORWAY             Fax   : +47 23 20 47 01              
    Key A2360FF3 availiable at subkeys.pgp.net

Attachment: pgp0xb1T0d4Bb.pgp
Description: PGP signature

_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Reply via email to