Please login or register.

Login with username, password and session length
Advanced search  

Author Topic: Upgrade sql missing items  (Read 2903 times)

philmoz

  • High flyer
  • Administrator
  • ULTIMATE member
  • ******
  • Karma: 161
  • Posts: 2001
    • fiddle 'n fly
Upgrade sql missing items
« 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.
Logged
Of all the things I have lost, it is my mind that I miss the most.