cant get it working [#1428232]

i tried to install as out of pox method on my local host
when i run run.sh i got this error

Feb 4, 2012 4:41:15 AM org.drupal.project.async_command.CommandLineLauncher launch
INFO: DrupalApp VERSION: 7_2_9
Feb 4, 2012 4:41:15 AM org.drupal.project.async_command.DrupalUtils locateFile
INFO: DRUPAL_HOME is set to: ../../../..
Feb 4, 2012 4:41:15 AM org.drupal.project.async_command.DrupalConnection create
WARNING: Cannot find config.properties file. Try settings.php now.
Feb 4, 2012 4:41:15 AM org.drupal.project.async_command.DrupalUtils locateFile
INFO: DRUPAL_HOME is set to: ../../../..
Feb 4, 2012 4:41:15 AM org.drupal.project.async_command.DrupalUtils locateFile
INFO: Found file 'settings.php' at: /home/quickstart/websites/book.ate/sites/default/settings.php
Feb 4, 2012 4:41:15 AM org.drupal.project.async_command.DrupalUtils evalPhp
WARNING: Please set PHP_EXEC. Use default php executable instead.
Feb 4, 2012 4:41:27 AM org.drupal.project.async_command.DrupalUtils evalPhp
WARNING: Please set PHP_EXEC. Use default php executable instead.
Feb 4, 2012 4:41:39 AM org.drupal.project.async_command.CommandLineLauncher launch
SEVERE: null
java.lang.NullPointerException
	at org.drupal.project.async_command.DrupalConnection.<init>(DrupalConnection.java:116)
	at org.drupal.project.async_command.DrupalConnection.create(DrupalConnection.java:82)
	at org.drupal.project.async_command.CommandLineLauncher.constructDrupalApp(CommandLineLauncher.java:143)
	at org.drupal.project.async_command.CommandLineLauncher.launch(CommandLineLauncher.java:61)
	at org.drupal.project.recommender.RecommenderApp.main(RecommenderApp.java:26)
Feb 4, 2012 4:41:39 AM org.drupal.project.async_command.CommandLineLauncher launch
INFO: Unexpected errors. Program exits.

Comments

Comment #1

danithaca CreditAttribution: danithaca commented 13 February 2012 at 21:15

Status:

Active

» Postponed (maintainer needs more info)

This module is still in active development so it's not very stable. Please also update to the latest async_command module and try again.

Comment #2

DerTobi75 CreditAttribution: DerTobi75 commented 7 March 2012 at 23:31

Hi,

I got this error, when trying to execute run.sh!

INFO: Total number of commands to run: 1
08.03.2012 00:29:07 org.drupal.project.async_command.Druplet handleException
SCHWERWIEGEND: Unexpected error happens for command: RunRecommender
org.drupal.project.async_command.exception.DrupletException: java.lang.reflect.InvocationTargetException
at org.drupal.project.async_command.Druplet.parseCommand(Druplet.java:238)
at org.drupal.project.async_command.Druplet.runSerial(Druplet.java:377)
at org.drupal.project.async_command.Druplet.run(Druplet.java:284)
at org.drupal.project.async_command.CommandLineLauncher.handleExecutables(CommandLineLauncher.java:107)
at org.drupal.project.async_command.CommandLineLauncher.launch(CommandLineLauncher.java:66)
at org.drupal.project.recommender.RecommenderApp.main(RecommenderApp.java:37)
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
at org.drupal.project.async_command.Druplet.parseCommand(Druplet.java:234)
... 5 more
Caused by: java.lang.NoSuchMethodError: org.drupal.project.async_command.DrupletUtils.decodeJsonObject(Ljava/lang/String;)Ljava/util/Map;
at org.drupal.project.recommender.RunRecommender.prepareCommand(RunRecommender.java:184)
at org.drupal.project.recommender.RunRecommender.(RunRecommender.java:78)
... 10 more
08.03.2012 00:29:07 org.drupal.project.async_command.Druplet runSerial
INFO: Command finished running with status: FAIL

Any idea what could cause this error?

Regards,

Tobi

Comment #3

danithaca CreditAttribution: danithaca commented 8 March 2012 at 00:58

@DerTobi75: Try to use async_command_7.x-2.0-alpha9 and recommender_7.x-4.0-alpha9, and it should fix the dependancy problem

@in a nutshell: The NullPointerException looks like you haven't started MySQL server.

Comment #4

DerTobi75 CreditAttribution: DerTobi75 commented 8 March 2012 at 14:29

Version:

7.x-4.0-alpha6

» 7.x-4.0-alpha7

Hi.

after the update I got the following errors!

INFO: Computing done. Records#: 0
Exception in thread "Delete-Batch" org.drupal.project.async_command.exception.DatabaseRuntimeException: java.sql.BatchUpdateException: Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'
	at org.drupal.project.async_command.BatchUploader.run(BatchUploader.java:102)
Caused by: java.sql.BatchUpdateException: Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'
	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2007)
	at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1443)
	at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
	at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
	at org.drupal.project.async_command.BatchUploader.run(BatchUploader.java:99)
