Jump to content
Larry Ullman's Book Forums

Strange Problem - Exist Fails - Only If Table Empty

Recommended Posts



Having a strange issue working through the Yii book CMS example.


So. I will empty all tables then login as admin.

I can then add a new user fine. user_id = 1.


If I then try to add a page/comment/file, and input a user_id of 1, it returns "User "1" is invalid."

The 'exist' validation is failing even though there is a user with user_id of 1.


Strangely, this only happens if there are no rows in the 'page' table.

If i manually add a row to the 'page' table then I can add pages from then on not a problem.

But, if I go and delete the pages and then try add a page - error comes back.


So, the fault only happens if the table is empty.


Any help would be apperciated.





Link to post
Share on other sites


Fixed the issue by using:

array('user_id', 'exist', 'attributeName'=>'id', 'className'=>'User'),


Did a bit of debugging, the SQL yii was using before using the above was

"SELECT 1 FROM `page` `t` WHERE `t`.`user_id`=:ycp0 LIMIT 1"


Now, with the above it uses

"SELECT 1 FROM `user` `t` WHERE `t`.`id`=:ycp0 LIMIT 1"


So, think this may be a mistake in the book?





Link to post
Share on other sites
  • 3 months later...

I didn't have this problem while I was writing that section, but I'll check into it. An issue is that the CMS example is used for various demonstration purposes, so it's not a complete thing (until I do that in Part 4 of the book), which can lead to problems depending upon what you have or have not implemented.

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...