Unable to Insert miniLogin per Tutorial

[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=

[Stormheart]

WEll here is the full post that should have posted


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=’Minilogin’ where varname=’LoginType’;

It always fails with a

Unknown column '’LoginType’' in 'where clause'

I searched the forums and found one matching thread but the response really didn't give me a clue. I said something like make a table called logintype and insert it into the database which made no sense to me cuzz im a newb with databases

I was able to create my peq database by sourcing load_system.sql and load_empty_players.sql just fine so I see a bunch of items in my PEQ database when I use my MYSQL BROWSER to select it. I am resisting switching to AX_CLASSIC database to try and overcome it. There was an interesting disclaimer in the tutorial saying if this errors out make sure you are using the CVS download of the PEQ_DB but I Cavedude kinda posted to use the sourceforge.net download

The peq db I am using is the final yekesha from sourceforge

Thanks for any help

[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