Details

    • Epic/Theme:
    • Fix Priority:
      5
    • Similar Issues:
      Show 3 results 

      Description

      21:27:59,169 ERROR [ajp-apr-8009-exec-3][JDBCExceptionReporter:82] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
      21:27:59,170 ERROR [ajp-apr-8009-exec-3][BasePersistenceImpl:202] Caught unexpected exception org.hibernate.exception.SQLGrammarException
      21:27:59,171 ERROR [ajp-apr-8009-exec-3][BaseSocialActivityInterpreter:50] Unable to interpret activity set

      1. Start with previous version of SO
      2. Perform a few actions so activity feed is populated
      3. Upgrade to latest version of SO
      4. Errors will come up when you try to view activities

        Issue Links

          Activity

          Hide
          Ken Duenwald added a comment - - edited

          FAILED Manual Testing following the steps in the description.

          Fixed on:
          Tomcat 7.0.40 + MySQL 5. Portal 6.1.30 EE GA3.
          Plugins 6.1.x EE GIT ID: 1c9c33a9153da6411cc446339c9ce791354a9878.

          Failed on:
          Tomcat 7.0.40 + MySQL 5. Portal 6.1.20 EE GA2.
          Plugins 6.1.x EE GIT ID: 1c9c33a9153da6411cc446339c9ce791354a9878.

          The following items were added (Need add a regular SO user as a connection and an SO site before the steps):

          1. A microblogs entry with a tag
          2. A microblogs entry with a mention
          3. A task assigned to Joe Bloggs
          4. A task assigned to a connection
          5. A folder and document inside the folder in Dashboard
          6. A site calendar event
          7. A site folder and site document in the folder
          8. A site message board category and thread inside the category
          9. A site blogs entry
          10. Two updates to the site wiki FrontPage
          11. A site bookmark entry

          Show
          Ken Duenwald added a comment - - edited FAILED Manual Testing following the steps in the description. Fixed on: Tomcat 7.0.40 + MySQL 5. Portal 6.1.30 EE GA3. Plugins 6.1.x EE GIT ID: 1c9c33a9153da6411cc446339c9ce791354a9878. Failed on: Tomcat 7.0.40 + MySQL 5. Portal 6.1.20 EE GA2. Plugins 6.1.x EE GIT ID: 1c9c33a9153da6411cc446339c9ce791354a9878. The following items were added (Need add a regular SO user as a connection and an SO site before the steps): 1. A microblogs entry with a tag 2. A microblogs entry with a mention 3. A task assigned to Joe Bloggs 4. A task assigned to a connection 5. A folder and document inside the folder in Dashboard 6. A site calendar event 7. A site folder and site document in the folder 8. A site message board category and thread inside the category 9. A site blogs entry 10. Two updates to the site wiki FrontPage 11. A site bookmark entry
          Hide
          Ken Duenwald added a comment - - edited

          Bug is only fixed in Portal 6.1.30 EE GA3. Portal 6.1.20 EE GA2 is still showing the exception. See Exception in 6.1.20.txt.

          Show
          Ken Duenwald added a comment - - edited Bug is only fixed in Portal 6.1.30 EE GA3. Portal 6.1.20 EE GA2 is still showing the exception. See Exception in 6.1.20.txt.
          Hide
          Ken Duenwald added a comment -

          For the bug to be reproduced in Portal 6.1.20, all of the activity entries listed in the previous comment have to be listed. Adding a smaller number of activities will not reproduce the bug.

          Show
          Ken Duenwald added a comment - For the bug to be reproduced in Portal 6.1.20, all of the activity entries listed in the previous comment have to be listed. Adding a smaller number of activities will not reproduce the bug.
          Hide
          Matthew Kong added a comment -

          I don't think you need to create everything, just create and then update a wiki.

          Anyways, it is a portal bug fixed in LPS-37690 which is why it is not an issue in 6.1.30.

          Show
          Matthew Kong added a comment - I don't think you need to create everything, just create and then update a wiki. Anyways, it is a portal bug fixed in LPS-37690 which is why it is not an issue in 6.1.30.
          Hide
          Ken Duenwald added a comment - - edited

          FAILED Manual Testing following the steps in the description.

          Failed on:
          Tomcat 7.0.27 + MySQL 5. Portal 6.1.20 EE GA2.
          Plugins 6.1.x EE GIT ID: 62cbe21f994e1a88e1802991b91d9b252e750286.
          Tomcat 7.0.40 + MySQL 5. Portal 6.1.30 EE GA3.
          Plugins 6.1.x EE GIT ID: 62cbe21f994e1a88e1802991b91d9b252e750286.

          Site activities are not visible upon upgrade. Only Microblogs are visible.

          Show
          Ken Duenwald added a comment - - edited FAILED Manual Testing following the steps in the description. Failed on: Tomcat 7.0.27 + MySQL 5. Portal 6.1.20 EE GA2. Plugins 6.1.x EE GIT ID: 62cbe21f994e1a88e1802991b91d9b252e750286. Tomcat 7.0.40 + MySQL 5. Portal 6.1.30 EE GA3. Plugins 6.1.x EE GIT ID: 62cbe21f994e1a88e1802991b91d9b252e750286. Site activities are not visible upon upgrade. Only Microblogs are visible.
          Hide
          Ken Duenwald added a comment -

          FAILED Manual Testing following the steps in the description.

          Fixed on:
          Tomcat 7.0.40 + MySQL 5. Portal 6.1.30 EE GA3.
          Plugins 6.1.x EE GIT ID: a4c3196fcea89a61cd8f7481898f7919543fedc0.

          Failed on:
          Tomcat 7.0.40 + MySQL 5. Portal 6.1.20 EE GA2.
          Plugins 6.1.x EE GIT ID: a4c3196fcea89a61cd8f7481898f7919543fedc0.

          The following items were added (Need add a regular SO user as a connection and an SO site before the steps):
          1. A microblogs entry with a tag
          2. A microblogs entry with a mention
          3. A task assigned to Joe Bloggs
          4. A task assigned to a connection
          5. A folder and document inside the folder in Dashboard
          6. A site calendar event
          7. A site folder and site document in the folder
          8. A site message board category and thread inside the category
          9. A site blogs entry
          10. Two updates to the site wiki FrontPage
          11. A new wiki page with two updates
          12. A site bookmark entry

          Show
          Ken Duenwald added a comment - FAILED Manual Testing following the steps in the description. Fixed on: Tomcat 7.0.40 + MySQL 5. Portal 6.1.30 EE GA3. Plugins 6.1.x EE GIT ID: a4c3196fcea89a61cd8f7481898f7919543fedc0. Failed on: Tomcat 7.0.40 + MySQL 5. Portal 6.1.20 EE GA2. Plugins 6.1.x EE GIT ID: a4c3196fcea89a61cd8f7481898f7919543fedc0. The following items were added (Need add a regular SO user as a connection and an SO site before the steps): 1. A microblogs entry with a tag 2. A microblogs entry with a mention 3. A task assigned to Joe Bloggs 4. A task assigned to a connection 5. A folder and document inside the folder in Dashboard 6. A site calendar event 7. A site folder and site document in the folder 8. A site message board category and thread inside the category 9. A site blogs entry 10. Two updates to the site wiki FrontPage 11. A new wiki page with two updates 12. A site bookmark entry
          Hide
          Ken Duenwald added a comment - - edited

          PASSED Manual Testing following the steps in the description.

          Fixed on:
          Tomcat 7.0.27 + MySQL 5. Portal 6.1.20 EE GA2.
          Plugins 6.1.x EE GIT ID: a4c3196fcea89a61cd8f7481898f7919543fedc0.
          Tomcat 7.0.40 + MySQL 5. Portal 6.1.30 EE GA3.
          Plugins 6.1.x EE GIT ID: a4c3196fcea89a61cd8f7481898f7919543fedc0.

          Initial test used improperly built plugins.

          Show
          Ken Duenwald added a comment - - edited PASSED Manual Testing following the steps in the description. Fixed on: Tomcat 7.0.27 + MySQL 5. Portal 6.1.20 EE GA2. Plugins 6.1.x EE GIT ID: a4c3196fcea89a61cd8f7481898f7919543fedc0. Tomcat 7.0.40 + MySQL 5. Portal 6.1.30 EE GA3. Plugins 6.1.x EE GIT ID: a4c3196fcea89a61cd8f7481898f7919543fedc0. Initial test used improperly built plugins.

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Date of First Response:
                Days since last comment:
                1 year, 43 weeks, 4 days ago

                Development

                  Structure Helper Panel