Solution for syntax error while importing the data.sql file

6 views
Skip to first unread message

Srini

unread,
Dec 14, 2011, 2:22:28 AM12/14/11
to scalr-...@googlegroups.com

In the data.sql file provided in the download, there is a syntax error that does not allow the import.

The first import statement is: INSERT INTO `account_users` (`id`, `account_id`, `status`, `email`, `fullname`, `password`, `dtcreated`, `dtlastlogin`, `type`, `comments`) VALUES (1, 0, 'Active', 'admin', 'Scalr Admin', '8c6976e5b5410415bde908bd4dee15dfb167a9c873fc4bb8a81f6f2ab448a918', '2011-09-09 10:49:07', '2011-12-06 02:28:16', 'ScalrAdmin', NULL)

Solution: There is a missing ; at the end of the first insert statement. Append a ; and you will be fine.

Version where this was noticed: scalr-12092011-r5916.tar.tgz

Srini

Dale-Kurt Murray

unread,
Dec 22, 2011, 10:46:42 AM12/22/11
to scalr-...@googlegroups.com
I too have experienced this error in the latest release scalr-12092011-r5916

http://cl.ly/23163Q2g2w2I0I1f3Y1v
Reply all
Reply to author
Forward
0 new messages