Sprinklino

Archive for the ‘Uncategorized’ Category

really want to get my workshop…

really want to get my workshop back up and running

today we press the grapes

today we press the grapes

the beard is dead

the beard is dead

Nitrogen Monitoring

Wondering how hard it would be to add nitrogen monitoring. You can apparently determine nitrogen content by checking how green the leaves are so I’m thinking I can hook up a color sensor, shine a light on the leaves at night (to eliminate ambient light changes) and track how green it is over time. If I start to see yellowing then it’s time to fertilize (or at least monitor things more closely)

waiting for veraison…

waiting for veraison…

Big delay

So work on this kinda ground to a halt what with moving house and assorted stuff but finding myself with 50 pinot noir vines I’m going to get started again so stay tuned :)

wp-forum fixed!

So just got the wp-forum plugin fixed, lots of problems with the db.

For starters it doesn’t create the tables you need, so I found the sql script (that cunningly has a .txt suffic) forum_db.txt and ran that directly against my db.

That didn’t work either because I was using a different prefix for my wp tables so I had to change all the wp_forum* table names to myprefix_forum* instead.

The other problem was that the code was referencing a bunch of columns that weren’t created either. I’ve included the actual script you need to run here at which point it all works as expected.

Enjoy!


-- --------------------------------------------------------

--
-- Table structure for table `wp_forum_threads`
--

DROP TABLE IF EXISTS `wp_forum_threads`;
CREATE TABLE IF NOT EXISTS `wp_forum_threads` (
`id` int(11) NOT NULL auto_increment,
`forum_id` int(11) NOT NULL default '0',
`views` int(11) NOT NULL default '0',
`subject` varchar(255) NOT NULL default '',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`last_post` date NOT NULL default '0000-00-00',
`status` varchar(50) NOT NULL default '',
`starter` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `wp_forum_posts`;
CREATE TABLE IF NOT EXISTS `wp_forum_posts` (
`id` int(11) NOT NULL auto_increment,
`author_name` varchar(255) default NULL,
`author_email` varchar(255) default NULL,
`author_web` varchar(255) default NULL,
`text` longtext,
`thread_id` int(11) NOT NULL default '0',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`author_id` int(11) NOT NULL default '0',
`subject` varchar(255) NOT NULL default '',
`views` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `wp_forum_forums`;
CREATE TABLE IF NOT EXISTS `wp_forum_forums` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`parent_id` int(11) NOT NULL default '0',
`description` varchar(255) NOT NULL default '',
`views` int(11) NOT NULL default '0',
`sort` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `wp_forum_groups`;
CREATE TABLE IF NOT EXISTS `wp_forum_groups` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`sort` int(11) default NULL,
`passwd` varchar(20) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

#sprinklino test tweet

#sprinklino test tweet

Sprinklino Blog

This is the spot where I’ll blog my progress building the Sprinklino, with a bit of luck it should all go together quite nicely :)

To find out more about the project click here or the About link at the top of the page.

You are currently browsing the archives for the Uncategorized category.