Recreate/repair columns in table; now missing entries

Support has been upgraded!



The Support Forum is closed. Not to worry!  Providing the top quality support you expect and we're known for will continue! We're not ending support, just changing where you submit requests. This will provide you with the best experience possible.

Premium Support

Have you purchased an addon for Connections such as one of our premium templates or extensions with a valid license and you need help?

Please open a Support Ticket in your user account.

Click here to open a support ticket.

Free Support

Are you using the free Connections plugin? Don't worry, you are still very important to us! We are still providing you with the same high quality support that we're known for.

Please open a new support topic in the WordPress support forums for Connections.

Click here to open a support topic.

This topic is: not resolved
Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • 01/15/2013 at 11:27 am #249123
    Brian
    Guest

    I installed your Connections plugin and I wanted to clean up the columns such as honorific_suffix and honorific_prefix since I wasn’t going to add info into these columns.  I opened PHPMyadmin and removed these columns.  Now, I do not see any of my contact entries.  I have tried to reinsert these columns back into the table but I still don’t see anymore entries.  Can you help?

    01/15/2013 at 12:01 pm #249128
    Steven Zahm
    Keymaster

    @Brian

    I’m not certain there is an easy solution. You would have to delete those columns again, deactivate Connections and edit the connections.php removing this line:

    if ( $wpdb->get_var( "SHOW TABLES LIKE '" . CN_ENTRY_TABLE . "'" ) != CN_ENTRY_TABLE ) {

    and the closing bracket “}”, no quotes right before this line:

    if ( $wpdb->get_var( "SHOW TABLES LIKE '" . CN_TERMS_TABLE . "'" ) != CN_TERMS_TABLE ) {

    Now reactivate Connections. This should create the missing columns in the primary table.

    You didn’t delete any other columns in any of the other tables for Connections did you?

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.