Greetings, <br /><br />I sent my brother here to TCH. TCH techs moved the whole account from the previous webhost. All well so far, so it looks at first <a href="http://www.lowcountrymudrats.com" target="_blank">http://www.lowcountrymudrats.com</a>.<br /><br />Yet no one can make a post to the SMF forum. The message when posting is:<br /><!--quoteo--><div class='quotetop'>QUOTE</div><div class='quotemain'><!--quotec-->Database Error: Duplicate entry '0' for key 1<br />File: /home/******/public_html/forum/Sources/Post.php<br />Line: 1297<!--QuoteEnd--></div><!--QuoteEEnd-->So I downloaded the database dump from the previous host, and using phpadmin, went to upload and inflate the dump file, and ened up with this:<br /><!--quoteo--><div class='quotetop'>QUOTE</div><div class='quotemain'><!--quotec-->SQL query: <br />CREATE TABLE `smf_attachments` (<br /><br />`ID_ATTACH` int( 11 ) unsigned NOT NULL AUTO_INCREMENT ,<br />`ID_MSG` int( 10 ) unsigned NOT NULL default '0',<br />`ID_MEMBER` int( 10 ) unsigned NOT NULL default '0',<br />`filename` tinytext NOT NULL ,<br />`size` int( 10 ) unsigned NOT NULL default '0',<br />`downloads` mediumint( 8 ) unsigned NOT NULL default '0',<br />PRIMARY KEY ( `ID_ATTACH` ) ,<br />UNIQUE KEY `ID_MEMBER` ( `ID_MEMBER` , `ID_ATTACH` ) ,<br />KEY `ID_MSG` ( `ID_MSG` ) <br />) ENGINE = MYISAM DEFAULT CHARSET = latin1 <br />MySQL said: <br /><br />#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 11<!--QuoteEnd--></div><!--QuoteEEnd--> <br /><br />The MySQL version at the previous host was <!--coloro:#FF0000--><span style="color:#FF0000"><!--/coloro-->MySQL 4.1.14-standard<!--colorc--></span><!--/colorc--><br />Here at TCH server 110 it is <!--coloro:#FF0000--><span style="color:#FF0000"><!--/coloro-->MySQL 4.0.25-standard <!--colorc--></span><!--/colorc--> <br /><br />I believe this is the problem. Can anyone shed any light on this, and if this is the problem, can/how it be rectified? I have been through the SMF to no avail......<br /><br />Thanks for any thoughts,<br /><br />Tom<!--content-->
Sorry Tom, I don't know the answer. Hopefully someone will be along soon that can help.<!--content-->
Thanks Bruce, I just got it going <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/biggrin.gif" style="vertical-align:middle" emoid="
" border="0" alt="biggrin.gif" /> Now I can go to work!<br /><br />This was it:<br /><br />It was a MySQL database issue, the 'old' server version of MySQL was <!--coloro:#FF0000--><span style="color:#FF0000"><!--/coloro-->MySQL 4.1.14-standard <!--colorc--></span><!--/colorc--> <br />The 'new' server MySQL version was <!--coloro:#FF0000--><span style="color:#FF0000"><!--/coloro-->MySQL 4.0.25-standard<!--colorc--></span><!--/colorc-->, an older version.<br />Had to remove references to <!--coloro:#000099--><span style="color:#000099"><!--/coloro-->'DEFAULT CHARSET=latin1'<!--colorc--></span><!--/colorc--> and <!--coloro:#000099--><span style="color:#000099"><!--/coloro-->'COLLATE utf8_unicode_ci'<!--colorc--></span><!--/colorc--> in the MySQL dump, then upload the dump again. All works now <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/yes.gif" style="vertical-align:middle" emoid=":yes:" border="0" alt="yes.gif" /> <br /><br />I actually ended up at WordPress forum, to find this solution <a href="http://wordpress.org/support/topic/61160" target="_blank">http://wordpress.org/support/topic/61160</a>.<!--content-->
Glad you got it sorted out. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/thumbup1.gif" style="vertical-align:middle" emoid=":thumbup1:" border="0" alt="thumbup1.gif" /><!--content-->
Sorry Tom, I don't know the answer. Hopefully someone will be along soon that can help.<!--content-->
Thanks Bruce, I just got it going <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/biggrin.gif" style="vertical-align:middle" emoid="
" border="0" alt="biggrin.gif" /> Now I can go to work!<br /><br />This was it:<br /><br />It was a MySQL database issue, the 'old' server version of MySQL was <!--coloro:#FF0000--><span style="color:#FF0000"><!--/coloro-->MySQL 4.1.14-standard <!--colorc--></span><!--/colorc--> <br />The 'new' server MySQL version was <!--coloro:#FF0000--><span style="color:#FF0000"><!--/coloro-->MySQL 4.0.25-standard<!--colorc--></span><!--/colorc-->, an older version.<br />Had to remove references to <!--coloro:#000099--><span style="color:#000099"><!--/coloro-->'DEFAULT CHARSET=latin1'<!--colorc--></span><!--/colorc--> and <!--coloro:#000099--><span style="color:#000099"><!--/coloro-->'COLLATE utf8_unicode_ci'<!--colorc--></span><!--/colorc--> in the MySQL dump, then upload the dump again. All works now <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/yes.gif" style="vertical-align:middle" emoid=":yes:" border="0" alt="yes.gif" /> <br /><br />I actually ended up at WordPress forum, to find this solution <a href="http://wordpress.org/support/topic/61160" target="_blank">http://wordpress.org/support/topic/61160</a>.<!--content-->Glad you got it sorted out. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/thumbup1.gif" style="vertical-align:middle" emoid=":thumbup1:" border="0" alt="thumbup1.gif" /><!--content-->