| Forum import error [message #30387] |
Wed, 22 February 2006 00:10  |
djechelon
Messages: 46
Registered: July 2005
Karma: 0
|
Member |
|
|
Dear FUDforum Team,
I noticed that when I tried to load a backup copy on my laptop using Forum Import.
The script stopped at user import query. I can't show the full error log because it contains personal user data of many people (such as email address and md5 hash of password which sometimes can be decrypted with a free online tool).
The error is:
Column count doesn't match value count at row 1.
I DID alter the SQL structure of the database. Since the query does not specify which values to set in the database, I have recreated the exact database structure by simply adding a field in the same exact place. I tried importing again but I get the same error.
I dunno what to do... Wouldn't it be more efficient to export all the field names explicitely?
|
|
|
|
| Re: Forum import error [message #30388 is a reply to message #30387] |
Wed, 22 February 2006 02:59  |
djechelon
Messages: 46
Registered: July 2005
Karma: 0
|
Member |
|
|
OK I solved the problem removing the column I added for my m0d.
But I wonder: since Importer does rebuild all the tables, why not exporting the structure as it is? Like phpMyAdmin's tool...
The result will be that m0dded Forums keep being m0dded... and the exportation will, actually, clone the Forum to another server.
[Updated on: Wed, 22 February 2006 03:00] Report message to a moderator |
|
|
|
| Re: Forum import error [message #30393 is a reply to message #30388] |
Wed, 22 February 2006 15:12 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
The forum takes the structure from the .sql files inside sql/ directory. If you've added new columns or removed old ones simply update those files and then there won't be a problem of missing columns on import/export.
FUDforum Core Developer
|
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]