[Solved] SubForm Reload error when using TEST server

Creating and using forms
Post Reply
MrEgg964
Posts: 12
Joined: Mon May 26, 2014 5:51 pm

[Solved] SubForm Reload error when using TEST server

Post by MrEgg964 »

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

GRANT USAGE ON *.* TO 'myuser'@'%' IDENTIFIED BY PASSWORD <secret>
GRANT ALL PRIVILEGES ON `mydatabase`.* TO 'myuser'@'%' WITH GRANT OPTION 
test server:

Code: Select all

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

Post by MrEgg964 »

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
Post Reply