GNUEdu error

hello.

I install gnuedu-1.3b in my computor.
And I create new account and new curriculum , new chapter ,
new keyword , new item for add resource.

But , I can not add resource.
It was displayed [DB error : syntax error].
So , I checked sql syntax.

I modify gnuedu.php in line 457.
die($query);  //die ($result -> getMessage());

I get a sql syntax.
insert into resource values('', 'ja', 'Mathmatics', 'MID',
'mat', 'explanation', 'html', '', 'WEBB', 'expositive',
'information', '3', 'announce test', '', 'http:
//ja.wikipedia.org/wiki/%E6%95%B0%E5%AD%A6', '', '1.0',
'final', 'pd', 2, , NULL, NULL, NOW(), NOW())


So , I try insert resource data in mysql.
But , error massage was displayed.

#mysql -u root
#use gnuedu
#insert into resource values('', 'ja', 'Mathmatics', 'MID',
'mat', 'explanation', 'html', '', 'WEBB', 'expositive',
'information', '3', 'announce test', '', 'http:
//ja.wikipedia.org/wiki/%E6%95%B0%E5%AD%A6', '', '1.0',
'final', 'pd', 2, , NULL, NULL, NOW(), NOW())

ERROR 1064 (42000): 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 ' NULL, NULL,
NOW(), NOW())' at line 1


How repair this error for add resource?

Hello,
thank you for the fine bugreport.
As it is not your first communication about gnuedu, and as
you seem to
need this software, I'd like to ask you to present yourself
briefly, and
say whether you would like to join the development team of
Gnuedu.
Odile, who is in Cc: and I are members of the association
OFSET, whose
website is http://www.ofset.org

If you agree with our goals (http://www.ofset.org/m
anifeste), please
consider also joining our association, who already has
members throughout 
the world.

mets_type_fyahoo.co.jp a écrit :
> hello.
> 
> I install gnuedu-1.3b in my computor.
> And I create new account and new curriculum , new
chapter , new keyword , new item for add resource.
> 
> But , I can not add resource.
...
> I modify gnuedu.php in line 457.
> die($query);  //die ($result -> getMessage());
> 
> I get a sql syntax.
> insert into resource values('', 'ja', 'Mathmatics',
'MID', 'mat', 'explanation', 'html', '', 'WEBB',
'expositive', 'information', '3', 'announce test', '', 'http:
//ja.wikipedia.org/wiki/%E6%95%B0%E5%AD%A6', '', '1.0',
'final', 'pd', 2, , NULL, NULL, NOW(), NOW())

The error stems clearly from the void parameter (the two
consecutive
commas).

However, I suppose that Odile will see better than I can
where the
function DBQuery was called from when you got the bug.


Best regards,			Georges.

On Tue, 26 Dec 2006 18:33:27 +0100 (CET)
mets_type_fyahoo.co.jp wrote:

> hello.
> 
> I install gnuedu-1.3b in my computor.
> And I create new account and new curriculum , new
chapter , new keyword , new item for add resource.
> 
> But , I can not add resource.
> It was displayed [DB error : syntax error].
> So , I checked sql syntax.
> 
> I modify gnuedu.php in line 457.
> die($query);  //die ($result -> getMessage());
> 
> I get a sql syntax.
> insert into resource values('', 'ja', 'Mathmatics',
'MID', 'mat', 'explanation', 'html', '', 'WEBB',
'expositive', 'information', '3', 'announce test', '', 'http:
//ja.wikipedia.org/wiki/%E6%95%B0%E5%AD%A6', '', '1.0',
'final', 'pd', 2, , NULL, NULL, NOW(), NOW())
> 
> 
> So , I try insert resource data in mysql.
> But , error massage was displayed.
> 
> #mysql -u root
> #use gnuedu
> #insert into resource values('', 'ja', 'Mathmatics',
'MID', 'mat', 'explanation', 'html', '', 'WEBB',
'expositive', 'information', '3', 'announce test', '', 'http:
//ja.wikipedia.org/wiki/%E6%95%B0%E5%AD%A6', '', '1.0',
'final', 'pd', 2, , NULL, NULL, NOW(), NOW())
> 
> ERROR 1064 (42000): 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 ' NULL,
NULL, NOW(), NOW())' at line 1
> 
> 
> How repair this error for add resource?
> 

Hello Nakamura

Thank you for the report, and for those you sent me
privately, too.

I'm currently steadily debugging the new 1.3 GNU Edu
version.

Hopefully my yesterday commit fixed your bug. Please try and
let me
know.

Did you manage to install? 

Regards,

-- 
Odile Bénassy
http://obenassy.free.fr