Install fails with latest using 1.0.15 Joomla

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Download latest version
2. Try to install as component
3. This is version 1.0.15 of Joomla

What is the expected output? What do you see instead?
Install Complete, but I see thisSQL Error DB function failed with error
number 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 'select
max(id)+1 from `jos_components`),'0','1','0','0000-00-00 SQL=INSERT INTO
`jos_menu`
(menutype,name,link,type,published,parent,componentid,sublevel,ordering,checked_
out,checked_out_time,pollid,browserNav,access,utaccess,params)
VALUES ('mainmenu','Hello
Jumi!','index.php?option=com_jumi&fileid=1','components','1','0',(select
max(id)+1 from `jos_components`),'0','1','0','0000-00-00
00:00:00','0','0','0','3','')
SQL =

INSERT INTO `jos_menu`
(menutype,name,link,type,published,parent,componentid,sublevel,ordering,checked_
out,checked_out_time,pollid,browserNav,access,utaccess,params)
VALUES ('mainmenu','Hello
Jumi!','index.php?option=com_jumi&fileid=1','components','1','0',(select
max(id)+1 from `jos_components`),'0','1','0','0000-00-00
00:00:00','0','0','0','3','')

[ Continue ... ]  ""

What version of the product are you using? On what operating system?
1.0.15 on Linux host at GoDaddy.com

Please provide any additional information below.
Thanks for creating this component.  It is excellent and I can't wait to
use it for my own website: www.demolishun.com.  I have had great success
with this at work for an internal site.

Original issue reported on code.google.com by demolish...@gmail.com on 19 Jul 2009 at 9:02

[GoogleCodeExporter]

The error 1064 occurs due to Mysql version mismatch,because differnt
versions have differnt reserved words,which if used by a previous version 
causes the
error to occur.

The simplest and most effective solution for it: when using phpMyadmin,select 
the
"compatibility mode" & select the target db version from the drop down box.

Original comment by martin2hajek@gmail.com on 19 Jul 2009 at 11:58

[GoogleCodeExporter]

You Sir, are a stud!  I created a new mysql 5.0 database, exported my old 
database,
imported into the new database, updated joomla to point to the new server and
database, installed Jumi, and everything is up and running!

Thanks for the help!  I could not find compatibility mode on the old 4.0 
database. 
So the procedure I described above was used.  Not bad for not really knowing if 
it
would work.

Original comment by demolish...@gmail.com on 19 Jul 2009 at 10:08