Upgrades tonight

[Red Squirrel]

Our host will be doing some upgrades on the server which might result in some minor downtime. Nothing too major, few minutes maybe, for reboot.

This is part of the email to show what will be updated:

+ PHP will be upgraded from 5.0.5 to 5.1.4
    - This will probably break any old installs of gallery and
      various forums. Please contact me if you are having any
      problems.

+ MySQL will be upgraded to 5.0
    - This is a two step upgrade, we will upgrade from 4.0 to 4.1,
      and then from 4.1 to 5.0.
    - This may also break old scripts. Please contact me if you are

      having problems.

+ Reinstall spam filtering
    - I will be making some heavy modifications to the mail system
      that will hopefully allow for filtering options to be
      controlled from cPanel. If you experience any issues with
      email, please contact me.

+ Kernel and other system patches.
    - A kernel upgrade requires a reboot, meaning services may be
      down for a few minutes.

Speaking of spam filtering my spam filter at home broke, something I need to fix... so if anyone sends me mail it may take longer to reply as I need to sort through tons of spam until I fix the issue with the filter.

Archived topic from Iceteks, old topic ID:4388, old post ID:35348

[Red Squirrel]

Upgrade was successfully done by the host, and I fixed the sql error that apeared throughout today. I'm guessing mysql changed syntax or something, I had to modify a query in sources/boards.php. In case someone out there is having the same problem this is the right query:

Code: Select all

        $DB->query("SELECT f.*, f.id, c.id as cat_id, c.position as cat_position, c.state as cat_state, c.name as cat_name, c.description as cat_desc, c.image, c.url, m.member_name as mod_name, m.member_id as mod_id, m.is_group, m.group_id, m.group_name, m.mid FROM  (rtforums as f, rtcategories as c) LEFT JOIN rtmoderators as m ON (f.id=m.forum_id) WHERE c.id=f.category ORDER BY c.position, f.position");
[code]

Its the first query you see in boards.php, maybe like 1 screen of scrolling if that, to get to it.

The issue seems to be that with the (rtforums as f, rtcategories as c) part, mysql does not like it if its not in brackets. 

[color=#888888][size=85]Archived topic from Iceteks,  old topic ID:4388, old post ID:35351[/size][/color]