AAC Problems!

[Amoaz]

Hello, been searching for a good AAC guide and cant find one (yea sure flame on).
Getting this message when im trying to make a home-page. Using Geisor AAC 0.3.6

This is the error i get. Please someone help me


bUmp

 

[Cykotitan]

0.3.6pl1

I was asking the original poster

 

[Amoaz]

0.3.6
Changed all now, made a new database, used the Gesior Account Maker for TFS 0.3.6 and still only getting to step 4 with the error occured :

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'skulltime' in 'field list'' in C:\xampp\htdocs\install.php:505 Stack trace: #0 C:\xampp\htdocs\install.php(505): PDO->query('INSERT INTO pla...') #1 {main} thrown in C:\xampp\htdocs\install.php on line 505

 

[Cykotitan]

Execute these queries on your database:

ALTER TABLE `players` CHANGE `redskulltime` `skulltime` INT NOT NULL DEFAULT 0;
ALTER TABLE `players` ADD `skull` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `save`;

 

[Amoaz]

And how do i execute them ? ;O and where?

 

[Cykotitan]

Click the SQL icon in phpMyAdmin ?

 

[Amoaz]

Ah ok found it now, its already something here, should i remove it?
SELECT * FROM `accounts` WHERE 1

 

[Amoaz]

Got this now when adding it :

SQL-fråga: Dokumentation

SELECT *
FROM `accounts`
WHERE 1
ALTER TABLE `players` CHANGE `redskulltime` `skulltime` INT NOT NULL DEFAULT 0;

MySQL sa: Dokumentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE `players` CHANGE `redskulltime` `skulltime` INT NOT NULL DEFAULT 0' at line 1

 

[Cykotitan]

It shouldn't fail, try copying it from my post again.

 

[Amoaz]

So i should keep the SELECT * FROM `accounts` WHERE 1 ?

 

[Cykotitan]

no.

 

[Amoaz]

Still not working, getting same message over and over again ;S

 

[Amoaz]

Getting this message now :

ANGE `redskulltime` `skulltime` INT NOT NULL DEFAULT 0;

MySQL sa: Dokumentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ANGE `redskulltime` `skulltime` INT NOT NULL DEFAULT 0' at line 1

 

[Cykotitan]

You're doing it wrong

ALTER TABLE `players` RENAME COLUMN `redskulltime` to `skulltime`;
ALTER TABLE `players` ADD `skull` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `save`;

 

[Amoaz]

Doing what wrong? And how to do then? :S

 

[Amoaz]

Getting this error code now when using
ALTER TABLE `players` RENAME COLUMN `redskulltime` to `skulltime`;
ALTER TABLE `players` ADD `skull` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `save`;


#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLUMN `redskulltime` to `skulltime`' at line 1

 

[vejsa]

RE do it all, and it will work, Do it step wise..
like

Step 1:
Step 2:

Etc.. I think there is a thread about it

 

[Amoaz]

Then post the theard please, ive tryd all

 

[Cykotitan]

ALTER TABLE `players` CHANGE `redskulltime` `skulltime` INT NOT NULL DEFAULT 0;
ALTER TABLE `players` CHANGE `redskull` `skull` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0;

 

[Amoaz]

Got to the last step now! Getting this error code

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'name' in 'field list'' in C:\xampp\htdocs\pot\OTS_Account.php:229 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Account.php(229): PDO->query('SELECT `id`, `n...') #1 C:\xampp\htdocs\install.php(558): OTS_Account->load(1) #2 {main} thrown in C:\xampp\htdocs\pot\OTS_Account.php on line 229

 

[Cykotitan]

It seems like you have database structure of TFS 0.2