#15 Problems with MAX, MIN, AVG and SUM

Current release
open
nobody
(General) (10)
5
2009-04-14
2009-04-14
Anonymous
No

Hi. I'm sorry for my English.
I would like to do a simple site for an association and unfortunately on the server
the MySQL service is not activated, therefore I have to use to force a DB text.
After a search in internet and read the many positive reviews I chose "Gladius",
taking into account that supports the SQL syntax.

Doing some test before using it in the site, I came across some bugs especially
in the version 0.8.1 and with the functions MAX, MIN, SUM and AVG; in fact every
SQL command that contains these functions returns the following messages:

Warning: reset () : Passed variable is not an array or object in D:\Dati\Web\gtest\gladius081\gladius_rs.php on line 391
Warning: key (): Passed variable is not an array or object in D:\Data\Web\gtest\gladius081\gladius_rs.php on line 396

while in the version 0.7.0 works fine.

Another warning that I receive when I do the INSERT statement that contains a date ex.

INSERT INTO messages VALUES ('12','2009-01-02 00:00:00','gruppo2','testo6','25');

the insert comes performed correctly, but I obtain also the following message

Warning: Missing argument 5 for gladius_date_enc () in D:\Dati\Web\gtest\gladius080\gladius.php on line 231

Experiencing to eliminate the argument $id in the functions “gladius_date_enc",
“gladius_time_enc" and “gladius_datetime_end" does not appear more the warning
and do not seem to be problems.
I do not know if it is a solution, but works...

In attached file there are the tests performed with the ver. 0.7.0 and 0.8.1.

Thank You
Michele

Discussion

  • Tests performed with the ver. 0.7.0 and 0.8.1.

     
    Attachments
  • snicker
    snicker
    2009-09-30

    I have the same issue, and gladius also does not return averages. PHP5