• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • 2026 staff recruitment is open! Check it out and consider applying!

ModernACC - Help!

L

Lindemans

Member
Joined
Sep 2, 2007
Messages
328
Reaction score
12
Hello Is there someone out there who could help me with a bug on modernacc? please message me fast!

A Database Error Occurred

Unable to connect to your database server using the provided settings.

I really dont know what to do! please help me out OTland.


Thanks Fera!
 
Sweddy said:
Look at ure database settings and see if everything is correct?
Click to expand...
Thanks, but now it came up something like this! A Database Error Occurred

Error Number: 1146

Table 'otserv.news' doesn't exist

SELECT `id`, `title`, `body`, `time` FROM `news` WHERE `active` = '1' ORDER BY id DESC LIMIT 3


do you know how to fix that? :/
 
SQL: 
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 ;

Relax, it may even take weeks before ppl can get help haha :p
Do that in ure phpmyadmin and in ure Database.
 
Sweddy said:
It shouldnt be same error, surely another error.
Click to expand...
A Database Error Occurred

Error Number: 1054

Unknown column 'active' in 'where clause'

SELECT `id`, `title`, `body`, `time` FROM `news` WHERE `active` = '1' ORDER BY id DESC LIMIT 3
 
lol it came up one more!
A Database Error Occurred

Error Number: 1146

Table 'otserv.poll' doesn't exist

SELECT p.id, p.question, GROUP_CONCAT(a.answer SEPARATOR ';') AS answers, GROUP_CONCAT(a.id SEPARATOR ';') AS answers_id FROM poll p JOIN poll_answer a ON p.id = a.poll_id WHERE p.status = 1 AND date_start <= NOW() AND date_end >= NOW()
 
SQL: 
CREATE TABLE IF NOT EXISTS `poll` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `question` VARCHAR(150) ,
  `created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `date_start` datetime ,
  `date_end` datetime ,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `question` (`question`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
SQL: 
CREATE TABLE IF NOT EXISTS `poll_answer` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `poll_id` INT(11) NOT NULL,
  `answer` VARCHAR(150) ,
  PRIMARY KEY (`id`),
  FOREIGN KEY (`poll_id`) REFERENCES `poll` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
SQL: 
CREATE TABLE IF NOT EXISTS `poll_votes` (`id` INT(11) NOT NULL AUTO_INCREMENT,`answer_id` INT(11) ,`poll_id` INT(11) ,`account_id` INT(11) NOT NULL,PRIMARY KEY (`id`),FOREIGN KEY (`answer_id`) REFERENCES `poll_answer` (`id`) ON DELETE CASCADE,FOREIGN KEY (`poll_id`) REFERENCES `poll` (`id`) ON DELETE CASCADE,FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
 
Back
Top