FUDforum: Bug Reports » Forum import error

Home » FUDforum Development » Bug Reports » Forum import error

Show: Today's Messages :: Polls :: Message Navigator

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?

Report message to a moderator

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

Report message to a moderator

Re: Forum import error [message #30397 is a reply to message #30387]

Wed, 22 February 2006 15:31

djechelon

Messages: 46
Registered: July 2005

Karma: 0

Member

Good!

Report message to a moderator

Previous Topic:	Error when deleting messages
Next Topic:	Cookie problems with IE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 04 21:40:12 GMT 2025

Total time taken to generate the page: 0.05756 seconds