updating band notes gives you Query failed error

[jasonrhl]

when you edit the bands notes you get this error

Query failed : 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 'http://www.bigdayout.com', contactname = '', contactphone = '', contactemail ' at line 3


If you can give some suggestion on how to fix this that would be good

[Capt. gigCal]

Is anyone else having this problem with the latest nightly builds? I'm not able to replicate this on my install.

[Mati Kochen]

Hello,
yes I have the same problem.
J!1.0.15 & gigCal 1.0.3

can't find the real reason for this...

[Mati Kochen]

OK, I thought it would take me longer:

the fix is very simple, a ' is missing in the query.
file: tasks.php
line: 242

Code:

bandname = '" . mosGetParam( $_POST, 'bandname', '' ) . "',

[Capt. gigCal]

Mati- I just checked line 242 in tasks.php and don't see a missing '. Can you verify that this is still a problem in the latest Nightly Build?

Thanks!

OK, I thought it would take me longer:

the fix is very simple, a ' is missing in the query.
file: tasks.php
line: 242

Code:

bandname = '" . mosGetParam( $_POST, 'bandname', '' ) . "',

[itzuv]

it fix

[aztrid]

I just downloaded and installed GigCalendar 1.0.4  on a totally fresh Joomla 1.5.15 - and i get this problem too when ceating new gigs! is there a fix?

Thank you :-)

-aztrid

[halelawya]

anybody knows how to fix this? help!!