A) Ok noted for copy. Procedure that I did:
In my Joomla 3.8.8 environment, I exported the 3.8.1 Fabrik 6 mentioned tables. I didn't export the fabrik_connection table.
On a different machine, I installed Joomla 3.9 + Fabrik 3.9. In phpmyadmin I dropped the 6 before mentioned Fabrik 3.9 tables and imported instead the 6 Fabrik 3.8.1 tables.
In new Joomla 3.9 backend I created a connection to the db needed for my list and tested the connection.
This id was 3 in my previous setup - but now a 2, (because it is a test database and I have been experimenting a bit and had more connections). I guess I should have just imported this table as well.
So therefore I changed, inside the relevant fabrik_lists, the connection_id column=2 for the particular list.
But ok, I will not do that.
B) Noted on warning. I did
not use a content type I exported myself as per your link in post above (
http://fabrikar.com/forums/index.php?wiki/content-type/) .
I did not move my Fabrik files, only the db tabels.
My problem on the update was initially a too low upload_max_filesize/memory_limit. Both were set too way too low. My mistake of course, I should have checked it more carefully.
Error said something about : Allowed memory size of 2097152 bytes exhausted (tried to allocate 32768 bytes) in /var/www/html/plugins/system/fabrik/fabrik.php on line 510
I also had issues on ownership of some files, they should have been apache but were root, so there were issues on copying files from the /tmp folder
After trying to install where thing went wrong due to above, Fabrik dissapeared from the components dropdown.
After fixing issues above, on install in the manage ->install , upload package file, after a few seconds I am back at the "upload package file".
But nothing has been installed. error_log says something about:
PHP Fatal error: Uncaught JDatabaseExceptionExecuting: Table 'joomla_users' was not locked with LOCK TABLES in /var/www/html/libraries/joomla/database/driver/mysqli.php:661\nStack trace:\n#0 /var/www/html/libraries/joomla/database/driver.php(1455): JDatabaseDriverMysqli->execute()\n#1 /var/www/html/libraries/src/Table/User.php(86): JDatabaseDriver->loadAssoc()\n#2 /var/www/html/libraries/src/User/User.php(883): Joomla\\CMS\\Table\\User->load('861')\n#3 /var/www/html/libraries/src/User/User.php(946): Joomla\\CMS\\User\\User->load('861')\n#4 [internal function]: Joomla\\CMS\\User\\User->__wakeup()\n#5 /var/www/html/libraries/vendor/joomla/registry/src/Registry.php(89): unserialize('O:8:"stdClass":...')\n#6 /var/www/html/libraries/src/Session/Session.php(386): Joomla\\Registry\\Registry->__clone()\n#7 /var/www/html/libraries/joomla/session/handler/native.php(189): Joomla\\CMS\\Session\\Session->getData()\n#8 [internal function]: JSessionHandlerNative->save()\n#9 {main}\n thrown in /var/www/html/libraries/joomla/database/driver/mysqli.php on line 661, referer:
http://localhost/administrator/index.php?option=com_installer
[Thu Nov 22 14:49:39.786997 2018] [php7:warn] [pid 5065] [client ::1:32824] PHP Warning: Unknown: Failed to write session data using user defined save handler. (session.save_path: /var/lib/php/session) in Unknown on line 0, referer:
http://localhost/administrator/index.php?option=com_installer
I use another joomla 3.9 compatible component and it has the same issue on install - so it is not a Fabrik issue.
Also it is not a problem on joomla 3.9 fresh install with Fabrik and other component on top of this.
I just think something is broken. Therefore I wanted to start from fresh. (with some more awaress of permissions, sizes and a more tidyness from now on ;-)).
I think also due to B) I will reconfigure everything again.
Thanks for your help troester!