Mysql Generated Error About Timestamps

[agroamer]

Hello,

I just came into the family and I have a question. all of my stuff was cpaneled over by the techs, what a pleasure!

 

But when I tried to connect on osticket, I got this error:

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/xxxxx/public_html/xxxxxx/tickets/class.ticket.php on line 303

 

I looked in the file and it said:

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/xxxxx/public_html/xxxxx/tickets/class.ticket.php on line 303

function time_convert($mysql_timestamp) {

global $config;

$t = mysql_fetch_array(mysql_query("SELECT UNIX_TIMESTAMP($mysql_timestamp) AS timestamp"));

$t[timestamp] += ($config[timezone] * 3600);

return $t[timestamp];

 

 

Does anyone know what might be the issue. Is there some componenet misssing on mysql on these servers that don't like the timestamp thing? Cause this did work fine on the last host I was on.

and I configured my paths and etc no issue there, able to run other programs etc.

 

Thanks much for any help.

[TCH-JimE]

Hello,

 

I am not sure about this error, but one thing to check, was your previous host using a slightly different version of Mysql?

 

JimE

[Guest tohaet]

Could be that the value being passed into that function isn't correct and so causes a bad query, it's not necessarily anything wrong with the database.

 

That function has no error handling, which makes it difficult to determine the problem, wonder why its using the Database server to do the casting too, seems like a waste.