You are required to register before you can post. This is via a custom verification system. Please post any problems you are encountering here and I`ll do my best to respond as soon as I can. Please note that a reply WILL be posted to all queries, so do not double post. There are no guarantees
when a reply will appear but I do my best to answer all within 3/4 days max. Bumping topics won`t make the slightest difference.
IMPORTANT: Posts in English ONLY please, thank you! Any other languages will be ignored and your message deleted.
SEARCH: Use the search option to see if your question has been answered on the forum before. Or check the relevant script docs.
CUSTOMER: If you have purchased a commercial version of any of my software, using the contact option at the licence centre ensures a faster response.
AUTO DELETION: Accounts older than 5 days, with no posts or topics, are automatically deleted. Only register if you are thinking of posting.
PRIVATE MESSAGES: Private messages are currently disabled.
LINKS: Any links posted are 'NOFOLLOW' and will not be picked up by search engines.
You are not logged in.
Pages: 1
Hi!
I have a problem when I upload to MySQL. This is the error message
#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' at line 10
What is the problem??
----------------------------------------------------------------------------------------------------------------------------------------------------
--
-- Table structure for table `ms_logfile`
--
CREATE TABLE ms_logfile(
`id` int(7) not null auto_increment,
`keywords` mediumtext not null,
`count` int(10) not null default '0',
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Table structure for table `ms_pages`
--
CREATE TABLE ms_pages(
`id` int(7) not null auto_increment,
`title` text not null,
`description` mediumtext not null,
`url` text not null,
`keywords` mediumtext not null,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
ALTER TABLE ms_pages ADD FULLTEXT (title,description,keywords);
--
-- Table structure for table `ms_settings`
--
CREATE TABLE ms_settings (
`id` tinyint(1) not null auto_increment,
`path` text not null,
`total` int(3) not null default '25',
`language` varchar(30) not null default 'english.php',
`target` enum('0','1') not null default '0',
`log` enum('0','1') not null default '0',
`skipwords` mediumtext not null,
`htmlcode` text not null,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO ms_settings VALUES (1,'http://www.yoursite.com/search','25','english.php','0','0','this,that,then,is,as,was,if,for','');
Regards Geir
Offline
You are probably using an older version of MySQL? Just remove the offending code.
ENGINE=MyISAM DEFAULT CHARSET=latin1;
Change to:
ENGINE=MyISAM;
Offline
It is same error message when I try install in MySQL :-(
MySQL I use is version 4.0.26
Offline
v4?
Try:
TYPE=MyISAM;
Offline
Pages: 1