https://www.icyphoenix.com/viewtopic.php?f=35&t=9016&p=58804#p58804
-----------------------------------
Joshua203
Sat 27 Apr, 2013 20:26

Re: Problem Update To 2.0 Version
-----------------------------------
[quote user="ThE KuKa" post="56058"]Show error "session_last_visit" no exist.

phpMyAdmin and SQL tab (into Icy DB)

[code]DROP TABLE `phpbb_sessions`;

CREATE TABLE `phpbb_sessions` (
	`session_id` VARCHAR(32) NOT NULL DEFAULT '',
	`session_user_id` MEDIUMINT(8) NOT NULL DEFAULT '0',
	`session_start` INT(11) NOT NULL DEFAULT '0',
	`session_time` INT(11) NOT NULL DEFAULT '0',
	`session_ip` VARCHAR(40) NOT NULL DEFAULT '0',
	`session_browser` VARCHAR(255) DEFAULT '' NOT NULL,
	`session_page` VARCHAR(255) NOT NULL DEFAULT '',
	`session_logged_in` TINYINT(1) NOT NULL DEFAULT '0',
	`session_forum_id` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL,
	`session_topic_id` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL,
	`session_last_visit` INT(11) UNSIGNED DEFAULT '0' NOT NULL,
	`session_forwarded_for` VARCHAR(255) DEFAULT '' NOT NULL,
	`session_viewonline` TINYINT(1) UNSIGNED DEFAULT '1' NOT NULL,
	`session_autologin` TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL,
	`session_admin` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
	PRIMARY KEY (`session_id`),
	KEY `session_user_id` (`session_user_id`),
	KEY `session_fid` (`session_forum_id`)
);

DROP TABLE `phpbb_sessions_keys`;

CREATE TABLE `phpbb_sessions_keys` (
	`key_id` VARCHAR(32) NOT NULL DEFAULT '0',
	`user_id` MEDIUMINT(8) NOT NULL DEFAULT '0',
	`last_ip` VARCHAR(40) NOT NULL DEFAULT '',
	`last_login` INT(11) NOT NULL DEFAULT '0',
	PRIMARY KEY (`key_id`,`user_id`),
	KEY `last_login` (`last_login`)
);

## `phpbb_sessions_keys`[/code]
And working... :roll:[/quote]


