Not signed in (Sign In)

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

    • CommentAuthorkanjigirl
    • CommentTimeMar 10th 2006 edited
     
    Please help. I've read the threads on the

    Could not run query SELECT * FROM plogger_config WHERE 1.Table 'waterline.plogger_config' doesn't exist

    error, which is what I was getting after the Admin screen. Only two tables are written on install and they have 0 data - albums and collections.

    When I delete plog_config.php and drop these two empty tables from my database, I rerun _install.php and now I get this error:

    Invalid default value for 'compression'

    CREATE TABLE `plogger_config` ( `max_thumbnail_size` int(11) NOT NULL default '0', `max_display_size` int(11) NOT NULL default '0', `thumb_num` int(11) NOT NULL default '0', `admin_username` varchar(64) NOT NULL default '', `admin_password` varchar(64) NOT NULL default '', `admin_email` varchar(50) NOT NULL default '', `date_format` varchar(64) NOT NULL default '', `compression` int(11) NOT NULL default '', `default_sortby` varchar(20) NOT NULL default '', `default_sortdir` varchar(5) NOT NULL default '', `gallery_name` varchar(255) NOT NULL default '', `allow_dl` smallint(1) NOT NULL default '0', `allow_comments` smallint(1) NOT NULL default '1', `allow_print` smallint(1) NOT NULL default '1', `truncate` int(11) NOT NULL default '12', `square_thumbs` tinyint default 1, `feed_num_entries` int(15) NOT NULL default '15', `rss_thumbsize` int(11) NOT NULL default '400', `feed_title` text NOT NULL, `use_mod_rewrite` tinyint NOT NULL default '0', `comments_notify` tinyint NOT NULL default '1', `feed_language` varchar(255) NOT NULL default 'en-us' ) Type=MyISAM DEFAULT CHARACTER SET UTF8

    I've done this 5 times now. Please help. I'm not that great with PHP but I can modify the code if someone tells me how.

    Debbie
    •  
      CommentAuthormike
    • CommentTimeMar 10th 2006
     
    Try changing the default value for compression. You are probably using MySQL 5 which doesn't seem to like empty strings as default values.


    `compression` int(11) NOT NULL default ''


    Try changing that to


    `compression` int(11) NOT NULL default '75'