matthuisman

Hi O'brien5. Maybe some example data may help? eg: HS_results EXAMPLE ROWS Exams_Board_results EXAMPLE ROWS

I had a few issues with the .htaccess as well. I ended up using the below which works for me. Options +FollowSymLinks IndexIgnore */* <ifModule mod_rewrite.c> # Turn on the engine: RewriteEngine on # Don't perform redirects for files and directories that exist: RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d # For everything else, redirect to index.php: RewriteRule ^.*$ /index.php [L] </ifModule>

Also, same fix for Comments.php model ' array('user_id', 'exist', 'attributeName'=>'id', 'className'=>'User'), array('page_id', 'exist', 'attributeName'=>'id', 'className'=>'Page'), '

Update: 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? Thanks, Matt

Hi, 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. Thanks, Matt