• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Need help with some probs

tyngaste

tyngaste

New Member
Joined
Dec 2, 2008
Messages
223
Reaction score
0
Location
Sweden
[20/02/2009 17:38:31] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login';: MYSQL ERROR: Table 'tfs.z_ots_comunication' doesn't exist
[20/02/2009 17:38:31] mysql_real_query(): UPDATE `players` SET `onlinetime7`=players.onlinetime6, `onlinetime6`=players.onlinetime5, `onlinetime5`=players.onlinetime4, `onlinetime4`=players.onlinetime3, `onlinetime3`=players.onlinetime2, `onlinetime2`=players.onlinetime1, `onlinetime1`=players.onlinetimetoday, `onlinetimetoday`=0;: MYSQL ERROR: Unknown column 'onlinetime7' in 'field list'
[20/02/2009 17:38:31] mysql_real_query(): UPDATE `players` SET `exphist7`=players.exphist6, `exphist6`=players.exphist5, `exphist5`=players.exphist4, `exphist4`=players.exphist3, `exphist3`=players.exphist2, `exphist2`=players.exphist1, `exphist1`=players.experience-players.exphist_lastexp, `exphist_lastexp`=players.experience;: MYSQL ERROR: Unknown column 'exphist7' in 'field list'
[20/02/2009 17:38:31] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1;: MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list'
[20/02/2009 17:39:02] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login';: MYSQL ERROR: Table 'tfs.z_ots_comunication' doesn't exist
[20/02/2009 17:39:32] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1;: MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list'
[20/02/2009 17:39:33] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login';: MYSQL ERROR: Table 'tfs.z_ots_comunication' doesn't exist
[20/02/2009 17:40:04] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login';: MYSQL ERROR: Table 'tfs.z_ots_comunication' doesn't exist
[20/02/2009 17:40:33] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1;: MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list'
[20/02/2009 17:40:35] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login';: MYSQL ERROR: Table 'tfs.z_ots_comunication' doesn't exist
[20/02/2009 17:41:06] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login';: MYSQL ERROR: Table 'tfs.z_ots_comunication' doesn't exist
[20/02/2009 17:41:34] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1;: MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list'
[20/02/2009 17:41:37] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login';: MYSQL ERROR: Table 'tfs.z_ots_comunication' doesn't exist
[20/02/2009 17:42:08] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login';: MYSQL ERROR: Table 'tfs.z_ots_comunication' doesn't exist
[20/02/2009 17:42:35] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1;: MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list'
[20/02/2009 17:42:39] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login';: MYSQL ERROR: Table 'tfs.z_ots_comunication' doesn't exist
[20/02/2009 17:43:10] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login';: MYSQL ERROR: Table 'tfs.z_ots_comunication' doesn't exist
[20/02/2009 17:43:36] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1;: MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list'
[20/02/2009 17:43:41] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login';: MYSQL ERROR: Table 'tfs.z_ots_comunication' doesn't exist
[20/02/2009 17:44:12] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login';: MYSQL ERROR: Table 'tfs.z_ots_comunication' doesn't exist
[20/02/2009 17:44:30] > Saving server...
[20/02/2009 17:44:37] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1;: MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list'
[20/02/2009 17:44:37] Preparing shutdown...
[20/02/2009 17:44:37] Exiting> Saving server...
[20/02/2009 17:44:43] Error: generating report file...

if anyone know what the prob is i would be thankfull for help
 
Sort by date Sort by votes
This happens because you have configured the web-shop on C:/SERVER_NAME/data/creaturescripts/scripts/login.lua and you don't have installed the queries for that script (like: z_ots_communication; z_shop_offer; z_shop_history_item; etc.)

Do all the steps that Gesior says on that link
(you have to do only the step 4, but if you missed something before that step > do it all).

You have to do this:

In your MySQL database execute (in phpmyadmin):
PHP: 
CREATE TABLE `z_ots_comunication` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `action` varchar(255) NOT NULL,
  `param1` varchar(255) NOT NULL,
  `param2` varchar(255) NOT NULL,
  `param3` varchar(255) NOT NULL,
  `param4` varchar(255) NOT NULL,
  `param5` varchar(255) NOT NULL,
  `param6` varchar(255) NOT NULL,
  `param7` varchar(255) NOT NULL,
  `delete_it` int(2) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
