Search the Community

When I tried to run the downloaded SQL commands in phpMyAdmin, various error messages appeared, stating that no author table exists. So I searched for all occurrences of the word "author" and replaced them with "user", except for this line: `type` enum('public','author','admin') NOT NULL, Is this correct? The file I downloaded is: yiibook2_cms.sql.zip Thanks.

I am going through chapter 9, "CMS with OOP", and I have encountered an error when I finally visited the site (after building a few files first). I reviewed my syntax thoroughly, then downloaded the files from this site just to see if my code was wrong, but the home page (index.php) still displays the following error: SQLSTATE[28000] [1045] Access denied for user 'username'@'localhost' (using password: YES)[/size] The "pages" table in the "cms" database does indeed have rows inside it, I am using the correct username and password for my database (checked in the mysql command line), and I ran a php_info( ) to verify that PDO is enabled. Can anyone offer a suggestion as to the issue? I reviewed the forums but saw no question pertaining to this; if this is a duplicate, I apologize. EDIT: My search engine of choice is telling me it's some sort of permissions issue, but I haven't found any fixes. Still looking. Now that that's the issue, I'm not sure if this question is still within the scope that the community can answer it since this is a PHP and not a MySQL book. If so, help would be much appreciated!

I may be missing the obvious but is there someplace that describes how to install and run the code provided in the example files? 1. I have installed Yii 2. I have created the database and populated it using the sql code provided. 3. I have moved the CMS files over to the protected directories. 4. I have confirmed that main.php has database data for the cms application So I am thinking everything should be good, except i need a username (email) and password to login. Lost, please help, David

After having almost finished learning the "Quickstart" version of the book, I recently bought the "Quickpro". I just had a look at the index, and I'm a little bit surprised not to find any mention of CMS as a widespread application of php/mySQL. Can you recommend a book dealing with this topic? Something like "Understand WordPress php/mySQL background"