sNews Forum

sNews 1.7 (current stable version) => Patches/fixes => Topic started by: philmoz on November 08, 2008, 06:09:24 am

Title: Upgrade sql missing items
Post by: philmoz on November 08, 2008, 06:09:24 am
For those that used upgrade sql (news16-17.sql) before November 8,
from issue posted here:- http://snewscms.com/forum/index.php?topic=7861.0
run the following in phpmyadmin
(if using a prefix, put it in now)
Code: [Select]
INSERT INTO `settings` VALUES ('', 'enable_comments', 'NO');
-- SPECIAL KEYS
ALTER TABLE `articles` ADD INDEX ( `show_on_home` );
ALTER TABLE `comments` ADD INDEX ( `articleid` );

first line will allow you to turn on comments for all new articles.
Other 2 will add indexing to those fields.