Search the Community
Showing results for tags '2nd edition'.
-
I successfully downloaded the code for the 2nd edition of this book. But when I tried to import the .sql into MAMP I got the following error: SQL query: CREATE TABLE `users` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT , `type` ENUM( 'member', 'admin' ) NOT NULL DEFAULT 'member', `username` VARCHAR( 45 ) NOT NULL , `email` VARCHAR( 80 ) NOT NULL , `pass` VARCHAR( 255 ) NOT NULL , `first_name` VARCHAR( 45 ) NOT NULL , `last_name` VARCHAR( 45 ) NOT NULL , `date_created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , `date_expires` DATE NOT NULL , `date_modified` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP , PRIMARY KEY ( `id` ) , UNIQUE INDEX `username_UNIQUE` ( `username` ASC ) , UNIQUE INDEX `email_UNIQUE` ( `email` ASC ) , INDEX `login` ( `email` ASC , `pass` ASC ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8; MySQL said: #1293 - Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause The 3 tables that came before this error; categories, pages, pdfs were created correctly. I'm not sure how to fix this.
-
How is PHP and MySQL for Dynamic Web Sites 5th Edition different than earlier editions? I have the 2nd Edition, so I'm wondering if I should buy the most current: 5th edition. I ask these considerations because of how much the internet may have changed in the time between editions.
- 1 reply
-
- 5th edition
- 4th edition
-
(and 2 more)
Tagged with:
-
Larry, Do you have any more chapters of the Yii Book? I mean the second edition, revised for Yii 2. I've read -- and mostly understood -- up to page 190, which is the last revised page. If you have more revised chapters, I'd be interested in reading them. No doubt, other readers would too. Can you post any additional chapters on your website and let everyone know? Thanks.