Fix table creation, missing column

  • vdvtt

    (@vdvtt)


    7 years, 3 months ago

    I noticed that you added a new column, called experience. But you forgot to update the table creation hook, to create this column when enabling the plugin.

    I had to add manually the column in mysql in order to make submissions work.

    resume-upload-form/index.php
    user_resume_create method

    
$sql = "CREATE TABLE $table_user_info (
    id int(11) NOT NULL AUTO_INCREMENT,			      
    user_id  int(11),
    name varchar(255),
    email varchar(255),
    phone varchar(100),
    experience int(3) UNSIGNED,
    resume_path varchar(255),
    comments text,
    UNIQUE KEY id (id)
);";
Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter vdvtt

    (@vdvtt)

    7 years, 3 months ago

    Also you need to fix resume-upload-form/upload_template.php as well.

    line ~159

    from 

    
$data = array(
                "name" => $fname.' '.$lname, 
                "email" => $email, 
                "phone" => $phone, 
                "user_id" => get_current_user_id(), 
                'resume_path' => strstr($movefile['url'], 'wp-content'),
                'comments' => $comments,
                'experince' => $exp
            );

    To

    
$data = array(
                "name" => $fname.' '.$lname, 
                "email" => $email, 
                "phone" => $phone, 
                "user_id" => get_current_user_id(), 
                'resume_path' => strstr($movefile['url'], 'wp-content'),
                'comments' => $comments,
                'experience' => $exp
            );
    Thread Starter vdvtt

    (@vdvtt)

    7 years, 3 months ago

    list_data() method need to fix too, change word experince to experience

    • This reply was modified 7 years, 3 months ago by vdvtt.
Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Fix table creation, missing column’ is closed to new replies.