Re: [Help-glpk] Error: requires numeric data.

[Marcello Henrique]

Hello Xypron,

$ echo $LANG
pt_BR.UTF-8

But I tested changed to C, en_US.UTF-8 and not worked.

$ 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...
20 lines were read
Reading shifts_cost...
SELECT id,cost FROM shifts
Display statement at line 19
I:
   (1,'1.000')
   (2,'1.200')
   (3,'1.300')
Model has been successfully generated
GLPK Simplex Optimizer, v4.43
0 rows, 0 columns, 0 non-zeros
~     0: obj =   0.000000000e+00  infeas =  0.000e+00
OPTIMAL SOLUTION FOUND
Time used:   0.0 secs
Memory used: 0.1 Mb (70106 bytes)

Thanks for you agility.

On Sat, Sep 4, 2010 at 22:01, glpk xypron <address@hidden> wrote:
> Hello Marcello,
>
> please, run the following:
>
> set I, dimen 2;
> table shifts_cost IN "MySQL" 'Database=nsp;UID=nsp;PWD=nurseproblem'
>  'SELECT id,cost FROM shifts' :
>  I <- [id, cost];
> display I;
> end;
>
> and send the result.
>
> What is the output of system command locale?
>
> Best regards
>
> Xypron
>
>
> -------- Original-Nachricht --------
>> Datum: Sat, 4 Sep 2010 20:53:14 -0300
>> Betreff: Re: [Help-glpk] Error: requires numeric data.
>
>> 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 <address@hidden> 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
>> address@hidden
>> http://lists.gnu.org/mailman/listinfo/help-glpk
>
> --
> 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)