[Solved] SubForm Reload error when using TEST server

Creating and using forms

[Solved] SubForm Reload error when using TEST server

Postby MrEgg964 » Thu Sep 21, 2017 11:45 am

Hi all,

I'm having a bit of an issue when reloading a sub-form, with 'Parameter index out of range' or 'Failed to refetch row' errors.

I have 2 exact copies of the same odb files, one being PROD.ODB and the other TEST.ODB. Prod.odb connects to the prod server, Test.odb connects to the test server. Prod server is running mysql 5.5, Test server is running mysql version 5.7.

Both databases are called the same on each server, with the exact same users and user grants. SHOW GRANTS FOR 'myuser'@'%'; shows a slight difference:
prod server:
Code: Select all   Expand viewCollapse view
GRANT USAGE ON *.* TO 'myuser'@'%' IDENTIFIED BY PASSWORD <secret>
GRANT ALL PRIVILEGES ON `mydatabase`.* TO 'myuser'@'%' WITH GRANT OPTION


test server:
Code: Select all   Expand viewCollapse view
GRANT USAGE ON *.* TO 'myuser'@'%'
GRANT ALL PRIVILEGES ON `mydatabase`.* TO 'myuser'@'%' WITH GRANT OPTION


When I connect either PROD.odb or TEST.odb to the production server, everything works fine, ie sub-form reloading has no issue whatsoever.

When I connect either PROD.odb or TEST.odb to the test server, I do get the errors stated above.

Any idea on how to solve this?

Thanks
LibreOffice 4.2.4.2 on Ubuntu 12.04
MrEgg964
 
Posts: 12
Joined: Mon May 26, 2014 5:51 pm

Re: [SOLVED] SubForm Reload error when using TEST server

Postby MrEgg964 » Thu Sep 21, 2017 4:19 pm

I solved this issue like so:
    1. install mysql 5.5 on the test server, so as to be using the same version on both prod and test
    2. delete /var/lib/mysql/* on the test server (or whatever datadir you may be using)
    3. rsync prodserver:/var/lib/mysql/ testserver:/var/lib/mysql

Hope this help anyone having similar or comparable issues.

Regards
LibreOffice 4.2.4.2 on Ubuntu 12.04
MrEgg964
 
Posts: 12
Joined: Mon May 26, 2014 5:51 pm


Return to Forms

Who is online

Users browsing this forum: Exabot [Bot] and 3 guests