Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 5.0.1
    • Fix Version/s: 5.1.2
    • Component/s: None
    • Labels:
      None
    • Environment:
      Linux, JDK 6, GlassFish, MySql, Liferay 5.0.1 RC

      Description

      I have a clean setup using the portal-minimal-mysql.sql script. The server starts normally but throws an exception when I try to log in. I verified my database setup by running the portal-mysql.sql script (which failed towards the end with a syntax error) and can log in. Looking at the Account_, Company and User_ tables all seem to have primary keys in the >10000 range, which makes the exception all that more mysterious.

      [#|2008-05-19T13:44:06.028-0400|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=13;_ThreadName=httpSSLWorkerThread-8080-0;|13:44:05,966 ERROR [ServicePreAction:144] com.liferay.portal.NoSuchCompanyException: No Company exists with the primary key 1
      com.liferay.portal.NoSuchCompanyException: No Company exists with the primary key 1
      at com.liferay.portal.service.persistence.CompanyPersistenceImpl.findByPrimaryKey(CompanyPersistenceImpl.java:243)
      at com.liferay.portal.service.impl.CompanyLocalServiceImpl.getCompanyById(CompanyLocalServiceImpl.java:385)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

      mysql> select * from Account_;
      ----------------------------------------------------------------------------------------------------------------------------------------------------------------+

      accountId companyId userId userName createDate modifiedDate parentAccountId name legalName legalId legalType sicCode tickerSymbol industry type_ size_

      ----------------------------------------------------------------------------------------------------------------------------------------------------------------+

      10109 10108 0   2008-05-19 13:41:56 2008-05-19 13:41:56 0 liferay.com                

      ----------------------------------------------------------------------------------------------------------------------------------------------------------------+
      1 row in set (0.00 sec)

      mysql> select * from Company;
      ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

      companyId accountId webId key_ virtualHost mx logoId

      ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

      10108 10109 liferay.com rO0ABXNyABRqYXZhLnNlY3VyaXR5LktleVJlcL35T7OImqVDAgAETAAJYWxnb3JpdGhtdAASTGphdmEvbGFuZy9TdHJpbmc7WwAHZW5jb2RlZHQAAltCTAAGZm9ybWF0cQB+AAFMAAR0eXBldAAbTGphdmEvc2VjdXJpdHkvS2V5UmVwJFR5cGU7eHB0AANERVN1cgACW0Ks8xf4BghU4AIAAHhwAAAACBOw00aSHLD4dAADUkFXfnIAGWphdmEuc2VjdXJpdHkuS2V5UmVwJFR5cGUAAAAAAAAAABIAAHhyAA5qYXZhLmxhbmcuRW51bQAAAAAAAAAAEgAAeHB0AAZTRUNSRVQ= localhost liferay.com 0

      ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      1 row in set (0.00 sec)

      mysql> select * from User_;
      ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

      uuid_ userId companyId createDate modifiedDate defaultUser contactId password_ passwordEncrypted passwordReset passwordModifiedDate graceLoginCount screenName emailAddress portraitId languageId timeZoneId greeting comments loginDate loginIP lastLoginDate lastLoginIP lastFailedLoginDate failedLoginAttempts lockout lockoutDate agreedToTermsOfUse active_

      ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

      5d034e25-4cf4-4f9a-97e3-e063ee30d325 10110 10108 2008-05-19 13:41:55 2008-05-19 13:41:55 1 10111 password 0 0 NULL 0 10110 default@liferay.com 0 en_US GMT Welcome!   2008-05-19 13:41:55   NULL   NULL 0 0 NULL 1 1
      c95c4e2a-6ef6-4a22-b2cc-081bf72f84fc 10128 10108 2008-05-19 13:41:57 2008-05-19 13:41:57 0 10129 qUqP5cyxm6YcTAhz05Hph5gvu9M= 1 0 NULL 0 test test@liferay.com 0 en_US GMT Welcome Test Test!   NULL   NULL   NULL 0 0 NULL 0 1

      ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      2 rows in set (0.00 sec)

        Attachments

          Activity

            People

            Assignee:
            raymond.auge Raymond Auge
            Reporter:
            jeff.eastman Jeff Eastman (Inactive)
            Participants of an Issue:
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Packages

                Version Package
                5.1.2