Migration Error: Call to a member function NumRows()

[partnerwerk]

I am trying to migrate from Version 5.4 to latest Corebos and receive the following error:
Fatal error: Call to a member function NumRows() on boolean in /var/www/clients/client1/web10/web/include/install/resources/utils.php on line 307

What is it about and what can I do to make it working?

[joebordes]

It seems to be having problems counting the number of available tables. Are you using mysql or mysqli?
Let me see if I can find a vt5.4 database and give it a try....

[partnerwerk]

(01-06-2017, 12:13 PM)joebordes Wrote: It seems to be having problems counting the number of available tables. Are you using mysql or mysqli?
Let me see if I can find a vt5.4 database and give it a try....

mysqli

Thanks, for the quick reply.

[joebordes]

Sorry, I don't know what I was thinking when I answered you.

coreBOS is the natural evolution of vtiger crm 5.4, so there is no migration script for a 5.4 database. One of the first things we did when we adopted the abandoned project was add coreBOS Updater

http://corebos.org/documentation/doku.php?id=en:devel:corebosupdater

Updater takes care of maintaining your database up to date with our code development. Once you are on coreBOS you can easily update your code from github and then load and apply the necessary database changes, you will never have to launch a migration script again.

The migration process that is in place is for versions lower than 5.4, to get them to 5.4.

So our goal for a vtiger CRM 5.4 database is to install coreBOS updater and have that extension take it from there.

You can read the details on this documentation page:

http://corebos.org/documentation/doku.php?id=en:upgradevt2cb

High level the idea is to setup a coreBOS copy with a copy of your database, install updater and apply the changes.

Give that a try and keep me informed.

[partnerwerk]

(01-06-2017, 01:16 PM)joebordes Wrote: http://corebos.org/documentation/doku.php?id=en:upgradevt2cb

High level the idea is to setup a coreBOS copy with a copy of your database, install updater and apply the changes.

Give that a try and keep me informed.

Thank you Joe,

I followed the instructions but receive an error message when attempting to login:

Code:

Migration Incompleted. Please contact your system administrator.

So I found in table vtiger_version there was an entry 5.5.0 which I changed to 5.4.0.
Now I get the login screen but the credentials do not work although I copied the folder user_privileges from the former installation.

[joebordes]

You haven't changed the vtigerversion.php file.

You have to set it to 5.4 and then back to 5.5 when you finished.

Anyway this issue got me thinking about the version and that whole check has been eliminated now.

https://github.com/tsolucio/corebos/commit/d63ba631b695da4e9c7709e5450f5a4cc922b3dc

Update your code and try again.

[partnerwerk]

I got my login working again but run into difficulties with the installupdater.php

Code:

ERROR installing !
Failed Queries Log

The Failed Queries Log is empty.