Problem with users table

Posted by jassics on November 29, 2012 at 5:29am

I installed fresh Drupal 7.17 and then imported values from older db.users (Drupal 6.24) table to newer db.users table without any issues.

But now,

users cannot login into the system
even after requesting new password, once trying to set password and save. It throws error.
PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'signature_format' at row 1

I am using
Apache version 2.2.23
PHP version 5.2.17
MySQL version 5.5.28-log

Any suggestions?

Comments

pls check this, seems a

Posted by manoj_j on November 29, 2012 at 5:56am

pls check this, seems a similar one.

http://drupal.org/node/1702106

=-=

Posted by VM on November 29, 2012 at 6:03am

you can't import a user table from Drupal 6 straight into a Drupal 7 database. One major reason is because Drupal 7 uses a completely different password storage for users.

Consider utilizing the user_import module or the feeds module.

still the same issue

Posted by jassics on November 29, 2012 at 6:51am

Thanks friend. But still login issues :(
While updating signature_format is causing error now

A computer geek and network freak guy

=-=

Posted by VM on November 29, 2012 at 1:24pm

you fail to explain what method you've used to properly import the users. Considering that signature_format is mentioned in the error in your opening post, it sounds like you're still trying to push forward with the original method or you didn't properly reverse what you had already done.