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

Sp0tl3ss

Nestalia.org
Joined
Jul 19, 2014
Messages
278
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:
OP
Sp0tl3ss

Sp0tl3ss

Nestalia.org
Joined
Jul 19, 2014
Messages
278
Reaction score
12
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

<?php echo $title; ?>
Staff member
Global Moderator
Premium User
Joined
Feb 14, 2008
Messages
6,872
Solutions
243
Reaction score
1,718
Location
Norway
GitHub
Znote

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:
OP
Sp0tl3ss

Sp0tl3ss

Nestalia.org
Joined
Jul 19, 2014
Messages
278
Reaction score
12

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
 
Top