[Antrix - Help needed] Import Querys.

S

SunBathing

Newbie Spellweaver
10 Happy Years
Joined
Apr 8, 2007
Messages
39
Reaction score
0
Hey there,

I'm trying to set up a Antrix server and I have got as far as importing the querys using SQLyog Community Edition. A Error keeps popping up saying "There was an error while executing a query.
The query and the error message has been logged at:
C:\Program Files\SQLyog Community\sqlyog.err.
Please click on "Open Error File..." to open the error file."

The error in the error log is: "Query:

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */
Error occured at:2007-07-21 22:37:33
Line no.:7
Error Code: 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 '
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */' at line 1
Query:

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */
Error occured at:2007-07-21 22:41:11
Line no.:7
Error Code: 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 '
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */' at line 1
Query:

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */
Error occured at:2007-07-22 10:05:56
Line no.:7
Error Code: 1064 - You have an error in your SQL syntax near '
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */' at line 1
Query:

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */
Error occured at:2007-07-22 10:05:59
Line no.:7
Error Code: 1064 - You have an error in your SQL syntax near '
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */' at line 1
Query:

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */
Error occured at:2007-07-22 10:07:58
Line no.:7
Error Code: 1064 - You have an error in your SQL syntax near '
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */' at line 1
Query:

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */
Error occured at:2007-07-22 10:08:17
Line no.:7
Error Code: 1064 - You have an error in your SQL syntax near '
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */' at line 1
Query:
CREATE TABLE `ai_agents` (
`entryId` int(6) NOT NULL default '0',
`AI_AGENT` int(2) NOT NULL default '0',
`procEvent` int(2) NOT NULL default '0',
`procChance` int(3) NOT NULL default '0',
`procCount` int(6) NOT NULL default '0',
`spellId` int(6) NOT NULL default '0',
`spellType` int(2) NOT NULL default '0',
`spelltargetType` int(2) NOT NULL default '0',
`spellCooldown` int(8) NOT NULL default '0',
`floatMisc1` float NOT NULL default '0',
`Misc2` int(6) NOT NULL default '0',
PRIMARY KEY (`entryId`,`AI_AGENT`,`spellId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2007-07-22 10:09:20
Line no.:36
Error Code: 1064 - You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 14
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(28) NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-07-22 10:10:17
Line no.:26
Error Code: 1064 - You have an error in your SQL syntax near 'on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email`' at line 7
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(28) NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-07-22 10:10:55
Line no.:26
Error Code: 1064 - You have an error in your SQL syntax near 'on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email`' at line 7
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(28) NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-07-22 10:12:11
Line no.:26
Error Code: 1064 - You have an error in your SQL syntax near 'on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email`' at line 7
Query:
CREATE TABLE `ai_agents` (
`entryId` int(6) NOT NULL default '0',
`AI_AGENT` int(2) NOT NULL default '0',
`procEvent` int(2) NOT NULL default '0',
`procChance` int(3) NOT NULL default '0',
`procCount` int(6) NOT NULL default '0',
`spellId` int(6) NOT NULL default '0',
`spellType` int(2) NOT NULL default '0',
`spelltargetType` int(2) NOT NULL default '0',
`spellCooldown` int(8) NOT NULL default '0',
`floatMisc1` float NOT NULL default '0',
`Misc2` int(6) NOT NULL default '0',
PRIMARY KEY (`entryId`,`AI_AGENT`,`spellId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2007-07-22 10:12:15
Line no.:36
Error Code: 1064 - You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 14
Query:

DROP TABLE IF EXISTS `ai_agents`
Error occured at:2007-07-22 10:13:00
Line no.:11
Error Code: 1064 - You have an error in your SQL syntax near '
DROP TABLE IF EXISTS `ai_agents`' at line 1
Query:

DROP TABLE IF EXISTS `ai_agents`
Error occured at:2007-07-22 10:13:28
Line no.:11
Error Code: 1064 - You have an error in your SQL syntax near '
DROP TABLE IF EXISTS `ai_agents`' at line 1
Query:

DROP TABLE IF EXISTS `ai_agents`
Error occured at:2007-07-22 10:18:15
Line no.:11
Error Code: 1064 - You have an error in your SQL syntax near '
DROP TABLE IF EXISTS `ai_agents`' at line 1
Query:
CREATE TABLE `ai_agents` (
`entryId` int(6) NOT NULL default '0',
`AI_AGENT` int(2) NOT NULL default '0',
`procEvent` int(2) NOT NULL default '0',
`procChance` int(3) NOT NULL default '0',
`procCount` int(6) NOT NULL default '0',
`spellId` int(6) NOT NULL default '0',
`spellType` int(2) NOT NULL default '0',
`spelltargetType` int(2) NOT NULL default '0',
`spellCooldown` int(8) NOT NULL default '0',
`floatMisc1` float NOT NULL default '0',
`Misc2` int(6) NOT NULL default '0',
PRIMARY KEY (`entryId`,`AI_AGENT`,`spellId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2007-07-22 10:29:48
Line no.:36
Error Code: 1064 - You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 14
Query:
CREATE TABLE `ai_agents` (
`entryId` int(6) NOT NULL default '0',
`AI_AGENT` int(2) NOT NULL default '0',
`procEvent` int(2) NOT NULL default '0',
`procChance` int(3) NOT NULL default '0',
`procCount` int(6) NOT NULL default '0',
`spellId` int(6) NOT NULL default '0',
`spellType` int(2) NOT NULL default '0',
`spelltargetType` int(2) NOT NULL default '0',
`spellCooldown` int(8) NOT NULL default '0',
`floatMisc1` float NOT NULL default '0',
`Misc2` int(6) NOT NULL default '0',
PRIMARY KEY (`entryId`,`AI_AGENT`,`spellId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2007-07-22 10:30:00
Line no.:36
Error Code: 1064 - You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 14
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(28) NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-07-22 10:30:20
Line no.:26
Error Code: 1064 - You have an error in your SQL syntax near 'on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email`' at line 7
Query:
CREATE TABLE `ai_agents` (
`entryId` int(6) NOT NULL default '0',
`AI_AGENT` int(2) NOT NULL default '0',
`procEvent` int(2) NOT NULL default '0',
`procChance` int(3) NOT NULL default '0',
`procCount` int(6) NOT NULL default '0',
`spellId` int(6) NOT NULL default '0',
`spellType` int(2) NOT NULL default '0',
`spelltargetType` int(2) NOT NULL default '0',
`spellCooldown` int(8) NOT NULL default '0',
`floatMisc1` float NOT NULL default '0',
`Misc2` int(6) NOT NULL default '0',
PRIMARY KEY (`entryId`,`AI_AGENT`,`spellId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2007-07-22 10:42:06
Line no.:36
Error Code: 1064 - You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 14
Query:
CREATE TABLE `ai_agents` (
`entryId` int(6) NOT NULL default '0',
`AI_AGENT` int(2) NOT NULL default '0',
`procEvent` int(2) NOT NULL default '0',
`procChance` int(3) NOT NULL default '0',
`procCount` int(6) NOT NULL default '0',
`spellId` int(6) NOT NULL default '0',
`spellType` int(2) NOT NULL default '0',
`spelltargetType` int(2) NOT NULL default '0',
`spellCooldown` int(8) NOT NULL default '0',
`floatMisc1` float NOT NULL default '0',
`Misc2` int(6) NOT NULL default '0',
PRIMARY KEY (`entryId`,`AI_AGENT`,`spellId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2007-07-22 10:42:08
Line no.:36
Error Code: 1064 - You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 14
Query:
CREATE TABLE `ai_agents` (
`entryId` int(6) NOT NULL default '0',
`AI_AGENT` int(2) NOT NULL default '0',
`procEvent` int(2) NOT NULL default '0',
`procChance` int(3) NOT NULL default '0',
`procCount` int(6) NOT NULL default '0',
`spellId` int(6) NOT NULL default '0',
`spellType` int(2) NOT NULL default '0',
`spelltargetType` int(2) NOT NULL default '0',
`spellCooldown` int(8) NOT NULL default '0',
`floatMisc1` float NOT NULL default '0',
`Misc2` int(6) NOT NULL default '0',
PRIMARY KEY (`entryId`,`AI_AGENT`,`spellId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2007-07-22 10:46:27
Line no.:36
Error Code: 1064 - You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 14
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(28) NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-07-22 10:49:55
Line no.:26
Error Code: 1064 - You have an error in your SQL syntax near 'on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email`' at line 7
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(28) NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-07-22 10:50:41
Line no.:26
Error Code: 1064 - You have an error in your SQL syntax near 'on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email`' at line 7
Query:
CREATE TABLE `ai_agents` (
`entryId` int(6) NOT NULL default '0',
`AI_AGENT` int(2) NOT NULL default '0',
`procEvent` int(2) NOT NULL default '0',
`procChance` int(3) NOT NULL default '0',
`procCount` int(6) NOT NULL default '0',
`spellId` int(6) NOT NULL default '0',
`spellType` int(2) NOT NULL default '0',
`spelltargetType` int(2) NOT NULL default '0',
`spellCooldown` int(8) NOT NULL default '0',
`floatMisc1` float NOT NULL default '0',
`Misc2` int(6) NOT NULL default '0',
PRIMARY KEY (`entryId`,`AI_AGENT`,`spellId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2007-07-22 10:54:55
Line no.:36
Error Code: 1064 - You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 14
Query:
CREATE TABLE `ai_agents` (
`entryId` int(6) NOT NULL default '0',
`AI_AGENT` int(2) NOT NULL default '0',
`procEvent` int(2) NOT NULL default '0',
`procChance` int(3) NOT NULL default '0',
`procCount` int(6) NOT NULL default '0',
`spellId` int(6) NOT NULL default '0',
`spellType` int(2) NOT NULL default '0',
`spelltargetType` int(2) NOT NULL default '0',
`spellCooldown` int(8) NOT NULL default '0',
`floatMisc1` float NOT NULL default '0',
`Misc2` int(6) NOT NULL default '0',
PRIMARY KEY (`entryId`,`AI_AGENT`,`spellId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2007-07-22 11:08:24
Line no.:36
Error Code: 1064 - You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 14
Query:
CREATE TABLE `ai_agents` (
`entryId` int(6) NOT NULL default '0',
`AI_AGENT` int(2) NOT NULL default '0',
`procEvent` int(2) NOT NULL default '0',
`procChance` int(3) NOT NULL default '0',
`procCount` int(6) NOT NULL default '0',
`spellId` int(6) NOT NULL default '0',
`spellType` int(2) NOT NULL default '0',
`spelltargetType` int(2) NOT NULL default '0',
`spellCooldown` int(8) NOT NULL default '0',
`floatMisc1` float NOT NULL default '0',
`Misc2` int(6) NOT NULL default '0',
PRIMARY KEY (`entryId`,`AI_AGENT`,`spellId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2007-07-22 11:08:41
Line no.:36
Error Code: 1064 - You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 14
Query:
CREATE TABLE `ai_agents` (
`entryId` int(6) NOT NULL default '0',
`AI_AGENT` int(2) NOT NULL default '0',
`procEvent` int(2) NOT NULL default '0',
`procChance` int(3) NOT NULL default '0',
`procCount` int(6) NOT NULL default '0',
`spellId` int(6) NOT NULL default '0',
`spellType` int(2) NOT NULL default '0',
`spelltargetType` int(2) NOT NULL default '0',
`spellCooldown` int(8) NOT NULL default '0',
`floatMisc1` float NOT NULL default '0',
`Misc2` int(6) NOT NULL default '0',
PRIMARY KEY (`entryId`,`AI_AGENT`,`spellId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2007-07-22 11:12:24
Line no.:36
Error Code: 1064 - You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 14
Query:
CREATE TABLE `ai_agents` (
`entryId` int(6) NOT NULL default '0',
`AI_AGENT` int(2) NOT NULL default '0',
`procEvent` int(2) NOT NULL default '0',
`procChance` int(3) NOT NULL default '0',
`procCount` int(6) NOT NULL default '0',
`spellId` int(6) NOT NULL default '0',
`spellType` int(2) NOT NULL default '0',
`spelltargetType` int(2) NOT NULL default '0',
`spellCooldown` int(8) NOT NULL default '0',
`floatMisc1` float NOT NULL default '0',
`Misc2` int(6) NOT NULL default '0',
PRIMARY KEY (`entryId`,`AI_AGENT`,`spellId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2007-07-22 11:18:24
Line no.:36
Error Code: 1064 - You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 14
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(28) NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-07-22 11:18:32
Line no.:26
Error Code: 1064 - You have an error in your SQL syntax near 'on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email`' at line 7
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(28) NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-07-22 11:21:29
Line no.:26
Error Code: 1064 - You have an error in your SQL syntax near 'on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email`' at line 7
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(28) NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-07-22 11:28:59
Line no.:26
Error Code: 1064 - You have an error in your SQL syntax near 'on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email`' at line 7
Query:
UPDATE `items` SET `stat_type1`='0' WHERE `stat_type1`='-1'
Error occured at:2007-07-22 11:31:13
Line no.:1
Error Code: 1146 - Table 'Antrix1.items' doesn't exist
Query:
CREATE TABLE `ai_agents` (
`entryId` int(6) NOT NULL default '0',
`AI_AGENT` int(2) NOT NULL default '0',
`procEvent` int(2) NOT NULL default '0',
`procChance` int(3) NOT NULL default '0',
`procCount` int(6) NOT NULL default '0',
`spellId` int(6) NOT NULL default '0',
`spellType` int(2) NOT NULL default '0',
`spelltargetType` int(2) NOT NULL default '0',
`spellCooldown` int(8) NOT NULL default '0',
`floatMisc1` float NOT NULL default '0',
`Misc2` int(6) NOT NULL default '0',
PRIMARY KEY (`entryId`,`AI_AGENT`,`spellId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2007-07-22 11:32:00
Line no.:36
Error Code: 1064 - You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 14
Query:
CREATE TABLE `ai_agents` (
`entryId` int(6) NOT NULL default '0',
`AI_AGENT` int(2) NOT NULL default '0',
`procEvent` int(2) NOT NULL default '0',
`procChance` int(3) NOT NULL default '0',
`procCount` int(6) NOT NULL default '0',
`spellId` int(6) NOT NULL default '0',
`spellType` int(2) NOT NULL default '0',
`spelltargetType` int(2) NOT NULL default '0',
`spellCooldown` int(8) NOT NULL default '0',
`floatMisc1` float NOT NULL default '0',
`Misc2` int(6) NOT NULL default '0',
PRIMARY KEY (`entryId`,`AI_AGENT`,`spellId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Error occured at:2007-07-22 11:32:07
Line no.:36
Error Code: 1064 - You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 14
Query:

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */
Error occured at:2007-07-22 11:33:49
Line no.:7
Error Code: 1064 - You have an error in your SQL syntax near '
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */' at line 1
Query:

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */
Error occured at:2007-07-22 11:34:36
Line no.:7
Error Code: 1064 - You have an error in your SQL syntax near '
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */' at line 1
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(28) NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-07-22 11:34:45
Line no.:26
Error Code: 1064 - You have an error in your SQL syntax near 'on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email`' at line 7
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(28) NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-07-22 11:41:25
Line no.:26
Error Code: 1064 - You have an error in your SQL syntax near 'on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email`' at line 7
Query:
INSERT INTO `creatureloot` VALUES (593432,23420,32362,10),(593433,23420,32345,10),(593434,23420,32354,10),(593435,23420,32352,10)
Error occured at:2007-07-22 11:41:46
Line no.:1
Error Code: 1146 - Table 'antrix.creatureloot' doesn't exist
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(28) NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-07-22 11:41:49
Line no.:26
Error Code: 1064 - You have an error in your SQL syntax near 'on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email`' at line 7
Query:
INSERT INTO `creatureloot` VALUES (593412,22917,32837,5),(593413,22917,32838,5),(593414,22917,31091,100),(593415,22917,31090,100),(593416,22917,31089,100),(593417,22917,32375,10),(593418,22917,32374,10),(593419,22917,32497,10),(593420,22917,32496,10),(593421,22917,32500,10),(593422,22917,32525,10),(593423,22917,32471,10),(593424,22917,32336,10),(593425,22917,32524,10),(593426,22917,32483,10),(593427,22917,32235,10),(593431,22917,32521,10)
Error occured at:2007-07-22 11:41:52
Line no.:1
Error Code: 1146 - Table 'antrix.creatureloot' doesn't exist
Query:
UPDATE `items` SET `stat_type1`='0' WHERE `stat_type1`='-1'
Error occured at:2007-07-22 11:42:05
Line no.:1
Error Code: 1146 - Table 'antrix.items' doesn't exist
Query:
UPDATE `items` SET `stat_type1`='0' WHERE `stat_type1`='-1'
Error occured at:2007-07-22 11:45:40
Line no.:1
Error Code: 1146 - Table 'antrix.items' doesn't exist
Query:
UPDATE `items` SET `stat_type1`='0' WHERE `stat_type1`='-1'
Error occured at:2007-07-22 11:48:12
Line no.:1
Error Code: 1146 - Table 'mysql.items' doesn't exist
Query:
UPDATE `items` SET `stat_type1`='0' WHERE `stat_type1`='-1'
Error occured at:2007-07-22 11:48:28
Line no.:1
Error Code: 1146 - Table 'Antrix1.items' doesn't exist
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(28) NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-07-22 14:25:52
Line no.:25
Error Code: 1064 - You have an error in your SQL syntax near 'on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email`' at line 7
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(28) NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-07-22 14:26:09
Line no.:25
Error Code: 1064 - You have an error in your SQL syntax near 'on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email`' at line 7
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(28) NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-07-22 14:33:06
Line no.:25
Error Code: 1064 - You have an error in your SQL syntax near 'on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email`' at line 7
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(28) NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-07-22 14:33:08
Line no.:25
Error Code: 1064 - You have an error in your SQL syntax near 'on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email`' at line 7
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(28) NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-07-22 14:34:23
Line no.:25
Error Code: 1064 - You have an error in your SQL syntax near 'on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email`' at line 7
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(28) NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-07-22 14:40:49
Line no.:25
Error Code: 1064 - You have an error in your SQL syntax near 'on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email`' at line 7"

Could anyone help?
 
You must log in or register to reply here.

RaGEZONE Sponsor

    HyperFilter

About RaGEZONE

RaGEZONE® is the top forum for MMO, MMORPG, and mobile game development. We provide binaries, source codes, and tutorials for your favorite games, making it the go-to resource for developers and fans. You can also find and share private servers, fostering a vibrant gamer community.

Forum Statistics

Members online
1,119
Guests online
3,905
Total visitors
5,024
Totals may include hidden visitors.

RaGEZONE Partners

    nongamstopbets.com UK sites not on GamStop Casino Deps NZ
Back