-3

While execution of an php script, i get an error description as,

Mysqli statement execute error : Prepared statement needs to be re-prepared.....

The function which performs the mysql execution ( insert / update statement) is an zend function _saveRow. Also it was observed that the data was been actually inserted in database and the function is still returning an execution error.

Any help will be appreciated.

Abhijit
  • 1
  • 2
  • *Any help will be appreciated.* I doubt you will get any help without the code that courses the error, your question attract downvotes – Masivuye Cokile Mar 28 '17 at 11:12
  • This is a duplicate, and [not the only one](https://stackoverflow.com/search?q=%22prepared+statement+needs+to+be+re-prepared%22). – reinierpost Jun 07 '17 at 09:06

1 Answers1

1

Issue: 'Prepared statement needs to be re-prepared'

This issue generally occurs at the time of calling procedure either by using any Computer Language(like Java) or Calling Procedures from the backend.

Solution: Increase the size of the cache by using (executing) below script.

Script: set global table_definition_cache = 4000;

iono
  • 2,575
  • 1
  • 28
  • 36
Sanjay Kushwaha
  • 11
  • 1