modern aac BUGS (Rep)

Calon · Jul 12, 2010

in aac modern when i set all infromation for new character such as name vocation and press create character i find this error and i cant create it

404 Page Not Found

The page you requested was not found.

-------------------------------
and when i run the server exe i find some bugs

PHP:

 [12/07/2010 12:31:23] mysql_real_query(): ALTER TABLE `accounts` DROP KEY `group_id`; - MYSQL ERROR: Error on rename of '.\tfs\#sql-cec_68' to '.\tfs\accounts' (errno: 150) (1025)
[12/07/2010 12:31:23] mysql_real_query(): ALTER TABLE `players` DROP KEY `group_id`; - MYSQL ERROR: Error on rename of '.\tfs\#sql-cec_68' to '.\tfs\players' (errno: 150) (1025)
[12/07/2010 12:31:23] mysql_real_query(): DROP TABLE `groups`; - MYSQL ERROR: Cannot delete or update a parent row: a foreign key constraint fails (1217)
[12/07/2010 12:31:27] mysql_real_query(): ALTER TABLE `house_data` ADD FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE; - MYSQL ERROR: Can't create table 'tfs.#sql-cec_68' (errno: 150) (1005)
[12/07/2010 12:31:28] mysql_real_query(): ALTER TABLE `guild_invites` ADD FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE; - MYSQL ERROR: Can't create table 'tfs.#sql-cec_68' (errno: 150) (1005)
[12/07/2010 12:31:28] mysql_real_query(): ALTER TABLE `guild_invites` ADD FOREIGN KEY (`guild_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE; - MYSQL ERROR: Can't create table 'tfs.#sql-cec_68' (errno: 150) (1005)
[12/07/2010 12:31:28] mysql_real_query(): ALTER TABLE `tiles` ADD FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE; - MYSQL ERROR: Can't create table 'tfs.#sql-cec_68' (errno: 150) (1005)[12/07/2010 12:33:29] mysql_real_query(): UPDATE `players` SET `onlinetime7`=players.onlinetime6, `onlinetime6`=players.onlinetime5, `onlinetime5`=players.onlinetime4, `onlinetime4`=players.onlinetime3, `onlinetime3`=players.onlinetime2, `onlinetime2`=players.onlinetime1, `onlinetime1`=players.onlinetimetoday, `onlinetimetoday`=0; - MYSQL ERROR: Unknown column 'onlinetime7' in 'field list' (1054)
[12/07/2010 12:33:29] mysql_real_query(): UPDATE `players` SET `exphist7`=players.exphist6, `exphist6`=players.exphist5, `exphist5`=players.exphist4, `exphist4`=players.exphist3, `exphist3`=players.exphist2, `exphist2`=players.exphist1, `exphist1`=players.experience-players.exphist_lastexp, `exphist_lastexp`=players.experience; - MYSQL ERROR: Unknown column 'exphist7' in 'field list' (1054)
[12/07/2010 12:33:29] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list' (1054)
[12/07/2010 12:34:30] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list' (1054)
[12/07/2010 12:35:31] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list' (1054)
[12/07/2010 12:36:32] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list' (1054)
[12/07/2010 12:37:33] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list' (1054)
[12/07/2010 12:38:34] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list' (1054)
[12/07/2010 12:39:35] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list' (1054)

Rep ++

Kavvson · Jul 12, 2010

secondly + third in the index: sql the OTS sample.sql

i guess it fix all

For more info

http://otland.net/f139/modern-aac-installation-tutorial-82825/

DarkStoorM · Jul 12, 2010

Are you sure that you have all tables in your Database?

Calon · Jul 12, 2010

thanks bro secondly + third solved
rep++
also for who help me in other bugs i will give him a rep

Calon · Jul 12, 2010

@DarkStoorM
nah i have no idea about add tables so try to tellme

DarkStoorM · Jul 12, 2010

Well, try this:

Kavvson said:
http://otland.net/f139/modern-aac-installation-tutorial-82825/

This should help.
By the way, when you enter your database, there is a form to create Tables...
But you need of course to know what fields to make

[edit

]Sorry, can't help you, because in some reason my XAMPP is crashed... o.o[/edit]

Just wait patiently ;p

Calon · Jul 12, 2010

U.u thanks for sharing

Calon · Jul 12, 2010

Kavvson · Jul 12, 2010

XxxTotlxxX said:

when i try to create character i become this error

-------------------------------
and when i run the server exe i find some bugs

PHP:

 [12/07/2010 12:31:23] mysql_real_query(): ALTER TABLE `accounts` DROP KEY `group_id`; - MYSQL ERROR: Error on rename of '.\tfs\#sql-cec_68' to '.\tfs\accounts' (errno: 150) (1025)
[12/07/2010 12:31:23] mysql_real_query(): ALTER TABLE `players` DROP KEY `group_id`; - MYSQL ERROR: Error on rename of '.\tfs\#sql-cec_68' to '.\tfs\players' (errno: 150) (1025)
[12/07/2010 12:31:23] mysql_real_query(): DROP TABLE `groups`; - MYSQL ERROR: Cannot delete or update a parent row: a foreign key constraint fails (1217)
[12/07/2010 12:31:27] mysql_real_query(): ALTER TABLE `house_data` ADD FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE; - MYSQL ERROR: Can't create table 'tfs.#sql-cec_68' (errno: 150) (1005)
[12/07/2010 12:31:28] mysql_real_query(): ALTER TABLE `guild_invites` ADD FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE; - MYSQL ERROR: Can't create table 'tfs.#sql-cec_68' (errno: 150) (1005)
[12/07/2010 12:31:28] mysql_real_query(): ALTER TABLE `guild_invites` ADD FOREIGN KEY (`guild_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE; - MYSQL ERROR: Can't create table 'tfs.#sql-cec_68' (errno: 150) (1005)
[12/07/2010 12:31:28] mysql_real_query(): ALTER TABLE `tiles` ADD FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE; - MYSQL ERROR: Can't create table 'tfs.#sql-cec_68' (errno: 150) (1005)[12/07/2010 12:33:29] mysql_real_query(): UPDATE `players` SET `onlinetime7`=players.onlinetime6, `onlinetime6`=players.onlinetime5, `onlinetime5`=players.onlinetime4, `onlinetime4`=players.onlinetime3, `onlinetime3`=players.onlinetime2, `onlinetime2`=players.onlinetime1, `onlinetime1`=players.onlinetimetoday, `onlinetimetoday`=0; - MYSQL ERROR: Unknown column 'onlinetime7' in 'field list' (1054)
[12/07/2010 12:33:29] mysql_real_query(): UPDATE `players` SET `exphist7`=players.exphist6, `exphist6`=players.exphist5, `exphist5`=players.exphist4, `exphist4`=players.exphist3, `exphist3`=players.exphist2, `exphist2`=players.exphist1, `exphist1`=players.experience-players.exphist_lastexp, `exphist_lastexp`=players.experience; - MYSQL ERROR: Unknown column 'exphist7' in 'field list' (1054)
[12/07/2010 12:33:29] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list' (1054)
[12/07/2010 12:34:30] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list' (1054)
[12/07/2010 12:35:31] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list' (1054)
[12/07/2010 12:36:32] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list' (1054)
[12/07/2010 12:37:33] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list' (1054)
[12/07/2010 12:38:34] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list' (1054)
[12/07/2010 12:39:35] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list' (1054)

Rep ++

Execute

PHP:

ALTER TABLE `players` ADD `exphist_lastexp` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `exphist1` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `exphist2` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `exphist3` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `exphist4` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `exphist5` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `exphist6` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `exphist7` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `onlinetimetoday` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `onlinetime1` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `onlinetime2` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `onlinetime3` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `onlinetime4` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `onlinetime5` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `onlinetime6` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `onlinetime7` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `onlinetimeall` BIGINT( 255 ) NOT NULL DEFAULT '0';

PHP:

UPDATE `players` SET `exphist_lastexp`=`players`.`experience`

Calon · Jul 12, 2010

still one error
[12/07/2010 14:17:49] mysql_real_query(): SELECT `house_id`, `player_id`, `bid` FROM `house_auctions` WHERE `endtime` < 1278929869 - MYSQL ERROR: Table 'tfs.house_auctions' doesn't exist (1146)
------------
also i cant create a account

404 Page Not Found

The page you requested was not found.

Calon · Jul 12, 2010

Kavvson · Jul 12, 2010

PHP:

CREATE TABLE `house_auctions`
(
	`house_id` INT UNSIGNED NOT NULL,
	`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
	`player_id` INT NOT NULL,
	`bid` INT UNSIGNED NOT NULL DEFAULT 0,
	`limit` INT UNSIGNED NOT NULL DEFAULT 0,
	`endtime` BIGINT UNSIGNED NOT NULL DEFAULT 0,
	UNIQUE (`house_id`, `world_id`),
	FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE,
	FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

Calon · Jul 12, 2010

#1005 - Can't create table 'tfs.house_auctions' (errno: 150)

about aac problem no answer ?

Paxton · Jul 12, 2010

Don't use relative paths, seems like we keep having problems with them. Use static path.

tosse12 · Jul 12, 2010

@up
Yeap

doing a more detailed explaination

in your config.php
change

PHP:

$config['website'] = 'http://'.$_SERVER['HTTP_HOST'] . '/'.trim(dirname($_SERVER['SCRIPT_NAME']), '/.\\');

INTO

PHP:

$config['website'] = "http://mywebsite.nu";

modern aac BUGS (Rep)

Calon

Experienced Member

Kavvson

Gdy boli cie glowa wez

DarkStoorM

New Member

Calon

Experienced Member

Calon

Experienced Member

DarkStoorM

New Member

Calon

Experienced Member

Calon

Experienced Member

Kavvson

Gdy boli cie glowa wez

Calon

Experienced Member

Calon

Experienced Member

Kavvson

Gdy boli cie glowa wez

Calon

Experienced Member

Paxton

Banned User

tosse12

Panchira Project Member

Similar threads