Mysql Error

[Softman]

Can Any one Help

 

[Rombadr]

Run this query

CREATE TABLE IF NOT EXISTS `dtt_players` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pid` bigint(20) NOT NULL,
  `team` int(5) NOT NULL,
  `ip` bigint(50) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

I doubt it's gonna be the only error, it seems like you might need the following table too:

CREATE TABLE IF NOT EXISTS `dtt_results` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `frags_blue` int(11) NOT NULL,
  `frags_red` int(11) NOT NULL,
  `towers_blue` int(11) NOT NULL,
  `towers_red` int(11) NOT NULL,
  `data` varchar(255) CHARACTER SET utf8 COLLATE utf8_swedish_ci NOT NULL,
  `hora` varchar(255) CHARACTER SET utf8 COLLATE utf8_swedish_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

[Softman]

REATE TABLE IF NOT EXISTS dtt_players (
No work
#1064 - 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 'REATE TABLE IF NOT EXISTS dtt_players ( id int(11) NOT NULL AUTO_INCREMEN' at line 1
REATE TABLE IF NOT EXISTS dtt_players (

 

[Evil Puncker]

change REATE to CREATE

 

[Softman]

Right
i dont see

 

[Softman]

mysql_real_query(): DELETE FROM guild_wars WHERE status = 0 AND begin < 1590847129; - MYSQL ERROR: Unknown column 'begin' in 'where clause' (1054)

 

[Leesne]

guild_wars doesn't have begin column.
also that image. please learn to crop. my eyes.

 

[Softman]

i need a code do you can give me

 

[Leesne]

You haven't even put any information about the server you run etc.
Nor have you posted the code for the the script you are having the issue with.

tfs1.3 uses started for its date and not begin etc.

 

[Softman]

was working in my ots

 

[Leesne]

I don't have access to the older otx code but look at globalevents\scripts and look for a startup script

you are looking for the code

DELETE FROM `guild_wars` WHERE `status` = 0 AND `begin`

change begin to started

 

[Softman]

no work
#1054 - Unknown column 'begin' in 'where clause'
DELETE FROM guild_wars WHERE status =0 AND begin

 

[Leesne]

omg -.-
You need to find that code, and just replace the word "begin" with "started", which is what is missing in your table, so it matches.

 

[Softman]

where?
[1/6/2020 18:41:9] mysql_real_query(): DELETE FROM guild_wars WHERE status = 0 AND begin < 1590856869; - MYSQL ERROR: Unknown column 'begin' in 'where clause' (1054)

CREATE TABLE `guild_wars` (
  `id` int(11) NOT NULL,
  `guild1` int(11) NOT NULL DEFAULT '0',
  `guild2` int(11) NOT NULL DEFAULT '0',
  `name1` varchar(255) NOT NULL,
  `name2` varchar(255) NOT NULL,
  `status` tinyint(2) NOT NULL DEFAULT '0',
  `started` bigint(15) NOT NULL DEFAULT '0',
  `ended` bigint(15) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

 

[Leesne]

I don't have access to the older otx code but look at globalevents\scripts and look for a startup script

you are looking for the code

DELETE FROM `guild_wars` WHERE `status` = 0 AND `begin`

change begin to started

I told you in this post.

 

[Softman]

#1054 - Unknown column 'begin' in 'where clause'
DELETE FROM guild_wars WHERE status =0 AND begin


no work

 

[Leesne]

try again. you are not running that code. you are finding it in the globalevents file and replacing a word.

 

[Softman]

Guild war Was working but when i change my vps
i lose all code of guild war
my guild war work good
but all i need code