I had to uninstall this module on my blog because it was causing very odd behaviour on the homepage for anonymous users... (reporting that 'an error had occurred') Digging into the watchdog logs, I was getting the following error:

PDOException: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'execution_time' at row 1: INSERT INTO {droptor_memory} (q, memory, execution_time, dt) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3); Array ( [:db_insert_placeholder_0] => user [:db_insert_placeholder_1] => 4084576 [:db_insert_placeholder_2] => 1293752174415 [:db_insert_placeholder_3] => 1293752174 ) in droptor_exit() (line 144 of /[...]/sites/all/modules/droptor/droptor.module).

Comments

jemond’s picture

jemond commented
Assigned: Unassigned » jemond

@jrguitar21,

Thanks for your note. I'm sorry for the trouble.

I applied a patch to the D7 dev snapshot of the module last week that I think addresses this. I will confirm this weekend and let you know.

The patch is included in the version 3.0 of the module coming out on Sunday. I will update this note then.

Thanks!
jpe

jemond’s picture

jemond commented

(Also, you can stop this error by disabling memory logging. This is in the settings for the Droptor module on your site.)

jemond’s picture

jemond commented
Status: Active » Fixed

@jrguitar21 - I can confirm this is fixed in version 3 of the module being released tomorrow. I'll update this ticket when the module is released.

jemond’s picture

jemond commented

Hi @jrguitar21,

We have just released version 2.2 of the module for Drupal 7. This includes the patch that addresses this issue. Would you kindly update your site to this new version, and let me know if you run into any issues?

If there is anything we can do to help, kindly let me know.

Thanks,
jpe

jwilson3’s picture

jwilson3
Primary language English
Location Ecuador
commented

Sure, I'll reenable and give it a try.

jemond’s picture

jemond commented

Thanks!

jwilson3’s picture

jwilson3
Primary language English
Location Ecuador
commented
Version: 7.x-2.01 » 7.x-2.7

Hrm, even after updating to 2.7, now I'm getting this error on droptor.com:

Droptor is not compatible with your version of the Droptor module. Kindly upgrade to the latest version.
jwilson3’s picture

jwilson3
Primary language English
Location Ecuador
commented

slightly confused by comment #3 above mentioning v3, versus comment #4 which, recommends version 2.2... and now version 2.7 is currently highest available (and the one i have installed now).

jwilson3’s picture

jwilson3
Primary language English
Location Ecuador
commented

I've just confirmed that the original issue no longer appears in the logs, however, there is now the following:

Notice: Undefined index: name in droptor_modules() (line 352 of /[...]/sites/all/modules/droptor/droptor_feed.inc).
jemond’s picture

jemond commented

Re: versions. Sorry for the confusion. Droptor.com is now in version 3. The Droptor module is in version 2.7.

Re: index issue. I am looking now and will update by tomorrow AM.

jemond’s picture

jemond commented

Hhi jrguitar21,

The update I released in http://drupal.org/node/1014712 should address this issue.

Would you kindly try the latest version of the module and let me know if you have any problems?

Thanks,
jpe

jwilson3’s picture

jwilson3
Primary language English
Location Ecuador
commented

The issues in #1014712: Droptor.com D7 integration have been solved. I'm monitoring the logs now for sql errors... will report back.

jemond’s picture

jemond commented

Thanks. Let me know how it works out.

jemond’s picture

jemond commented

I will assume this issue has been addressed unless I hear from you by Friday.

jwilson3’s picture

jwilson3
Primary language English
Location Ecuador
commented
Status: Fixed » Closed (fixed)

Havent hit any more sql errors.... but just checked the site logs and am getting another php error. :/

jemond’s picture

jemond commented

@jrguitar21 - Thanks, I'll take a look at the other issue.