dupliate ID for key last_message on topic table?

[Red Squirrel]

Writing a script to combine several forums into one and getting a hard time.  What is last_message and why am I getting a duplicate error, when that column does not even exist?  This is my query and the error:

Code Select Expand

Query: INSERT INTO smf_topics(is_sticky,id_board,id_member_started,id_member_updated,id_poll,num_views,locked,approved)
    VALUES('0','11','1','1','0','9001','0','1');
Error:Duplicate entry '0-11' for key 'last_message'

What in the world is last_message?  I don't see that column anywhere when looking at the topics table in phpmyadmin.  And what is 0-11 about?  How and where is it getting that?  That's not even an integer.

[margarett]

Check this --> http://www.simplemachines.org/community/index.php?topic=513684.0

[Red Squirrel]

Hmmm that may be an option, I can convert all 4 forums to 4 separate SMF then use that script... I'll have to play with that.

I did end up figuring out the duplicate ID stuff though, honestly no idea what I even did... lol.