sql yukleme sorunu ( hiç bir sorgu calıstıramıyorum)

apache2triad kurdum sayfaları calıstıryor bi sroun yok amasql yuklemsine gelince kocam bir sorunla karşılaşıyorum hiç bir sql dosyasını yukluemyo
elimde bi script var kurulumanu geliyorum sqlları yukle adınıda verdiği hata su

Error on line 1 of Query:

CREATE TABLE `links` (
`id` int(10) NOT NULL auto_increment,
`title` text NOT NULL,
`location` int(2) NOT NULL,
`code` text NOT NULL,
`active` int(1) NOT NULL,
`addon` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=59


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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=59' at line 9

aynı sorguyu elimle phpmyadminden kurmaya calıstıgımda su hatayı alıyorum

MySQL çıktısı: Yardım
#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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=59' at line 17




ve başka scrriptler kurmaya calsıtıgımda da şu hatayı veriyo

MySQL çıktısı:
#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 'collate latin1_german2_ci NOT NULL default '',
`kategorie` v


bunun biçzöümü yokmu

script cronjob gerektiriyo elimde windows reseller var ama cpanel lazım işte o da bende yok
bunu nasıl çözeriz.

acaba yanlışmı kurdum dedim sildim apache yi başta krudum gene aynı sonuc

Phpmyadmine göre konuşalım. Çünkü nedense her farklı yükleme için satır değişmiş gözüküyor.

#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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=59' at line 17

17. satırı kopyalar mısın ?

16-- Table structure for table `banned`
17--
18
19CREATE TABLE `banned` (
`id` int(11) NOT NULL auto_increment,
`ip` varchar(20) NOT NULL default '',
`date` int(50) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1;

--
-- Dumping data for table `banned`
--

--
31-- Table structure for table `links`
32--
33
34CREATE TABLE `links` (

diye gdiyo 17 boş yani

Hataya sebep olan yer burası değil. Eğer sql dosyası büyük değilse tamamını kopyalar mısın ?

ama bence hata burdan kaynaklanmıyo cünkü hiç bi sql dosyası yukleyemedim 3 tanedene gerçi hepside ***** script belki sql dosyası bozuk verilmişti bileme tabi işin ehli değiliz


-- phpMyAdmin SQL Dump
-- version 2.9.0.2
-- phpMyAdmin | MySQL Database Administration Tool | www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 12, 2007 at 03:26 PM
-- Server version: 4.1.21
-- PHP Version: 4.4.2
--
-- Database: `MyScript`
--

-- --------------------------------------------------------

--
-- Table structure for table `banned`
--

CREATE TABLE `banned` (
`id` int(11) NOT NULL auto_increment,
`ip` varchar(20) NOT NULL default '',
`date` int(50) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1;

--
-- Dumping data for table `banned`
--

--
-- Table structure for table `links`
--

CREATE TABLE `links` (
`id` int(10) NOT NULL auto_increment,
`title` text NOT NULL,
`location` int(2) NOT NULL,
`code` text NOT NULL,
`active` int(1) NOT NULL,
`addon` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=59 ;

--
-- Dumping data for table `links`
--

INSERT INTO `links` (`id`, `title`, `location`, `code`, `active`, `addon`) VALUES
(1, 'Scout', 3, 'scout.php?tru=$tru', 1, '0'),
(2, 'The Lab', 3, 'produce.php?tru=$tru', 1, '0'),
(3, 'Discipline', 3, 'collect.php?tru=$tru', 1, '0'),
(4, 'Pimp Store', 3, 'purchase.php?tru=$tru', 1, '0'),
(5, 'Travel', 3, 'travel.php?tru=$tru', 1, '0'),
(6, 'Bank', 3, 'bank.php?tru=$tru', 1, '0'),
(7, 'Attack', 3, 'attack.php?tru=$tru', 1, '0'),
(8, 'Purchase Credits', 3, '../credits.php', 1, '0'),
(9, 'Home', 2, 'index.php', 1, '0'),
(10, 'Play', 2, 'play.php', 1, '0'),
(11, 'My Account', 2, 'myaccount.php', 1, '0'),
(12, 'Purchase Credits', 2, 'credits.php', 1, '0'),
(13, 'Winners', 2, 'winners.php', 1, '0'),
(14, 'logout', 2, 'logout.php', 1, '0'),
(15, 'Home', 1, 'index.php', 1, '0'),
(16, 'Login', 1, 'login.php', 1, '0'),
(17, 'Register', 1, 'signup.php', 1, '0'),
(18, 'Guide', 1, 'guide.php', 1, '0'),
(19, 'Winners', 1, 'winners.php', 1, '0'),
(20, 'Rules', 1, 'rules.php', 1, '0'),
(21, 'Ranks', 5, 'ranks.php?tru=$tru', 1, '0'),
(22, 'Crew Ranks', 5, 'cranks.php?tru=$tru', 1, '0'),
(23, 'Supporter Ranks', 5, 'sranks.php?tru=$tru', 1, '0'),
(24, 'Free Ranks', 5, 'franks.php?tru=$tru', 1, '0'),
(25, 'Global Ranks', 5, 'granks.php?tru=$tru', 1, '0'),
(26, 'Pimp Awards', 5, 'awards.php?tru=$tru', 1, '0'),
(27, 'Find a Pimp', 6, 'pimp.php?tru=$tru', 1, '0'),
(28, 'Find/Create Crew', 6, 'crew.php?tru=$tru', 1, '0'),
(29, 'Who is Online', 6, 'whosonline.php?tru=$tru', 1, '0'),
(30, 'Message Board', 7, 'forum.php?tru=$tru', 1, '0'),
(31, 'Recruiting Board', 7, 'board.php?tru=$tru', 1, '0'),
(32, 'Guide', 8, '../guide.php', 1, '0'),
(33, 'Rules', 8, '../rules.php', 1, '0'),
(34, 'Transfer Credits', 8, 'bank.php?tru=$tru', 1, '0'),
(35, 'Refer Pimps', 8, 'refer.php?tru=$tru', 1, '0'),
(36, 'Exit Round', 8, 'logout.php?tru=$tru', 1, '0'),
(37, 'Home', 4, 'index.php?tru=$tru', 1, '0'),
(38, 'My Settings', 4, 'options.php?tru=$tru', 1, '0'),
(39, 'Mailbox', 4, 'mailbox.php?tru=$tru', 1, '0'),
(40, 'Free Ranks', 4, 'franks.php?tru=$tru', 1, '0'),
(41, 'Global Ranks', 4, 'granks.php?tru=$tru', 1, '0'),
(42, 'Crew Management', 4, 'crew.php?tru=$tru', 1, '0');

-- --------------------------------------------------------

--
-- Table structure for table `cronjobs`
--

CREATE TABLE `cronjobs` (
`cronjob` varchar(32) NOT NULL default '',
`lastran` int(12) NOT NULL default '0'
) ENGINE=MyISAM;

--
-- Dumping data for table `cronjobs`
--
--
-- Table structure for table `bans`
--

CREATE TABLE `bans` (
`banned` varchar(255) NOT NULL default '',
`reason` text NOT NULL,
`expires` int(11) NOT NULL default '0'
) ENGINE=MyISAM;

--
-- Dumping data for table `bans`
--


-- --------------------------------------------------------


--
-- Table structure for table `games`
--

CREATE TABLE `games` (
`round` int(11) NOT NULL auto_increment,
`type` varchar(12) NOT NULL default '',
`speed` tinyint(4) NOT NULL default '2',
`maxbuild` int(11) NOT NULL default '0',
`reserves` int(11) NOT NULL default '0',
`credits` int(11) NOT NULL default '0',
`crewmax` tinyint(4) NOT NULL default '0',
`starts` int(11) NOT NULL default '0',
`ends` int(11) NOT NULL default '0',
`status` varchar(10) NOT NULL default 'normal',
`prize` varchar(255) NOT NULL default '',
`other` varchar(255) NOT NULL default '',
`startjackpot` int(10) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`pause` int(15) NOT NULL default '0',
`first` int(15) NOT NULL default '0',
`second` int(15) NOT NULL default '0',
`third` int(15) NOT NULL default '0',
`auto` int(15) NOT NULL default '0',
`endjackpot` varchar(15) NOT NULL default '0',
`jplock` int(1) NOT NULL default '0',
PRIMARY KEY (`round`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `games`
--


-- --------------------------------------------------------


--
-- Table structure for table `addons`
--

CREATE TABLE `addons` (
`id` int(5) NOT NULL auto_increment,
`addonname` varchar(255) NOT NULL default '',
`code` varchar(255) NOT NULL default '',
`installed` int(1) NOT NULL default '0',
`enable` int(1) NOT NULL default '1',
`type` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `games`
--


-- --------------------------------------------------------
--
-- Table structure for table `html`
--

CREATE TABLE `html` (
`rules` text NOT NULL,
`description` text NOT NULL,
`tos` text NOT NULL,
`guide` text NOT NULL
) ENGINE=MyISAM;

--
-- Dumping data for table `html`
--

INSERT INTO `html` VALUES ('Your Site Rules Here', 'Your Site Description Here, This will show on the front page', 'Your Terms Of Service', 'Your Site Guide');

-- --------------------------------------------------------

--
-- Table structure for table `logs`
--

CREATE TABLE `logs` (
`id` int(10) NOT NULL auto_increment,
`time` int(11) NOT NULL default '0',
`round` int(10) NOT NULL default '0',
`pimpname` varchar(255) NOT NULL default '',
`action` text NOT NULL,
`ip` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `logs`
--


-- --------------------------------------------------------

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
`id` bigint(20) NOT NULL auto_increment,
`news` text NOT NULL,
`posted` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `news`
--

-- --------------------------------------------------------

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
`id` int(20) NOT NULL auto_increment,
`tranid` varchar(255) NOT NULL default '',
`amount` varchar(255) NOT NULL default '',
`type` varchar(255) NOT NULL default '',
`user` varchar(255) NOT NULL default '',
`date` int(20) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM;

-- --------------------------------------------------------
--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
`sitename` varchar(255) NOT NULL default '',
`adminemail` varchar(255) NOT NULL default '',
`adminpaypal` varchar(255) NOT NULL default '',
`fullurl` varchar(255) NOT NULL default '',
`domain` varchar(255) NOT NULL default '',
`refpercent` int(12) NOT NULL default '10',
`refcredits` int(10) NOT NULL default '0',
`licensekey` varchar(255) NOT NULL default '',
`adverts` text NOT NULL,
`withdrawturns` varchar(255) NOT NULL default '',
`depositturns` varchar(255) NOT NULL default '',
`maxdep` varchar(255) NOT NULL default '',
`jackpotper` int(10) NOT NULL default '0',
`bottomadverts` text NOT NULL,
`block` text NOT NULL,
`showblock` varchar(255) NOT NULL default '',
`numbernews` int(10) NOT NULL default '0',
`pimpversion` varchar(255) NOT NULL default '',
`confirm` int(1) NOT NULL default '1'
) ENGINE=MyISAM;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` VALUES ('Your Site Name', 'admin@yoursite.com', 'yourpaypal@yoursite.com', 'http://www.yoursite.com/', 'yoursite.com', 10, 100, '', '', '10', '10', 10000000, 10, '', '', '', 5, '3.0RC2','1');

-- --------------------------------------------------------

--
-- Table structure for table `stats`
--

CREATE TABLE `stats` (
`user` char(18) NOT NULL default '',
`round` bigint(20) NOT NULL default '0',
`credits` bigint(20) NOT NULL default '0',
`code` varchar(25) NOT NULL default ''
) ENGINE=MyISAM;

--
-- Dumping data for table `stats`
--


-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
`id` bigint(20) NOT NULL auto_increment,
`username` varchar(18) NOT NULL default '',
`password` varchar(255) NOT NULL default '',
`credits` bigint(20) NOT NULL default '0',
`email` varchar(100) NOT NULL default '',
`fullname` varchar(100) NOT NULL default '',
`age` tinyint(4) NOT NULL default '0',
`messager` varchar(50) NOT NULL default '',
`online` int(11) NOT NULL default '0',
`ip` varchar(15) NOT NULL default '0.0.0.0',
`lastip` varchar(15) NOT NULL default '0.0.0.0',
`host` varchar(100) NOT NULL default '',
`code` varchar(32) NOT NULL default '',
`membersince` int(11) NOT NULL default '0',
`status` varchar(12) NOT NULL default 'unverified',
`statusexpire` int(11) NOT NULL default '0',
`reason` varchar(200) NOT NULL default '',
`ref_by` varchar(255) NOT NULL default '',
`ref_amount` bigint(20) NOT NULL default '0',
`ref_credits` bigint(20) NOT NULL default '0',
`ads` varchar(5) NOT NULL default 'yes',
`hitmancon` int(5) NOT NULL default '0',
`thiefcon` int(5) NOT NULL default '0',
`robberycon` int(5) NOT NULL default '0',
`newsletter` ENUM('yes', 'no') NOT NULL DEFAULT 'yes',
PRIMARY KEY (`id`),
KEY `ip` (`ip`),
KEY `lastip` (`lastip`)
) ENGINE=MyISAM AUTO_INCREMENT=1;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1, 'admin', '21232f297a57a5a743894a0e4a801fc3', 0, 'admin@yoursite.com', 'First Lastname', 22, 'N/A:', 1141322544, '88.152.22.182', '88.152.22.182', 'bzq-88-152-22-182.red.bezeqint.net', '6d1777a6e42946d5175a6182bc0f4adb', 1141253352, 'admin', 0, '', '', 0, 0, 'yes', 0, 0, 0,'yes');

42. satırdaki

değiştirin bu şekilde

kurulumdaki hata buna döndü
phpmyadmindeki hata aynı hala

Error on line 1 of Query:

CREATE TABLE `links` (
`id` int(10) NOT NULL auto_increment,
`title` text NOT NULL,
`location` int(2) NOT NULL,
`code` text NOT NULL,
`active` int(1) NOT NULL,
`addon` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=59 ;


INSERT INTO `links` (`id`, `title`, `location`, `code`, `active`, `addon`) VALUES
(1, 'Scout', 3, 'scout.php?tru=$tru', 1, '0'),
(2, 'The Lab', 3, 'produce.php?tru=$tru', 1, '0'),
(3, 'Discipline', 3, 'collect.php?tru=$tru', 1, '0'),
(4, 'Pimp Store', 3, 'purchase.php?tru=$tru', 1, '0'),
(5, 'Travel', 3, 'travel.php?tru=$tru', 1, '0'),
(6, 'Bank', 3, 'bank.php?tru=$tru', 1, '0'),
(7, 'Attack', 3, 'attack.php?tru=$tru', 1, '0'),
(8, 'Purchase Credits', 3, '../credits.php', 1, '0'),
(9, 'Home', 2, 'index.php', 1, '0'),
(10, 'Play', 2, 'play.php', 1, '0'),
(11, 'My Account', 2, 'myaccount.php', 1, '0'),
(12, 'Purchase Credits', 2, 'credits.php', 1, '0'),
(13, 'Winners', 2, 'winners.php', 1, '0'),
(14, 'logout', 2, 'logout.php', 1, '0'),
(15, 'Home', 1, 'index.php', 1, '0'),
(16, 'Login', 1, 'login.php', 1, '0'),
(17, 'Register', 1, 'signup.php', 1, '0'),
(18, 'Guide', 1, 'guide.php', 1, '0'),
(19, 'Winners', 1, 'winners.php', 1, '0'),
(20, 'Rules', 1, 'rules.php', 1, '0'),
(21, 'Ranks', 5, 'ranks.php?tru=$tru', 1, '0'),
(22, 'Crew Ranks', 5, 'cranks.php?tru=$tru', 1, '0'),
(23, 'Supporter Ranks', 5, 'sranks.php?tru=$tru', 1, '0'),
(24, 'Free Ranks', 5, 'franks.php?tru=$tru', 1, '0'),
(25, 'Global Ranks', 5, 'granks.php?tru=$tru', 1, '0'),
(26, 'Pimp Awards', 5, 'awards.php?tru=$tru', 1, '0'),
(27, 'Find a Pimp', 6, 'pimp.php?tru=$tru', 1, '0'),
(28, 'Find/Create Crew', 6, 'crew.php?tru=$tru', 1, '0'),
(29, 'Who is Online', 6, 'whosonline.php?tru=$tru', 1, '0'),
(30, 'Message Board', 7, 'forum.php?tru=$tru', 1, '0'),
(31, 'Recruiting Board', 7, 'board.php?tru=$tru', 1, '0'),
(32, 'Guide', 8, '../guide.php', 1, '0'),
(33, 'Rules', 8, '../rules.php', 1, '0'),
(34, 'Transfer Credits', 8, 'bank.php?tru=$tru', 1, '0'),
(35, 'Refer Pimps', 8, 'refer.php?tru=$tru', 1, '0'),
(36, 'Exit Round', 8, 'logout.php?tru=$tru', 1, '0'),
(37, 'Home', 4, 'index.php?tru=$tru', 1, '0'),
(38, 'My Settings', 4, 'options.php?tru=$tru', 1, '0'),
(39, 'Mailbox', 4, 'mailbox.php?tru=$tru', 1, '0'),
(40, 'Free Ranks', 4, 'franks.php?tru=$tru', 1, '0'),
(41, 'Global Ranks', 4, 'granks.php?tru=$tru', 1, '0'),
(42, 'Crew Management', 4, 'crew.php?tru=$tru', 1, '0')


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 '; INSERT INTO `links` (`id`, `title`, `location`, `code`, `a

sorgusunu phpmyadminde çalıştırdığında ne oluyor bir bakar mısın ?

4.0.26-nt-log
bi sorun vermedi