Problem setting up my first OT server...

[usualsuspect]

Hi guys, I am an old school Tibia player (started Nova and played a few later servers) who would like to set up an OT server for nostalgia PVE and PVPing with friends. I have followed your excellent ‘running your own OT server’ guide but have run into a little problem. While importing the Znote schema to phpmyadmin I had the following message:

Import has been successfully finished, 30 queries executed. (znote_schema.sql)
Error
SQL query: Documentation

I only imported the schema to phpmyadmin, and not to my named database. Despite the error I then continued with the steps as described and was able to view the website successfully at 127.0.0.1. However, when I completed the following step ‘go ahead and create your account’ I received this error:

Register Account
string(177) "INSERT INTO znote_accounts (account_id, ip, created, active, active_email, activekey, flag) VALUES ('1', '2130706433', '1601997432', '1', '0', '336783027', 'gb')"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Table 'tibworld.znote_accounts' doesn't exist

I also saw the following error:

INSERT INTO znote_accounts (account_id, ip, created, flag)
SELECT
a.id AS account_id,
0 AS ip,
UNIX_TIMESTAMP(CURDATE()) AS created,
'' AS flag
FROM accounts AS a
LEFT JOIN znote_accounts AS z
ON a.id = z.account_id
WHERE z.created IS NULL
MySQL said: Documentation

#1146 - Table 'phpmyadmin.accounts' doesn't exist

Inside my UniServZ database (‘tibworld’) I can see the two accounts I tried to create, including names and email addresses. However, no registration emails were received and I cannot login to the Znote site with the corresponding usernames and passwords to create accounts. Is there some way I can manually approve these accounts to enable me to create characters? Or have I made an earlier mistake which needs rectifying?

Many thanks for any help, really excited to try 7.4 again after so many years

Post automatically merged: Oct 7, 2020

...forgot to mention, I set $config['ServerEngine'] with 'TFS_1.2', which I believe is the version I'm using.

 

[JayMeazy]

Hi guys, I am an old school Tibia player (started Nova and played a few later servers) who would like to set up an OT server for nostalgia PVE and PVPing with friends. I have followed your excellent ‘running your own OT server’ guide but have run into a little problem. While importing the Znote schema to phpmyadmin I had the following message:

Import has been successfully finished, 30 queries executed. (znote_schema.sql)
Error
SQL query: Documentation

I only imported the schema to phpmyadmin, and not to my named database. Despite the error I then continued with the steps as described and was able to view the website successfully at 127.0.0.1. However, when I completed the following step ‘go ahead and create your account’ I received this error:

Register Account
string(177) "INSERT INTO znote_accounts (account_id, ip, created, active, active_email, activekey, flag) VALUES ('1', '2130706433', '1601997432', '1', '0', '336783027', 'gb')"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Table 'tibworld.znote_accounts' doesn't exist

I also saw the following error:

INSERT INTO znote_accounts (account_id, ip, created, flag)
SELECT
a.id AS account_id,
0 AS ip,
UNIX_TIMESTAMP(CURDATE()) AS created,
'' AS flag
FROM accounts AS a
LEFT JOIN znote_accounts AS z
ON a.id = z.account_id
WHERE z.created IS NULL
MySQL said: Documentation

#1146 - Table 'phpmyadmin.accounts' doesn't exist

Inside my UniServZ database (‘tibworld’) I can see the two accounts I tried to create, including names and email addresses. However, no registration emails were received and I cannot login to the Znote site with the corresponding usernames and passwords to create accounts. Is there some way I can manually approve these accounts to enable me to create characters? Or have I made an earlier mistake which needs rectifying?

Many thanks for any help, really excited to try 7.4 again after so many years

Post automatically merged: Oct 7, 2020

...forgot to mention, I set $config['ServerEngine'] with 'TFS_1.2', which I believe is the version I'm using.

did you import the schema.sql?

 

[usualsuspect]

did you import the schema.sql?

Yes I imported it to phpmyadmin in UniServZ. It said ‘30 queries were executed’ but also mentioned a MySQL error. Is this the problem?

thank you very much for your help

 

[JayMeazy]

Yes I imported it to phpmyadmin in UniServZ. It said ‘30 queries were executed’ but also mentioned a MySQL error. Is this the problem?

thank you very much for your help

I'd recommend redoing the imports, starting with tfs import, and then when you enter 127.0.0.1/phpmyadmin it will give you the znote schema. It's hard to say what error there was when you imported. It kinda looks like you have 2 different mysql settings though.

Table 'tibworld.znote_accounts' doesn't exist

#1146 - Table 'phpmyadmin.accounts' doesn't exist

I believe that second error should be looking for 'tibworld.accounts' if it's setup correctly. Also, the query that your website sent to database put 0 as the email, which might be why you can't login.

 

[usualsuspect]

I'd recommend redoing the imports, starting with tfs import, and then when you enter 127.0.0.1/phpmyadmin it will give you the znote schema. It's hard to say what error there was when you imported. It kinda looks like you have 2 different mysql settings though.

Table 'tibworld.znote_accounts' doesn't exist

#1146 - Table 'phpmyadmin.accounts' doesn't exist

I believe that second error should be looking for 'tibworld.accounts' if it's setup correctly. Also, the query that your website sent to database put 0 as the email, which might be why you can't login.

Thanks Jay,

Post automatically merged: Oct 8, 2020

I'm using the TFS schema from here right?

Release The Forgotten Server 1.2 · otland/forgottenserver

This is the third stable release of The Forgotten Server in the 1.x series. Precompiled Windows binaries are provided for the convenience of Windows users. Users of other operating systems are advi...

github.com

 

[usualsuspect]

Thank you for your help Jay, I have successfully created my first character - yay! Now to try and get the client working..

Post automatically merged: Oct 9, 2020

Thank you for your help Jay, I have successfully created my first character - yay! Now to try and get the client working..

In case this helps others, I used xampp to successfully import the 31 lines of the tfs schema. Couldn’t get uniserverz to work.