Page 1 of 1

SQL Errors on hosted account

Posted: Wed Apr 06, 2005 7:57 pm
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?

Re: SQL Errors on hosted account

Posted: Wed Apr 06, 2005 9:57 pm
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.