[osdldbt-general] (no subject)

[gio\.daniello\@libero\.it <gio...@li...>]

Hi all,

when I execute dbt-2, I have in ./client/error.log thousands o=
f these errors:

Fri Dec  3 22:36:57 2004
tid:49156 nonsp/dbc_order_st=
atus.c:163
ERROR: O_CARRIER_ID=3DNULL for query ORDER_STATUS_3:
SELECT =
o_id, o_carrier_id, o_entry_d, o_ol_cnt
FROM orders
WHERE o_w_id =3D x=0D
=
  AND o_d_id =3D x
  AND o_c_id =3D xxxx
ORDER BY o_id DESC

(x are v=
ariable parameters)

If i do this query:

mysql> SELECT o_id, o_carri=
er_id, o_entry_d, o_ol_cnt
    -> FROM orders
    -> WHERE o_w_id =3D 1=

    ->   AND o_d_id =3D 5
    ->   AND o_c_id =3D 2680
    -> ORDER B=
Y o_id DESC
    -> ;

+------+--------------+---------------------+---=
-------+
| o_id | o_carrier_id | o_entry_d           | o_ol_cnt |
+----=
--+--------------+---------------------+----------+
| 5087 |         NUL=
L | 2004-12-04 12:28:21 |        8 |
| 4266 |         NULL | 2004-12-04 =
11:46:59 |       10 |
| 4078 |         NULL | 2004-12-04 11:38:02 |     =
  15 |
| 3454 |            8 | 2004-12-04 11:07:46 |       14 |
| 3149 =
|            2 | 2004-12-04 10:53:46 |        9 |
| 3055 |            4 =
| 2004-12-04 10:49:17 |        9 |
|  417 |            2 | 2004-11-22 00=
:15:58 |       14 |
+------+--------------+---------------------+-------=
---+
7 rows in set (0.09 sec)


Is there a problem in the database?=0D
=

Regards
Gio

=0A=0A=0A=0A___________________________________________=
_________________=0ALibero ADSL: 3 mesi gratis e navighi a 1.2 Mega, senz=
a costi di attivazione.=0AAbbonati subito su http://www.libero.it=0A