• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

AAC Znote Acc Not Wroking With Nostalrius 7.7. need help to update Database

Sp0tl3ss

Nestalia.org
Joined
Jul 19, 2014
Messages
279
Reaction score
12
Hello im trying to use Znote acc for Nostalrius 7.7 (https://otland.net/threads/nostalrius-7-7.262406/), but im getting an error
"
string(92) "SELECT id, name, password, email, premdays FROM accounts WHERE id = 3 LIMIT 1;"
(query - SQL error)
Type: select_single (select single row from database)

Unknown column 'name' in 'field list'"
Post automatically merged:



Znote AAC
string(241) "SELECT account_id, name, level, group_id, vocation, health, healthmax, experience, mana, manamax, sex, lastlogin, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons FROM players WHERE id = 3;"
(query - SQL error)
Type: select_single (select single row from database)

Unknown column 'lookaddons' in 'field list'
 
Last edited:
Lua:
ALTER TABLE `accounts` ADD `name` int NOT NULL;
ALTER TABLE `accounts` ADD `premdays` int NOT NULL;
Gives me an error

SQL-fråga: Kopiera



ALTER TABLE accounts ADD name int NOT NULL



MySQL sa: Dokumentation

#1060 - Kolumnnamn 'name finns flera gånger
Kolumnnamn "name" exists several times.

Fixed this error, but it seems im missing alot of columns...


string(65) "SELECT id FROM accounts WHERE email='[email protected]';"
(query - SQL error)
Type: select_single (select single row from database)

Unknown column 'email' in 'where clause'
Post automatically merged:

You miss "premdays" column on the accounts table
yes it seems like i need to update several of the columns, i changed to Myaac instead but im still getting errors from columns
"
SQLSTATE[HY000]: General error: 1364 Field 'id' doesn't have a default value


Backtrace:

#0 C:\UniServerZ\www\system\libs\pot\OTS_Account.php(140): PDO->exec()
#1 C:\UniServerZ\www\install\steps\7-finish.php(60): OTS_Account->create()
#2 C:\UniServerZ\www\install\index.php(216): require('...')
#3 {main}"

im not sure what im doing wrong here im using the mql file that came with this distro
 
Last edited:

Znote AAC does not officially support Nostalrius because of bad schema design that breaks compatibility. It is based on TFS 1.2, but modified so it won't work with TFS 1.2 schema compatibility. But there is an unofficial modification of Znote AAC where TFS_10 engine option in config.php is modified to at least partly work with Nostalrius.

I don't think there is a github fork available for Nostalrius support? Someone should make it to allow Nostalrius patches and bugfixes to occur, since I won't do it on the official repo.

Edit: MyAAC by @slaw seems to officially support Nostlarius: (since v0.8.1)

Using an AAC that is maintained (as opposed to downloading an unofficial zip file) and officially support the engine your using is always preferential.
 
Last edited:

Znote AAC does not officially support Nostalrius because of bad schema design that breaks compatibility. It is based on TFS 1.2, but modified so it won't work with TFS 1.2 schema compatibility. But there is an unofficial modification of Znote AAC where TFS_10 engine option in config.php is modified to at least partly work with Nostalrius.

I don't think there is a github fork available for Nostalrius support? Someone should make it to allow Nostalrius patches and bugfixes to occur, since I won't do it on the official repo.

Edit: MyAAC by @slaw seems to officially support Nostlarius: (since v0.8.1)

Using an AAC that is maintained (as opposed to downloading an unofficial zip file) and officially support the engine your using is always preferential.
Ye i found working schemas and an edited znote version with it, I can crate account, chars login to account but not login to The char. I can post them here when im home incase somone needs it in The future😁 i had some issues with myaac columns aswell
 
Ye i found working schemas and an edited znote version with it, I can crate account, chars login to account but not login to The char. I can post them here when im home incase somone needs it in The future😁 i had some issues with myaac columns aswell
You happen to have the link to the working schema? Trying to have a pet project on my spare time, but not very good with sql
 
Back
Top