20 replies to this topic

[lucas.corbeaux]

Hi Zurmo community,

As I tried to install Zurmo on a virtualized Ubuntu 12.04, I encountered an issue in the "run installation" step.

I have the following warning that blocks the install :

Invalid argument supplied for foreach()
/home/xxx/zurmo/app/protected/modules/zurmo/utils/ReadPermissionsOptimizationUtil.php(911)

I investigated a bit, and it seems that the following query returns an error :

$sql = "select securableitem_id
						 from   ownedsecurableitem
						 where  owner__user_id = $userId";

And in fact, the ownedsecurableitem doesn't exists in my database after running the install script. Here is the list of tables created by the installation process :

_group
_group__user
_right
_user
address
auditevent
basecustomfield
currency
customfield
customfielddata
customfieldsmodel
email
emailbox
emailfolder
item
ownedcustomfield
permitable
person
policy
role

Any clue of what happened ?

I also have a suggestion : in the settings form, the Super User password field is a text field instead of password, here is a really simple patch that "fix" it. Sorry for the .txt extension, I'm not allowed to post .patch files.

Attached Files

•  zurmo-superUserPassword-text-to-password.txt   970bytes   20 downloads

[Jason]

Which version of the application are you using? Also can you paste the query error you are seeing? Maybe it is complaining that the table is missing but I would like to confirm. Another thing to help is if you run the unit tests locally, hopefully it will help us identify more about this problem.

[speixoto]

I got the same error using ubuntu 12.04 and using a fresh cloned version from the zurmo/zurmo repository. Runing unit tests localy i get:

"PHP Warning: Invalid argument supplied for foreach() in /var/www/zurmo/app/protected/modules/zurmo/utils/ReadPermissionsOptimizationUtil.php on line 911"

Ill attach a print screen from the Instalation error page i get.

Attached Files

•  mozilla.pdf   99.71K   190 downloads

[Jason]

Ok. We will need to investigate this further. I know we made a change to something with the installation recently, but all tests pass for us in our server configs so not sure why this is happening.

[Jason]

Did both you guys use the virtualized image we have available for download?

[Ivica]

I am checking this issue, but I need to know which version of PHP is used on your servers?

[Ivica]

Can you update your code to previou s stable version, for example 0.6.80, and try to run installation again? Version that you try to install pass all out unit tests, and works on our computers, so we need your help to find and fix this issue.
You can use command:
hg update 71b23244411c
and try to install application again.
And please inform me which PHP version is installed on your server.

I got the same error using ubuntu 12.04 and using a fresh cloned version from the zurmo/zurmo repository. Runing unit tests localy i get:

"PHP Warning: Invalid argument supplied for foreach() in /var/www/zurmo/app/protected/modules/zurmo/utils/ReadPermissionsOptimizationUtil.php on line 911"

Ill attach a print screen from the Instalation error page i get.

[speixoto]

I got the same problem with the stable version.

I'll attach two more files (phpinfo and unit tests resutl).

Attached Files

•  phpinfo.pdf   109.01K   48 downloads
•  UnitTests.txt   15.78K   73 downloads

[Ivica]

But have you tried previous stable version: 0.6.80(changeset 71b23244411c). This is important for me to know, so I can know when this issue started to happen.

Your PHP settings look fine.

I got the same problem with the stable version.

I'll attach two more files (phpinfo and unit tests resutl).

[speixoto]

But have you tried previous stable version: 0.6.80(changeset 71b23244411c). This is important for me to know, so I can know when this issue started to happen.

Your PHP settings look fine.

Yes, i tried that stable version (0.6.80).

[Ivica]

Can you try to run tests with unfrozen database:
phpunit TestSuite.php All --no-freeze

About your tests that fails, you need to setup email test email accounts, and testApiUrl in perInstanceTest.php file, and many of those tests that fails should pass.

[lucas.corbeaux]

Hi there, thanks for your replies.

Which version of the application are you using? Also can you paste the query error you are seeing? Maybe it is complaining that the table is missing but I would like to confirm. Another thing to help is if you run the unit tests locally, hopefully it will help us identify more about this problem.

