[Users] presence module database tables

Daniel-Constantin Mierla daniel at voice-system.ro
Thu Jan 11 12:10:47 CET 2007


Hello,

the size of those columns was adjusted to match other tables -- it was a 
mistake in the documentation -- I have updated it:
http://www.openser.org/docs/modules/1.2.x/presence.html#AEN199
http://openser.org/dokuwiki/doku.php/presence:database-tables

Thanks for reporting,
Daniel

On 01/11/07 11:55, Cristian Caprar wrote:
> Hi,
>
> I am having trouble creating the xcap_xml table of the new presence
> module in mysql (latest 4.1.22 on RHEL 4).
>
> The table definition from the docs is:
>
> CREATE TABLE `xcap_xml` (
>   `user` varchar(256) NOT NULL,
>   `domain` varchar(256) NOT NULL,
>   `xcap` text NOT NULL,
>   `doc_type` varchar(64) NOT NULL,
>   PRIMARY KEY  (`user`,`domain`,`doc_type`)
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
>
> I get the following error:
> ERROR 1170 (42000): BLOB/TEXT column 'user' used in key specification
> without a key length
>
> In my opinion, the problem is the definition of the user and domain
> columns, which are varchar(256), instead of varchar(255) and are
> automatically promoted to text columns. If changing the size to 255,
> everything is fine.
>
> Does the presence db code do some length checks that can be affected by
> this change? Is the table definition correct or am I missing something?
>
> Thanks,
> Cristian
>
> _______________________________________________
> Users mailing list
> Users at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>
>   




More information about the sr-users mailing list