SQL Errors on hosted account
Posted: Wed Apr 06, 2005 7:57 pm
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
Any thoughts?
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
So, I found the .sql file, and tried to manually create the tables using phpmyadmin and got the followingParse error: parse error, unexpected T_STRING, expecting '{' in /home/domainname/domains/domainname.org/public_html/lib/adodb/adodb-datadict.inc.php on line 24
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,