Error in SQL syntax

[Anonymous]

I just found out about your script. After a long search for the ideal link-script I think I have found it now :)

Installation was very easy, but while uploading database.sql in phpMyAdmin it returned :

Content visible to registered users only.

When I try to run the script, I get next line on top of the page :

Content visible to registered users only.

I guess both errors are related to eachother.
All help appreciated

Sx

[David]

Which table were you adding when you had the problem?
And ... did you try simply adding the tables manually through phpMyAdmin?
What tables exist in the database now?

[Anonymous]

No, I haven't added the tables manually, I uploaded the database.sql file.
The only table that was added to the database is Category. After that it seemed to give the error, so the other tables haven't been added.

I tried it manually :

It seems that when I leave out "DEFAULT CHARSET=latin1" in the category-table, it continous to accept the tables. Is the charset necessary ? or can I drop it ?

The next error I got was concerning INSERT INTO `dir_user` VALUES (1, 'admin', 'admin');

When I changed it to INSERT INTO `User` ( `id` , `username` , `password` ) VALUES ('1', 'admin', 'admin'); it worked

[David]

No, the character set should not be necessary.
It sounds like you got it running. Let me know if you need any additional support.

[IGonza]

Open database.sql.
There are :
CREATE TABLE `Email` (
`id` int(11) NOT NULL auto_increment,
`email` varchar(100) NOT NULL default '',
`title` varchar(100) NOT NULL default '',
`url` varchar(100) NOT NULL default '',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=421 ;

Just delete 'ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=421 ;' .
Your mysql doesn't support it.