• 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: Missing KeepIP db column in JMS multisite

Missing KeepIP db column in JMS multisite 9 years 10 months ago #31444

  • azurelink
  • azurelink's Avatar
  • OFFLINE
  • Junior Boarder
  • Posts: 30
  • Thank you received: 3
I'm running a Joomla 3.4.1 site which has JMS MultiSites installed and I have the 1 master site and about 5 slave sites running on it. In JMS I have the option to share one database, or for each slave to run on its own database. I'm using the latter option, each slave runs on it's own database.

I recently upgraded RSForm Pro from 1.50.0 to 1.50.16 using the method precscribed by JMS (upgrade the extension in the parent site, then in each slave site using Extension Manager.)

PROBLEM:

After the upgrade, my forms are not working properly. I'm getting an error saying that the db column KeepIP does not exist in the _rsform_forms table. It does exist in the upgraded parent database. Why did it not get added to the slave databases during the extension upgrade? What is the process for upgrading from 1.50.0 to 1.50.16? In the past, I usually just install it over the old one in Extension Manager/Install.

Below is the text of an error I get when trying to save a change to the admin email address property in one of my forms.

Please help.

Should I manually add the KeepIP column to my slave databases? What other db structure changes were included between those versions? (1.50.0 to 1.50.160)

Thanks.
1054 Unknown column 'KeepIP' in 'field list' SQL=UPDATE `bgj_rsform_forms` SET `FormName`='Business Card Order Form',`FormLayout`='<h2>Step One: Layout Options (Continued)</h2>\r\n<p><em>All business cards will be double-sided, at no additional cost. You may choose to have an appointment card on the reverse side, or XYZ Company\'s social media network sites listed (Facebook and Twitter).</em></p>\r\n<p>Appointment card option:</br><img style=\"border: 1px solid #627d77;\" src=\"images_specific/stories/xyz_appt-card_back.jpg\"></p>\r\n<p>Social media option:</br><img style=\"border: 1px solid #627d77;\" src=\"images_specific/stories/xyz_bcard_back.jpg\"></p>\r\n {appointmentoption:caption}<span class=\"req\">*</span><br/>\r\n {appointmentoption:body}<br/>\r\n {appointmentoption:validation}\r\n {appointmentoption:description}<br/>\r\n<hr></hr>\r\n<h2>Step Two: Personal Information</h2>\r\n {name:caption}<span class=\"req\">*</span><br/>\r\n {name:body}<br/>\r\n {name:validation}\r\n {name:description}<br/>\r\n {degree:caption}<br/>\r\n {degree:body}<br/>\r\n {degree:validation}\r\n {degree:description}<br/>\r\n {job_title:caption}<span class=\"req\">*</span><br/>\r\n {job_title:body}<br/>\r\n {job_title:validation}\r\n {job_title:description}<br/>\r\n {department:caption}<br/>\r\n {department:body}<br/>\r\n {department:validation}\r\n {department:description}<br/>\r\n {email:caption}<span class=\"req\">*</span><br/>\r\n {email:body}<br/>\r\n {email:validation}\r\n {email:description}<br/>\r\n {direct_phone:caption}<span class=\"req\">*</span><br/>\r\n {direct_phone:body}<br/>\r\n {direct_phone:validation}\r\n {direct_phone:description}<br/>\r\n {additional_phone:caption}<br/>\r\n {additional_phone:body}<br/>\r\n {additional_phone:validation}\r\n {additional_phone:description}<br/>\r\n {fax:caption}<br/>\r\n {fax:body}<br/>\r\n {fax:validation}\r\n {fax:description}<br/>\r\n {address:caption}<br/>\r\n {address:body}<br/>\r\n {address:validation}\r\n {address:description}<br/>\r\n\r\n<hr></hr>\r\n<h2>Step Three: Quantity</h2>\r\n {quantity_radio:caption}<span class=\"req\">*</span><br/>\r\n {quantity_radio:body}<br/>\r\n {quantity_radio:validation}\r\n {quantity_radio:description}<br/>\r\n<em>Prices do not include shipping costs and should not be entered on your PRF; shipping rates vary based on the total amount ordered.</em>\r\n<hr></hr>\r\n<h2>Step Four: Finalize and Submit</h2>\r\n {admin_name:caption}<span class=\"req\">*</span><br/>\r\n {admin_name:body}<br/>\r\n {admin_name:validation}\r\n {admin_name:description}<br/>\r\n {admin_email:caption}<span class=\"req\">*</span><br/>\r\n {admin_email:body}<br/>\r\n {admin_email:validation}\r\n {admin_email:description}<br/>\r\n {doublecheck:caption}<br/>\r\n {doublecheck:body}<br/>\r\n {doublecheck:validation}\r\n {doublecheck:description}<br/>\r\n {submit:caption}<br/>\r\n {submit:body}<br/>\r\n {submit:validation}\r\n {submit:description}<br/>\r\n</div>\r\n',`FormLayoutName`='2lines',`FormLayoutAutogenerate`='0',`CSS`='',`JS`='',`FormTitle`='PHMC General Card',`ShowFormTitle`='1',`Lang`='en-GB',`Keepdata`='1',`KeepIP`='1',`ReturnUrl`='',`ShowThankyou`='1',`ShowContinue`='1',`UserEmailTo`='{admin_email:value}',`UserEmailCC`='',`UserEmailBCC`='',`UserEmailFrom`='communications@phmc.org',`UserEmailReplyTo`='',`UserEmailFromName`='XYZ Company',`UserEmailSubject`='You have successfully submitted an order for a new business card.',`UserEmailMode`='1',`UserEmailAttach`='0',`UserEmailAttachFile`='',`AdminEmailTo`='admin@xyzcompany.com',`AdminEmailCC`='',`AdminEmailBCC`='',`AdminEmailFrom`='admin@xyzcompany.com',`AdminEmailReplyTo`='',`AdminEmailFromName`='XZY Company',`AdminEmailSubject`='Someone has submitted an order for a new business card.',`AdminEmailMode`='1',`ScriptProcess`='',`ScriptProcess2`='',`ScriptDisplay`='',`UserEmailScript`='',`AdminEmailScript`='',`AdditionalEmailsScript`='',`MetaTitle`='0',`MetaDesc`='',`MetaKeywords`='',`Required`='(*)',`MultipleSeparator`='\\n',`TextareaNewLines`='1',`CSSClass`='',`CSSId`='userForm',`CSSName`='',`CSSAction`='',`CSSAdditionalAttributes`='',`AjaxValidation`='0',`ThemeParams`='',`Backendmenu`='',`ConfirmSubmission`='0',`Access`='',`Published`='1' WHERE `FormId`='3'
Last Edit: 9 years 10 months ago by azurelink. Reason: Fixed typos
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!