Details
-
Bug
-
Resolution: Fixed
-
Medium
-
3.0 Standard Beta
-
Postgres 7.1
-
3
-
Description
If the field-type-name is set to "postgres", and JIRA is pointed to a clean Postgres database, there is an error creating the 'portletconfiguration' table:
i:Exit -:PrevPg <Space>:NextPg ?:Help
[INFO] Http11Protocol - -Initializing Coyote HTTP/1.1 on port 9090
Starting service Tomcat-Standalone
Apache Tomcat/4.1.29
[INFO] jotm - -JOTM started with a local transaction factory which is not bound.
[INFO] jotm - -CAROL initialization
2004-10-14 12:40:30,406 WARN [core.entity.jdbc.DatabaseUtil] Entity "Action" has no table in the database
2004-10-14 12:40:30,522 WARN [core.entity.jdbc.DatabaseUtil] Entity "ChangeGroup" has no table in the database
2004-10-14 12:40:30,561 WARN [core.entity.jdbc.DatabaseUtil] Entity "ChangeItem" has no table in the database
2004-10-14 12:40:30,681 WARN [core.entity.jdbc.DatabaseUtil] Entity "ColumnLayout" has no table in the database
2004-10-14 12:40:30,722 WARN [core.entity.jdbc.DatabaseUtil] Entity "ColumnLayoutItem" has no table in the database
2004-10-14 12:40:30,781 WARN [core.entity.jdbc.DatabaseUtil] Entity "Component" has no table in the database
2004-10-14 12:40:30,874 WARN [core.entity.jdbc.DatabaseUtil] Entity "CustomField" has no table in the database
2004-10-14 12:40:30,971 WARN [core.entity.jdbc.DatabaseUtil] Entity "CustomFieldOption" has no table in the database
2004-10-14 12:40:31,021 WARN [core.entity.jdbc.DatabaseUtil] Entity "CustomFieldValue" has no table in the database
2004-10-14 12:40:31,121 WARN [core.entity.jdbc.DatabaseUtil] Entity "FieldLayout" has no table in the database
2004-10-14 12:40:31,152 WARN [core.entity.jdbc.DatabaseUtil] Entity "FieldLayoutItem" has no table in the database
2004-10-14 12:40:31,201 WARN [core.entity.jdbc.DatabaseUtil] Entity "FieldLayoutScheme" has no table in the database
2004-10-14 12:40:31,305 WARN [core.entity.jdbc.DatabaseUtil] Entity "FieldLayoutSchemeAssociation" has no table in the
database
2004-10-14 12:40:31,329 WARN [core.entity.jdbc.DatabaseUtil] Entity "FileAttachment" has no table in the database
2004-10-14 12:40:31,381 WARN [core.entity.jdbc.DatabaseUtil] Entity "FilterSubscription" has no table in the database
2004-10-14 12:40:31,421 WARN [core.entity.jdbc.DatabaseUtil] Entity "Issue" has no table in the database
2004-10-14 12:40:31,501 WARN [core.entity.jdbc.DatabaseUtil] Entity "IssueLink" has no table in the database
2004-10-14 12:40:31,561 WARN [core.entity.jdbc.DatabaseUtil] Entity "IssueLinkType" has no table in the database
2004-10-14 12:40:31,591 WARN [core.entity.jdbc.DatabaseUtil] Entity "IssueSecurityScheme" has no table in the database
2004-10-14 12:40:31,681 WARN [core.entity.jdbc.DatabaseUtil] Entity "IssueType" has no table in the database
2004-10-14 12:40:31,751 WARN [core.entity.jdbc.DatabaseUtil] Entity "ListenerConfig" has no table in the database
2004-10-14 12:40:31,781 WARN [core.entity.jdbc.DatabaseUtil] Entity "MailServer" has no table in the database
2004-10-14 12:40:31,871 WARN [core.entity.jdbc.DatabaseUtil] Entity "NodeAssociation" has no table in the database
2004-10-14 12:40:31,921 WARN [core.entity.jdbc.DatabaseUtil] Entity "Notification" has no table in the database
2004-10-14 12:40:31,951 WARN [core.entity.jdbc.DatabaseUtil] Entity "NotificationInstance" has no table in the database
2004-10-14 12:40:32,001 WARN [core.entity.jdbc.DatabaseUtil] Entity "NotificationScheme" has no table in the database
2004-10-14 12:40:32,082 WARN [core.entity.jdbc.DatabaseUtil] Entity "OSCurrentStep" has no table in the database
2004-10-14 12:40:32,121 WARN [core.entity.jdbc.DatabaseUtil] Entity "OSCurrentStepPrev" has no table in the database
2004-10-14 12:40:32,184 WARN [core.entity.jdbc.DatabaseUtil] Entity "OSGroup" has no table in the database
2004-10-14 12:40:32,221 WARN [core.entity.jdbc.DatabaseUtil] Entity "OSHistoryStep" has no table in the database
2004-10-14 12:40:32,251 WARN [core.entity.jdbc.DatabaseUtil] Entity "OSHistoryStepPrev" has no table in the database
2004-10-14 12:40:32,301 WARN [core.entity.jdbc.DatabaseUtil] Entity "OSMembership" has no table in the database
2004-10-14 12:40:32,371 WARN [core.entity.jdbc.DatabaseUtil] Entity "OSPropertyData" has no table in the database
2004-10-14 12:40:32,421 WARN [core.entity.jdbc.DatabaseUtil] Entity "OSPropertyDate" has no table in the database
2004-10-14 12:40:32,461 WARN [core.entity.jdbc.DatabaseUtil] Entity "OSPropertyDecimal" has no table in the database
2004-10-14 12:40:32,501 WARN [core.entity.jdbc.DatabaseUtil] Entity "OSPropertyEntry" has no table in the database
2004-10-14 12:40:32,542 WARN [core.entity.jdbc.DatabaseUtil] Entity "OSPropertyNumber" has no table in the database
2004-10-14 12:40:32,581 WARN [core.entity.jdbc.DatabaseUtil] Entity "OSPropertyString" has no table in the database
2004-10-14 12:40:32,682 WARN [core.entity.jdbc.DatabaseUtil] Entity "OSPropertyText" has no table in the database
2004-10-14 12:40:32,782 WARN [core.entity.jdbc.DatabaseUtil] Entity "OSUser" has no table in the database
2004-10-14 12:40:32,882 WARN [core.entity.jdbc.DatabaseUtil] Entity "Permission" has no table in the database
2004-10-14 12:40:32,922 WARN [core.entity.jdbc.DatabaseUtil] Entity "PermissionScheme" has no table in the database
2004-10-14 12:40:33,002 WARN [core.entity.jdbc.DatabaseUtil] Entity "PortalPage" has no table in the database
2004-10-14 12:40:33,041 WARN [core.entity.jdbc.DatabaseUtil] Entity "PortletConfiguration" has no table in the database
2004-10-14 12:40:33,043 ERROR [core.entity.jdbc.DatabaseUtil] Could not create table "portletconfiguration"
2004-10-14 12:40:33,043 ERROR [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
CREATE TABLE portletconfiguration (ID NUMERIC(18,0) NOT NULL, PORTALPAGE NUMERIC(18,0), PORTLET_ID VARCHAR(255),
COLUMN_NUMBER NUMERIC(9,0), POSITION NUMERIC(9,0), CONSTRAINT PK_portletconfiguration PRIMARY KEY (ID))
Error was: java.sql.SQLException: ERROR: parser: parse error at or near "POSITION"
2004-10-14 12:40:33,043 WARN [core.entity.jdbc.DatabaseUtil] Entity "Priority" has no table in the database
2004-10-14 12:40:33,101 WARN [core.entity.jdbc.DatabaseUtil] Entity "Project" has no table in the database
2004-10-14 12:40:33,221 WARN [core.entity.jdbc.DatabaseUtil] Entity "ProjectCategory" has no table in the database
2004-10-14 12:40:33,321 WARN [core.entity.jdbc.DatabaseUtil] Entity "QRTZCalendars" has no table in the database
2004-10-14 12:40:33,421 WARN [core.entity.jdbc.DatabaseUtil] Entity "QRTZCronTriggers" has no table in the database
2004-10-14 12:40:33,461 WARN [core.entity.jdbc.DatabaseUtil] Entity "QRTZFiredTriggers" has no table in the database
2004-10-14 12:40:33,492 WARN [core.entity.jdbc.DatabaseUtil] Entity "QRTZJobDetails" has no table in the database
2004-10-14 12:40:33,541 WARN [core.entity.jdbc.DatabaseUtil] Entity "QRTZJobListeners" has no table in the database
2004-10-14 12:40:33,591 WARN [core.entity.jdbc.DatabaseUtil] Entity "QRTZSimpleTriggers" has no table in the database
2004-10-14 12:40:33,622 WARN [core.entity.jdbc.DatabaseUtil] Entity "QRTZTriggerListeners" has no table in the database
2004-10-14 12:40:33,681 WARN [core.entity.jdbc.DatabaseUtil] Entity "QRTZTriggers" has no table in the database
2004-10-14 12:40:33,721 WARN [core.entity.jdbc.DatabaseUtil] Entity "Resolution" has no table in the database
2004-10-14 12:40:33,792 WARN [core.entity.jdbc.DatabaseUtil] Entity "SchemeIssueSecurities" has no table in the database
2004-10-14 12:40:33,827 WARN [core.entity.jdbc.DatabaseUtil] Entity "SchemeIssueSecurityLevels" has no table in the database
2004-10-14 12:40:33,901 WARN [core.entity.jdbc.DatabaseUtil] Entity "SchemePermissions" has no table in the database
2004-10-14 12:40:33,941 WARN [core.entity.jdbc.DatabaseUtil] Entity "SearchRequest" has no table in the database
2004-10-14 12:40:34,064 WARN [core.entity.jdbc.DatabaseUtil] Entity "SequenceValueItem" has no table in the database
2004-10-14 12:40:34,122 WARN [core.entity.jdbc.DatabaseUtil] Entity "ServiceConfig" has no table in the database
2004-10-14 12:40:34,161 WARN [core.entity.jdbc.DatabaseUtil] Entity "Status" has no table in the database
2004-10-14 12:40:34,261 WARN [core.entity.jdbc.DatabaseUtil] Entity "TrackbackPing" has no table in the database
2004-10-14 12:40:34,321 WARN [core.entity.jdbc.DatabaseUtil] Entity "UpgradeHistory" has no table in the database
2004-10-14 12:40:34,361 WARN [core.entity.jdbc.DatabaseUtil] Entity "UserAssociation" has no table in the database
2004-10-14 12:40:34,422 WARN [core.entity.jdbc.DatabaseUtil] Entity "Version" has no table in the database
2004-10-14 12:40:34,501 WARN [core.entity.jdbc.DatabaseUtil] Entity "VersionControl" has no table in the database
2004-10-14 12:40:34,541 WARN [core.entity.jdbc.DatabaseUtil] Entity "Workflow" has no table in the database
2004-10-14 12:40:34,621 WARN [core.entity.jdbc.DatabaseUtil] Entity "WorkflowScheme" has no table in the database
2004-10-14 12:40:34,721 WARN [core.entity.jdbc.DatabaseUtil] Entity "WorkflowSchemeEntity" has no table in the database
[INFO] StdSchedulerFactory - -Quartz scheduler 'JiraQuartzScheduler' initialized from default resource file in Quartz
package: 'quartz.properties'
This is because POSITION is a SQL92 reserved word.