New MiniLogin Release!

Angelox · #1 03-23-2009, 07:46 PM

I got a problem here, sort of know what it is, but not sure what to do.
You all using MySql 5.1x? I have MySql 5.0x
here's my problem;
After the variables table is made, I get this error;

Code:

ERROR 1231 (42000): Variable 'character_set_client' can't be set to the value of 'NULL'

When attempting to run this line;

Code:

SET character_set_client = @saved_cs_client;

I'm thinking it's the version, or maybe it's because I have the old password method active?

devn00b · #2 03-23-2009, 07:52 PM

yeah stupid sql i think you can just remove that line from the sql file and it should load normally

Angelox · #3 03-23-2009, 08:01 PM

Thanks! I had an urge to do that but I wasn't sure, been researching that error for about an hour now (I found a lot of brick walls). I'll give it a run.

image · #4 03-23-2009, 08:41 PM

Yea you can ignore those, thats new MySQL stuff, don't ask me what for. You just need the default tables anyway.

Aergad · #5 03-26-2009, 02:15 AM

Just a side note you have to put the minilogin server into a seperate directory from your main eqemu server with all the files included in the zip file for it to work

warhawk · #6 03-26-2009, 04:08 PM

I'm having trouble sourcing the SQL. This bit seems to cause a 1064 error:-

Code:

DROP TABLE IF EXISTS `variables`;
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;

Any Ideas?

image · #7 03-26-2009, 04:26 PM

DROP TABLE IF EXISTS `variables`;
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;

Remove " DEFAULT"