MySQL error. Works locally but not remotelly

Asked Jul 22 '13 at 15:24

Active Nov 18 '13 at 15:09

Viewed 72 times

I have this code

$savechanges = $dataserver->prepare("UPDATE hub_apps SET aname=?, aicon=?, aimage=?, atype=?, aurl=? WHERE id = ?");
$savechanges->bind_param('sssisi',
$_POST['app_name'],
$_POST['app_icon'],
$_POST['app_screen'],
$_POST['app_type'],
$_POST['app_url'],
$_GET['id']);
$savechanges->execute();
$savechanges->close();

It runs on my local server but online it fails with:

Fatal error: Call to a member function bind_param() on a non-object

on the bind_param line.

Am I missing something?

UPDATE: Well I followed user "Your Common Sense" link and added "or trigger_error($dataserver->error)". Turns out user didn't had UPDATE privileges. Thanks for the help :) My mistake. :X

edited Nov 18 '13 at 15:09

asked Jul 22 '13 at 15:24

Fábio Alves

1

It seems that `prepare` is not working – Explosion Pills Jul 22 '13 at 15:26
check if the dll of mysqli is enabled. http://php.net/manual/en/mysqli.installation.php – Sebas Jul 22 '13 at 15:26
[Fatal error: Call to a member function bind_param() on a non-object](http://stackoverflow.com/a/15447204/285587) – Your Common Sense Jul 22 '13 at 15:28
It is enabled. I can do INSERT it works flawlessly, this on the other hand, fails and it's weird. – Fábio Alves Jul 22 '13 at 15:29
Well I followed Your Common Sense's link and added "or trigger_error($dataserver->error)" Turns out user does not have UPDATE privileges. Thanks for the help :) My mistake. :X – Fábio Alves Jul 22 '13 at 15:32

MySQL error. Works locally but not remotelly

0 Answers0