Athena

Look where the errors start! And maybe you will get a clue of what is it. Also, what revision did you pull? Note: "The last one" isn't a answer!

But that doesn't explain the Unknown column 'username' in 'where clause

hum... unless the engine_logon_db variable doesn't point to your auth DB i don't see why it throws that error!

ok... i see that i have to do a sketch! PHP Basic 101: <?php $variable = '0'; //The value of the $variable is 0. $variable = mysql_query("SELECT id FROM account WHERE username = 'test'"); //The value of variable is the id from test. ?> TBL_ACCOUNT get his variable somewhere... i just want to know where and that code!

TBL_ACCOUNT is a variable... somewhere in the code it have to get his value. where is it?

Where does the variable TBL_ACCOUNT get his value?

That SQL string isn't complete! Post all file and maybe we find something wrong on it.

Reviving old threads?! [CLOSED]

You have compiled every single version of ACE??? All 70 Versions of ACE??? You are my hero dude!

--- Canned message start It appears the issue in the original post was solved, so this thread shall be closed. Should you encounter any other difficulties, please open a new thread. --- Canned message end ---

--- Canned message start It appears the issue in the original post was solved, so this thread shall be closed. Should you encounter any other difficulties, please open a new thread. --- Canned message end ---

Is it the same problem? Sure? Read the entire thread.

This means something, doesn't it?

With what program did you loaded it? I just checked and that column is present on it... soo... if you don't see it, it's because something was not loaded very well.

How i missed that?! Paradox you're the best! When will you come again to the team?

Does your table item_instance looks like this: CREATE TABLE `item_instance` ( `guid` int(10) unsigned NOT NULL DEFAULT '0', `itemEntry` mediumint(8) unsigned NOT NULL DEFAULT '0', // <-- It seems this column is missing on your DB. `owner_guid` int(10) unsigned NOT NULL DEFAULT '0', `creatorGuid` int(10) unsigned NOT NULL DEFAULT '0', `giftCreatorGuid` int(10) unsigned NOT NULL DEFAULT '0', `count` int(10) unsigned NOT NULL DEFAULT '1', `duration` int(10) NOT NULL DEFAULT '0', `charges` tinytext, `flags` mediumint(8) unsigned NOT NULL DEFAULT '0', `enchantments` text NOT NULL, `randomPropertyId` smallint(5) NOT NULL DEFAULT '0', `durability` smallint(5) unsigned NOT NULL DEFAULT '0', `playedTime` int(10) unsigned NOT NULL DEFAULT '0', `text` text, PRIMARY KEY (`guid`), KEY `idx_owner_guid` (`owner_guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Item System';

What is your core version?

bitherd, if you look @ the image you will see that he has the right MySQL version, that is only a warning. But the [ERROR]: Unknown column 'itemEntry' in 'field list' means that he missed some DB updates.

You missed some DB updates!

Just put the last 25-30 lines.

A more detailed log output would help!

Seems like permissions problem! Try creating a folder on your root disk and compile from their.

It seems you are compiling a outdated version... also your GIT is outdated. Maybe if you update your GIT and re-download all source code and compile, everything goes well.

And BTW. First and last time i used Navicat (yes, i did tryed it once) it simply skiped SQL lines! And that is definitely a BIG problem! Anyway, sqlyog is a good program... i prefere the command line (but that's me! hehehehe!) Cheers, Athena