support 7.x-1.0-beta1

In addition to the Drupal 7 porting effort, this release contains all changes from the 6.x-1.x branch up to September 20, 2011.

Things to watch out for:

1) Make sure to take a backup of your site before attempting an upgrade! The update code has not been comprehensively tested and there are KNOWN bugs!

2) support_update_7002() attempts to migrate comment_upload data into a file.module field. Due to the way files in Drupal 7 are stored, and more stringent validation, it is possible that this update will fail. The two failures that have been found so far are:
a) If you have an extremely long filename, there may not be enough space to store the full filename in the table, and the update will fail.
b) If you have multiple files with the same case insensitive name, the system will not be able to store them both, and the update will fail.

If this turns out to be a common problem in practice, we will write code to attempt to work around these. If you hit either, please ask in the issue queue for assistance.

3) Access control may still be a little off. Please report any issues you have.

4) The query altering used by support.module is known to tickle a core bug regarding unqualified column names. If you suddenly have "column ... in where clause is ambiguous" errors appearing in other modules, please see #766382: Column 'nid' is ambiguous when using node access modules.

5) It is possible there are still some PHP warnings.

Changes since 6.x-1.x:
September 20th, 2011
- support.module
o Fixing some minor warnings on D7.
o Don't load the ticket in support_account_load() unless we actually need it.
o bug #1285676: Access control borked on D7: Fixing access control bugs.
o bug #1282418: Notice: Undefined variable: autocomplete in support_node_validate() reported by rolandk: (followup) Fix a second instance where $autocomplete was missing.
o tagged 7.x-1.0-beta1

September 19th, 2011
- support.module
o bug #1282418: Notice: Undefined variable: autocomplete in support_node_validate() reported by rolandk: Fix undefined variable: $autocomplete. Reported by rolandk.
- support.user.inc
o bug #1282010: Notice: Undefined variable: result in support_page_user() reported by rolandk: Fix undefined variable warning.
- support_charts.module
o bug #1282726: Notice: Undefined index: 17 in support_charts_build_graph() reported by eduardo barros: Fix warnings on admin/support/charts.

September 14th, 2011
- support.module
o bug #1153854: fechting mails goes fataly wrong: Rename query placeholders to hopefully prevent query errors on some sites.
o bug #1275806: accessing tickets generates an error: Fix warning in support_client_load().

September 14th, 2011
- support.module
o Pushing a huge 7.x update.
- support_pm.module
o feature #1190320: Use support ticketing system also as project managemen system?: rename support_plan to support_pm and add it to the
main support project, as a place to add project management functionality.

August 9th, 2011
- support.module
o bug #1035774: Duplicate message-id produced in the header: set Message-ID (not Message-Id) only if not set already

May 7th, 2011
- Fixed subscription.
- Added update to convert mail variables to html.

February 20th, 2011
- Initial conversion to Drupal 7, using Coder module.

April 11th, 2011
- support.install
o Cleanup install variables

April 18th, 2011
- Issue #589552: Drupal 7 version of Support Ticketing System: mega-cleanup porting support module to Drupal 7 by
javier.alejandro.castro

April 28, 2011
- Issue #1139946: Client access missing hook_permission: Client access missing hook_permission by miro_dietiker.
- Fix header sorting.
- Fix select all checkbox.
- Fix autocomplete queries.