execute () on a non-object

timstring

:glare: I am getting this error on every one of my scripts:

Fatal error: Call to a member function execute() on a non-object in /Library/WebServer/Documents/DispatchReports/InTime.php on line 55

The offending code is:

$host="localhost";
$user="root";
$password="g1G3m#1989";
$Dbname = "CallsToDispatch";

$mysqli = new mysqli($host, $user, $password, $Dbname) or die('host doesnt work ' . $mysqli->error);

// Check connection
if ($mysqli->connect_errno) {
    echo "Hey you dolt, Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}

///////no good


$Quest = "SELECT WorkDate FROM InTime";

$stmt = $mysqli->prepare($Quest);

$stmt->execute(); // <- error happens here
$DateResult = $stmt->get_result();

$TestWorkDate = $row['WorkDate'];
echo $TestWorkDate . ' a ' . $WorkDate . '<br>';

ini_set('auto_detect_line_endings', true);

Everything was good at 5:00 yesterday. Why now?

bradgrafelman

You're asking the wrong entities. We could all speculate, but it would be wiser to ask your MySQL server since it apparently has detected a problem.

You should always be checking to see if each MySQL operation succeeded before continuing on with the next, that way you can log and react to errors appropriately. For example, here:

    $stmt = $mysqli->prepare($Quest); 

$stmt->execute(); // <- error happens here

you never checked to see if [man]mysqli_prepare/man indicated a problem has occurred and, if so, output/log the MySQL error message.

timstring

I put the error trap on the 'prepare' statement and got the following error:

Table 'callstodispatch.intime' doesn't exist

That is right. There's no database table with that name. The name should be

`CallsToDispatch`.`InTime`

This also happened day-before-yesterday. Is my database somehow getting corrupted?

My setup is this:

MacBook Pro OS 10.8.3
PHP Version 5.3.15.
mysql-5.6.11

bradgrafelman

Sounds like the lower_case_table_names system variable needs to be tweaked; see this MySQL manual page. You might try setting the variable to "1" and see if that works.

Depending upon which file system you're using on your Mac (HFS+ vs. HFSX, I think?), value "0" might even be more appropriate (despite the seemingly incorrect guidance that Mac OS X is strictly an O/S with "case-insensitive file names").

timstring

So, I found many references to my problem. All of them say to put your statement into 'my.ini' Naturally, I can't find that file. Where should I look?

bradgrafelman

Try searching for 'my.cnf' instead. I'm not sure what the default location on a Mac would be. (That is to say, I'm not too sure where anything on a Mac would be - I try to stay far away from them. :p)

dalecosp

bradgrafelman;11027573 wrote:
Try searching for 'my.cnf' instead. I'm not sure what the default location on a Mac would be. (That is to say, I'm not too sure where anything on a Mac would be - I try to stay far away from them. :p)

I'm aware that the screen generally faces the front, at least 😉

This might help:

http://forums.mysql.com/read.php?11,366143,376017#msg-376017

Weedpacket

I like how MySQL's "case-sensitive table names on case-sensitive filesystems and case-insensitive table names on case-insensitive filesystems" is called an "extension to the SQL standard" instead of a "violation of the SQL standard".

dalecosp

Weedpacket;11027587 wrote:
I like how MySQL's "case-sensitive table names on case-sensitive filesystems and case-insensitive table names on case-insensitive filesystems" is called an "extension to the SQL standard" instead of a "violation of the SQL standard".

So, just like the US Government, someone else has read George Orwell.

Not overly surprising, I guess. ;-)