I've spent a LONG time trying to find out why I couldn't get a table created in one of my plugins. Tables above and below it in the code were fine. The def file was written but the table was never created. Finally, after much testing, line by line, I have discovered that it doesn't seem to like the name 'Group' as a field name! This line works:

Test => { pos => 5, type => 'VARCHAR', size => 255 },

and this one doesn't

Group => { pos => 5, type => 'VARCHAR', size => 255 },

- I made sure it was exactly the same line with just the name changed. Does anyone have any idea why this is? It seems like a very strange error. Is Group a special SQL term that I should have known about?

Laura.
The UK High Street

Yes, GROUP is an reserved SQL term.

Ivan
-----
Iyengar Yoga Resources / GT Plugins

That explains it then!

Thanks.