Bandit
|
| Posted: 05/13/2003, 6:34 PM |
|
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? either that or I'm just too tired..lol
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
)
|
|
|
 |
HarryTheHat
|
| Posted: 05/14/2003, 8:06 AM |
|
Yeh, I get that as well. Can't find a solution though 
|
|
|
|
Bandit
|
| Posted: 05/22/2003, 7:08 PM |
|
Hey Harry,
I actually found a solution for this, though i submitted a ticket which didn't really go anywhere cos the solution was already been discovered from playing around.
Anyway, if you are using the apache,php & mysql from firepages.com.au drop it or upgrade mysql. For my case, instead of upgrading I went to foxserv.net to download a different compilation of apache, php & mysql and it worked fine.
I didn't think the dump file was any problem, it worked great on my dedicated server but never worked on my workstation.
Hoped that helped..
Regs,
Bandit
|
|
|
|
|
