MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Krata Date:August 16 2002 2:26pm
Subject:Strange network error using mysql,mysql c api
View as plain text  
Hi,
 i am using mysql c api to send some queries to mysql server which is on 
another computer (100MBit almost next to the client)
in my code i am doing this 
        if (mysql_real_query(mysql,query,strlen(query)))
        {
                fprintf(stderr,"In query : \"%s\"\n",query);
                fprintf(stderr,"Error occured : %s\n",mysql_error(mysql));
        }


and this sometimes (e.g. 1 from 1.000.000 sends) do this :


In query : "insert into TR_ITEMS_TEMP (PLU_ID,SOL_PRICE,VOIDED,TR_ID,DPH,DELETE_INDEX)
values (-70,500,0,8052,2,8301)
"
Error occured : Unknown column 'QR_ID' in 'field list'
In query : "insert into TR_ITEMS_TEMP (PLU_ID,SOL_PRICE,VOIDED,TR_ID,DPH,DELETE_INDEX)
values (-70,500,0,8052,2,8301)
"

do someone know what should be the problem? 
Server is Win2K and has latest mysql server installed client is the one 
from RedHat 7.3 (3.23.49) (=`mysql_config --version`)

Can someone help me? Thanks.
Krata


Thread
Strange network error using mysql,mysql c apiKrata16 Aug