mySQL error

berry05 · December 6, 2008

i keepg etting this error when trying to uplaod a file to mySQL....

#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 'Ã

dezkit · December 6, 2008

LOL POST YER MYSQL QUERY PLZ

berry05 · December 6, 2008

ÁÄ db1663b íà localhost 
# phpMyAdmin SQL Dump
# version 2.5.3
# http://www.phpmyadmin.net
#
# Õîñò: localhost
# Âðåìÿ ñîçäàíèÿ: Ìàé 08 2004 ã., 08:15
# Âåðñèÿ ñåðâåðà: 4.0.16
# Âåðñèÿ PHP: 4.3.3
# 
# ÁÄ : `db1663b`
# 

# --------------------------------------------------------

#
# Ñòðóêòóðà òàáëèöû `AtackLog`
#

CREATE TABLE `AtackLog` (
  `ID` int(11) NOT NULL auto_increment,
  `userID` int(11) NOT NULL default '0',
  `toUserID` int(11) NOT NULL default '0',
  `atackTurns` int(11) NOT NULL default '0',
  `atackStrength` int(11) NOT NULL default '0',
  `defStrength` int(11) NOT NULL default '0',
  `gold` int(11) NOT NULL default '0',
  `phrase` varchar(255) NOT NULL default '',
  `atackUsersKilled` int(11) NOT NULL default '0',
  `defUsersKilled` int(11) NOT NULL default '0',
  `atackTrained` int(11) NOT NULL default '0',
  `atackUnTrained` int(11) NOT NULL default '0',
  `defTrained` int(11) NOT NULL default '0',
  `defUnTrained` int(11) NOT NULL default '0',
  `atackWeapons` varchar(255) NOT NULL default '',
  `defWeapons` varchar(255) NOT NULL default '',
  `atackWeaponWas` varchar(255) NOT NULL default '',
  `atackWeaponIs` varchar(255) NOT NULL default '',
  `time` int(11) NOT NULL default '0',
  `atackWeaponCount` varchar(255) NOT NULL default '',
  `defWeaponWas` varchar(255) NOT NULL default '',
  `defWeaponIs` varchar(255) NOT NULL default '',
  `defWeaponCount` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=63 ;

#
# Äàìï äàííûõ òàáëèöû `AtackLog`
#


# --------------------------------------------------------

#
# Ñòðóêòóðà òàáëèöû `IPs`
#

CREATE TABLE `IPs` (
  `ID` int(11) NOT NULL auto_increment,
  `ip` varchar(15) NOT NULL default '',
  `userID` int(11) NOT NULL default '0',
  `time` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=14 ;

#
# Äàìï äàííûõ òàáëèöû `IPs`
#

INSERT INTO `IPs` (`ID`, `ip`, `userID`, `time`) VALUES (1, '67.67.147.81', 0, 1083710034),
(2, '194.146.134.4', 0, 1083709874),
(3, '67.67.147.81', 41, 1083711236),
(4, '67.67.147.81', 42, 1083711472),
(5, '67.67.147.81', 43, 1083711525),
(6, '67.67.147.81', 44, 1083711607),
(7, '24.55.128.133', 45, 1083764140),
(8, '24.55.128.133', 46, 1083764260),
(9, '66.139.248.248', 20, 1083987485),
(10, '66.139.248.248', 27, 1083987507),
(11, '66.139.248.248', 28, 1083987541),
(12, '194.146.134.4', 25, 1083987609),
(13, '194.146.134.4', 28, 1083987786);

# --------------------------------------------------------

#
# Ñòðóêòóðà òàáëèöû `Mercenaries`
#

CREATE TABLE `Mercenaries` (
  `attackSpecCount` int(11) NOT NULL default '0',
  `defSpecCount` int(11) NOT NULL default '0',
  `untrainedCount` int(11) NOT NULL default '0',
  `lastTurnTime` int(11) NOT NULL default '0'
) TYPE=MyISAM;

#
# Äàìï äàííûõ òàáëèöû `Mercenaries`
#

INSERT INTO `Mercenaries` (`attackSpecCount`, `defSpecCount`, `untrainedCount`, `lastTurnTime`) VALUES (215, 215, 215, 1083963719);

# --------------------------------------------------------

#
# Ñòðóêòóðà òàáëèöû `Messages`
#

CREATE TABLE `Messages` (
  `ID` int(11) NOT NULL auto_increment,
  `userID` int(11) NOT NULL default '0',
  `fromID` int(11) NOT NULL default '0',
  `subject` varchar(255) NOT NULL default '',
  `text` text NOT NULL,
  `date` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=7 ;

#
# Äàìï äàííûõ òàáëèöû `Messages`
#


# --------------------------------------------------------

#
# Ñòðóêòóðà òàáëèöû `Ranks`
#

CREATE TABLE `Ranks` (
  `ID` int(11) NOT NULL auto_increment,
  `userID` int(11) NOT NULL default '0',
  `rank` int(11) NOT NULL default '0',
  `strikeActionRank` int(11) NOT NULL default '0',
  `defenceActionRank` int(11) NOT NULL default '0',
  `covertActionRank` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=38 ;

#
# Äàìï äàííûõ òàáëèöû `Ranks`
#

INSERT INTO `Ranks` (`ID`, `userID`, `rank`, `strikeActionRank`, `defenceActionRank`, `covertActionRank`) VALUES (11, 20, 3, 4, 3, 2),
(35, 44, 0, 0, 0, 0),
(15, 24, 0, 0, 0, 0),
(16, 25, 0, 0, 0, 0),
(18, 27, 5, 5, 5, 1),
(17, 26, 2, 2, 2, 4),
(19, 28, 4, 3, 4, 3),
(37, 46, 6, 6, 6, 6),
(34, 43, 0, 0, 0, 0),
(33, 42, 0, 0, 0, 0),
(32, 41, 0, 0, 0, 0);

# --------------------------------------------------------

#
# Ñòðóêòóðà òàáëèöû `SpyLog`
#

CREATE TABLE `SpyLog` (
  `ID` int(11) NOT NULL auto_increment,
  `userID` int(11) NOT NULL default '0',
  `toUserID` int(11) NOT NULL default '0',
  `spyStrength` int(11) NOT NULL default '0',
  `spyDefStrength` int(11) NOT NULL default '0',
  `trainedAttackSold` varchar(15) NOT NULL default '',
  `trainedAttackMerc` varchar(15) NOT NULL default '',
  `trainedDefSold` varchar(15) NOT NULL default '',
  `trainedDefMerc` varchar(15) NOT NULL default '',
  `untrainedMerc` varchar(15) NOT NULL default '',
  `untrainedSold` varchar(15) NOT NULL default '',
  `strikeAction` varchar(15) NOT NULL default '',
  `defenceAction` varchar(15) NOT NULL default '',
  `covertSkill` varchar(15) NOT NULL default '',
  `covertOperatives` varchar(15) NOT NULL default '',
  `siegeLevel` varchar(15) NOT NULL default '',
  `atackTurns` varchar(15) NOT NULL default '',
  `unitProduction` varchar(15) NOT NULL default '',
  `weapons` varchar(255) NOT NULL default '',
  `types` varchar(255) NOT NULL default '',
  `types2` varchar(255) NOT NULL default '',
  `quantities` varchar(255) NOT NULL default '',
  `strengths` varchar(255) NOT NULL default '',
  `allStrengths` varchar(255) NOT NULL default '',
  `time` int(11) NOT NULL default '0',
  `spies` int(11) NOT NULL default '0',
  `isSuccess` tinyint(1) NOT NULL default '0',
  `race` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=38 ;

#
# Äàìï äàííûõ òàáëèöû `SpyLog`
#


# --------------------------------------------------------

#
# Ñòðóêòóðà òàáëèöû `UserDetails`
#

CREATE TABLE `UserDetails` (
  `ID` int(11) NOT NULL auto_increment,
  `userName` varchar(100) NOT NULL default '',
  `race` tinyint(4) NOT NULL default '0',
  `e_mail` varchar(255) NOT NULL default '',
  `password` varchar(50) NOT NULL default '',
  `commander` int(11) NOT NULL default '0',
  `active` int(1) NOT NULL default '0',
  `uniqueLink` varchar(12) NOT NULL default '',
  `fortificationLevel` int(11) NOT NULL default '0',
  `siegeLevel` int(11) NOT NULL default '0',
  `gold` int(11) NOT NULL default '0',
  `attackTurns` int(11) NOT NULL default '0',
  `currentUnitProduction` int(11) default NULL,
  `currentSpySkill` int(11) default NULL,
  `trainedAttackSold` int(11) default NULL,
  `trainedAttackMerc` int(11) default NULL,
  `trainedDefSold` int(11) default NULL,
  `trainedDefMerc` int(11) default NULL,
  `untrainedSold` float default NULL,
  `untrainedMerc` int(11) default NULL,
  `spies` int(11) default NULL,
  `lastTurnTime` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=49 ;

#
# Äàìï äàííûõ òàáëèöû `UserDetails`
#

INSERT INTO `UserDetails` (`ID`, `userName`, `race`, `e_mail`, `password`, `commander`, `active`, `uniqueLink`, `fortificationLevel`, `siegeLevel`, `gold`, `attackTurns`, `currentUnitProduction`, `currentSpySkill`, `trainedAttackSold`, `trainedAttackMerc`, `trainedDefSold`, `trainedDefMerc`, `untrainedSold`, `untrainedMerc`, `spies`, `lastTurnTime`) VALUES (27, 'user13', 2, '[email protected]', '1', 0, 1, 'uk4610829096', 1, 1, 2053218, 180, 24, 38, 21, 864, 490, 1831, '1580', 1049, 237, 1083987525),
(28, 'user5', 3, '[email protected]', '1', 0, 1, 'uu3310829096', 3, 3, 1, 1, 80, 25, 1, 1, 1, 1, '1', 1, 223, 1083987973),
(44, 'xvxczcxddaa', 0, '[email protected]', '32800635', 0, 0, 'sl1083711607', 0, 0, 2800, 17, 0, 0, 0, 0, 0, 0, '1', 0, 0, 1083711607),
(20, 'user6', 1, '[email protected]', '1', 0, 1, 'yt2010829096', 1, 0, 7171076, 221, 55, 28, 1582, 1716, 719, 1084, '4264', 1365, 1237, 1089727410),
(46, 'jason', 0, '[email protected]', 'internet', 0, 1, 'ep1083764260', 0, 0, 3699, 46, 0, 0, 0, 0, 0, 0, '1', 0, 0, 1083764636),
(26, 'user12', 1, '[email protected]', '1', 0, 1, 'ab6810829096', 3, 1, 9071948, 210, 91, 18, 1770, 912, 1850, 1959, '5651', 459, 808, 1090281246),
(25, 'user11', 1, '[email protected]', '1', 0, 0, 'df8510829096', 2, 2, 83874, 98, 13, 0, 1670, 654, 1047, 979, '1273', 527, 207, 1083611939),
(24, 'user10', 2, '[email protected]', '1', 0, 0, 'iu2421082909', 2, 2, 132483, 75, 92, 79, 1146, 1197, 1, 1881, '1998', 1881, 772, 1084659030),
(43, 'xvxczcxdd', 0, '[email protected]', '40447503', 0, 0, 'ez1083711525', 0, 0, 2800, 17, 0, 0, 0, 0, 0, 0, '1', 0, 0, 1083711525),
(42, 'xvxczcx', 0, '[email protected]', '34349144', 0, 0, 'rg1083711472', 0, 0, 2800, 17, 0, 0, 0, 0, 0, 0, '1', 0, 0, 1083711472),
(41, 'sfdsfsfd', 2, '[email protected]', '33360663', 0, 0, 'ql1083711236', 0, 0, 2800, 17, 0, 0, 0, 0, 0, 0, '1', 0, 0, 1083711236),
(45, 'tsunami', 0, '[email protected]', '65882608', 0, 0, 'pi1083764140', 0, 0, 806, 43, 0, 0, 0, 0, 0, 0, '1', 0, 0, 1083765813),
(48, 'admin', 0, '[email protected]', '1', 0, 4, '', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);

# --------------------------------------------------------

#
# Ñòðóêòóðà òàáëèöû `Weapon`
#

CREATE TABLE `Weapon` (
  `ID` int(11) NOT NULL auto_increment,
  `weaponID` int(11) NOT NULL default '0',
  `weaponStrength` int(11) NOT NULL default '0',
  `weaponCount` int(11) NOT NULL default '0',
  `isAtack` int(11) NOT NULL default '0',
  `userID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=25 ;

#
# Äàìï äàííûõ òàáëèöû `Weapon`
#

INSERT INTO `Weapon` (`ID`, `weaponID`, `weaponStrength`, `weaponCount`, `isAtack`, `userID`) VALUES (24, 0, 10, 1, 0, 45),
(23, 0, 5, 1, 1, 45);

# --------------------------------------------------------

#
# Ñòðóêòóðà òàáëèöû `c_ban_users`
#

CREATE TABLE `c_ban_users` (
  `username` varchar(30) NOT NULL default '',
  `latin1` tinyint(1) NOT NULL default '0',
  `ip` varchar(16) NOT NULL default '',
  `rooms` varchar(100) NOT NULL default '',
  `ban_until` int(11) NOT NULL default '0'
) TYPE=MyISAM;

#
# Äàìï äàííûõ òàáëèöû `c_ban_users`
#


# --------------------------------------------------------

#
# Ñòðóêòóðà òàáëèöû `c_messages`
#

CREATE TABLE `c_messages` (
  `type` tinyint(1) NOT NULL default '0',
  `room` varchar(30) NOT NULL default '',
  `username` varchar(30) NOT NULL default '',
  `latin1` tinyint(1) NOT NULL default '0',
  `m_time` int(11) NOT NULL default '0',
  `address` varchar(30) NOT NULL default '',
  `message` text NOT NULL
) TYPE=MyISAM;

#
# Äàìï äàííûõ òàáëèöû `c_messages`
#

INSERT INTO `c_messages` (`type`, `room`, `username`, `latin1`, `m_time`, `address`, `message`) VALUES (1, 'Default', 'SYS enter', 0, 1080955692, '', 'sprintf(L_ENTER_ROM, "vv")'),
(1, 'Default', 'SYS welcome', 0, 1080956641, 'vv', 'sprintf("Welcome to our chat. Please obey the net etiquette while chatting: <I>try to be pleasant and polite</I>.")'),
(1, 'Default', 'vv', 1, 1080955707, '', '<FONT COLOR="#000000">fuck</FONT>'),
(1, 'Default', 'vv', 1, 1080955710, '', '<FONT COLOR="#000000">dfgdfg</FONT>'),
(1, 'Default', 'vv', 1, 1080955715, '', '<FONT COLOR="#3ffc40">dsfsdf</FONT>'),
(1, 'Default', 'vv', 1, 1080955718, '', '<FONT COLOR="#a503d3">sdfsdf</FONT>'),
(1, 'Default', 'SYS enter', 0, 1080955950, '', 'sprintf(L_ENTER_ROM, "rrrr")'),
(1, 'Default', 'SYS welcome', 0, 1080955951, 'rrrr', 'sprintf("Welcome to our chat. Please obey the net etiquette while chatting: <I>try to be pleasant and polite</I>.")'),
(1, 'Default', 'rrrr', 1, 1080955973, '', '<FONT COLOR="#000000">vv> rrr</FONT>'),
(1, 'Default', 'SYS enter', 0, 1080955995, '', 'sprintf(L_ENTER_ROM, "ee")'),
(1, 'Default', 'SYS welcome', 0, 1080956023, 'ee', 'sprintf("Welcome to our chat. Please obey the net etiquette while chatting: <I>try to be pleasant and polite</I>.")'),
(1, 'Default', 'SYS exit', 0, 1080956012, '', 'sprintf(L_EXIT_ROM, "ee")'),
(1, 'MyRoom1', 'SYS enter', 0, 1080956012, '', 'sprintf(L_ENTER_ROM, "ee")'),
(1, 'MyRoom1', 'SYS exit', 0, 1080956016, '', 'sprintf(L_EXIT_ROM, "ee")'),
(1, 'MyRoom2', 'SYS enter', 0, 1080956017, '', 'sprintf(L_ENTER_ROM, "ee")'),
(1, 'MyRoom2', 'SYS exit', 0, 1080956022, '', 'sprintf(L_EXIT_ROM, "ee")'),
(1, 'Default', 'SYS enter', 0, 1080956022, '', 'sprintf(L_ENTER_ROM, "ee")'),
(1, 'Default', 'SYS enter', 0, 1080956640, '', 'sprintf(L_ENTER_ROM, "vv")'),
(1, 'Default', 'SYS enter', 0, 1080979836, '', 'sprintf(L_ENTER_ROM, "iii")'),
(1, 'Default', 'SYS welcome', 0, 1080979837, 'iii', 'sprintf("Welcome to our chat. Please obey the net etiquette while chatting: <I>try to be pleasant and polite</I>.")'),
(1, 'Default', 'iii', 1, 1080979862, '', '<FONT COLOR="#000000">ghgfhg</FONT>');

# --------------------------------------------------------

#
# Ñòðóêòóðà òàáëèöû `c_reg_users`
#

CREATE TABLE `c_reg_users` (
  `username` varchar(30) NOT NULL default '',
  `latin1` tinyint(1) NOT NULL default '0',
  `password` varchar(32) NOT NULL default '',
  `firstname` varchar(64) NOT NULL default '',
  `lastname` varchar(64) NOT NULL default '',
  `country` varchar(64) NOT NULL default '',
  `website` varchar(64) NOT NULL default '',
  `email` varchar(64) NOT NULL default '',
  `showemail` tinyint(1) NOT NULL default '0',
  `perms` varchar(9) NOT NULL default '',
  `rooms` varchar(128) NOT NULL default '',
  `reg_time` int(11) NOT NULL default '0',
  `ip` varchar(16) NOT NULL default '',
  `gender` tinyint(1) NOT NULL default '0'
) TYPE=MyISAM;

#
# Äàìï äàííûõ òàáëèöû `c_reg_users`
#

INSERT INTO `c_reg_users` (`username`, `latin1`, `password`, `firstname`, `lastname`, `country`, `website`, `email`, `showemail`, `perms`, `rooms`, `reg_time`, `ip`, `gender`) VALUES ('admin', 0, '21232f297a57a5a743894a0e4a801fc3', '', '', '', '', '', 0, 'admin', '', 0, '', 0),
('vv', 1, 'c4055e3a20b6b3af3d10590ea446ef6c', 'vv', 'vv', '', '', '[email protected]', 0, 'user', '', 1080956640, '127.0.0.1', 0);

# --------------------------------------------------------

#
# Ñòðóêòóðà òàáëèöû `c_users`
#

CREATE TABLE `c_users` (
  `room` varchar(30) NOT NULL default '',
  `username` varchar(30) NOT NULL default '',
  `latin1` tinyint(1) NOT NULL default '0',
  `u_time` int(11) NOT NULL default '0',
  `status` char(1) NOT NULL default '',
  `ip` varchar(16) NOT NULL default '',
  UNIQUE KEY `room` (`room`,`username`)
) TYPE=MyISAM;

#
# Äàìï äàííûõ òàáëèöû `c_users`
#


# --------------------------------------------------------

Philip · December 6, 2008

I could be mistaken, but your first line is missing #

(haven't worked with sql dumps for a while, but thats what it looks like to me)

Sign In

mySQL error

Recommended Posts

berry05

Link to comment

Share on other sites

dezkit

Link to comment

Share on other sites

berry05

Link to comment

Share on other sites

Philip

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information