Database.sql contains syntax error

Bug #327015 reported by Alex Harrington
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Xibo
Fix Released
Medium
Dan Garner

Bug Description

I'm trying to setup a Dev server using the latest and greatest from lp:~dangarner/xibo/xibo-server R74, but when I create a new database and attempt to load the SQL in to it, I get the following error:

root@xibo-dev:/var/www# mysql -u xibo -p xibo < xibo/server/Database.sql
Enter password:
ERROR 1064 (42000) at line 705: 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 'ALTER TABLE `version` ADD `XmdsVersion` SMALLINT NOT NULL ,
ADD `XlfVersion` SMA' at line 4

Using the latest MySQL from Ubuntu Intrepid:
mysql --version
mysql Ver 14.12 Distrib 5.0.67, for debian-linux-gnu (i486) using readline 5.2

Related branches

Changed in xibo:
assignee: nobody → dangarner
Dan Garner (dangarner)
Changed in xibo:
importance: Undecided → Medium
milestone: none → 1.0rc1
status: New → Fix Committed
Changed in xibo:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.