Title: Fix table creation, missing column
Last modified: March 11, 2019

---

# Fix table creation, missing column

 *  [vdvtt](https://wordpress.org/support/users/vdvtt/)
 * (@vdvtt)
 * [7 years, 3 months ago](https://wordpress.org/support/topic/fix-table-creation-missing-column/)
 * 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](https://wordpress.org/support/users/vdvtt/)
 * (@vdvtt)
 * [7 years, 3 months ago](https://wordpress.org/support/topic/fix-table-creation-missing-column/#post-11300733)
 * 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](https://wordpress.org/support/users/vdvtt/)
 * (@vdvtt)
 * [7 years, 3 months ago](https://wordpress.org/support/topic/fix-table-creation-missing-column/#post-11300764)
 * **_list\_data()_** method need to fix too, change word **experince** to **experience**
    -  This reply was modified 7 years, 3 months ago by [vdvtt](https://wordpress.org/support/users/vdvtt/).

Viewing 2 replies - 1 through 2 (of 2 total)

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

 * ![](https://s.w.org/plugins/geopattern-icon/resume-upload-form_b93734.svg)
 * [Upload Resume](https://wordpress.org/plugins/resume-upload-form/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/resume-upload-form/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/resume-upload-form/)
 * [Active Topics](https://wordpress.org/support/plugin/resume-upload-form/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/resume-upload-form/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/resume-upload-form/reviews/)

 * 2 replies
 * 1 participant
 * Last reply from: [vdvtt](https://wordpress.org/support/users/vdvtt/)
 * Last activity: [7 years, 3 months ago](https://wordpress.org/support/topic/fix-table-creation-missing-column/#post-11300764)
 * Status: not resolved