08.03.2012 15:28:29 org.drupal.project.recommender.RunRecommender$AlgorithmImpl genericComputeSave
INFO: Done saving data.
08.03.2012 15:28:29 org.drupal.project.async_command.Druplet runSerial
INFO: Command finished running with status: OKOK
08.03.2012 15:28:29 org.drupal.project.async_command.CommandRecord persistResult
SCHWERWIEGEND: Cannot update command record. Fatal error. Record id: 15
08.03.2012 15:28:29 org.drupal.project.async_command.CommandLineLauncher launch
SCHWERWIEGEND: java.sql.SQLException: Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT' Query: UPDATE async_command SET output=?, id1=?, id2=?, id3=?, id4=?, number1=?, number2=?, number3=?, number4=?, string1=?, string2=?, string3=?, string4=?, status=?, control=?, message=?, weight=?, start=?, end=?, checkpoint=?, progress=? WHERE id=? Parameters: [null, 1, null, null, null, 2.0, 1.0, 0.0, 0.0, null, null, null, null, OKOK, null, Users: 2. Items: 1. (Time spent: 0h0m0s), 0, 1331216909, 1331216909, null, null, 15]
org.drupal.project.async_command.exception.DatabaseRuntimeException: java.sql.SQLException: Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT' Query: UPDATE async_command SET output=?, id1=?, id2=?, id3=?, id4=?, number1=?, number2=?, number3=?, number4=?, string1=?, string2=?, string3=?, string4=?, status=?, control=?, message=?, weight=?, start=?, end=?, checkpoint=?, progress=? WHERE id=? Parameters: [null, 1, null, null, null, 2.0, 1.0, 0.0, 0.0, null, null, null, null, OKOK, null, Users: 2. Items: 1. (Time spent: 0h0m0s), 0, 1331216909, 1331216909, null, null, 15]
	at org.drupal.project.async_command.CommandRecord.persistResult(CommandRecord.java:130)
	at org.drupal.project.async_command.Druplet.runSerial(Druplet.java:390)
	at org.drupal.project.async_command.Druplet.run(Druplet.java:284)
	at org.drupal.project.async_command.CommandLineLauncher.handleExecutables(CommandLineLauncher.java:107)
	at org.drupal.project.async_command.CommandLineLauncher.launch(CommandLineLauncher.java:66)
	at org.drupal.project.recommender.RecommenderApp.main(RecommenderApp.java:37)
Caused by: java.sql.SQLException: Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT' Query: UPDATE async_command SET output=?, id1=?, id2=?, id3=?, id4=?, number1=?, number2=?, number3=?, number4=?, string1=?, string2=?, string3=?, string4=?, status=?, control=?, message=?, weight=?, start=?, end=?, checkpoint=?, progress=? WHERE id=? Parameters: [null, 1, null, null, null, 2.0, 1.0, 0.0, 0.0, null, null, null, null, OKOK, null, Users: 2. Items: 1. (Time spent: 0h0m0s), 0, 1331216909, 1331216909, null, null, 15]
	at org.apache.commons.dbutils.QueryRunner.rethrow(QueryRunner.java:542)
	at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:599)
	at org.drupal.project.async_command.DrupalConnection.update(DrupalConnection.java:351)
	at org.drupal.project.async_command.CommandRecord.persistResult(CommandRecord.java:126)
	... 5 more

Comment #5

DerTobi75 CreditAttribution: DerTobi75 commented 8 March 2012 at 14:35

This is the complete output, when I try to execute run.sh:

