Re: [Mailmanager-users] Mailmanager 2.0.1 install - MySql problem

[Kevin C. <ke...@lo...>]

On Wed, Oct 19, 2005 at 01:36:46PM +0800, Ron Goodwin wrote:
> This is a fresh install on a new machine running Deb3.1. I have 
> installed all the 3rd Party products and during the creation of a new 
> Mailmanager site (based on MySqlDb) got the following error:
> 
> An error was encountered while publishing this resource.
> 
> Error Type: ProgrammingError
> Error Value: (1064, "You have an error in your SQL syntax. Check the 
> manual that corresponds to your MySQL server version for the right 
> syntax to use near 'SCHEMA mmdata' at line 1")
> 
> I don't think MySql syntax uses 'SCHEMA'. Any ideas?

That is correct, MySQL does not use schemas. Leaving the schema field blank
when creating the MailManager instance should resolve this. I've filed a bug
(#1331443) for this as it's something which should be made clearer on the
creation form and should be fixed so that schemas aren't a possible option 
for MySQL.

Regards,
Kevin

--
Kevin Campbell                                        GPG Key: F480EC23
Software Engineer                                   ke...@lo...
LogicalWare Ltd                              http://www.logicalware.com