[OpenSIPS-Users] database sermyadmin+opensips

[troxlinux]

Hi Flavio,  I making it but he gives me an error message:

vim presence-create.sql
[root at twoxserver mysql] #mysql -or root -p sermyadmin <presence-create.sql
Enter password:
ERROR 1062 (23000) at line 1: Duplicate you entry ' presentity' for key 1

presence-create.sql
INSERT INTO version (table_name, table_version) values ('presentity','3');

that appropriate value can give him?

best regards


2009/3/16 Flávio Eduardo de Andrade <flavio at voffice.com.br>:
> Hi Ricky,
>
> It is an old definition in the presence tables. Delete the presence related
> tables and recreate them with the mysql scripts in the opensips source code.
> /scripts/mysql/.... It is fixed in the newest version.
>
> Flavio
> ________________________________
-- 
rickygm

http://gnuforever.homelinux.com