Please login or register.

Login with username, password and session length
Advanced search  

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


  • High flyer
  • ULTIMATE member
  • ******
  • Karma: 161
  • Posts: 1988
    • 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:-
run the following in phpmyadmin
(if using a prefix, put it in now)
Code: [Select]
INSERT INTO `settings` VALUES ('', 'enable_comments', 'NO');
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.
Of all the things I have lost, it is my mind that I miss the most.