[MODERNAAC]Missing tables etc[Tutorial]

[Denblinde]

This is not working for me where ever i paste this it dont work...

- - - Updated - - -

If i get this error what do i need to do to fix it?

Not Found

The requested URL /v/index.php/account/create was not found on this server.

 

[Amiroslo]

open ur config.php and search for /v/index.php and change it to /index.php

 

[usualsolid1]

where am i going to do ctrl+f

- - - Updated - - -

and where am i going to enter this things

 

[Amiroslo]

do ctrl+f in the thread and search for news and u will find the table, copy it and paste it in ur phpmyadmin (sql)

 

[usualsolid1]

ok i did what you told me now in my sql it comes an error #1005 - Can't create table 'otserv.comments'

- - - Updated - - -

hello

- - - Updated - - -

help me

 

[Amiroslo]

u do the same, ctrl+f, search for comments and paste it...

CREATE TABLE IF NOT EXISTS `comments` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `news_id` INT(11),
  `body` text,
  `time` INT(11) DEFAULT '0',
  `author` INT(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  FOREIGN KEY (`news_id`) REFERENCES `news` (`id`) ON DELETE CASCADE,
  FOREIGN KEY (`author`) REFERENCES `players` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT

 

[usualsolid1]

look, this is how it looks right now in my sql "CREATE TABLE IF NOT EXISTS `comments` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`news_id` INT(11),
`body` text,
`time` INT(11) DEFAULT '0',
`author` INT(11) DEFAULT '0',
PRIMARY KEY (`id`),
FOREIGN KEY (`news_id`) REFERENCES `news` (`id`) ON DELETE CASCADE,
FOREIGN KEY (`author`) REFERENCES `players` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
but it still gives me that eror

 

[Amiroslo]

try this

ALTER TABLE `players` ADD `comment` text;

 

[usualsolid1]

i Went to my sql and pasted this ALTER TABLE `players` ADD `comment` text; KNOW FIRST I PASTED id` INT(11) NOT NULL AUTO_INCREMENT,
`news_id` INT(11),
`body` text,
`time` INT(11) DEFAULT '0',
`author` INT(11) DEFAULT '0',
PRIMARY KEY (`id`),
FOREIGN KEY (`news_id`) REFERENCES `news` (`id`) ON DELETE CASCADE,
FOREIGN KEY (`author`) REFERENCES `players` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

AND THEN IT GAVE ME AN ERROR, SO I DID WHAT YOU TOLD ME TO AND NOW WHEN IM TRYING TO ENTER MY WEBSITE IT COMES ANOTHER ERROR "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()

 

[Amiroslo]

search for poll and u should find this

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 ;

now add it...

 

[usualsolid1]

oohhhhh meeeeen now it comes Another error "Table 'otserv.poll_answer' 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()

 

[Amiroslo]

DUDE PLEASE SEARCH

use CTRL+F in the main thread and search for poll_answer
copy the query and paste it, same with all errors you will get..

 

[usualsolid1]

neer mind i fixed it

- - - Updated - - -

hey you said it was the modern website like real tibia website but it is a whole other website

 

[Undercraft]

How i can fix it?

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'old_name' in 'where clause'' in C:\xampp\htdocs\public_html\system\application\libraries\POT\OTS_Player.php:146 Stack trace: #0 C:\xampp\htdocs\public_html\system\application\libraries\POT\OTS_Player.php(146): PDO->query('SELECT `id` FRO...') #1 C:\xampp\htdocs\public_html\system\application\controllers\character.php(137): OTS_Player->find('Magician') #2 [internal function]: Character->create_character('1') #3 C:\xampp\htdocs\public_html\system\codeigniter\CodeIgniter.php(236): call_user_func_array(Array, Array) #4 C:\xampp\htdocs\public_html\index.php(165): require_once('C:\xampp\htdocs...') #5 {main} thrown in C:\xampp\htdocs\public_html\system\application\libraries\POT\OTS_Player.php on line 146

 

[Amiroslo]

i see nothing its far..
Copy the text and paste it here

 

[Undercraft]

Oh sorry false alarm haha i'm so stupid, i fixed it

- - - Updated - - -

Bug:

But i have Sample Character :s

 

[bodycarcoo11]

[20/05/2014 15:35:03] mysql_real_query(): SELECT * FROM shop_history WHERE `processed` = 0; - MYSQL ERROR: Table 'otserv.shop_history' doesn't exist (1146)
[20/05/2014 15:35:07] mysql_real_query(): SELECT * FROM shop_history WHERE `processed` = 0; - MYSQL ERROR: Table 'otserv.shop_history' doesn't exist (1146)
[20/05/2014 15:35:11] mysql_real_query(): SELECT * FROM shop_history WHERE `processed` = 0; - MYSQL ERROR: Table 'otserv.shop_history' doesn't exist (1146)

Plzz HeLp

 

[viseq]

Hey guys, look for my bug...
mysql_real_query(): SELECT * FROM messages WHERE `delete_it` = 1; - MYSQL ERROR: Unknown column 'delete_it' in 'where clause' (1054)

 

[fire_shock666]

i got an error like this in guild

string(71) "SELECT `player_id` FROM `players_online` WHERE `player_id`='2' LIMIT 1;"
(query - SQL error)
Type: select_single (select single row from database)

Table 'players_online' doesn't exist

 

[jacobot1]

When i try to create a character:

Error Number: 1054

Unknown column 'deleted' in 'where clause'

SELECT COUNT(*) AS `numrows` FROM (`players`) WHERE `account_id` = '2' AND `deleted` = 0