Mauricio Souza
New Member
- Joined
- Feb 29, 2016
- Messages
- 3
- Reaction score
- 0
Hello guys, I'm in a little of a trouble here....
I'm running this Znote ACC version 1.5 with a TSF 1.2 Tibia Version 10.90 on a wamp server with lastes versions of all services.
The problem here is when I try to upload the SQL code i receive on the instalation manual i keep on gettin the same error, over and over again, i'm not sure how to fix that.
MySql Schema - From Znote Connection Error's page
Sorry about the Pastebin link, i just received a error msg from the forum saying that my post was too long :s
I also tried fix the error msg with this piece of code:
Yet, nothing happened. My TSFVersion in config.php is set to TSF_10 (since i'm running a 1.2) and every other option for this tag makes the site crash.
Right now when i try to create an account i receive the following error:
I think is because of the first one, from the mysql code.
My instalation workflow have been this, trough out all of the several times i tried to reinstall it:
Any help would be awesome.
Thanks,
I'm running this Znote ACC version 1.5 with a TSF 1.2 Tibia Version 10.90 on a wamp server with lastes versions of all services.
The problem here is when I try to upload the SQL code i receive on the instalation manual i keep on gettin the same error, over and over again, i'm not sure how to fix that.
MySql Schema - From Znote Connection Error's page
Sorry about the Pastebin link, i just received a error msg from the forum saying that my post was too long :s
SQL query:
INSERT INTO `znote_accounts` (`account_id`, `ip`, `created`) VALUES
('1', '0', '1457256304')
MySQL said:
#1364 - Field 'activekey' doesn't have a default value
INSERT INTO `znote_accounts` (`account_id`, `ip`, `created`) VALUES
('1', '0', '1457256304')
MySQL said:
#1364 - Field 'activekey' doesn't have a default value
I also tried fix the error msg with this piece of code:
Insert into `znote_accounts` (`account_id`, `ip`, `created`, `activekey`, `flag`) VALUES
('1', '0', '144894621', '0', '0')
('1', '0', '144894621', '0', '0')
Yet, nothing happened. My TSFVersion in config.php is set to TSF_10 (since i'm running a 1.2) and every other option for this tag makes the site crash.
Right now when i try to create an account i receive the following error:
No changelogs submitted.
C:\wamp64\www\znote-newserver\engine\database\connect.php:301:string 'SELECT `n`.`id`, `n`.`title`, `n`.`text`, `n`.`date`, `p`.`name` FROM `znote_news` AS `n` INNER JOIN `players` AS `p` ON `n`.`pid` = `p`.`id` ORDER BY `n`.`id` DESC;' (length=165)
(query - SQL error)
Type: select_multi (select multiple rows from database)
Table 'newserver.znote_news' doesn't exist
C:\wamp64\www\znote-newserver\engine\database\connect.php:301:string 'SELECT `n`.`id`, `n`.`title`, `n`.`text`, `n`.`date`, `p`.`name` FROM `znote_news` AS `n` INNER JOIN `players` AS `p` ON `n`.`pid` = `p`.`id` ORDER BY `n`.`id` DESC;' (length=165)
(query - SQL error)
Type: select_multi (select multiple rows from database)
Table 'newserver.znote_news' doesn't exist
I think is because of the first one, from the mysql code.
My instalation workflow have been this, trough out all of the several times i tried to reinstall it:
- I extract the files to my www diretory.
- Without modifying the config.php i enter the website (to get the mysql schema).
- I edit the config.php file to connect it to the server and database.
- And get the error posted here :'D
Any help would be awesome.
Thanks,