08.03.2012 15:32:19 org.drupal.project.async_command.CommandLineLauncher launch
INFO: Druplet VERSION: 7_2_13
08.03.2012 15:32:19 org.drupal.project.async_command.DrupletUtils locateFile
INFO: DRUPAL_HOME is set to: ../../../..
08.03.2012 15:32:19 org.drupal.project.async_command.DrupletUtils loadConfig
WARNUNG: Cannot find config.properties file. Try settings.php now.
08.03.2012 15:32:19 org.drupal.project.async_command.DrupletUtils locateFile
INFO: DRUPAL_HOME is set to: ../../../..
08.03.2012 15:32:19 org.drupal.project.async_command.DrupletUtils locateFile
INFO: Found file 'settings.php' at: /home/xxxx/sites/default/settings.php
08.03.2012 15:32:19 org.drupal.project.async_command.DrupletUtils evalPhp
WARNUNG: Please set PHP_EXEC. Use default php executable instead.
08.03.2012 15:32:19 org.drupal.project.async_command.DrupletUtils evalPhp
WARNUNG: Please set PHP_EXEC. Use default php executable instead.
08.03.2012 15:32:19 org.drupal.project.async_command.Druplet <init>
INFO: Drupal access mode is: LOCAL
08.03.2012 15:32:19 org.drupal.project.async_command.DrupalConnection testConnection
INFO: Database connection successful: MySQL5.1.61-log
08.03.2012 15:32:19 org.drupal.project.async_command.Druplet runSerial
INFO: Total number of commands to run: 3
08.03.2012 15:32:19 org.drupal.project.async_command.Druplet runSerial
INFO: Executing command: RunRecommender
08.03.2012 15:32:19 org.drupal.project.recommender.RunRecommender$AlgorithmImpl run
INFO: Initializing data model, similarity and recommender.
08.03.2012 15:32:19 org.drupal.project.recommender.RunRecommender$AlgorithmImpl initDataModel
INFO: Initializing data model.
log4j:WARN No appenders could be found for logger (org.apache.mahout.cf.taste.impl.model.jdbc.AbstractJDBCDataModel).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
08.03.2012 15:32:19 org.drupal.project.recommender.RunRecommender$AlgorithmImpl initDataModel
INFO: Switching to MEMORY mode. Load all data from database into memory first.
08.03.2012 15:32:19 org.drupal.project.recommender.RunRecommender$AlgorithmImpl run
INFO: Using similarity class: org.apache.mahout.cf.taste.impl.similarity.LogLikelihoodSimilarity
08.03.2012 15:32:19 org.drupal.project.recommender.RunRecommender$AlgorithmImpl run
INFO: Using recommender class: org.apache.mahout.cf.taste.impl.recommender.GenericBooleanPrefItemBasedRecommender
08.03.2012 15:32:19 org.drupal.project.recommender.RunRecommender$AlgorithmImpl run
INFO: Computing and saving similarity data.
Exception in thread "Delete-Batch" org.drupal.project.async_command.exception.DatabaseRuntimeException: java.sql.BatchUpdateException: Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'
	at org.drupal.project.async_command.BatchUploader.run(BatchUploader.java:102)
Caused by: java.sql.BatchUpdateException: Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'
	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2007)
	at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1443)
	at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
	at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
	at org.drupal.project.async_command.BatchUploader.run(BatchUploader.java:99)
08.03.2012 15:32:19 org.drupal.project.recommender.RunRecommender$AlgorithmImpl genericComputeSave
INFO: Start computing recommendation and saving results in serial.
08.03.2012 15:32:19 org.drupal.project.recommender.RunRecommender$AlgorithmImpl genericComputeSave
INFO: Computing done. Records#: 0
08.03.2012 15:32:19 org.drupal.project.recommender.RunRecommender$AlgorithmImpl genericComputeSave
INFO: Done saving data.
08.03.2012 15:32:19 org.drupal.project.recommender.RunRecommender$AlgorithmImpl run
INFO: Computing and saving prediction data.
Exception in thread "Delete-Batch" org.drupal.project.async_command.exception.DatabaseRuntimeException: java.sql.BatchUpdateException: Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'
	at org.drupal.project.async_command.BatchUploader.run(BatchUploader.java:102)
Caused by: java.sql.BatchUpdateException: Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'
	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2007)
	at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1443)
	at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
	at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
	at org.drupal.project.async_command.BatchUploader.run(BatchUploader.java:99)
