WP e-commerce Column 'user_id' cannot be null (3 posts)

  1. ricoj
    Posted 9 years ago #

    I've setup WP e-commerce and works fine unless a user it not registered. I get this error:

    WordPress database error: [Column 'user_id' cannot be null]
    INSERT INTO wp_usermeta ( user_id , meta_key , meta_value ) VALUES ( null, 'wpshpcrt_usr_profile', 'a:10:{i:2;s:5:"--
    FName--";i:3;s:12:"--Name--";i:4;s:23:"--address-- 14";i:5;s:6:"Gdansk";i:6;s:9:"--address--";i:7;a:1:{i:0;s:2:"PL";}i:8;s:6:"80-283";i:18;s:0:"";i:9;s:19:"--email-- ";i:20;s:17:"--Name--";}');

    (names etc replaced by --xxxx--)

    Anyone seen this?

  2. jaangus
    Posted 9 years ago #

    I get the same error and have posted about it on the WP-ecommerce support site too.


    Not sure how to fix it, but I can confirm it is a problem! Helpful I know.

  3. Dan Milward
    Posted 9 years ago #

    Thanks. We have fixed this now. It was a problem with MySQL 5 in that MySQL 5 is very precious.

    A new download or a patch will be available later today / early tomorrow.

    // me shakes fist at the mqsql overlords!!

Topic Closed

This topic has been closed to new replies.

About this Topic