The problem was in fact an illegal column name in one of the tables that a
Content Management program tried to create. (phpWebSite) The program seems
to be well done, but somehow they missed a beat on one of the modules that
it creates (or doesn't because of the illegal name) I tracked it down
On Wednesday 31 October 2001 10:44 am, Richard W. Wood wrote:
> I've been trying to add the following table to my database, and I keep
> getting the error below.
>
> CREATE TABLE mod_userpage_data (
>id INT(5) NOT NULL default '0',
>title VARCHAR(200) NULL,
>data LONGTEXT NULL,
>PR
t; <[EMAIL PROTECTED]>
To: "Richard W. Wood" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, October 31, 2001 9:06 AM
Subject: Re: Problem adding table
is data a reseverd word in mysql?
On Wed, 31 Oct 2001, Richard W. Wood wrote:
> I've been tryi
From: rc <[EMAIL PROTECTED]>
> is data a reseverd word in mysql?
No.
> On Wed, 31 Oct 2001, Richard W. Wood wrote:
> > I've been trying to add the following table to my database, and I keep
> > getting the error below.
I copy-pasted your SQL and it worked. I'm using 3.23.38.
---
Rodney Bro
There may be a space before the word "data" as in "mod_userpage_ data"
-Original Message-
From: Richard W. Wood [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 31, 2001 9:44 AM
To: [EMAIL PROTECTED]
Subject: Problem adding table
I've been trying to add the following table to my data
is data a reseverd word in mysql?
On Wed, 31 Oct 2001, Richard W. Wood wrote:
> I've been trying to add the following table to my database, and I keep
> getting the error below.
>
> CREATE TABLE mod_userpage_data (
>id INT(5) NOT NULL default '0',
>title VARCHAR(200) NULL,
>data L