Uploaded image for project: 'phpBB'
  1. phpBB
  2. PHPBB-14504

phpBB 3.1.7pl1 to 3.1.8 migration issue (MSSQL)

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Major Major
    • None
    • None
    • None
    • None

      Hello,

      I had an issue with the migration happening at the increase_size_of_dateformat.php level.

      This migration step was triggering the following SQL query:

      ALTER TABLE [dbo].[phpbb3_users] ADD CONSTRAINT [DF_phpbb3_users_user_dateformat_1] DEFAULT ("d M Y H:i") FOR [user_dateformat]

      MSSQL is complaining about the " before d M Y H:i, as it should really be a '.
      Is this probably happening only with MSSQL and not with MySQL?

      I had to work around it by doing this step manually (executing the query manually myself with the correct sintax) instead of going though increase_size_of_dateformat.php.

      Now I have the forum working and up to date with the latest version, but I had to spend some time investigating this .

      Any thoughts about this?

            Unassigned Unassigned
            ssjvegetto ssjvegetto [X] (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: