usualsuspect
New Member
- Joined
- Oct 6, 2020
- Messages
- 19
- Solutions
- 1
- Reaction score
- 2
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
(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
SELECT
0 AS
UNIX_TIMESTAMP(CURDATE()) AS
'' AS
FROM
LEFT JOIN
ON
WHERE
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
...forgot to mention, I set $config['ServerEngine'] with 'TFS_1.2', which I believe is the version I'm using.
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 NULLMySQL 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:
...forgot to mention, I set $config['ServerEngine'] with 'TFS_1.2', which I believe is the version I'm using.