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
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 test server, I do get the errors stated above.
Any idea on how to solve this?
Thanks