Problem with installing CMSms 1.1 - cannot complete step 4

Help with getting the CMS CORE package up and running. This does not include 3rd party modules, PHP scripts, anything downloaded via module manager or from any external source.
Locked
pschoenb
Forum Members
Forum Members
Posts: 92
Joined: Sun Jul 15, 2007 1:18 pm

Problem with installing CMSms 1.1 - cannot complete step 4

Post by pschoenb »

Hi,

I am trying to install CMSms 1.1, and I am using:

- Linux
- Apache 2.2
- PostgreSQL 8.2.4

At step 4 of the installation process, I get:

Code: Select all

Creating additional_users table...[done]

Adding admin_bookmarks table...[done]

Creating adminlog table...[done]

Adding admin_recent_pages table...[done]

Creating content table...[done]

Creating content_props table...[done]

Adding crossref table...[done]

Creating css table...[done]

Creating css_assoc table...[done]

Creating event_handlers table...[done]

Creating events table...[done]

Creating group_perms table...[done]

Creating groups table...[done]

Creating htmlblobs table...[done]

Creating additional_htmlblob_users table...[done]

Creating modules table...[done]

Creating module_deps table...[done]

Adding module_templates table...[done]

Creating permissions table...[done]

Creating siteprefs table...[done]

Creating templates table...[done]

Creating user_groups table...[done]

Creating userprefs table...[done]

Creating users table...[done]

Creating userplugins table...[done]

Creating version table...[done]

Importing sample data...Invalid query: INSERT INTO cms_content ( CONTENT_ID, CONTENT_NAME, TYPE, OWNER_ID, PARENT_ID, TEMPLATE_ID, ITEM_ORDER, HIERARCHY, DEFAULT_CONTENT, MENU_TEXT, CONTENT_ALIAS, SHOW_IN_MENU, COLLAPSED, MARKUP, ACTIVE, CACHABLE, ID_HIERARCHY, HIERARCHY_PATH, PROP_NAMES, METADATA, TITLEATTRIBUTE, TABINDEX, ACCESSKEY, LAST_MODIFIED_BY, CREATE_DATE, MODIFIED_DATE ) VALUES ( 15, 'Home', 'content', 1, -1, 17, 1, '00001', 1, 'Home', 'home', 1, 1, 'html', 1, 1, '15', 'home', 'content_en', null, 'Home Page, shortcut key=1', null, '1', 2, '2006-07-25 21:22:31', '2006-07-25 21:22:31' );
What could be wrong?
Regards,
Patrick
Pierre M.

Re: Problem with installing CMSms 1.1 - cannot complete step 4

Post by Pierre M. »

Hello,

please provide a database error log. Or ask your provider about this.

Pierre M.
pschoenb
Forum Members
Forum Members
Posts: 92
Joined: Sun Jul 15, 2007 1:18 pm

Re: Problem with installing CMSms 1.1 - cannot complete step 4

Post by pschoenb »

Hi,

the problem is that all the tables are not being created, because all date-time fields are specified as type "DT", which causes a syntax error, because this seems to be an unknown type name in PostgreSQL.
Regards,
Patrick
Pierre M.

Re: Problem with installing CMSms 1.1 - cannot complete step 4

Post by Pierre M. »

Thank you Patrick for this feedback.

Anybody knows how "DT" should be changed ? Or what should should be made to increase the database agnosticism ?

Pierre M.
calguy1000
Support Guru
Support Guru
Posts: 8169
Joined: Tue Oct 19, 2004 6:44 pm

Re: Problem with installing CMSms 1.1 - cannot complete step 4

Post by calguy1000 »

We're looking into this potential issue.  I've asked a dev team member to install on postgres again (to see if we can reproduce it).
Follow me on twitter
Please post system information from "Extensions >> System Information" (there is a bbcode option) on all posts asking for assistance.
--------------------
If you can't bother explaining your problem well, you shouldn't expect much in the way of assistance.
Gotty

Re: Problem with installing CMSms 1.1 - cannot complete step 4

Post by Gotty »

Hi,

I'm having the same problem. Any news from the postgres install ?
reneh
Dev Team Member
Dev Team Member
Posts: 446
Joined: Tue Nov 28, 2006 8:39 pm

Re: Problem with installing CMSms 1.1 - cannot complete step 4

Post by reneh »

The dev team have found the problem. The fix now must be confirmed ok before its released.
ReneH 8-)
A search will save you hours waiting for an answer! Image
jeffunk
Forum Members
Forum Members
Posts: 32
Joined: Thu Mar 16, 2006 3:17 am

Re: Problem with installing CMSms 1.1 - cannot complete step 4

Post by jeffunk »

Yep.  I am also having this problem... :-\

If someone could post here when the solution gets okayed by the devs, I would be appreciative! :)
MacApp

workaround! Re: Problem with installing CMSms 1.1 - cannot complete step 4

Post by MacApp »

Same problem here with DT database type that doesn't exist in postgres. :'(
Any fix/trick or workaround is available?
thanks

EDIT: workaround! ;D
in postgres console:

Code: Select all

create domain DT as timestamp;
Last edited by MacApp on Thu Jul 26, 2007 4:40 pm, edited 1 time in total.
jeffunk
Forum Members
Forum Members
Posts: 32
Joined: Thu Mar 16, 2006 3:17 am

Re: Problem with installing CMSms 1.1 - cannot complete step 4

Post by jeffunk »

Hurray MacApp!

That worked for me!  Now to wait and see if anything explodes! 

Hopefully not!  :D
Locked

Return to “[locked] Installation, Setup and Upgrade”