How to debug when CakePHP Model::save() doesn't attempt an INSERT

Question

I am having a bear of a time saving the simplest record from a model called ItemView:

if($this->save($this->data)) {
  echo 'worked';
} else {
  echo 'failed';
}

Where $this->data is:

Array
(
    [ItemView] => Array
        (
            [list_id] => 1
            [user_id] => 1
        )
)

And my table is:

CREATE TABLE IF NOT EXISTS `item_views` (
  `id` int(11) NOT NULL auto_increment,
  `list_id` int(11) NOT NULL,
  `user_id` int(11) default NULL,
  `user_ip` int(10) unsigned default NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED AUTO_INCREMENT=1 ;

Looking at the query dump in debug mode, Cake isn't even attempting an INSERT, so I have no idea how to debug.

Any help would be appreciated.

By the way you should be using InnoDB as your database engine also. — k4t434sis, Mar 17 '11 at 20:23
this will be helpful and save time http://teknoid.wordpress.com/2008/06/09/15-essential-cakephp-tips/ — RSK, Jun 17 '10 at 09:39

score 25 · Accepted Answer · edited Apr 29 '11 at 05:04

25

Wow, two miserable hours of my life wasted.

Remember that your beforeSave() must return true!

edited Apr 29 '11 at 05:04

mauris

42,982
15
99
131

answered Feb 19 '09 at 18:32

ryonlife

6,563
14
51
64

Great! Thanks for saving me those 2 hours! :) – Seb Jul 08 '09 at 23:31
I spent 8 hours duplicating this and finding the same thing. Wish I had searched SO earlier! – atp Jan 20 '10 at 03:07
ahhh, thanks for saving my life. this problem costs me 2 hours – Ish Apr 05 '10 at 06:13

Jan Moritz · Answer 2 · 2014-08-05T17:16:06.690

24

To debug Model->save() check the validation errors and the last sql query

$this->Model->save($data);

debug($this->Model->validationErrors); //show validationErrors

debug($this->Model->getDataSource()->getLog(false, false)); //show last sql query

edited Aug 05 '14 at 17:16

answered Dec 10 '13 at 18:48

Jan Moritz

2,145
4
23
33

score 10 · Answer 3 · edited Mar 07 '16 at 12:34

10

In cakephp 3.x, you can debug during insert/update

if ($this->TableName->save($entity)) {
      // success 
} else {
// if not save, will show errors 
  debug($entity->errors());

}

edited Mar 07 '16 at 12:34

Nikolay Kostov

16,433
23
85
123

answered Mar 07 '16 at 12:13

Saidul Haque

606
7
11

1

The newer version seem to use: $entity->getErrors() – TechFanDan Aug 10 '21 at 12:54

rodrigo-silveira · Answer 4 · 2016-05-28T12:33:04.423

8

What always gets me is that if I modify the actual table (usually by adding attributes to it), then you must flush your cache. Usually just deleting everything inside the following two folders does the trick for me:

tmp > cache > models 
tmp > cache > persistent

edited May 28 '16 at 12:33

answered Apr 17 '12 at 20:31

rodrigo-silveira

12,607
11
69
123

3

This was super helpful!! after 2 hours of derping around I win... Cheers!! – Brenton Pierce May 27 '16 at 23:41

score 1 · Answer 5 · edited May 30 '13 at 19:00

What is the name of controller you are using?

Mismatching the name of controller and model also cause some errors. If you are using Posts controller then the Post model should be used. If you are using Post model inside other controller; say BlogsController then the Post model should be loaded like following:

    <?php
    class BlogsController extends AppController
    {
        public function index()
        {
            $this->loadModel("Post");    
            //Here I'm loading other model inside blogs controller
            if($this->request->is('post'))
            {
                $this->Post->save($this->request->data);
            }
        }
    }
    ?>

score 1 · Answer 6 · edited Feb 24 '16 at 17:34

1

It may be, Validations returns false.. You can check like

$this->Model->save($this->data, false);

Put false and check whether now data inserts, if it is then it is validation error

edited Feb 24 '16 at 17:34

samayo

16,163
12
91
106

answered Jun 24 '13 at 16:54

Hitesh Chopra

45
5

1

What? How about just checking Model->validationErrors instead on fail? – mark Jun 24 '13 at 17:16

score 1 · Answer 7 · answered Sep 27 '13 at 07:58

1

may be something like this

$this->Model->set($this->data);

$errors = $this->Model->validate();// or perhaps validationError(), please confirm

if(!$errors) {
   $this->Model->save();
}else{
   //show errors
   pr($errors);

}

answered Sep 27 '13 at 07:58

Sumit Kumar

1,855
19
19

score 1 · Answer 8 · answered Aug 15 '15 at 18:40

1

Same problem here. I wasted 2 hours of my life.

Solution: I forget to this:

array('post', 'put')

answered Aug 15 '15 at 18:40

user1999

87
1
10

How to debug when CakePHP Model::save() doesn't attempt an INSERT

8 Answers8

Linked