08.03.2012 15:32:19 org.drupal.project.recommender.RunRecommender$AlgorithmImpl genericComputeSave
INFO: Start computing recommendation and saving results in serial.
08.03.2012 15:32:19 org.drupal.project.recommender.RunRecommender$AlgorithmImpl genericComputeSave
INFO: Computing done. Records#: 0
08.03.2012 15:32:19 org.drupal.project.recommender.RunRecommender$AlgorithmImpl genericComputeSave
INFO: Done saving data.
08.03.2012 15:32:19 org.drupal.project.async_command.Druplet runSerial
INFO: Command finished running with status: OKOK
08.03.2012 15:32:19 org.drupal.project.async_command.CommandRecord persistResult
SCHWERWIEGEND: Cannot update command record. Fatal error. Record id: 15
08.03.2012 15:32:19 org.drupal.project.async_command.CommandLineLauncher launch
SCHWERWIEGEND: java.sql.SQLException: Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT' Query: UPDATE async_command SET output=?, id1=?, id2=?, id3=?, id4=?, number1=?, number2=?, number3=?, number4=?, string1=?, string2=?, string3=?, string4=?, status=?, control=?, message=?, weight=?, start=?, end=?, checkpoint=?, progress=? WHERE id=? Parameters: [null, 1, null, null, null, 2.0, 1.0, 0.0, 0.0, null, null, null, null, OKOK, null, Users: 2. Items: 1. (Time spent: 0h0m0s), 0, 1331217139, 1331217139, null, null, 15]
org.drupal.project.async_command.exception.DatabaseRuntimeException: java.sql.SQLException: Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT' Query: UPDATE async_command SET output=?, id1=?, id2=?, id3=?, id4=?, number1=?, number2=?, number3=?, number4=?, string1=?, string2=?, string3=?, string4=?, status=?, control=?, message=?, weight=?, start=?, end=?, checkpoint=?, progress=? WHERE id=? Parameters: [null, 1, null, null, null, 2.0, 1.0, 0.0, 0.0, null, null, null, null, OKOK, null, Users: 2. Items: 1. (Time spent: 0h0m0s), 0, 1331217139, 1331217139, null, null, 15]
	at org.drupal.project.async_command.CommandRecord.persistResult(CommandRecord.java:130)
	at org.drupal.project.async_command.Druplet.runSerial(Druplet.java:390)
	at org.drupal.project.async_command.Druplet.run(Druplet.java:284)
	at org.drupal.project.async_command.CommandLineLauncher.handleExecutables(CommandLineLauncher.java:107)
	at org.drupal.project.async_command.CommandLineLauncher.launch(CommandLineLauncher.java:66)
	at org.drupal.project.recommender.RecommenderApp.main(RecommenderApp.java:37)
Caused by: java.sql.SQLException: Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT' Query: UPDATE async_command SET output=?, id1=?, id2=?, id3=?, id4=?, number1=?, number2=?, number3=?, number4=?, string1=?, string2=?, string3=?, string4=?, status=?, control=?, message=?, weight=?, start=?, end=?, checkpoint=?, progress=? WHERE id=? Parameters: [null, 1, null, null, null, 2.0, 1.0, 0.0, 0.0, null, null, null, null, OKOK, null, Users: 2. Items: 1. (Time spent: 0h0m0s), 0, 1331217139, 1331217139, null, null, 15]
	at org.apache.commons.dbutils.QueryRunner.rethrow(QueryRunner.java:542)
	at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:599)
	at org.drupal.project.async_command.DrupalConnection.update(DrupalConnection.java:351)
	at org.drupal.project.async_command.CommandRecord.persistResult(CommandRecord.java:126)
	... 5 more
08.03.2012 15:32:19 org.drupal.project.async_command.CommandLineLauncher launch
INFO: Unexpected errors. Program exits.

Comment #6

danithaca CreditAttribution: danithaca commented 8 March 2012 at 15:37

Interesting. I've never seen this message before. Will look into it. The cloud service is almost ready. If you just want to try how the recommender works, you might consider using the free cloud service too.

Comment #7

DerTobi75 CreditAttribution: DerTobi75 commented 9 March 2012 at 06:01

Will try to install it once again, and I contact my SysAdmin, maybe we find, what causes this problem!

Comment #8

danithaca CreditAttribution: danithaca commented 14 March 2012 at 13:54

