Not signed in (Sign In)

Vanilla 1.1.5a is a product of Lussumo. More Information: Documentation, Community Support.

Please sign in or apply for membership to remove the ads

General Support: Can't create Collection

Bottom of Page

1 to 4 of 4

  1.  
    • CommentAuthorBrashquido
    • CommentTimeFeb 10th 2006
     
    Hi All,

    Trying to install Plogger on a Windows 2003 Server using IIS 6, PHP 4.3.11 and MySQL 5.0.18. Everything goes smootly for the install, but when I try and creat a category I get the following error;

    Field 'thumbnail_id' doesn't have a default value

    INSERT INTO plogger_collections (`name`,`description`,`id`,`path`) VALUES ('tes', '', '', 'tes')

    All the directories under the Plogger installation are writable by the web server, and the MySQL user has full permissions to the database I've installed it in. Any ideas?
    • CommentAuthorddejong
    • CommentTimeFeb 10th 2006
     
    Try changing 'thumbnail_id' to auto-increment; that way, if Plogger doesn't give MySQL a value, it will just take the last value and add 1. No guarantee it'll work, but it's a good start.

    Cheers,
    Derek
    • CommentAuthorBrashquido
    • CommentTimeFeb 10th 2006
     
    The above error seems like it was cased by MySQL 5. If you configure your MySQL instance so that 'Enable Strict Mode' is disabled (shown in TCP/IP setting page) then this is no longer an issue. From what I could gather it has something to do with MySQL not liking it when you try to insert null values.
    • CommentAuthorBrashquido
    • CommentTimeFeb 10th 2006
     
    Thanks for the suggestion Derek :)

1 to 4 of 4

  1.