Jump to content

mysql install error


TheWebFanatik

Recommended Posts

Hello, I'm trying to install a database .sql file & when I upload it I get the following:

 

Error

 

SQL query:

 

--

-- Dumping data for table `7stat`

--

INSERT INTO `7stat` ( `usrid` , `date` , `num` , `hits_delivered` )

VALUES -- --------------------------------------------------------

--

-- Table structure for table `7statsite`

--

 

CREATE TABLE IF NOT EXISTS `7statsite` (

`site_id` int( 11 ) default NULL ,

`date` date default NULL ,

`num` int( 11 ) default NULL ,

KEY `site_id_date` ( `site_id` , `date` ) ,

) ENGINE = MYISAM DEFAULT CHARSET = latin1;

 

MySQL said: Documentation

#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 'CREATE TABLE IF NOT EXISTS `7statsite` (

  `site_id` int(11) default NULL,

  `' at line 9

 

the system is:

 

MySQL version 5.0.92-community-log 

 

I cannot seem to see the error it mentions.

 

Thank you,

Joseph

Link to comment
https://forums.phpfreaks.com/topic/240262-mysql-install-error/
Share on other sites

I thought that had fixed it but now I'm getting this:

 

Query: --

--

INSERT INTO `7stat` (`usrid`, `date`, `num`, `hits_delivered`) VALUES

--

--

CREATE TABLE IF NOT EXISTS `7statsite` (

`siteid` int(11) default NULL,

`date` date default NULL,

`num` int(11) default NULL,

KEY `siteid_date` (`siteid`,`date`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

MySQL: 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 'CREATE TABLE IF NOT EXISTS `7statsite` ( `siteid` int(11) default NULL, `dat' at line 6

 

 

Thanks for the help.

Link to comment
https://forums.phpfreaks.com/topic/240262-mysql-install-error/#findComment-1234485
Share on other sites

Please copy and paste the exact script here.  Do not omit or edit anything.  I took the script you provided, made the edit i recommended and created the table last night.  There is something that doesn't match up if you're getting an error.

Link to comment
https://forums.phpfreaks.com/topic/240262-mysql-install-error/#findComment-1234533
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.