Re: Corn job anomaly

> On Sep 23, 2016, at 5:38 AM, Richard =
<[email protected]> wrote:
>=20
>=20
>=20
>> Date: Friday, September 23, 2016 03:28:47 -0500
>> From: Karl DeSaulniers <[email protected]>
>>=20
>> Ok, so I have run down all the possible things (that I know of)
>> that could be keeping this from working. I have checked with my
>> hosting service that:
>>=20
>> 1. MySQL is accessible with the original user I started with (for
>> this case were using db123456) via ssh. 2. The cron is accessing my
>> php script fine.
>> 3. The cron is running the script and is attempting to access MySQL
>> but not allowing access still.
>>=20
>> I tried running the script via ssh and it is timing out. No error
>> of not accessing MySQL, just telling me it is timing out.  This
>> tells me (I could be wrong) that it is in fact accessing MySQL and
>> that my calls to MySQL are making the script time out? What bothers
>> me is that the cron errors out saying access denied but ssh says
>> timeout error. Does anyone have any ideas for me to try at this
>> point? If I don't get this to work in the next couple of days, I am
>> toast!
>>=20
>=20
> -- Try the mysql access and commands directly from the command
>    line (using the mysql cli).
>=20
> -- Put debug/print statements in your code so you can clearly
>    see where you are getting.=20
>=20
>    -- This includes printing out your mysql statements so that
>       you know exactly what is being passed to mysql (both when
>       you run the script by hand and via cron).
>=20

Thanks Richard,
That got me thinking and I figured out my access issue... HALELUYAAAAA!

Now I am getting an error with mysql syntax.

"SELECT otn.*, cf.* FROM ".ORDER_TABLE." otn LEFT JOIN ".FIELDS_TABLE." =
cf ON cf.Order_ID =3D otn.Order_ID WHERE cf.Earliest_Pickup >=3D =
DATE(NOW()) AND cf.Earliest_Pickup <=3D DATE(NOW() + INTERVAL =
".($Num_Days_Away+1)." DAY) AND otn.Order_Status !=3D 'Shipping' AND =
otn.Order_Status !=3D 'Completed'"

is giving me this error:
	You have an error in your SQL syntax; check the manual that =
corresponds to your MySQL server version for the right syntax to use =
near '\"Shipping\" AND otn.Order_Status !=3D \"Completed\"' at line 1

I think at this point my brain is fried and I am not seeing what is =
wrong with this.=20
Can anyone point out my folly? My guess is it is an obvious one, but I =
am not seeing it.

Thanks again for your help everyone. I think I am almost there!

Best,

Karl DeSaulniers
Design Drumm
http://designdrumm.com


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php