and
PHP: 
CREATE TABLE `z_shop_offer` (
  `id` int(11) NOT NULL auto_increment,
  `points` int(11) NOT NULL default '0',
  `itemid1` int(11) NOT NULL default '0',
  `count1` int(11) NOT NULL default '0',
  `itemid2` int(11) NOT NULL default '0',
  `count2` int(11) NOT NULL default '0',
  `offer_type` varchar(255) default NULL,
  `offer_description` text NOT NULL,
  `offer_name` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
and
PHP: 
ALTER TABLE `accounts` ADD `premium_points` INT( 11 ) NOT NULL DEFAULT '0';
and
PHP: 
CREATE TABLE `z_shop_history_item` (
  `id` int(11) NOT NULL auto_increment,
  `to_name` varchar(255) NOT NULL default '0',
  `to_account` int(11) NOT NULL default '0',
  `from_nick` varchar(255) NOT NULL,
  `from_account` int(11) NOT NULL default '0',
  `price` int(11) NOT NULL default '0',
  `offer_id` int(11) NOT NULL default '0',
  `trans_state` varchar(255) NOT NULL,
  `trans_start` int(11) NOT NULL default '0',
  `trans_real` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
and
PHP: 
CREATE TABLE `z_shop_history_pacc` (
  `id` int(11) NOT NULL auto_increment,
  `to_name` varchar(255) NOT NULL default '0',
  `to_account` int(11) NOT NULL default '0',
  `from_nick` varchar(255) NOT NULL,
  `from_account` int(11) NOT NULL default '0',
  `price` int(11) NOT NULL default '0',
  `pacc_days` int(11) NOT NULL default '0',
  `trans_state` varchar(255) NOT NULL,
  `trans_start` int(11) NOT NULL default '0',
  `trans_real` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
 
Last edited:
Upvote 0 Downvote
Xampy said:
This happens because you have configured the web-shop on C:/SERVER_NAME/data/creaturescripts/scripts/login.lua and you don't have installed the queries for that script (like: z_ots_communication; z_shop_offer; z_shop_history_item; etc.)

Do all the steps that Gesior says on that link
(you have to do only the step 4, but if you missed something before that step > do it all).

You have to do this:

In your MySQL database execute (in phpmyadmin):
PHP: 
CREATE TABLE `z_ots_comunication` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `action` varchar(255) NOT NULL,
  `param1` varchar(255) NOT NULL,
  `param2` varchar(255) NOT NULL,
  `param3` varchar(255) NOT NULL,
  `param4` varchar(255) NOT NULL,
  `param5` varchar(255) NOT NULL,
  `param6` varchar(255) NOT NULL,
  `param7` varchar(255) NOT NULL,
  `delete_it` int(2) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
and
PHP: 
CREATE TABLE `z_shop_offer` (
  `id` int(11) NOT NULL auto_increment,
  `points` int(11) NOT NULL default '0',
  `itemid1` int(11) NOT NULL default '0',
  `count1` int(11) NOT NULL default '0',
  `itemid2` int(11) NOT NULL default '0',
  `count2` int(11) NOT NULL default '0',
  `offer_type` varchar(255) default NULL,
  `offer_description` text NOT NULL,
  `offer_name` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
and
PHP: 
ALTER TABLE `accounts` ADD `premium_points` INT( 11 ) NOT NULL DEFAULT '0';
and
PHP: 
CREATE TABLE `z_shop_history_item` (
  `id` int(11) NOT NULL auto_increment,
  `to_name` varchar(255) NOT NULL default '0',
  `to_account` int(11) NOT NULL default '0',
  `from_nick` varchar(255) NOT NULL,
  `from_account` int(11) NOT NULL default '0',
  `price` int(11) NOT NULL default '0',
  `offer_id` int(11) NOT NULL default '0',
  `trans_state` varchar(255) NOT NULL,
  `trans_start` int(11) NOT NULL default '0',
  `trans_real` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
and
PHP: 
CREATE TABLE `z_shop_history_pacc` (
  `id` int(11) NOT NULL auto_increment,
  `to_name` varchar(255) NOT NULL default '0',
  `to_account` int(11) NOT NULL default '0',
  `from_nick` varchar(255) NOT NULL,
  `from_account` int(11) NOT NULL default '0',
  `price` int(11) NOT NULL default '0',
  `pacc_days` int(11) NOT NULL default '0',
  `trans_state` varchar(255) NOT NULL,
  `trans_start` int(11) NOT NULL default '0',
  `trans_real` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
Click to expand...

still getting this

[20/02/2009 18:21:14] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1;: MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list'
[20/02/2009 18:22:15] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1;: MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list'
[20/02/2009 18:23:16] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1;: MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list'
[20/02/2009 18:24:17] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1;: MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list'
[20/02/2009 18:25:18] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1;: MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list'
 
Upvote 0 Downvote
That's because you are using Powergamers and online time stats of Gesior too xDDD.

Do this:

In your MySQL database execute (in phpmyadmin):
PHP: 
ALTER TABLE `players` ADD `exphist_lastexp` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist1` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist2` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist3` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist4` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist5` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist6` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist7` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetimetoday` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime1` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime2` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime3` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime4` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime5` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime6` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime7` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetimeall` BIGINT( 255 ) NOT NULL DEFAULT '0';
and
PHP: 
UPDATE `players` SET `exphist_lastexp`=`players`.`experience`

[Gesior acc. maker][TFS 0.3]Powergamers and online time stats
 
Upvote 0 Downvote
Xampy said:
That's because you are using Powergamers and online time stats of Gesior too xDDD.

Do this:

In your MySQL database execute (in phpmyadmin):
PHP: 
ALTER TABLE `players` ADD `exphist_lastexp` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist1` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist2` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist3` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist4` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist5` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist6` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist7` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetimetoday` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime1` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime2` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime3` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime4` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime5` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime6` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime7` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetimeall` BIGINT( 255 ) NOT NULL DEFAULT '0';
and
PHP: 
UPDATE `players` SET `exphist_lastexp`=`players`.`experience`

[Gesior acc. maker][TFS 0.3]Powergamers and online time stats
Click to expand...

thanks but the shop buttons dont come up ^^
 
Upvote 0 Downvote
@up

Go to:

PHP: 
xampp/htdocs/config/config.php

Open that. Then change:

PHP: 
$config['site']['shop_system'] = 0;

to

PHP: 
$config['site']['shop_system'] = 1;
 
Upvote 0 Downvote
Master-z said:
@up

Go to:

PHP: 
xampp/htdocs/config/config.php

Open that. Then change:

PHP: 
$config['site']['shop_system'] = 0;

to

PHP: 
$config['site']['shop_system'] = 1;
Click to expand...

thanks alot i got another topic named temple postion and samples help! if you could help me with that one i would be very thankfull m8.

rep++ to you
 
Upvote 0 Downvote
For me nothing?? :(
I solved you the bugs you posted. I told you the links for the complete guide of the shop/powergamers script and you gave me only 1 point? :(!

Np if you dont give me rep++. I like to help people and then I wait a reward: maybe rep++ ...
 
Upvote 0 Downvote
@up

How can you give more points? :p

All I see is a rep button, I click on it, fill in a comment and after that it says 'You cannot give reputation to the same post twice.' and if I do another post then it says 'You need to spread some reputation around before giving it to ... again.' xD
 
Upvote 0 Downvote
@up:
Yes, I dont know xD. I have a black button (like green rep button but black, like talaturen rep) and it says that is "balanced rep", maybe because he didnt write a comment for my rep, I dont know.

PS thanks for rep++ me :p xD
 
Last edited:
Upvote 0 Downvote

Similar threads

WikiArk21
  • Question
Error MySql
Replies
0
Views
235
WikiArk21
WikiArk21
johnsamir
  • Question
how to solve these errors that has appeared in my database
Replies
2
Views
614
johnsamir
johnsamir
F
  • Question
TFS 1.X+ [tfs 1.4/1.5] edit database multiworld system
Replies
3
Views
622
lursky
L
Back
Top