Whoops, looks like something went wrong.

Hi,
I’m damned this morning,
my invoiceninja won’t work , im doing nothing particular on it, normal use but this morning
“Whoops, looks like something went wrong.”

I have trying to make a fresh install to a different directory with a new database :
but after setup is finish by same message: Whoops…
Strange ?
I’m sorry but i don’t understand where is the problem !!!

Please help.

thanks,

my error log below:

------laravel-error.log------
[2017-10-11 10:08:48] production.ERROR: Illuminate\Database\QueryException [HY000] : /home/xxxxx/ninja/vendor/laravel/framework/src/Illuminate/Database/Connection.php [Line 729] => SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared (SQL: insert into companies (utm_source, utm_medium, utm_campaign, utm_term, utm_content, referral_code, updated_at, created_at) values (, , , , , , 2017-10-11 10:08:48, 2017-10-11 10:08:48)) {“context”:“PHP”,“user_id”:0,“account_id”:0,“user_name”:"",“method”:“POST”,“url”:“https://xxxxxx/setup",“previous”:“https://xxxxx/setup”,“user_agent”:"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/604.1.38 (KHTML, like Gecko) Version/11.0 Safari/604.1.38”,“ip”:“xxxxxxxxxxxx”,“count”:1,“is_console”:“no”,“is_api”:“no”,“db_server”:“mysql”} []

Maybe this will help…

https://laracasts.com/discuss/channels/general-discussion/mysql-general-error-1615-prepared-statement-needs-to-be-re-prepared?page=1

Thanks Hillel,

The site is back, but i don’t understand how !
The provider admin does not know how.

Strange…

to follow

Best regards

Hi,

Argh Problem is back this morning !
Support ticket has sent to my Provider.

Debug mode on :

https://pastebin.com/1VtyNAzQ

Thanks for any help

Best regards.

OK!

my provider have modified some cache variables in the my.cnf file that seems to work.

THANKS !!!

Hi,

again this morning ninja is down.

1/2
PDOException in Connection.php line 335:
SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared

2/2
QueryException in Connection.php line 729:
SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared (SQL: select count(*) as aggregate from accounts where accounts.deleted_at is null)

It is recurring every morning.

the provider is wondering what process can cause this phenomenon.
an opinion?

investigation on the server …

to follow

Thanks

Hello everyone,
I just found a solution here:

https://laracasts.com/discuss/channels/laravel/general-error-1615-prepared-statement-needs-to-be-re-prepared-selecting-mysql-view/replies/119726

Indeed I applied this instruction to the lign 61 of config / database.php

and all is well thought out.

Wait and see …

Cordially.