SQL Errors on hosted account

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
BAlGaInTl

SQL Errors on hosted account

Post by BAlGaInTl »

Hello,

I recently found CMS Made Simple, and it really looks like what I need.  However, I have been unable to get it to install.

I'm currently trying to install it on a hosted account.

I was able to make the database just fine, but I'm unable to create the tables.  In the install procedure, I got the following error
Parse error: parse error, unexpected T_STRING, expecting '{' in /home/domainname/domains/domainname.org/public_html/lib/adodb/adodb-datadict.inc.php on line 24
So, I found the .sql file, and tried to manually create the tables using phpmyadmin and got the following

Code: Select all

Error

SQL-query : 

INSERT INTO {DB_PREFIX}content(
CONTENT_ID,
CONTENT_NAME,

TYPE ,
OWNER_ID,
PARENT_ID,
TEMPLATE_ID,
ITEM_ORDER,
HIERARCHY,
DEFAULT_CONTENT,
MENU_TEXT,
CONTENT_ALIAS,
SHOW_IN_MENU,
MARKUP,
ACTIVE,
CACHABLE,
CREATE_DATE,
MODIFIED_DATE
)
VALUES ( 1, 'CMS Install Successful!', 'content', 1, -1, 1, 1, '00001', 1, 'Home Page', 'cms-install-successful-', 1, 'html', 1, 1, '2005-02-24 18:25:29', '2005-02-24 18:25:29' )

MySQL said:
#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '{DB_PREFIX}content ( CONTENT_ID, CONTENT_NAME, TYPE, OWNER_ID,
Any thoughts?
Ted
Power Poster
Power Poster
Posts: 3329
Joined: Fri Jun 11, 2004 6:58 pm

Re: SQL Errors on hosted account

Post by Ted »

This could be one of two things...

1. (more likely) All of the files didn't get uploaded right, particularly lib/adodb/adodb-datadict.inc.php

2. They might have a REALLY old version of PHP, but it would have to be about 3 years old for it to matter.  (less than 4.1.2)

I suspect it's #1.
Locked

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