Easter Sale 2025

  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: RSFormPro bug and solution at SQL Mapping Function

RSFormPro bug and solution at SQL Mapping Function 12 years 5 months ago #19999

Problem:

When I use last_insert_id at SQL Mapping function, it writes 0 instead of the new created submission id!


Solution:

/administrator/components/com_rsform/helpers/rsform.php line #1924:

- $query = str_replace('{last_insert_id}',$lastinsertid,$query);
+ $query = str_replace('{last_insert_id}',$SubmissionId,$query);
The administrator has disabled public write access.

RSFormPro bug and solution at SQL Mapping Function 12 years 5 months ago #20014

  • octavian
  • octavian's Avatar
  • OFFLINE
  • RSJoomla! Official Staff
  • Posts: 783
  • Thank you received: 110
Actually, this is not a bug. "{last_insert_id}" was never meant to display the Submission ID, that's what "{global:submissionid}" or "{global:submission_id}" (they both work) are there for.
{last_insert_id} is used to retrieve the last inserted ID in the database, eg. following another query used in the mappings section.
Please note: my help is not official customer support. To receive your support, submit a ticket by clicking here
Regards,
RSJoomla! Development Team
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!