Announcement

Collapse
No announcement yet.

Bigboard upgrade question, pre run queries. 3.5.1 to 3.6

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Bigboard upgrade question, pre run queries. 3.5.1 to 3.6

    Would it be ok for me to prerun these queries and comment out he lines in the upgrade file, before I even run the upgrade.php scripts.

    I rather run them beforehand if I can, then encounter a timeout and have to run them.

    PHP Code:
    ALTER TABLE post ADD COLUMN infraction smallint(5); 
    ALTER TABLE thread ADD COLUMN deletedcount smallint(5); 
    ALTER TABLE post ADD COLUMN reportthreadid int(11); 
    ALTER TABLE thread ADD COLUMN lastpostid int(11); 
    http://www.andreas-kraus.net/blog/up...date-timeouts/

  • #2
    Yes. Versions <3.6 have no use for those fields, so extra fields won't cause any harm.

    Of course the locking of the tables would make your forum all but impossible to use during the period in which you perform these queries. I have 3.6 million posts and each post query took 39 minutes. The thread queries only took a couple of seconds.

    Matt

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X