[renob]

ok , Short and sweet, i exported my old 7.7 phpnuke database and upgraded my site to another version of nuke. I have some 400+ members id like to keep but when i run the INSERT INTO Query, I get this error

Code:

#1136 - Column count doesn't match value count at row 1

.

Ive tried inserting any missing fields between the 2 verions and running the query again but same error happens.

Any ideas?

Thanx

[nugensoftware]

you most likely didn't patch/update the database tables to work with the new information. the problem your having is that the SQL used in the new software is requesting either non-existant fields in a table, or attempting to read them as a different "field type".

As an example lets say your old database stored information in a "varchar" field type and could contain both numbers and alphas. The new version of the software only reads that table as numeric information (int) and access's it with mathmatical equations. This would cause a failure since the database itself will not treat varchar as a integer or float numerical value. Varchar is always string in the database servers eyes.

Anyways it might sound complex but the issue you're having is because the database has changed and you most likely missed the field change, addition, or removal. Check the phpnuke site for details about it.

[renob]

Thanx alot for that, the eroor makes more sense that you explained it. Is there any wy to determine where the differences are without having to insert the old users manually?

Thanx again.