Ray Rewind
Doctor
I've looked up the connect.php and did not find this table
Table 'panamera.guild_membership' doesn't exist
its for the guilds.php do you have any information about it?
Oh okay I'm using 0.3.6 that's why it doesn't work I suppose!Change the TFSVersion in config.php, guild_membership is for TFS 1.0.
tring(142) "INSERT INTO `znote_deleted_characters`(`original_account_id`, `character_name`, `time`, `done`) VALUES(3, "Testerere", (NOW() + INTERVAL ), 0)"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), 0)' at line
string(56) "SELECT `password` FROM `accounts` WHERE `id` = LIMIT 1;"
(query - SQL error)
Type: select_single (select single row from database)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1
Gesior and Modern shop points to Znote AAC shop points
Convert donation/shop points from previous Gesior/Modern installation to Znote AAC:
Detected: 310 accounts who have points in old system.
Failed to syncronize accounts. You need to convert all accounts to Znote AAC first!
Are you using the right database connections, username, password, database and stuff? If so then remove the username and try connect again and you will get the list with the missing SQL tables, then just add it and it should work.Guys can u help me with znote SQL what i have to add to my ots database? It dont show list when i go to localhost
string(128) "SELECT `name`, `level`, `vocation`, `town_id`, `lastlogin`, `online` FROM `players` WHERE `account_id`='1' ORDER BY `level` DESC"
(query - SQL error)
Type: select_multi (select multiple rows from database)
Unknown column 'online' in 'field list'
Warning: mysql_result() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\engine\function\users.php on line 1180
Nobody is online.
return mysql_result(mysql_query("SELECT COUNT(`id`) from `players` WHERE `online` = 1;"), 0);
string(128) "SELECT `name`, `level`, `vocation`, `town_id`, `lastlogin`, `online` FROM `players` WHERE `account_id`='1' ORDER BY `level` DESC"
(query - SQL error)
Type: select_multi (select multiple rows from database)
Unknown column 'online' in 'field list'
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\engine\function\users.php on line 140
while ($row = mysql_fetch_assoc($query)) {
Live preview of Znote AAC 1.5_dev: http://demo.znote.eu/live preview doesn't work, fix it please
thxLive preview of Znote AAC 1.5_dev: http://demo.znote.eu/