Results 1 to 5 of 5
  1. #1

    Question problem while combine two tables

    i had a wired situation i have two db's one is vbulletin 3.8 and other is vbulletin 4.x

    i want to merge user table from db 1 to user table of db 2

    and i get same error (phpmyadmin/ssh)

    ERROR 1136 (21S01): Column count doesn't match value count at row 1
    is there any way which ignores and merges it ?

    Thank you in advance

  2. #2
    Join Date
    Dec 2002
    chennai , tamil nadu , IN
    Quote Originally Posted by Xcode View Post
    is there any way which ignores and merges it ?

    A better way would be to find out which fields(columns) are missing and add those columns to the table before importing.
    Chris, Developer/Programmer,
    Php laravel developers,
    Ruby on Rails developers,

  3. #3
    Check first the table structure there might some missing fields. After you have created the missing fields, you can import the data from the old to the new one.

    Doesn't vbulletin have migration script for upgrading databases? If not do what I suggested.

  4. #4
    Join Date
    Apr 2013
    Before doing anything, make a backup of the original database. Then, you can add the fields which are missing from vbulletin 4.x, and then import like normal.

    you can also modify the import script, and in the location of the missing fields, add in NULL so that the right number of columns are there.

  5. #5
    Join Date
    Nov 2010
    Looks like there is some column missing in either of your database. Compare the structure of both the tables and add the missing column and try again.

Similar Threads

  1. IP Tables Problem, Not Able to login in SSH directly ( In Rescue Mode )
    By rajking in forum Hosting Security and Technology
    Replies: 13
    Last Post: 03-30-2010, 04:47 PM
  2. Validating rss and tables problem
    By myself1982 in forum Web Design and Content
    Replies: 1
    Last Post: 11-27-2006, 08:32 AM
  3. I have a problem with my html tables and table backgrounds
    By Georgecooldude in forum Web Design and Content
    Replies: 0
    Last Post: 09-10-2005, 08:27 PM
  4. Problem /W Tables
    By Armyrulz30 in forum Programming Discussion
    Replies: 3
    Last Post: 09-25-2003, 12:28 AM
  5. Tables problem, Please Help Meh :-(
    By PanicAcid in forum Programming Discussion
    Replies: 0
    Last Post: 08-25-2003, 05:03 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts