Is there any way to make it so one has to be a sysop, rather than just a registered user, to administer/accept comments? On second thought, a better solution would be to just require that commenters be logged-in users.
The SQL to create the table does not work with MySQL 4.0.16. The SQL listed in UserComments.php is different, would create a slightly different table, and also does not work.
can the special tag be removed (auto added to all pages)?
if i want to allow commenting on any page
MySQL #1064 Error
When I'm trying to put this:
CREATE TABLE `usercomments` ( `Id` int(11) NOT NULL auto_increment, `IdPage` int(10) unsigned NOT NULL default '0', `Email` varchar(255) NOT NULL default , `Text` blob NOT NULL, `Validated` tinyint(1) NOT NULL default '0', `Time` timestamp NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY (`Id`) )
into my MySQL it give me an 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 'CURRENT_TIMESTAMP, PRIMARY KEY (`Id`) )' at line 7
Any help? (my MySQL version is 4.0.21)