Problem with visforms update

He,
I have a problem with the visForms update.
Everything works well (theoretically) except the definition of new and updating old fields.
Then a message appears: Unknown column 'dataordering' in 'field list'.
When viewing component updates, the following:
Cannot upgrade 3.11.3.to 3.11.3
But the list shows 3.10.4 (installed) to 3.11.3 (available).

The PHP error logs include the entry:
Got error 'PHP message: PHP Notice: Undefined property: stdClass::$savesettings in /home/.../public_html/...../public/components/com_visforms/models/visforms.php on line 283\n', referer: https://.....edu.pl/index.php/oferta/formularz-zgloszeniowy/sp-zcd-1-2018

I tried to do a clean installation and import declared earlier forms and fields. As you can see, something has changed in the table diagram?
I have no ideas to solve.
I am asking for help in finding a solution to the problem.

About the system:
Joomla! 3.8.12 Stable
PHP: 7.0.26-1+0~20171129100718.10+stretch~1.gbp95da5c

Regards
Mariusz Pulkowski

Hi Mariusz,

I'm sorry for your trouble.
It looks to me, as if something really went wrong during the update from Visforms 3.10.4 to 3.11.3. I have tried to make the update process as secure as possible but sometimes such things just happen. That is, why it is so important to have a full backup of your Website and Database, before you start an update, so that you can go back and try again.

Basically the way you tried to solve the problem is ok (to do a clean install and import the database). Your problem is, that there where some changes to the database (fields and a new table added) which simple are missing, because you imported from the database from an older version.

To fix the problem you must create the missing fields manually.

You have to add one field to the #__visforms table
name: savesettings
type: text

You have to add three fields to teh #__visfields table
displayImgAsImgInList tinyint(1) NOT NULL default 0
displayImgAsImgInDetail tinyint(1) NOT NULL default 0
dataordering int(11) not null DEFAULT 0

You probably have to create the new table #__visverificationcodes (if it does not already exist)
You can use the following sql statement for that, just replace #_ with the proper table prefix
create table #__visverificationcodes (
id int(11) not null AUTO_INCREMENT,
fid int(11) NOT NULL DEFAULT 0,
created datetime NOT NULL default '0000-00-00 00:00:00',
email varchar(100) default '' not null,
code varchar(30) default '' not null,
KEY `idx_email` (`email`),
KEY `idx_fid` (`fid`),
primary key (id)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;

Regards,
Aicha

He,
Thank you for a quick and comprehensive answer.
Problem solved.
I admit that the first time I had such problems with the update.

Thank you again for help.
Regards
Mariusz Pulkowski

Hi,

I'm happy to hear, that you could solve the problem. As far as I know, such a thing happens extremely rarely and I think it is not caused by the Visforms update itself but by some "external" problem which just happened at that time (slow connection, to long execution time or something like that).

Regards,
Aicha