Hi,

I am using joomla1.5 and an RSAP 2.0.1. When I tried to setup PayPal I got this message:


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 ',0,'','1','','hr-HR','','')' at line 1 SQL=INSERT INTO jos_sv_apptpro2_requests(name, user_id, phone, email, sms_reminders, sms_phone, sms_dial_code, resource, service, startdate, starttime, enddate, endtime, request_status, payment_status, cancellation_id, booking_total, booking_due, credit_used, coupon_code, booked_seats, admin_comment, booking_language, manual_payment_collected, comment ) VALUES('marta1','81','',' This email address is being protected from spambots. You need JavaScript enabled to view it. ','','','','1','','2012-02-14','14:00:00','2012-02-14','15:00:00','new','paid','5fb3c1e6b50cd6df344e070648ef0dcf',,,0,'','1','','hr-HR','','')

I am confused.

A assume by 'RSAP 2.0.1' you mean ABPro 2.0.1.

You say 'When I tried to setup PayPal I got this message', but the error you show is sql called during a booking.

Are you getting the error when setting up PayPal (in the Admin screens), or when you try to do a booking?

The 'booking_due' value is missing.

Does your booking screen show the correct numbers for booking total?

If it shows NaN in the total box it means there is a problem with your setup. Can be caused by things like setting the resource rate as a non-number like '$5.00' when it should be '5.00'.

it comes when I tried to book an appointment

The 'booking_due' value is missing.

Does your booking screen show the correct numbers for booking total?

If it shows NaN in the total box it means there is a problem with your setup. Can be caused by things like setting the resource rate as a non-number like '$5.00' when it should be '5.00'.

yes, everything is fine. but when sent to pay mentioned error shows.

I haven't really noticed before because it was working great when testing it with PP sandbox, once I moved sandbox option, error showed

?? The totals are missing the SQL call.

So your booking screen shows totals like this..




With valid numbers not 'NaN'?