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