Need Help Rep - +1

[Rainerr]

when i create account to my Server and then i cant login i get an error like this

Help me out and get Rep +

 

[TGYoshi]

Run the mysql sql query that came with your server, do not run any other random sql file since they are usually not compatible with the server itself, like in your case.

 

[a7aa7a]

Hey
Copy That In Sql

ALTER TABLE `accounts` ADD
`vipdays` int(11) NOT NULL DEFAULT 0;

Then Tell Me =)

 

[Korrex]

Hey
Copy That In Sql


Then Tell Me =)

The fuck? The error didn't even state anything about vipdays? xDDD

DROP TABLE IF EXISTS `accounts`

CREATE TABLE `accounts`
(
	`id` INT NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(32) NOT NULL DEFAULT '',
	`password` VARCHAR(255) NOT NULL/* VARCHAR(32) NOT NULL COMMENT 'MD5'*//* VARCHAR(40) NOT NULL COMMENT 'SHA1'*/,
	`premdays` INT NOT NULL DEFAULT 0,
	`lastday` INT UNSIGNED NOT NULL DEFAULT 0,
	`email` VARCHAR(255) NOT NULL DEFAULT '',
	`key` VARCHAR(20) NOT NULL DEFAULT '0',
	`blocked` TINYINT(1) NOT NULL DEFAULT FALSE COMMENT 'internal usage',
	`warnings` INT NOT NULL DEFAULT 0,
	`group_id` INT NOT NULL DEFAULT 1,
	PRIMARY KEY (`id`), UNIQUE (`name`)
) ENGINE = InnoDB;

INSERT INTO `accounts` VALUES (1, '1', '1', 65535, 0, '', '0', 0, 0, 1);

If this doesn't work then look for all "onLogin" scripts in your creaturescripts folder and paste them here.

 

[Rainerr]

Im done with that now. Got it working But thanks for Helping.

 

[Korrex]

Im done with that now. Got it working But thanks for Helping.

Why won't OP deliver?

 

[TGYoshi]

Why won't OP deliver?

Happens when you make it too easy for them.

 

[Korrex]

Happens when you make it too easy for them.

This guy is shitlisted. Not going to help him.