# RadSystems 8.2.3 sqlstate\[hy000\]: general error: 1615 using View

**URL:** <https://forum.radsystems.io/t/radsystems-8-2-3-sqlstate-hy000-general-error-1615-using-view/1769>\
**Category:** PHPRad Vue\
**Created:** [October 7, 2023, 7:54pm UTC](https://forum.radsystems.io/t/radsystems-8-2-3-sqlstate-hy000-general-error-1615-using-view/1769 "2023-10-07T19:54:57Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![usmraf786](https://forum.radsystems.io/user_avatar/forum.radsystems.io/usmraf786/32/1018_2.png) [@usmraf786](https://forum.radsystems.io/u/usmraf786)\
**Post date:** [October 7, 2023, 7:54pm UTC](https://forum.radsystems.io/t/radsystems-8-2-3-sqlstate-hy000-general-error-1615-using-view/1769/1 "2023-10-07T19:54:57Z")

</div>

If you are using views in RadSystems and facing below error:  
sqlstate[hy000]: general error: 1615 prepared statement needs to be re-prepared (sql: select count(\*) as aggregate

 ![image](https://forum.radsystems.io/uploads/default/original/2X/0/09f1bbed7db4f545e394cee51164fd0edb2153c2.png)

Add below code in php-laravel-api\config\Database.php file  
‘options’ =\> [  
\PDO::ATTR\_EMULATE\_PREPARES =\> true  
],

Note: View will give error always after Publish Project with Sync Database.  
To solve it:  
Restart MySQL  
And then Publish Project again, View pages will work.