I cloned the last version of Zurmo, and I tried the last stable too with the same results. I don't see query error during installation, only when I try to execute the query into my mysql client (in the same database). I tried to trace the RedBean error message right after the query that returns null, using R::$adapter->getErrorMsg(), but the error message seems to be empty. And yes, I run unit tests locally.

Can you try to run tests with unfrozen database:
phpunit TestSuite.php All --no-freeze

I tried to launch only install module tests :

phpunit TestSuite.php install --no-freeze

There is 4 errors :

1) AutoBuildDatabaseTest::testAutoBuildDatabase
Invalid argument supplied for foreach()

2) InstallUtilTest::testRunInstallation
Invalid argument supplied for foreach()

3) InstallUtilTest::testRunInstallationWithoutMemCacheOn
Invalid argument supplied for foreach()

4) InstallWalkthroughTest::testAllActions
Invalid argument supplied for foreach()

It seems to be a very environment specific problem (I don't remember such behavior in my Mac OS X), I'll try to take a deeper look tomorrow.

[Jason]

Hi there, thanks for your replies.



I cloned the last version of Zurmo, and I tried the last stable too with the same results. I don't see query error during installation, only when I try to execute the query into my mysql client (in the same database). I tried to trace the RedBean error message right after the query that returns null, using R::$adapter->getErrorMsg(), but the error message seems to be empty. And yes, I run unit tests locally.



I tried to launch only install module tests :

phpunit TestSuite.php install --no-freeze

There is 4 errors :


It seems to be a very environment specific problem (I don't remember such behavior in my Mac OS X), I'll try to take a deeper look tomorrow.

We narrowed it down with the help of
speixoto

We think it is related to R::getCol not returning an array when empty in your environment, but returning Null. Maybe you can figure out why

[lucas.corbeaux]

Ok I think I got it... I wasn't using the right RedBean version, and in this case the ownedsecurableitem table were never created. I probably downloaded the v1.3.2L instead of v1.3.2, but I can't figure out how this happens, as I already installed Zurmo 3 or 4 times... Replaced with the good one, everything is ok now (install process and install unit tests), sorry for the beginner mistake !

[Jason]

Ok I think I got it... I wasn't using the right RedBean version, and in this case the ownedsecurableitem table were never created. I probably downloaded the v1.3.2L instead of v1.3.2, but I can't figure out how this happens, as I already installed Zurmo 3 or 4 times... Replaced with the good one, everything is ok now (install process and install unit tests), sorry for the beginner mistake !

Glad you figured it out. The installation let you complete with the wrong version?

[lucas.corbeaux]

Glad you figured it out. The installation let you complete with the wrong version?

No, the installation failed after the settings step, the warning on ReadPermissionsOptimizationUtil.php stopped the process.

[speixoto]

Can you try to run tests with unfrozen database:
phpunit TestSuite.php All --no-freeze

About your tests that fails, you need to setup email test email accounts, and testApiUrl in perInstanceTest.php file, and many of those tests that fails should pass.

What info should i put in $emailTestAccounts? Whats the diference between userSmtpSettings and smtpSettings? IsdropboxImapSettings the settings for DropBox account?

And, how should i make perInstanceTest.php not changeble when i run unit tests again?

[Jason]

No, the installation failed after the settings step, the warning on ReadPermissionsOptimizationUtil.php stopped the process.

Well it should have failed in the system check screen. We will have to work to get that fixed.

[lucas.corbeaux]

Well it should have failed in the system check screen. We will have to work to get that fixed.

I'm not sure that will be so easy, as my wrong rb.php file had the same version number : getVersion returns "1.3" for both files. As we need to manually patch the file during install, using a checksum to ensure the rb.php is OK might be difficult too.

[Jason]

I'm not sure that will be so easy, as my wrong rb.php file had the same version number : getVersion returns "1.3" for both files. As we need to manually patch the file during install, using a checksum to ensure the rb.php is OK might be difficult too.

speixoto made a pull request, i have to pull in. https://bitbucket.or...on-132l-file-is It is interesting how he did it.