[SOLVED] What is secure_key? How to import current SQL DB into PS?

[iDevil]

I have the customers' info, passwords in my current DB, I would like to export them and adjust them for PS. But in the PS DB, I found secure_key column, I do not find this column in my current DB, How can I import the current data to PS DB?

Thank you!

[mnementh64]

Hi,

Did you have any info about this field. I am migrating an old OScommerce database and I have the same question for my customers.

Best regards,

[rocky]

I'm currently working on an osCommerce Import module with Tomer. The secure_key is just a random key. Use the following code to generate it:

md5(uniqid(rand(), true))

[mnementh64]

Ok, thank you very much.

[muhsinap]

Hai i am new to prestashop ,

i have inserted a customer using database,when i enable and disable a customer in back office customer page it showing a error message

[PrestaShopException]

 

Property Customer->secure_key is not valid

at line 837 in file classes/ObjectModel.php

 

831.

832. $message = $this->validateField($field, $this->$field);

833. if ($message !== true)

834. {

835. if ($die)

836. throw new PrestaShopException($message);

837. return $error_return ? $message : false;

838. }

839. }

840.

841. return true;

 

 

Thanks

[muhsinap]

Hai i am new to prestashop ,

i have inserted a customer using database,when i enable and disable a customer in back office customer page it showing a error message

[PrestaShopException]

 

Property Customer->secure_key is not valid

at line 837 in file classes/ObjectModel.php

 

831.

832. $message = $this->validateField($field, $this->$field);

833. if ($message !== true)

834. {

835. if ($die)

836. throw new PrestaShopException($message);

837. return $error_return ? $message : false;

838. }

839. }

840.

841. return true;

 

 

Thanks

[Anubisss]

I'm currently working on an osCommerce Import module with Tomer. The secure_key is just a random key. Use the following code to generate it:

 

md5(uniqid(rand(), true))

 

Where should I put this? Thank you very much

[DiegoYungh]

I used this in my case to convert all corrupted orders.

 

 

UPDATE
  ps_orders
SET
  secure_key = md5(date_format(date_add( sysdate(), INTERVAL FLOOR( 1 + (RAND() * 998)) MICROSECOND),"%Y%m%d%H%i%s%f"))
WHERE
  secure_key = -1;

Does the same just a random secure key for each order.

[disarci]

Tks Diego, easy way

 

also for 

ps_customer

[pbraconnot]

I tried Diego's command with ps_customer but still get an error 500. What should be the syntax for generat secure_key in Prestashop 1.6.x?

 

[bcsteeve]

Same here, can anyone help?  I successfully put a random key into the field for each imported customer, but results in error 500 when customer attempts to reset password.

 

They can successfully use the forgot password to mail themselves a reset link, but the reset link then presents them with error 500.

 

HELP!!!  If I can't import customers, this is a no-go and I'll be sad.

[bcsteeve]

I figured out how to turn on dev mode in config\defines.inc.php

define('_PS_MODE_DEV_', true);

which gave me a clue that it had something to do with the customer siret field.  I then did a search and found a post where someone deleted that column (bad move) and it "fixed" their issue.  Well, for me, I realized that the imported data put a text value of "null" there instead of a real null.  Set all fake "null" to null and I'm in business.

[adller99]

Same here, can anyone help?  I successfully put a random key into the field for each imported customer, but results in error 500 when customer attempts to reset password.

 

They can successfully use the forgot password to mail themselves a reset link, but the reset link then presents them with error 500.

 

HELP!!!  If I can't import customers, this is a no-go and I'll be sad.

Hi, how did you solve it? Thanks

[pitada]

Followed this tutorial and solved this problem in a much simpler way:

 

http://www.gswellinc.com/migrating-new-prestashop-installation-breaks-customer-employee-login-passwords/

 

Then my admin password stoped working and I used this:

 

http://www.templatemonster.com/help/how-to-reset-prestashop-admin-details.html