I have sent the following questions to support, but having read of lack of answers from this forum I would like to ask if anyone here has any ideas for me. I am quite new to Joomla websites but have been learning so not too technical please.


I have an RSFormPro license and used the component to build forms on a live website.
My live site was hacked and destroyed but I had all my backups to duplicate on my local host site.

But it turned out that the RSForms component that I had backed up on my live site would not transfer to my local site.
I think this is a major shortcoming in a piece of commercial software.

I did have all the database from my live site and thought I would then just need to transfer the relevant tables.
However when attempting to transfer jos_rsforms_forms from my old database into my local database I received the MySQL error message

Well, after waiting 15 days I have received no response from support for this component.

Thought I would post here again as a warning to other potential users of this component.
I decided I would try further to solve my own problems as I was able recently to get my live site up and running again, so decided to build my lost forms again from scratch. Here is exactly what I did:

Hello,

I'm terribly sorry your site was hacked. However, you have been receiving support from one of my colleagues as far as I know and things are coming along.
The component can be used on both live and development websites, as long as you use the same version. It seems to me that you used an older version on the hacked website, that's why you kept getting the MySQL errors when trying to restore the backup on a newer version of RSform! Pro.

Well it seems that posting to this forum yesterday generated some interest from support. Thank you for this response and to Alex

Hello,

It seems to me there are perhaps different versions of MySQL. The MySQL query does contain the JOIN syntax which could be part of your problem, if you have an older MySQL version. Could you tell me what version do you use on your live site, where you encounter these problems ?

Hello,
Thanks for responding so quickly to this.
The version of MySql on my remote sever is 5.0.67-community
On my local site it is 5.0.51b
Its not that long since I downloaded and installed the local server, yet it looks as though that might be the older version of MySql ??

It is the live site that is working correctly and the local site that will not generate new layouts.
I

Hello,

Finally got to the middle of this - there is a bug in our RSform! Pro version, some php tags were left short opened(<? instead of <?php).
It appears that your live server allows short open tags but the local one doesn't. Set short_open_tag in your local php configuration to On (either modify the global php.ini file or create a new text document in the root of your Joomla! installation, rename it to php.ini and type short_open_tag = On)

This bug will be solved in the next update.

Hello,

Thank you for investigating the reason behind this. I really appreciate your help.

I tried to make the change but I was unsure where to find the php.ini file on my local server.
So I looked in my configuration.php file to see if there was any reference to short_open_tag.
When I saw there was not I made the new text file as you said in my Joomla root and called it php.ini.
The issue still remained.

Searched further and thought I had found the correct file in C:\wamp\bin\php\php5.2.6\php
But after I changed to

Hello,

In your server's php.ini configuration, please make sure the short_open_tag is not preceded by any \";\" character. So it should read only:on a new line.

You should probably restart the web server after this change.

Nope.......had already checked both these things. Sorry.

Ok, try this: open the file administrator/components/com_rsform/admin.rsform.html.php and replace \"<? \" with \"<?php \" (remove the quotes, keep the extra space at the end). There should be 5 tokens replaced.

The file I found was ...../com_rsform/rsform.html.php (no admin)

It already was \"<?php although there was no space after it.
So I tried adding a space to see if it made any difference. But no.

Hello,

The directory path where that file is located is administrator/components/com_rsform.
You were probably searching in components/com_rsform.

I'm sorry, I've gone to the correct directory now.

However, with the same result. It was already <?php, and again I tried adding a space.

I think I'll just not use that first inline option do you think........ or maybe you prefer to find the solution for your self anyway??

I've just downloaded R19 of RSform! Pro and administrator/components/com_rsform/admin.rsform.html.php has <? instead of <?php on lines 250, 256, 262, 268 and 273.
Line 273 looks like this:Instead, it should look like this:The same applies for other lines. Hope this finally works for you.

I can't actually find this line \"273\" anywhere. Trawled through the file and the only lines I can find referring to form layout are:

<input type=\"hidden\" name=\"FormName\" value=\"\"/>
<input type=\"hidden\" name=\"FormLayout\" value=\"\"/>
<input type=\"hidden\" name=\"FormLayoutName\" value=\"\"/>
<input type=\"hidden\" name=\"FormLayoutAutogenerate\" value=\"\"/>
<input type=\"hidden\" name=\"FormTitle\" value=\"\"/>

