Project

General

Profile

Push notification component's schema issues - dist max 7.2.0

kellogs .
Added over 1 year ago

Hello,

I am getting some errors when importing the schema. The tigase archive is a nighly build from about 4 days ago.

mysql> source database/mysql-push-schema-1.0.0.sql
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    5240
Current database: tigasedb

Query OK, 0 rows affected (0.27 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.02 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'declare _nodeSha1 char(40)' at line 1
ERROR 1327 (42000): Undeclared variable: _serviceJidSha1
ERROR 1054 (42S22): Unknown column '_serviceJidSha1' in 'where clause'
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'end //


delimiter' at line 1

Thank you