Please help. Get to Step 4 and then there's an error!

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
HooverDST

Please help. Get to Step 4 and then there's an error!

Post by HooverDST »

I've installed all the files on a server, it passes all the tests and it obviously connects to the DB because it writes the tables.

But it doesn't get past this point (see below).  Any ideas?
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_userplugins ( USERPLUGIN_ID, USERPLUGIN_NAME, CODE, CREATE_DATE, MODIFIED_DATE ) VALUES ( 1, 'user_agent', '//Code to show the user''s user agent information. echo $_SERVER["HTTP_USER_AGENT"];', '2006-07-25 21:22:33', '2006-07-25 21:22:33' );
HooverDST

Re: Please help. Get to Step 4 and then there's an error!

Post by HooverDST »

Anybody have an ideas yet?  This is getting really frustrating.  I've installed the package on another server at it installs fine.

The server I'm having trouble with runs PHP 4.4.4 and MySQL 4.1.21
tsw
Power Poster
Power Poster
Posts: 1408
Joined: Tue Dec 13, 2005 10:50 pm

Re: Please help. Get to Step 4 and then there's an error!

Post by tsw »

well its a mysql error (most probably)

try installing without the sample data (asked few steps before in the installer)

maybe that mysql version has some limitation, can you access the server logs to get detailed information of the error?
HooverDST

Re: Please help. Get to Step 4 and then there's an error!

Post by HooverDST »

try installing without the sample data (asked few steps before in the installer)
I did that and it still didn't work.

I got a developer to have a look at the issue and he had to rewrite some of the mysql to get it working and installed.  He also played with the schema.php file all within the 'install' directory.  I haven't had a chance to reinstall it with his modifications but he told me it should be okay.
tsw
Power Poster
Power Poster
Posts: 1408
Joined: Tue Dec 13, 2005 10:50 pm

Re: Please help. Get to Step 4 and then there's an error!

Post by tsw »

glad to hear,

could you attach the modified files here so we can take a look and fix it in next version

thanks
HooverDST

Re: Please help. Get to Step 4 and then there's an error!

Post by HooverDST »

Well since I'm not a developer (designer here :D ), I can't say whether posting these will prove very beneficial since I've installed CMSMS on numerous servers with no issues.

But I will anyway.  Just so if anybody else comes across this issue in the future.

I've put the code into .txt files since I can't upload .sql or .php files. 

So create.txt is really create.sql and schema.txt is schema.php

[gelöscht durch Administrator]
Locked

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