Hello Xypron, mysql> desc shifts; +-------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------------+------------------+------+-----+---------+----------------+ | id | int(11) unsigned | NO | PRI | NULL | auto_increment | | shift | varchar(100) | YES | | | | | duration_in_hours | tinyint(4) | NO | | NULL | | | cost | double | YES | | NULL | | +-------------------+------------------+------+-----+---------+----------------+ 4 rows in set (0.00 sec)
mysql> select * from shifts; +----+--------+-------------------+------------------+ | id | shift | duration_in_hours | cost | +----+--------+-------------------+------------------+ | 1 | turno1 | 8 | 1 | | 2 | turno2 | 8 | 1.20000004768372 | | 3 | turno3 | 8 | 1.29999995231628 | +----+--------+-------------------+------------------+ 3 rows in set (0.00 sec) $ mysql --version mysql Ver 14.14 Distrib 5.1.49, for debian-linux-gnu (i486) using readline 6.1 $ dpkg -l|grep mysql ii libaprutil1-dbd-mysql 1.3.9+dfsg-3 The Apache Portable Runtime Utility Library - MySQL Dri ii libdbd-mysql-perl 4.016-1 Perl5 database interface to the MySQL database ii libmysql-ruby 2.8.2-1 MySQL module for Ruby ii libmysql-ruby1.8 2.8.2-1 MySQL module for Ruby 1.8 ii libmysqlclient15-dev 5.0.51a-24+lenny2 MySQL database development files ii libmysqlclient15off 5.0.51a-24+lenny2 MySQL database client library ii libmysqlclient16 5.1.49-1 MySQL database client library ii libqt4-sql-mysql 4:4.6.3-1 Qt 4 MySQL database driver ii mysql-client-5.1 5.1.49-1 MySQL database client binaries ii mysql-common 5.1.49-1 MySQL database common files, e.g. /etc/mysql/my.cnf ii mysql-server 5.1.49-1 MySQL database server (metapackage depending on the lat ii mysql-server-5.1 5.1.49-1 MySQL database server binaries and system database setu ii mysql-server-core-5.1 5.1.49-1 MySQL database server binaries ii php5-mysql 5.3.2-2 MySQL module for php5 $ glpsol -m nurse.mod GLPSOL: GLPK LP/MIP Solver, v4.43 Parameter(s) specified in the command line: -m nurse.mod Reading model section from nurse.mod... Reading data section from nurse.mod... 30 lines were read Reading shifts_cost... SELECT shift, cost FROM shifts nurse.mod:12: Shifts_cost requires numeric data MathProg model processing error I was careful to restart mysql, do not you think that strange? I await your advice. Thanks. On Sat, Sep 4, 2010 at 19:01, glpk xypron <[email protected]> wrote: > Hello Marcello, > > your examples runs fine, when I use the following to create the > MySQL table: > > USE nsp; > > DROP TABLE IF EXISTS shifts; > > CREATE TABLE shifts ( > id INT, > cost DOUBLE, > PRIMARY KEY ( id ) > ); > > INSERT INTO shifts ( id, cost ) VALUES > ( 1, 1. ), > ( 2, 2. ), > ( 3, 4.3 ); > > > Please, check the definition of column cost in > your MySQL table using one of the following commands: > > SHOW CREATE TABLE shifts; > DESCRIBE shifts; > > Best regards > > Xypron > > -------- Original-Nachricht -------- >> Datum: Sat, 4 Sep 2010 15:27:18 -0300 >> Betreff: [Help-glpk] Error: requires numeric data. > >> Hello, >> >> Looking in my bare bone model, see this error down, can you help me? >> >> $ glpsol -m nurse.mod >> GLPSOL: GLPK LP/MIP Solver, v4.43 >> Parameter(s) specified in the command line: >> -m nurse.mod >> Reading model section from nurse.mod... >> Reading data section from nurse.mod... >> 32 lines were read >> Reading shifts_cost... >> SELECT id,cost FROM shifts >> nurse.mod:14: Shifts_cost requires numeric data >> MathProg model processing error >> >> /* nurse.mod - Solve simple NSP - Nurse Scneduling Problem >> /*** Variables ***/ >> set SHIFTS; >> >> /*** Parameters ***/ >> /* Custo por turno */ >> param Shifts_cost{i in SHIFTS}; >> table shifts_cost IN "MySQL" 'Database=nsp;UID=nsp;PWD=nurseproblem' >> 'SELECT id,cost FROM shifts' : SHIFTS <- [id], Shifts_cost~cost; >> >> param Time_work >= 0; >> >> /*** solve section ***/ >> solve; >> for {i in SHIFTS} >> { >> printf "%d",Shifts_cost[i]; >> printf "\n"; >> } >> >> /*** data section ***/ >> data; >> >> #param Shifts_cost := 1 1, 2 2, 3 4.3; >> end; >> >> -- >> Marcello Henrique > > -- > GMX DSL SOMMER-SPECIAL: Surf & Phone Flat 16.000 für nur 19,99 Euro/mtl.!* > http://portal.gmx.net/de/go/dsl > -- Marcello Henrique Blog - http://faraohh.wordpress.com Associação Software Livre de Goiás (www.aslgo.org.br) Cercomp - UFG (www.cercomp.ufg.br) _______________________________________________ Help-glpk mailing list [email protected] http://lists.gnu.org/mailman/listinfo/help-glpk
