369673 – genericmail.sql incompatible with mysql5.1

Bug 369673 - genericmail.sql incompatible with mysql5.1

Summary: genericmail.sql incompatible with mysql5.1

Status:	RESOLVED FIXED

Alias:	None

Product:	[OLD] Docs on www.gentoo.org
Classification:	Unclassified
Component:	Other documents (show other bugs)
Hardware:	All Linux

Importance:	Normal minor (vote)
Assignee:	nm (RETIRED)

URL:	http://www.gentoo.org/doc/en/files/ge...
Whiteboard:
Keywords:

Depends on:
Blocks:

Reported:	2011-06-01 15:27 UTC by wanie
Modified:	2011-06-13 22:56 UTC (History)
CC List:	1 user (show)

See Also:
Package list:
Runtime testing required:	---

Attachments
Updated genericmailsql.sql file with correct comment field (genericmailsql.sql,3.05 KB, text/plain) 2011-06-13 11:13 UTC, Sven Vermeulen	Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description wanie 2011-06-01 15:27:50 UTC

After the command "mysql -u root -p mailsql < genericmailsql.sql" i got an error with mysql5.1.
Line4 is commentet like this: '-----------------'
Deleting complete line 4 was working for me.
Apparently, since MySql5.1 only comments like '-- this are working', not comments like '--this'. 

Reproducible: Always

Steps to Reproduce:
1.mysql -u root -p mailsql < genericmailsql.sql with MySql5.1 and this file http://www.gentoo.org/doc/en/files/genericmailsql.sql
2.
3.

Comment 1 Sven Vermeulen 2011-06-13 11:13:48 UTC

Created attachment 276903 [details]
Updated genericmailsql.sql file with correct comment field

With the risk of overdoing things, updated "genericmailsql.sql" file which uses correct comment syntax.

Comment 2 nm (RETIRED) gentoo-dev

2011-06-13 22:56:50 UTC

Fixed in CVS. Thanks for the updates, Sven!