Unable to Insert miniLogin per Tutorial

[leslamarch]

Originally Posted by Stormheart

Ok I am using peq_db dowloaded from sourceforge.net

When I use my Mysql browser and (per tutorial guide instuctions) go and select my peq database so that its bold "PEQ"

then I paste the line to the right of the execute button

UPDATE variables set value=

First of all do you have the variables table in you database?
If not you need to add it. by executing this query

CREATE TABLE `variables` (
  `varname` varchar(25) NOT NULL default '',
  `value` text NOT NULL,
  `information` text NOT NULL,
  `ts` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`varname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

and if you do have that table already then you just need to add this to your database

INSERT INTO `variables` VALUES ('LoginType', 'minilogin', 'What type of login you wanbr', '2008-02-05 17:07:49');

hope that helps