[WEBSITE] Avesta 7.6 using Uniform Server & Modern AAC - HELP WITH THIS LITTLE BUG.

[Zackvor]

Not solved...

Hello, I have recently come up with an bug. Well, let me explain.

I am using Avesta 7.6, and is interested on making it work on Uniform Server & Modern AAC (Yes, it should work, just take a look here).

Everything is working properly, I can start the server, PMA works completely fine, and the settings in server config is correct. On my homepage, I can search for characters, frags and guilds what so ever.

The problem: As soon as I am trying to create a character it stops working. Please, click here to watch the picture. Furthermore, neither can I create an account/character over SQL Queries on PMA...

Error
SQL query: 

#---------------------------------------------------
INSERT INTO accounts(  `id` ,  `password` ,  `type` ,  `group_id` ) 
VALUES (

@acc , @pass , 5, (

SELECT  `id` 
FROM groups
WHERE  `name` =  'a god'
)
);

MySQL said: 

#1054 - Unknown column 'type' in 'field list'

According to me, everything seem to work but to create new accounts and characters. But there might lay some problems deep in that shit which I do not understand right now, therefore I kindly ask you... Some of you say that Uniform/Modern only works on TFS distros, but according to Znote's thread he says that "It does not matter what OT server you want to run, but this tutorial will use the latest official TFS server available."

Help will be remembered and rep+++!

Sincerely

 

[Zackvor]

After inserting following code:

ALTER TABLE `accounts` ADD `type` INT( 5 ) NOT NULL AFTER `password`

I got a new error, featuring the following one.

Error
SQL query: 
 
#---------------------------------------------------
INSERT INTO accounts(  `id` ,  `password` ,  `type` ,  `group_id` ) 
VALUES (
 
@acc , @pass , 5, (
 
SELECT  `id` 
FROM groups
WHERE  `name` =  'a god'
)
);
 
MySQL said: 
 
#1054 - Unknown column 'group_id' in 'field list'

This will say, problem not solved....

 

[RealSoft]

ALTER TABLE `accounts` ADD `group_id` INT( 5 ) NOT NULL AFTER `type`

 

[Zackvor]

ALTER TABLE `accounts` ADD `group_id` INT( 5 ) NOT NULL AFTER `type`

I guess we'll take it over here

Unfortunately, a new error is coming...

Error
SQL query: 

#---------------------------------------------------
INSERT INTO accounts(  `id` ,  `password` ,  `type` ,  `group_id` ) 
VALUES (

@acc , @pass , 5, (

SELECT  `id` 
FROM groups
WHERE  `name` =  'a god'
)
);

MySQL said: 

#1048 - Column 'group_id' cannot be null

 

[RealSoft]

wops my bad.

First do

ALTER TABLE `accounts` DROP `group_id`

and after do this

ALTER TABLE `accounts` ADD `group_id` INT( 5 ) NOT NULL DEFAULT '0' AFTER `type`

That should do it

 

[Zackvor]

wops my bad.

First do

ALTER TABLE `accounts` DROP `group_id`

and after do this

ALTER TABLE `accounts` ADD `group_id` INT( 5 ) NOT NULL DEFAULT '0' AFTER `type`

That should do it

But it didn't, this must apparently be some difficult shit... I got a new error. Here it goes:

Error
SQL query: 

#---------------------------------------------------
INSERT INTO accounts(  `id` ,  `password` ,  `type` ,  `group_id` ) 
VALUES (

@acc , @pass , 5, (

SELECT  `id` 
FROM groups
WHERE  `name` =  'a god'
)
);

MySQL said: 

#1048 - Column 'group_id' cannot be null

 

[Aleh]

Column 'group_id' cannot be null

ALTER TABLE `accounts` ADD `group_id` int(11) NOT NULL DEFAULT '1' AFTER `type`

 

[Zackvor]

ALTER TABLE `accounts` ADD `group_id` int(11) NOT NULL DEFAULT '1' AFTER `type`

Error
SQL query: 

#---------------------------------------------------
INSERT INTO accounts(  `id` ,  `password` ,  `type` ,  `group_id` ) 
VALUES (

@acc , @pass , 5, (

SELECT  `id` 
FROM groups
WHERE  `name` =  'a god'
)
);

MySQL said: 

#1048 - Column 'group_id' cannot be null

 

[RealSoft]

it's the select id from groups that's failing...
it can't find the result and when it doesn't find anything, it report nothing...

try

INSERT INTO accounts(  `id` ,  `password` ,  `type` ,  `group_id` ) 
VALUES (

@acc , @pass , 5, 0);

change the 0 to 1 if the player group to your server should be 1, else let it stay 0.

But just so you know... this is just the website want that... avesta doesn't read those fields unless you make it read them.

 

[Zackvor]

it's the select id from groups that's failing...
it can't find the result and when it doesn't find anything, it report nothing...

try

INSERT INTO accounts(  `id` ,  `password` ,  `type` ,  `group_id` ) 
VALUES (

@acc , @pass , 5, 0);

change the 0 to 1 if the player group to your server should be 1, else let it stay 0.

But just so you know... this is just the website want that... avesta doesn't read those fields unless you make it read them.

What can be done to Avesta to make it read those fields?

 

[RealSoft]

What can be done to Avesta to make it read those fields?

if you don't know how or why, then you shouldn't bother trying.. not yet at least..
Avesta read their groups between SQL table groups and the players table group_id.

In Avesta you can't make an account have a certain status, only each player.
Etc, if you are tutor, the acc isn't, only THAT player...

So the table in accounts "type" and "group" are totally useless here unless you change that in the sources of avesta (which i suppose you use)

 

[Zackvor]

if you don't know how or why, then you shouldn't bother trying.. not yet at least..
Avesta read their groups between SQL table groups and the players table group_id.

In Avesta you can't make an account have a certain status, only each player.
Etc, if you are tutor, the acc isn't, only THAT player...

So the table in accounts "type" and "group" are totally useless here unless you change that in the sources of avesta (which i suppose you use)

Yeah, alright. Thank you for sorting that up for me.
Anyway, there must be some way around it, to make it work, just as you are saying. You don't think there are any tutorials I've missed about it, or something/somewhere/someone I can take help from?

 

[RealSoft]

Yeah, alright. Thank you for sorting that up for me.
Anyway, there must be some way around it, to make it work, just as you are saying. You don't think there are any tutorials I've missed about it, or something/somewhere/someone I can take help from?

remove the crap from the website.. make the code so it doesn't try to insert any type/group to the accounts, and that part should work fine

 

[Zackvor]

remove the crap from the website.. make the code so it doesn't try to insert any type/group to the accounts, and that part should work fine

If you could help me doing it, I'd appreciate it very much. If not, thank you for taking your time!