Gesior AAC installation problem

[Sammol]

When i get to step five this pops up

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'rlname' in 'field list'' in C:\xampp\htdocs\pot\OTS_Account.php:237 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Account.php(237): PDO->query('SELECT `id`, `n...') #1 C:\xampp\htdocs\install.php(572): OTS_Account->load(1) #2 {main} thrown in C:\xampp\htdocs\pot\OTS_Account.php on line 237

I use Gesior 0.3.8

Xammp 1.6.6a

and forgotten server 8.6

Help please !

 

[8408323]

Add this to your phpmyadmin.

ALTER TABLE `accounts` ADD `rlname` VARCHAR( 255 ) NOT NULL DEFAULT '';

 

[Sammol]

Add this to your phpmyadmin.

ALTER TABLE `accounts` ADD `rlname` VARCHAR( 255 ) NOT NULL DEFAULT '';

Didnt work :/, same error

 

[8408323]

I would suggest you to start all over, and try another version of gesior, but youcould always try to add tis first

CREATE TABLE IF NOT EXISTS `accounts` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(32) NOT NULL DEFAULT '',
  `password` VARCHAR(255) NOT NULL,
  `premdays` INT(11) NOT NULL DEFAULT '0',
  `lastday` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `email` VARCHAR(255) NOT NULL DEFAULT '[email protected]',
  `key` VARCHAR(20) NOT NULL DEFAULT '0',
  `blocked` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'internal usage',
  `warnings` INT(11) NOT NULL DEFAULT '0',
  `group_id` INT(11) NOT NULL DEFAULT '1',
  `page_lastday` INT(11) NOT NULL DEFAULT '0',
  `email_new` VARCHAR(255) NOT NULL DEFAULT 'test',
  `email_new_time` INT(15) DEFAULT NULL,
  `created` INT(11) NOT NULL DEFAULT '0',
  `rlname` VARCHAR(255) NOT NULL DEFAULT '',
  `location` VARCHAR(255) NOT NULL DEFAULT '',
  `page_access` INT(11) NOT NULL DEFAULT '0',
  `email_code` VARCHAR(255) NOT NULL DEFAULT '0',
  `next_email` INT(11) NOT NULL DEFAULT '0',
  `premium_points` INT(11) NOT NULL DEFAULT '0',
  `vote` INT(11) DEFAULT NULL,
  `last_post` INT(11) DEFAULT NULL,
  `flag` VARCHAR(255) DEFAULT NULL,
  `vip_time` BIGINT(20) DEFAULT NULL,
  `referral` INT(10) DEFAULT NULL,
  `referral2` INT(10) DEFAULT NULL,
  `vip_time2` BIGINT(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8814087 ;

but in most cases is just messes up the database when you try to put in queries that should be there from the beginning. But t is worth a try.

 

[Sammol]

I would suggest you to start all over, and try another version of gesior, but youcould always try to add tis first

CREATE TABLE IF NOT EXISTS `accounts` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(32) NOT NULL DEFAULT '',
  `password` VARCHAR(255) NOT NULL,
  `premdays` INT(11) NOT NULL DEFAULT '0',
  `lastday` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `email` VARCHAR(255) NOT NULL DEFAULT '[email protected]',
  `key` VARCHAR(20) NOT NULL DEFAULT '0',
  `blocked` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'internal usage',
  `warnings` INT(11) NOT NULL DEFAULT '0',
  `group_id` INT(11) NOT NULL DEFAULT '1',
  `page_lastday` INT(11) NOT NULL DEFAULT '0',
  `email_new` VARCHAR(255) NOT NULL DEFAULT 'test',
  `email_new_time` INT(15) DEFAULT NULL,
  `created` INT(11) NOT NULL DEFAULT '0',
  `rlname` VARCHAR(255) NOT NULL DEFAULT '',
  `location` VARCHAR(255) NOT NULL DEFAULT '',
  `page_access` INT(11) NOT NULL DEFAULT '0',
  `email_code` VARCHAR(255) NOT NULL DEFAULT '0',
  `next_email` INT(11) NOT NULL DEFAULT '0',
  `premium_points` INT(11) NOT NULL DEFAULT '0',
  `vote` INT(11) DEFAULT NULL,
  `last_post` INT(11) DEFAULT NULL,
  `flag` VARCHAR(255) DEFAULT NULL,
  `vip_time` BIGINT(20) DEFAULT NULL,
  `referral` INT(10) DEFAULT NULL,
  `referral2` INT(10) DEFAULT NULL,
  `vip_time2` BIGINT(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8814087 ;

but in most cases is just messes up the database when you try to put in queries that should be there from the beginning. But t is worth a try.

Yeah didnt work, well i'll follow your advice, thanks for the help and i'll give you a rep+ for your effort

 

[8408323]

I don't really know the reason to the problem, but it must be compatible with different softwares, i have experienced the same thing earlier, but with other errors. Post here if another version doesn't work, and I'll give my best shot to help you solve the problem.