Search the Community
Showing results for tags 'database script'.
-
I am really enjoying your books. They focus on may concerns for todays systems. Especially security. Thanks for taking the time to write them. I finished PHP and MySQL for dynamic web sites. I found great information throughout that title. I have now started this book (effortless eCommerce 2nd ed.), which is very intriguing. I started the book, and ran into a strange issue. The very first SQL script failed on 'users' table. The exception I received; 16:24:57 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 Error Code: 1293. Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause 0.000 sec I figured I did something wrong, so I tried again this time using the downloaded script, and exact same error occurred. In addition, the errata seems to be missing from the website, if there is an errata? I searched the forum to find that not one person has seen this issue. I am wondering if my MySQL is malfunctioning... I can not determine where the problem lies. Any help wold be much appreciated. Please advise... Thank you for your time, -Mike-