Page 1 of 1

Problem with installing CMSms 1.1 - cannot complete step 4

Posted: Sun Jul 15, 2007 1:32 pm
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?

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

Posted: Mon Jul 16, 2007 3:18 pm
by Pierre M.
Hello,

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

Pierre M.

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

Posted: Mon Jul 16, 2007 7:32 pm
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.

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

Posted: Mon Jul 16, 2007 8:50 pm
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.

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

Posted: Mon Jul 16, 2007 8:59 pm
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).

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

Posted: Sat Jul 21, 2007 1:41 pm
by Gotty
Hi,

I'm having the same problem. Any news from the postgres install ?

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

Posted: Sat Jul 21, 2007 3:29 pm
by reneh
The dev team have found the problem. The fix now must be confirmed ok before its released.

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

Posted: Mon Jul 23, 2007 11:41 pm
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! :)

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

Posted: Thu Jul 26, 2007 3:13 pm
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;

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

Posted: Fri Jul 27, 2007 5:27 pm
by jeffunk
Hurray MacApp!

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

Hopefully not!  :D