Version:	7.x-4.0-alpha7	» 7.x-4.0-alpha13
Status:	Postponed (maintainer needs more info)	» Fixed

From what I see, you database doesn't support certain IsolationTransactionLevel. I have made some changes to the code to bypass it. This is fixed in 4.0-alpha13.

Mark this issue as fixed. Please reopen if it doesn't solve your problem.

Comment #9

28 March 2012 at 14:00

Status:

Fixed

» Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

Comment #10

DerTobi75 CreditAttribution: DerTobi75 commented 13 April 2012 at 14:05

Status:

Closed (fixed)

» Active

Sorry for setting this one on active again, but I still get this errors ;(

log4j:WARN No appenders could be found for logger (org.apache.mahout.cf.taste.impl.model.jdbc.AbstractJDBCDataModel).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.

That is, where all the trouble starts. Do not know, if I need to install something else or config anything.

I downloaded this file mahout-distribution-0.6.tar.gz from the Mahout Servers.

Then unpack it and renamed it to mahout.

EDIT: I use my webserver for Mahout, when I get the README.txt from the async_command Module right, I do not configure anything for this module, do I?

EDIT2: Could this maybe caused from my database?
Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'
After a little research, this could be a MySQL Bug?!

Regards,

Tobi

Comment #11

DerTobi75 CreditAttribution: DerTobi75 commented 13 April 2012 at 14:26

Another strange thing, I changed the DRUPAL_HOME path in the run.sh to the absolute path.

But when I execute run.sh I get:

WARNUNG: Cannot find config.properties file. Try settings.php now.
13.04.2012 16:14:23 org.drupal.project.async_command.DrupletUtils locateFile

And I put the config.properties in both module folders, ...

Comment #12

DerTobi75 CreditAttribution: DerTobi75 commented 13 April 2012 at 17:35

SCHWERWIEGEND: Cannot update command record. Fatal error. Record id: 5
13.04.2012 19:27:22 org.drupal.project.async_command.CommandLineLauncher launch
SCHWERWIEGEND: java.sql.SQLException: Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT' Query: UPDATE async_command SET output=?, id1=?, id2=?, id3=?, id4=?, number1=?, number2=?, number3=?, number4=?, string1=?, string2=?, string3=?, string4=?, status=?, control=?, message=?, weight=?, start=?, end=?, checkpoint=?, progress=? WHERE id=? Parameters: [null, 1, null, null, null, 0.0, 0.0, 0.0, 0.0, null, null, null, null, OKOK, null, Users: 0. Items: 0. (Time spent: 0h0m0s), 0, 1334338042, 1334338042, null, null, 5]
org.drupal.project.async_command.exception.DatabaseRuntimeException: java.sql.SQLException: Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT' Query: UPDATE async_command SET output=?, id1=?, id2=?, id3=?, id4=?, number1=?, number2=?, number3=?, number4=?, string1=?, string2=?, string3=?, string4=?, status=?, control=?, message=?, weight=?, start=?, end=?, checkpoint=?, progress=? WHERE id=? Parameters: [null, 1, null, null, null, 0.0, 0.0, 0.0, 0.0, null, null, null, null, OKOK, null, Users: 0. Items: 0. (Time spent: 0h0m0s), 0, 1334338042, 1334338042, null, null, 5]
	at org.drupal.project.async_command.CommandRecord.persistResult(CommandRecord.java:130)
	at org.drupal.project.async_command.Druplet.runSerial(Druplet.java:390)
	at org.drupal.project.async_command.Druplet.run(Druplet.java:284)
	at org.drupal.project.async_command.CommandLineLauncher.handleExecutables(CommandLineLauncher.java:107)
	at org.drupal.project.async_command.CommandLineLauncher.launch(CommandLineLauncher.java:66)
	at org.drupal.project.recommender.RecommenderApp.main(RecommenderApp.java:37)
Caused by: java.sql.SQLException: Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT' Query: UPDATE async_command SET output=?, id1=?, id2=?, id3=?, id4=?, number1=?, number2=?, number3=?, number4=?, string1=?, string2=?, string3=?, string4=?, status=?, control=?, message=?, weight=?, start=?, end=?, checkpoint=?, progress=? WHERE id=? Parameters: [null, 1, null, null, null, 0.0, 0.0, 0.0, 0.0, null, null, null, null, OKOK, null, Users: 0. Items: 0. (Time spent: 0h0m0s), 0, 1334338042, 1334338042, null, null, 5]
	at org.apache.commons.dbutils.QueryRunner.rethrow(QueryRunner.java:542)
	at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:599)
	at org.drupal.project.async_command.DrupalConnection.update(DrupalConnection.java:351)
	at org.drupal.project.async_command.CommandRecord.persistResult(CommandRecord.java:126)
	... 5 more
