[Tango-cs-bug-info] [tango-cs:bugs] #661 problems with create_db.sql script

0 views

Skip to first unread message

tango-cs...@lists.sourceforge.net

unread,

Oct 7, 2015, 2:55:32 AM10/7/15

to Tango-cs...@lists.sf.net

status: unread --> closed-fixed
Comment:

Fixed with Tango 9

[bugs:#661] problems with create_db.sql script

Status: closed-fixed
Created: Mon Apr 07, 2014 02:31 PM UTC by Zbigniew Reszela
Last Updated: Tue Apr 08, 2014 09:05 AM UTC
Owner: Emmanuel Taurel

I'm not a mysql expert, but it seems that create_db.sql has some problems with inserting devices.
It tries to insert string 'nada' for columns with int and datetime type.

/bin/sh ../../cppserver/database/create_db.sh < ../../cppserver/database/create_db.sql
ERROR 1366 (22007) at line 26: Incorrect integer value: 'nada' for column 'exported' at row 1

Similar errors are reported for columns: pid, started and stopped.

I substituted strings 'nada' with the default values and it worked.

I'm using the following "mysql":
Server version: 5.5.33-MariaDB openSUSE package
And operating system: openSUSE 13.1

Sent from sourceforge.net because Tango-cs...@lists.sf.net is subscribed to https://sourceforge.net/p/tango-cs/bugs/

To unsubscribe from further messages, a project admin can change settings at https://sourceforge.net/p/tango-cs/admin/bugs/options. Or, if this is a mailing list, you can unsubscribe from the mailing list.