[Zope] mysql database difficulties: creating tables with zope

[rhood]

I'm just learning to use Zope.  I've set it up, created some working sites, 
and love it.

Now I'mt rying to make it work with a new mysql database (so my problem could 
very well be with the configuration of the database!)  I would appreciate any 
help!

I was working through an example and tried to create a table (using the "test" 
screen in zope):

CREATE TABLE users 
( 
user_id char(25) NOT NULL, 
cpasswd char(25) NOT NULL, 
Id int(11) DEFAULT '0' NOT NULL auto_increment, 
PRIMARY KEY (user_id), 
KEY Id (Id) 
);

and get the following error:

Error Type: sql.error
Error Value: ('42000', 1064, "[TCX][MyODBC]You have an error in your SQL 
syntax near ';\n' at line 7")

I seem to get this error (esp the part about ;\n ) when I try to create a 
table.

I can view tables, and otherwise test the database.

thanks for any help!

Robert
rhood@mtsu.edu

Robert Hood
Assistant Professor
Department of Philosophy
Middle Tennessee State University

email: rhood@mtsu.edu                              voice: 615.650.2459 or 615.898.2050
web: http://appliedphilosophy.mtsu.edu   fax: 615.905.8055