Uploaded image for project: 'In-Portal CMS'
  1. In-Portal CMS
  2. INP-976

Fatal error during Installation on States import with MySQL in Strict Mode

    XMLWordPrintable

    Details

    • Type: Bug Report
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.1.0
    • Fix Version/s: 5.2.0-B2
    • Component/s: Install / Upgrages
    • Labels:
      None
    • External issue URL:
    • Additional information:
      Hide

      My System is:
      In-Portal version: in-portal_5_2_0_B1
      MySQL Server version: 5.1.45
      MySQL client version: 5.1.11
      OS: Windows web Server2008
      IIS: 6.0 SP1
      PHP version: php-5.2.6-nts-Win32

      Show
      My System is: In-Portal version: in-portal_5_2_0_B1 MySQL Server version: 5.1.45 MySQL client version: 5.1.11 OS: Windows web Server2008 IIS: 6.0 SP1 PHP version: php-5.2.6-nts-Win32
    • Change Log Message:
      Fixed Fatal error during Installation on States import with MySQL in Strict Mode
    • Story Points:
      1
    • External issue ID:
      1201
    • Copy Issue Key:
    • Patch Instructions:

      Patches must be submitted through Phabricator.

      Description

      On 2nd Installation STEP SQL error due to MySQL being in Strict Mode (default in Windows)

      " Error: (1364) Field 'l1_Name' doesn't have a default value

      Last Database Query:
      INSERT INTO CountryStates (CountryStateId, Type, StateCountryId,
      IsoCode, ShortIsoCode) VALUES
      (1, 1, NULL, 'AFG', 'AF'),
      (2, 1, NULL, 'ALB', 'AL'),
      (3, 1, NULL, 'DZA', 'DZ'),
      (4, 1, NULL, 'ASM', 'AS'),
      (5, 1, NULL, 'AND', 'AD'),
      (6, 1, NULL, 'AGO', 'AO'),
      (7, 1, NULL, 'AIA', 'AI'),
      (8, 1, NULL, 'ATA', 'AQ'),
      (9, 1, NULL, 'ATG', 'AG'),
      (10, 1, NULL, 'ARG', 'AR'),
      (11, 1, NULL, 'ARM', 'AM'),
      (12, 1, NULL, 'ABW', 'AW'),
      (13, 1, NULL, 'AUS', 'AU'),
      (14, 1, NULL, 'AUT', 'AT'),
      (15, 1, NULL, 'AZE', 'AZ'),
      .....
      (308, 2, 225, 'AZ', NULL),
      (307, 2, 225, 'AK', NULL),
      (306, 2, 225, 'AL', NULL)

      Additionally, all developers agreed to enable MYSQL STRICT mode by default via DBG during project development.

        Attachments

          Issue Links

          relates to

          Bug Report - A problem which impairs or prevents the functions of the product. INP-6 Installation Fails with MySQL in Strict mode

          • Major - Major loss of function.
          • Closed

          Feature Request - A new feature of the product, which has yet to be developed. INP-48 Add Timezone Field to User record

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Feature Request - A new feature of the product, which has yet to be developed. INP-88 Implement "MemCached" functionality

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Feature Request - A new feature of the product, which has yet to be developed. INP-235 Phrases of state and country names

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Feature Request - A new feature of the product, which has yet to be developed. INP-509 User / Group Access restriction by IP

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Feature Request - A new feature of the product, which has yet to be developed. INP-713 Site domain-based agents

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Feature Request - A new feature of the product, which has yet to be developed. INP-762 Change in "Forgot Password" logic

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug Report - A problem which impairs or prevents the functions of the product. INP-764 Log CURL requests to database table instead of file

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Feature Request - A new feature of the product, which has yet to be developed. INP-778 Improvements to user Login field

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Feature Request - A new feature of the product, which has yet to be developed. INP-851 Ability to access Disabled Section with Direct Link

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug Report - A problem which impairs or prevents the functions of the product. INP-923 Report Review

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Feature Request - A new feature of the product, which has yet to be developed. INP-1652 Create smart filters functionality for item lists on Front-End

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          mentioned in

          Wiki Page Loading...

            Activity

              People

              • Assignee:
                alex Alex
                Reporter:
                dmitry Dmitry Andrejev [Intechnic]
                Developer:
                Alex
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: