Return to Answer

Some people suggests that your local box is out of sync with the current time, so try to correct it.

Some people suggests that your local box is out of sync with the current time, so try to correct it.

sounds like the error of Amazon S3 service. So I assuming your code doesn't have failing scenario and populating the error message, instead of the username (connecting issues?).

Some people suggests that your local box is out of sync with the current time, so try to correct it.

sounds like the error of Amazon S3 service (possibly you're using Storage API module). So I assuming your code doesn't have failing scenario and populating the error message, instead of the username (connecting issues?).

Some people suggests that your local box is out of sync with the current time, so try to correct it.

So please double check that you followed installation instruction of the module correctly, as below:

This service requires an account with the external service provider. Please refer to the online documentation for additional help: https://www.drupal.org/node/656716

See: Amazon S3 at Drupal.org

So possible solution is to run as root the following commands:

ntpdate ntp.ubuntu.com
echo "ntpdate ntp.ubuntu.com" >> /etc/cron.daily/ntpdate && chmod 755 /etc/cron.daily/ntpdate

depending on your Linux distribution.

Since you're having MySQL error, you should rather check my.cnf, not php.ini, unless PHP CLI and Apache are using different instances of MySQL (via mysql.sock).

However your problem is something else.

You you look closely into the error:

Data too long for column 'name' at row 1

it complains that your name column is too long.

Now check your db placeholders:

uid:

[:db_insert_placeholder_0] => 17328

name:

[:db_insert_placeholder_1] => RequestTimeTooSmywebsiteedThe difference between the request time and the current time is too

that means you've problem with the username, as above value is not valid username, secondly it's too long.

So you've to double check the code in:

mywebsite_externalsystem_integration.module:564: user_save('', Array)

and its Array (especially value of name).

The way how you call it:

#5 mywebsite_externalsystem_integration.module(564): user_save('', Array)
#6 mywebsite_externalsystem_integration.module(239): _mywebsite_externalsystem_integration_create_new_user(Array)
#7 mywebsite_externalsystem_integration.module(26): _mywebsite_externalsystem_integration_update_and_create_user_records(Array)
#8 mywebsite_externalsystem_integration.drush.inc(17): _mywebsite_externalsystem_integration_sync()

doesn't seems you're running cron task from your code (but executing custom drush command), so nothing to do with it, that's why it's not happening during your cron.php.

So to summarize it, this is a bug of your custom code which you need to find and fix it.

Check: user_save() API for the valid syntax, where:

$edit: An array of fields and values to save. For example array('name' => 'My name').

Since you're having MySQL error, you should rather check my.cnf, not php.ini, unless PHP CLI and Apache are using different instances of MySQL (via mysql.sock).

However your problem is something else.

You you look closely into the error:

Data too long for column 'name' at row 1

it complains that your name column is too long.

Now check your db placeholders:

uid:

[:db_insert_placeholder_0] => 17328

name:

[:db_insert_placeholder_1] => RequestTimeTooSmywebsiteedThe difference between the request time and the current time is too

that means you've problem with the username, as above value is not valid username, secondly it's too long.

So you've to double check the code in:

mywebsite_externalsystem_integration.module:564: user_save('', Array)

and its Array (especially value of name).

The way how you call it:

#5 mywebsite_externalsystem_integration.module(564): user_save('', Array)
#6 mywebsite_externalsystem_integration.module(239): _mywebsite_externalsystem_integration_create_new_user(Array)
#7 mywebsite_externalsystem_integration.module(26): _mywebsite_externalsystem_integration_update_and_create_user_records(Array)
#8 mywebsite_externalsystem_integration.drush.inc(17): _mywebsite_externalsystem_integration_sync()

doesn't seems you're running cron task from your code (but executing custom drush command), so nothing to do with it, that's why it's not happening during your cron.php.

So to summarize it, this is a bug of your custom code which you need to find and fix it.

Check: user_save() API for the valid syntax, where:

$edit: An array of fields and values to save. For example array('name' => 'My name').

Going more deeply, the following error (changed based on my assumption):

RequestTimeTooSkewed: The difference between the request time and the current time is too large.

sounds like the error of Amazon S3 service. So I assuming your code doesn't have failing scenario and populating the error message, instead of the username (connecting issues?).

So the only difference between Web and drush is how the code implements the user import. If you're using some specific credentials or performing HTTP requests, make sure you're loading the right variables, site profile, using the right host, proxy settings, etc. Plus print some debugs (-v/-d). For example:

drush -vd -l http://mywebsite.dev mysync

and check your watchdog messages (drush ws --tail).

Some people suggests that your local box is out of sync with the current time, so try to correct it.