13.04.2012 19:27:22 org.drupal.project.async_command.CommandLineLauncher launch
INFO: Unexpected errors. Program exits.

I have no idea, what there is missing or went wrong, ... ;(

Comment #13

danithaca CreditAttribution: danithaca commented 17 April 2012 at 00:49

Version:	7.x-4.0-alpha13	» 7.x-4.0-alpha14
Category:	support	» bug

I'll look into it.
I assume you use MySQL database right?
Also, have you tried the alpha14 release?

Comment #14

DerTobi75 CreditAttribution: DerTobi75 commented 18 April 2012 at 08:08

Yes, I am on MySQL and all modules are the latest releases!

Comment #15

klokie CreditAttribution: klokie commented 18 April 2012 at 13:52

Hi, I'm having a similar issue when trying to get recommender API and async_command up and running. run.sh doesn't find my config.properties file, outputting the following:

18-Apr-2012 14:25:05 org.drupal.project.async_command.CommandLineLauncher launch
INFO: Druplet VERSION: 7_2_13
18-Apr-2012 14:25:05 org.drupal.project.async_command.DrupletUtils locateFile
INFO: DRUPAL_HOME is set to: ../../../../..
18-Apr-2012 14:25:05 org.drupal.project.async_command.DrupletUtils loadConfig
WARNING: Cannot find config.properties file. Try settings.php now.
18-Apr-2012 14:25:05 org.drupal.project.async_command.DrupletUtils locateFile
INFO: DRUPAL_HOME is set to: ../../../../..
18-Apr-2012 14:25:05 org.drupal.project.async_command.DrupletUtils locateFile
INFO: Found file 'settings.php' at: /var/www/vhosts/example.org/sites/default/settings.php
18-Apr-2012 14:25:05 org.drupal.project.async_command.DrupletUtils evalPhp
SEVERE: PHP process exception.
18-Apr-2012 14:25:05 org.drupal.project.async_command.CommandLineLauncher launch
SEVERE: Unexpected PHP error: 255
org.drupal.project.async_command.exception.DrupletException: Unexpected PHP error: 255
	at org.drupal.project.async_command.DrupletUtils.evalPhp(DrupletUtils.java:57)
	at org.drupal.project.async_command.DrupletUtils.convertSettingsToConfig(DrupletUtils.java:311)
	at org.drupal.project.async_command.DrupletUtils.loadConfig(DrupletUtils.java:365)
	at org.drupal.project.async_command.DrupletConfig.load(DrupletConfig.java:49)
	at org.drupal.project.async_command.CommandLineLauncher.constructDruplet(CommandLineLauncher.java:148)
	at org.drupal.project.async_command.CommandLineLauncher.launch(CommandLineLauncher.java:64)
	at org.drupal.project.recommender.RecommenderApp.main(RecommenderApp.java:37)
18-Apr-2012 14:25:05 org.drupal.project.async_command.CommandLineLauncher launch
INFO: Unexpected errors. Program exits.

I'm also using the fb module which, like several other modules, requires the addition of several require_once statements to the bottom of my settings.php file. That seems to be causing this "PHP process exception". For me it would be preferable to use my config.properties file rather than to remove these statements.

Like #11, I've tried using an absolute path, but recommender.jar still doesn't find my config.properties file.
I've customized run.sh to use the appropriate relative path to my DRUPAL_ROOT, indicating that my modules are stored in sites/all/modules/contrib. I've also tried other values for DRUPAL_ROOT.

Thanks for your help.

Comment #16

plopesc

he/him

Spanish

CreditAttribution: plopesc commented 19 April 2012 at 16:06

Hello
I'm having the same error described by DerTobi75. However, I tried it on different MySQL instances and it works fine in the first one but not in the other.

For me works fine on 5.1.61-0ubuntu0.11.10.1, but I have the STATEMENT error in 5.1.49-3-log (Debian).

Maybe this could help.

Thank you