[Devel] latest cvs , missing column inserted_time

[Anca-Maria Vamanu]

Indeed one of the changes included adding a new column in watchers table .
Please take the updated script from:

http://openser.org/dokuwiki/doku.php/presence:database-tables.

Anca

Adrian Georgescu wrote:

> Latest cvs seem to require a new database schema for one of the  
> presence tables but I cannot find a reference for the missing column  
> referred here:
>
> Dec  8 13:53:36 node03 /usr/local/openser/sbin/openser[12013]:  
> PRESENCE:query_db_notify: Could not get subs_dialog from database
> Dec  8 13:53:36 node03 /usr/local/openser/sbin/openser[12013]:   
> PRESENCE:update_presentity:Error in notify() function
> Dec  8 13:53:36 node03 /usr/local/openser/sbin/openser[12013]:  
> PRESENCE: handle_publish: sip-etag: [SIP-ETag: a. 
> 1165146884.27960.375  /34]
> Dec  8 13:53:36 node03 /usr/local/openser/sbin/openser[12014]:  
> PRESENCE: handle_publish: sip-etag: [SIP-ETag: a.1165582120.12014.6  / 
> 32]
>
> Dec  8 13:53:42 node03 /usr/local/openser/sbin/openser[12015]:  
> submit_query: Unknown column 'inserted_time' in 'where clause'
>
> Dec  8 13:53:42 node03 /usr/local/openser/sbin/openser[12015]:  
> db_delete: Error while submitting query
> Dec  8 13:53:42 node03 /usr/local/openser/sbin/openser[12015]:  
> PRESENCE:msg_watchers_clean: ERROR cleaning pending  subscriptions
>
>
> Adrian
>
>
> _______________________________________________
> Devel mailing list
> Devel at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/devel
>