Jump to content


Photo

Upgraded MYSQL and have an error on one line...please help.


  • Please log in to reply
1 reply to this topic

#1 hbidad

hbidad
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 23 September 2006 - 07:55 PM

Error: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/user/public_html/quotes2/class.ticket.php on line 289

Problem:
function time_convert($mysql_timestamp) {
    global $config;
    $t = mysql_fetch_array(mysql_query("SELECT UNIX_TIMESTAMP($mysql_timestamp)$ <-- line 289
    $t[timestamp] += ($config[timezone] * 3600);
    return $t[timestamp];

We upgraded from  4.0.27-standard to 4.1.21-standard and cant figure it out.

Please advise.

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 25 September 2006 - 03:50 AM

That's not a valid query.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users