Clearing tmp / cache cakephp solves the problem for only one save call. What is the reason?

Question

I changed the mysql database schema (added a new table, etc.), I cleared tmp / cache (except directories). Now, saving to a new table occurs only once (I have several save calls in a for loop and saving happens for all of them) and a crash the next time I enter the stream.

I am using cakephp 1.3.

What else should I check?

Answer 1

Got it.

The cache issue was one of the problems that was fixed by cleaning the files in the tmp / cache directory.

Training - If you make changes to the mysql schema (add a new table / column, etc.) In mysql, empty the tmp / cache directory or set the debug level to 3 and refresh the page and set the debug level back to 0 (if in production).

I also received a save error - mysql server left because wait_timeout was 600 seconds in configs. But my script took longer. Therefore model-> save () did not work.

In my.cnf, I updated the timeout to 4800 and restarted mysql and it fixed the problem.