Print Page - dupliate ID for key last

Title: dupliate ID for key last_message on topic table?
Post by: Red Squirrel on April 29, 2015, 10:48:08 PM

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

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.

Title: Re: dupliate ID for key last_message on topic table?
Post by: margarett on April 30, 2015, 05:31:46 AM

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

Title: Re: dupliate ID for key last_message on topic table?
Post by: Red Squirrel on May 10, 2015, 12:55:50 AM

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.

Simple Machines Community Forum

SMF Support => Converting to SMF => Topic started by: Red Squirrel on April 29, 2015, 10:48:08 PM