MySql Upgrade to 4.0 Schema Bug

Submitted by Anonymous on Mon, 2008-09-08 22:37.
::

Just a minor fix, but tigase-server revision 1114 is missing the following line in tigase-server/database/mysql-schema-4-sp.schema:

drop procedure if exists TigAddNode;

Also, thanks for adding in my suggestion of making sure all JIDs are lower case.

-Alan Geleynse

‹ MUC discrepency TLS over SSL ›

Trackback URL for this post:

http://www.tigase.org/pl/trackback/1446
Hi, Thank you for letting me
kobit's picture
Submitted by kobit on Tue, 2008-09-09 06:52.

Hi,

Thank you for letting me know about the bug. It is fixed now.

Actually, you were not supposed to update the database schema before the Tigase server told you to do so. The code using the schema is not submitted to the SVN yet as I am testing it locally.

I just wanted to be sure the upgrade schema guide is available at the time of releasing the code and prepared it ahead of time. The old code won't be able to add a new user to the database.

And yes, I have changed the code to lowercase user JIDs but I am not yet 100% sure if all places are covered by my fix. Hopeful my tests expose all of them.


Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.