User talk:Kan/UserComments

From Meta, a Wikimedia project coordination wiki
Jump to: navigation, search

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.

FWIW.



can the special tag be removed (auto added to all pages)?[edit]

if i want to allow commenting on any page


MySQL #1064 Error[edit]

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)