Net packets out of order

Net packets out of order

Postby m4him » Mon 18 Apr 2005 15:13

Using the sql editor with 4.70.4 libary

When a query does not understand the name of the table, this happens about 10% of the time, then the tablename must be manually added via the TableMappings property. This has always worked fine in the past BUT now When I click on TableMappings an error message pops up which says Net packets out of order: received[51],expected[1]. Although your website said this bug is fixed, it is not.

I am finishing a project and it requires a fix for this bug for me to continue.

Here is the query that requires a manual entry into TableMappings
Code: Select all
SELECT
  diagnosis.RecordNr,
  diagnosis.VisitDate,
  diagnosis.confirmed,
  diagnosis.ndcCode,
  sum(diagnosis.Qty) as Qty,
  diagnosis.cost,
  pharmacyinventory.stockItem,
  pharmacyinventory.inventoryAmount,
  pharmacyinventory.reorderLevel,
  pharmacyinventory.`timeStamp`,
  pharmacyinventory.ExpireFlag,
  pharmacyinventory.Unit,
  pharmacyinventory.TradeName,
  pharmacyinventory.GenericName,
  pharmacyinventory.Strength,
  pharmacyinventory.DoseForm,
  pharmacyinventory.Route,
  pharmacyinventory.Category,
  pharmacyinventory.MasterCategory,
  pharmacyinventory.currentInventory,
  DATE_FORMAT(diagnosis.VisitDate,'%Y%m%d')as visitDateYMD,
  DATE_FORMAT(diagnosis.VisitDate,'%Y%m')as YearMonth FROM
  lomadeluz.diagnosis INNER JOIN
  pharmacy.pharmacyinventory ON
   lomadeluz.diagnosis.ndcCode = pharmacy.pharmacyinventory.ndcCode
WHERE  (diagnosis.confirmed = 'Y' AND diagnosis.ndcCode != '0' AND DATE_FORMAT(visitDate,'%Y%m%d')   >= :parmStartDate AND   DATE_FORMAT(visitDate,'%Y%m%d') <= :parmEndDate)
   group by YearMonth,ndcCode
   order by YearMonth
m4him
 
Posts: 4
Joined: Fri 15 Apr 2005 18:57

Postby Serious » Tue 19 Apr 2005 08:26

Please specify MySQL server version.
Serious
 


Return to dotConnect for MySQL