These are somewhere around line 400-ish (how do you keep count?)
I did see a few lines starting at 254 that had a <? instead of <?php but not at 250. But without anything resembling what you say should be at 273, then I'm not going to start changing anything.
???

If you use Notepad, go to Edit -> Go To and type the line numbers I gave you.
Maybe you can paste them here if they don't resemble to what they're supposed to.

Hi,

My OS is Vista and uses Wordpad rather than Notepad. Wordpad does not have a Goto function to find specific lines. I can use its 'find' function by pasting in your copy of the text of line 273. So I was able to find and change that line. I guessed where the other lines might be but I guessed incorrectly and the component would not function after I changed a few ?php's.

So I tried again and ONLY changed line 273. The component actually seems to be working correctly now. If you think lines 250, 256, 262, and 268 really do still need to be changed then I think the only way that I will be able to identifiy them correctly is if you send me the actual text in these lines, then I can do what I just did to find line 273.

However, as I said, the component SEEMS to be working, and maybe I can leave it at that. ??


or??? here is a big chunk of text (unidentifiable lines to me) leading up to and ending with (the now altered) line 273

echo _RSFORM_BACKEND_FORMS_EDIT_LAYOUT_INLINE;?><br/>
<img src=\"<?php echo _RSFORM_BACKEND_REL_PATH.\"/images/layouts/inline.gif\";?>\" width=\"175\"/>
</label>
</div>
<div style=\"border:1px solid #cccccc;width:185px;margin:5px;padding:2px;float:left;\">
<label for=\"formLayout2lines\">
<input type=\"radio\" id=\"formLayout2lines\" name=\"formLayoutOption\" value=\"2lines\" onClick=\"saveLayoutName('<? echo $formId; ?>','2lines')\" <?php RSreturnCheckedLayoutName($formId,'2lines') ?>/><?php echo _RSFORM_BACKEND_FORMS_EDIT_LAYOUT_2LINES;?><br/>
<img src=\"<?php echo _RSFORM_BACKEND_REL_PATH.\"/images/layouts/2lines.gif\";?>\" width=\"175\"/>
</label>
</div>
<div style=\"border:1px solid #cccccc;width:185px;margin:5px;padding:2px;float:left;\">
<label for=\"formLayout2colsinline\">
<input type=\"radio\" id=\"formLayout2colsinline\" name=\"formLayoutOption\" value=\"2colsinline\" onClick=\"saveLayoutName('<? echo $formId; ?>','2colsinline')\" <?php RSreturnCheckedLayoutName($formId,'2colsinline') ?> /><?php echo _RSFORM_BACKEND_FORMS_EDIT_LAYOUT_2COLSINLINE;?><br/>
<img src=\"<?php echo _RSFORM_BACKEND_REL_PATH.\"/images/layouts/2colsinline.gif\";?>\" width=\"175\"/>
</label>
</div>
<div style=\"border:1px solid #cccccc;width:185px;margin:5px;padding:2px;float:left;\">
<label for=\"formLayout2cols2lines\">
<input type=\"radio\" id=\"formLayout2cols2lines\" name=\"formLayoutOption\" value=\"2cols2lines\" onClick=\"saveLayoutName('<? echo $formId; ?>','2cols2lines')\" <?php RSreturnCheckedLayoutName($formId,'2cols2lines') ?>/><?php echo _RSFORM_BACKEND_FORMS_EDIT_LAYOUT_2COLS2LINES;?><br/>
<img src=\"<?php echo _RSFORM_BACKEND_REL_PATH.\"/images/layouts/2cols2lines.gif\";?>\" width=\"175\"/>
</label>
</div>
<br/>
<input type=\"hidden\" name=\"formLayoutStyle\" id=\"formLayoutStyle\" value=\"<?php echo RSgetFormLayoutName($formId); ?>\"/>

Hello,

Here are the exact lines that you need to modify:

Replace every \"<? \" with \"<?php \".

Hello and thank you yet again. I have made all the changes and everything is working.

I have so much appreciated all the support you have given through this forum.
After the initial delay with the support through the ticketing system that worried me for future use (maybe the systems still need to be addressed?), the dialogue here with admin has been outstanding.
I am therefore pleased to be able to say this to all prospective users of this component.
If I had not found the component so useful in the first place I would not have been as keen to find a solution to my issues.

I am now able to thoroughly recommend this product.

Anne-Marie