Database Error Geisor AAC

[renots10]

fixed. close please

 

[Cronox]

try added table news in phpmyadmin
goto phpmyadmin - SQL and use this query:

CREATE TABLE IF NOT EXISTS `news` (
  `hide_news` tinyint(1) NOT NULL DEFAULT '0',
  `date` int(11) NOT NULL DEFAULT '0',
  `author` varchar(255) NOT NULL,
  `author_id` int(11) NOT NULL,
  `image_id` int(3) NOT NULL DEFAULT '0',
  `topic` varchar(255) NOT NULL,
  `text` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

[renots10]

I still Get the same Error.. =\

 

[Cronox]

hmm try this query

INSERT INTO `news` (`hide_news`, `date`, `author`, `author_id`, `image_id`, `topic`, `text`) VALUES
(0, 1343408794, 'tester', 6120912, 4, 'Test New', 'test news');

 

[renots10]

hmm try this query

INSERT INTO `news` (`hide_news`, `date`, `author`, `author_id`, `image_id`, `topic`, `text`) VALUES
(0, 1343408794, 'tester', 6120912, 4, 'Test New', 'test news');

#1054 - Unknown column 'hide_news' in 'field list'

 

[Cronox]

try use all querys

delete from news;

ALTER TABLE `accounts` ADD `page_access` int(11);
ALTER TABLE `accounts` ADD `page_lastday` int(11);
ALTER TABLE `accounts` ADD `email_new` varchar(255);
ALTER TABLE `accounts` ADD `email_new_time` int(15);
ALTER TABLE `accounts` ADD `rlname` varchar(255);
ALTER TABLE `accounts` ADD `location` varchar(255);
ALTER TABLE `accounts` ADD `created` int(16);
ALTER TABLE `accounts` ADD `email_code` varchar(255);
ALTER TABLE `accounts` ADD `next_email` int(11);
ALTER TABLE `accounts` ADD `premium_points` int(11);
ALTER TABLE `players` ADD `old_name` varchar(255);
ALTER TABLE `players` ADD `hide_char` int(11);
ALTER TABLE `players` ADD `worldtransfer` int(11);
ALTER TABLE `players` ADD `created` int(16);

ALTER TABLE `players` ADD `nick_verify` int(11);

ALTER TABLE `players` ADD `comment` text;



CREATE TABLE IF NOT EXISTS `news` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `title` varchar(64) NOT NULL DEFAULT '',

  `body` text NOT NULL,

  `time` int(18) NOT NULL DEFAULT '0',

  PRIMARY KEY (`id`)

) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;



CREATE TABLE IF NOT EXISTS `comments` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `news_id` int(11) DEFAULT NULL,

  `body` text NOT NULL,

  `time` int(18) NOT NULL DEFAULT '0',

  `author` varchar(64) NOT NULL DEFAULT '0',

  PRIMARY KEY (`id`)

) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;



CREATE TABLE IF NOT EXISTS `forums` (

  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,

  `name` varchar(64) NOT NULL,

  `description` text NOT NULL,

  `access` int(5) unsigned NOT NULL,

  `closed` int(1) unsigned NOT NULL COMMENT 'Min. access to see the board',

  `moderators` text NOT NULL,

  `order` int(6) DEFAULT NULL,

  `requireLogin` int(1) DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;



CREATE TABLE IF NOT EXISTS `posts` (

  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,

  `title` varchar(64) NOT NULL,

  `text` text NOT NULL,

  `time` int(16) unsigned NOT NULL,

  `author` varchar(64) NOT NULL,

  `board_id` int(16) unsigned NOT NULL,

  `thread_id` int(16) unsigned NOT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;



CREATE TABLE IF NOT EXISTS `threads` (

  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,

  `name` varchar(64) NOT NULL,

  `sticked` tinyint(1) unsigned NOT NULL,

  `closed` tinyint(1) unsigned NOT NULL,

  `author` varchar(64) NOT NULL,

  `time` int(12) unsigned NOT NULL,

  `board_id` int(12) unsigned NOT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;



CREATE TABLE IF NOT EXISTS `bugtracker` (

  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,

  `category` int(3) unsigned NOT NULL,

  `time` int(16) unsigned NOT NULL,

  `author` int(16) unsigned NOT NULL,

  `text` text NOT NULL,

  `title` varchar(64) NOT NULL,

  `done` int(3) unsigned NOT NULL,

  `priority` int(3) unsigned NOT NULL,

  `closed` int(1) DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

if only for news

CREATE TABLE IF NOT EXISTS `news` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `title` varchar(64) NOT NULL DEFAULT '',

  `body` text NOT NULL,

  `time` int(18) NOT NULL DEFAULT '0',

  PRIMARY KEY (`id`)

) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;