Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-30079

When Renaming Pages, Receive Incorrect Syntax Near the Keyword 'AS' in Sybase

    Details

      Description

      Steps to Reproduce
      1) Can only be Reproduced on sybase database
      2) First in edit mode , click on the page name in the web site menu, make a change and click the green check mark (see scrennshot1.jpg). You will notice that there is no warning message, but in the server log you will get "Incorrect syntax near the keyword 'AS' ".

      3) The second method is by going to the Control Panel -> Site Pages choose the page you want to rename and make the modification in the name field (see scrennshot2.jpg). Hit the save button and you will get the error "Your request failed to complete." on the screen and the "Incorrect syntax near the keyword 'AS' " in the server log file.

      4) Taking steps 2 and 3 you will see the following error

      "ERROR [JDBCExceptionReporter:75] Incorrect syntax near the keyword 'AS'"

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  7 years, 15 weeks, 5 days ago

                  Packages

                  Version Package
                  6.1.30 EE GA3
                  6.2.0 CE M2