Joe Fernandez
|
| Posted: 05/14/2003, 2:27 AM |
|
Hi,
I can't seem to find what is the actual problem with this table from the
mysql dump file or internet.mdb that came with CSS.
I get this error "MySQL Error: 1064 (You have an error in your SQL syntax
near 'events' at line 1)" Anyone see the problem?
I must be blind................
I used the sql script that came with CSS and it keeps come up with an error
when trying to create the table. So the option was to import it from the
internet.mdb provided, that worked ok with the import. But trying out the
portal example, I get the same errors as mentioned above when I was trying
to create the table from the sql script. Anyone??
Thx in advance
================================================================
CREATE TABLE events (
event_id integer auto_increment primary key,
category_id integer null,
is_approve integer null,
user_id_approve_by integer null,
date_add datetime null,
date_start datetime null,
date_end datetime null,
event_name text null,
event_desc text null,
presenter varchar(50) null,
location text null,
location_url varchar(50) null,
image_url varchar(50) null,
fee varchar(50) null,
user_id_add integer null
)
|
|
|
 |
DonB
|
| Posted: 05/14/2003, 4:51 AM |
|
It's may be that My SQL requires the ";" at the end of the CREATE statement.
Many implementations allow it to be left off, but others insist on it.
DonB
"Joe Fernandez" <jfernand@netjump.net> wrote in message
news:b9t26d$2a0$1@news.codecharge.com...
> Hi,
>
> I can't seem to find what is the actual problem with this table from the
> mysql dump file or internet.mdb that came with CSS.
> I get this error "MySQL Error: 1064 (You have an error in your SQL syntax
> near 'events' at line 1)" Anyone see the problem?
>
> I must be blind................
>
> I used the sql script that came with CSS and it keeps come up with an
error
> when trying to create the table. So the option was to import it from the
> internet.mdb provided, that worked ok with the import. But trying out the
> portal example, I get the same errors as mentioned above when I was trying
> to create the table from the sql script. Anyone??
>
>
>
> Thx in advance
>
>
>
> ================================================================
>
> CREATE TABLE events (
> event_id integer auto_increment primary key,
> category_id integer null,
> is_approve integer null,
> user_id_approve_by integer null,
> date_add datetime null,
> date_start datetime null,
> date_end datetime null,
> event_name text null,
> event_desc text null,
> presenter varchar(50) null,
> location text null,
> location_url varchar(50) null,
> image_url varchar(50) null,
> fee varchar(50) null,
> user_id_add integer null
> )
>
>
|
|
|
|
Robert Johnson
|
| Posted: 05/15/2003, 8:52 AM |
|
Add the ; at the end of your command line.
MySQL requires this.
Robert
"Joe Fernandez" <jfernand@netjump.net> wrote in message
news:b9t26d$2a0$1@news.codecharge.com...
> Hi,
>
> I can't seem to find what is the actual problem with this table from the
> mysql dump file or internet.mdb that came with CSS.
> I get this error "MySQL Error: 1064 (You have an error in your SQL syntax
> near 'events' at line 1)" Anyone see the problem?
>
> I must be blind................
>
> I used the sql script that came with CSS and it keeps come up with an
error
> when trying to create the table. So the option was to import it from the
> internet.mdb provided, that worked ok with the import. But trying out the
> portal example, I get the same errors as mentioned above when I was trying
> to create the table from the sql script. Anyone??
>
>
>
> Thx in advance
>
>
>
> ================================================================
>
> CREATE TABLE events (
> event_id integer auto_increment primary key,
> category_id integer null,
> is_approve integer null,
> user_id_approve_by integer null,
> date_add datetime null,
> date_start datetime null,
> date_end datetime null,
> event_name text null,
> event_desc text null,
> presenter varchar(50) null,
> location text null,
> location_url varchar(50) null,
> image_url varchar(50) null,
> fee varchar(50) null,
> user_id_add integer null
> )
>
>
|
|
|
|
|
