• 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: Problem exporting/importing RS Form Pro

Problem exporting/importing RS Form Pro 14 years 4 days ago #10479

Dear Support,

I am having a problem exporting/importing RS Form Pro from testing to live environment. Everything works great on testing site but because all your tables are all in uppercase, when I export is it all being converted to lowercase so when I import to live site the RS Form Pro tables cannot be found.

Please let me know if I'm doing something incorrectly or if there is any way to resolve this issue.

Thanks!
The administrator has disabled public write access.

Re:Problem exporting/importing RS Form Pro 13 years 11 months ago #10527

  • andreic
  • andreic's Avatar
  • NOW ONLINE
  • RSJoomla! Official Staff
  • Posts: 733
  • Thank you received: 60
Hello,

This is most likely caused by the fact that you are using an older version(probably before revision 20) on your test server and a newer version on your live site. In order to fix this issue you will have to update the RSForm!Pro version on your test server and then create a new backup for you live site. In order to perform the update on your test server you will need to make the following changes:

1. run the latest installer file downloaded from our site on your test server;
2. delete the newly created tables that have the name written in lowercase;
3. rename your tables from uppercase to lowercase;
4. run the install file again from Extensions > Install/Uninstall;

If your forms and submissions are not shown you will have to access your phpMyAdmin and run the following query:
ALTER TABLE `jos_rsform_submission_values` ADD `FormId` INT NOT NULL AFTER `SubmissionValueId`;
UPDATE `jos_rsform_submission_values` sv, `jos_rsform_submissions` s SET sv.FormId=s.FormId WHERE sv.SubmissionId = s.SubmissionId;
ALTER TABLE `jos_rsform_submissions` ADD INDEX (`FormId`);
ALTER TABLE `jos_rsform_submission_values` ADD INDEX (`FormId`);
ALTER TABLE `jos_rsform_submission_values` ADD INDEX (`Submiss
Please note: my help is not official customer support. To receive your support, submit a ticket by clicking here
Regards,
RSJoomla! Development Team
Last Edit: 13 years 11 months ago by andreic.
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!