Robert, Take taking off the ; at the end. This worked for me. 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) ) -----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of rhood Sent: Saturday, January 26, 2002 9:19 AM To: Zope@zope.org Subject: [Zope] mysql database difficulties: creating tables with zope 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 _______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )