How to SELECT from a view in SQL? (General error: 1615 Prepared statement needs to be re-prepared)

Question

UPDATE: The query is working perfectly as follows; the error solely appears when I select from the view.

$query = "
SELECT ModuleID, ModuleName, Credits, Lecturer, Room, EmployeeID, Forename, Surname, RoomID, RoomCode
FROM ((Module 
INNER JOIN Employee ON Module.Lecturer = Employee.EmployeeID) 
INNER JOIN Room ON Module.Room = Room.RoomID)
";

$result = $DBH->prepare($query);
$result->execute();
$data = $result->fetchAll();

I'm receiving the following error when trying to SELECT * FROM a view I created. (Selecting from a table works perfectly).

Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared'

I have no issues when using

SELECT * FROM Module

Here is my query:

$query = "
SELECT * FROM module_info
";

$result = $DBH->prepare($query);
$result->execute();
$data = $result->fetchAll();

The view I created:

CREATE VIEW module_info 
AS
SELECT ModuleID, ModuleName, Credits, Lecturer, Room, EmployeeID, Forename, Surname, RoomID, RoomCode
FROM ((Module 
INNER JOIN Employee ON Module.Lecturer = Employee.EmployeeID) 
INNER JOIN Room ON Module.Room = Room.RoomID);

Using a MySQL db, using workbench to create SQL scripts @RadimBača — Xander, Nov 28 '17 at 19:53
@RadimBača Running SELECT * FROM module_info; in workbench results in the correct output with no errors — Xander, Nov 28 '17 at 19:55
The following link is old, but have you looked into increasing the `table_definitition_cache`? https://stackoverflow.com/questions/4380813/how-to-get-rid-of-mysql-error-prepared-statement-needs-to-be-re-prepared — zambonee, Nov 28 '17 at 20:02
@Xander I don't say there's an issue with it, just not necessary. — Eric, Nov 30 '17 at 19:18

score 3 · Accepted Answer · answered Nov 30 '17 at 16:59

The solution in this instance was as follows:

Emulation of prepared statements needs to be enabled.

In the connection file, the following line

PDO::ATTR_EMULATE_PREPARES   => false,

needs to be changed like so:

PDO::ATTR_EMULATE_PREPARES   => true,

In other instances it appears the solution may be to increase the table_definitition_cache

How to SELECT from a view in SQL? (General error: 1615 Prepared statement needs to be re-prepared)

1 Answers1

Emulation of prepared statements needs to be enabled.