Modern ACC and TFS?

[Dingza]

Alright so I followed znotes tutorial Here

And I'm using TFS 0.3.6 Here
With ModernACC 1.0.2 Here.
But when I configure my website i get this error

Error:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'auzzieot.killers' doesn't exist

I remember i had this error last time i had my own ot and the guy told me I had to use GessiorACC but i cant remember what I did.. haha so do i need to use Gessior or is there something i can do to make this work? I'm really stuck..

Thanks guys =)

 

[Bogart]

CREATE TABLE `killers`
(
	`id` INT NOT NULL AUTO_INCREMENT,
	`death_id` INT NOT NULL,
	`final_hit` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE,
	`unjustified` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE,
	PRIMARY KEY (`id`),
	FOREIGN KEY (`death_id`) REFERENCES `player_deaths`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

 

[Dingza]

Thanks...But what do i do with it? lol i'm picking it all up again...

 

[Bogart]

go to localhost/phpmyadmin
log into your account, go to the database of your server, press SQL, and there will be a white box, then paste it there.

 

[Cykotitan]

must've imported wrong schema. better import the real one (mysql.sql) than the temporary solution

 

[Dingza]

hmm... Same error...

EDIT

Wait no its different now...

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'auzzieot.player_killers' doesn't exist

 

[Cykotitan]

don't tell me you're using sqlite.

config.lua sqlType = "mysql"

 

[Dingza]

I've Imported the right one.. its the only one there lol

 

[Cykotitan]

if you did, this couldn't be happening. or you don't have 0.3.6 but something else.

 

[Dingza]

Its nothing to do with my server its database wise its coming up on my website..

 

[Dingza]

Nah i'm not that noob my server is working fine and everything its just the website..

 

[Archez]

You sure that's your database name? auzzieot?

 

[Dingza]

Yeah triple checked it..

EDIT

Do i need to create another table?

 

[Dingza]

Sorry i need to bump it lol giving me the shits... the erorr now is

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'auzzieot.player_killers' doesn't exist

Can i have a code to make that table? or..

 

[Bogart]

CREATE TABLE `player_killers`
(
	`kill_id` INT NOT NULL,
	`player_id` INT NOT NULL,
	FOREIGN KEY (`kill_id`) REFERENCES `killers`(`id`) ON DELETE CASCADE,
	FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

 

[Dingza]

Cheers mate <3

 

[Dingza]

Sorry for another double post but i figured no point starting another thread... On znotes tut he says to use sha1 passwords but when i set it up for that it wont let me log in but when i change it to plain i can log in... did i miss a convertor or something to download or?

never mind I fixed it

 

[Bogart]

Sorry for another double post but i figured no point starting another thread... On znotes tut he says to use sha1 passwords but when i set it up for that it wont let me log in but when i change it to plain i can log in... did i miss a convertor or something to download or?

never mind I fixed it

go to your config.lua and change encryptionType = "plain" to encryptionType = "sha1"

 

[Dingza]

Yeah i had that done but I had to convert my accoutns to 'sha1' passwords they were still plain....Cept NOW my problem is when i login i have a database error..

A Database Error Occurred

Error Number: 1054

Unknown column 'name' in 'where clause'

SELECT `id`, `page_access`, `nickname` FROM (`accounts`) WHERE `name` = '8223331' AND `password` = '9e1f9977fe72d5d37e0960751f89314fd1fcbe09'

i think errors are attracted to me? haha if you could help would be great but you've done tones already so.. =)

 

[Dingza]

Yeah k fml lol is there a code i need? hahaha