Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Blocker
-
Resolution: Won't Fix
-
Affects Version/s: None
-
Fix Version/s: TSA Pixel Tracking V2
-
Component/s: None
-
Labels:None
-
Environment:
Staging-db5,6 and 7
Description
While executing the create.sql, it throws syntax error exception.
pradeep.nair@tvvm-staging-xml1:~$ mysql -uroot -ptestvalsvr -h 192.168.30.15
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 354980
Server version: 5.0.30-enterprise-gpl MySQL Enterprise Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> source /home/pradeep.nair/create.sql
Query OK, 0 rows affected, 1 warning (0.01 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.04 sec)
Query OK, 0 rows affected (0.02 sec)
Query OK, 0 rows affected (0.03 sec)
Query OK, 16 rows affected (0.00 sec)
Records: 16 Duplicates: 0 Warnings: 0
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 'USING BTREE,
KEY `waypoints` (`siteID`,`visitorKeyHash`,`sessionKeyHash`,`wayp' at line 36
Query OK, 0 rows affected (0.03 sec)
Query OK, 0 rows affected (0.02 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.01 sec)
ERROR 1046 (3D000): No database selected
Query OK, 0 rows affected (0.04 sec)
Query OK, 0 rows affected (0.03 sec)
Query OK, 0 rows affected (0.05 sec)
