My MySQL qwery wont load the contacts from the database.

[cshores]

My MySQL qwery wont load the contacts from the database. I am running a MySQL qwery:


SELECT
emailaddress.EmailAddressID,
emailaddress.EmailAddress,
emailaddress.FirstName,
emailaddress.LastName,
schooldistrict.SchoolDistrict,
schooldistrict.County,
State.State,
'11366' AS CampaignID FROM emailaddress
LEFT JOIN schooldistrict ON schooldistrict.SchoolDistrictID=emailaddress.SchoolDistrictID LEFT JOIN State ON State.Abbreviation=EmailAddress.State WHERE 1 AND emailaddress.LastEmailCampaignID=11366 ORDER BY RAND()




This qwery works on 4 other machines with the exact same settings. Does anyone have any idea what could be causing this to happen? I have even uninstalled this application and reinstalled MaxBulk Mailer.

Thanks in advance
Cole

 

[stanbusk]

Do you mean it works with MaxBulk Mailer is 4 other machines but not on that one?

 

[cshores]

Our company has 4 licenses and 4 different machines use the softare. only one machine seems to start loading the query then drops off without error however no load. I tried switching the machines static ips and gateways around... that causes the issue to switch to the other machine. Im at a loss. thanks in advance.

 

[stanbusk]

Are you 100% sure the query and the settings are the same?