• 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: Table 'seerworx_seerworx.jos_RSFORM_COMPONENTS' do

Table 'seerworx_seerworx.jos_RSFORM_​COMPONENTS' do 16 years 4 months ago #6030

Can someone please assist with this issue. I really need help. I have created several forms with this component.

I created the forms on my local machine and when I pushed it live, I get this error message.

Table 'seerworx_seerworx.jos_RSFORM_COMPONENTS' do

Can someone explain to me how to make the necessary change on the live hosting server. Thanks!
The administrator has disabled public write access.

Re:Table 'seerworx_seerworx.jos_RSFORM_​COMPONENTS' do 16 years 4 months ago #6041

  • bertm
  • bertm's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 5
  • Thank you received: 1
I am just now discovering a related problem. If you look at your database using MySQL you will probably see that there are two sets of tables for RSFORMS. One set is in full caps and the other is in lower case. It seems that your exported and uploaded forms get imported with the table names in full caps. Linux distinguishes between upper/lower case, whereas Windows does not (WinMySQL defaults to lower case). You can probably see that there are a number of potential potholes in this situation. My case seems similar to yours, but I cannot guarantee that the remedy will be exactly the same.

I installed on my local server (WAMP) messed around with a few forms then cloned it to my livesite. I then built my final forms on WAMP, exported them, then uploaded (imported) to my livesite. After importing the new form to my livesite, I noticed that my example forms crapped out (or disapeared entirely, I cant remember). Then I tried to clone the site back down to WAMP, and got a duplicate table error in the SQL database import process. I opened the SQL file and saw that there were two sets of RSFORMS tables - upper & lower case. The tables that I want to keep are in UPPERCASE. The examples and experiments from before are contained in the tables in lower case.

So I am about to blow away the tables in lower case on my livesite. I have experimented on my local site and I feel confident there will be no problems. I hate doing this kind of surgery to a livesite, but I think I have no other alternative.

I guess there is an error in RSFORMS export/import routines, using caps for table names rather than lowercase. I have not tried to track that one down yet.

Under Linux, it looks like the tables in CAPS show up at the top of the database and are grabbed properly by RSforms. It seems that the forms contained in the lowercase tables can be seen at least partially by the backend, but fail completely on the front end. Is that what you see?<br><br>Post edited by: bertm, at: 2009/01/04 00:34
The administrator has disabled public write access.

Re:Table 'seerworx_seerworx.jos_RSFORM_​COMPONENTS' do 16 years 4 months ago #6250

  • bertm
  • bertm's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 5
  • Thank you received: 1
hate to 'bump' but isn't this a bug?
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!