SMF Ads Support Forum

Support => General Support => Topic started by: Neighbours-Unite on February 19, 2009, 09:53:30 am

Title: importing MYsql database to SMF 1.1.8 (SOLVED)
Post by: Neighbours-Unite on February 19, 2009, 09:53:30 am
I've tried to upgrade from SMF 1.1.4 to 1.1.8 and import the original database
but I've run in to a problem I can't figure out.

Code: [Select]
SQL query:

--
-- Table structure for table `attachments`
--
CREATE TABLE `attachments` (

`ID_ATTACH` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`ID_THUMB` int( 10 ) unsigned NOT NULL default '0',
`ID_MSG` int( 10 ) unsigned NOT NULL default '0',
`ID_MEMBER` mediumint( 8 ) unsigned NOT NULL default '0',
`attachmentType` tinyint( 3 ) unsigned NOT NULL default '0',
`filename` tinytext NOT NULL ,
`size` int( 10 ) unsigned NOT NULL default '0',
`downloads` mediumint( 8 ) unsigned NOT NULL default '0',
`width` mediumint( 8 ) unsigned NOT NULL default '0',
`height` mediumint( 8 ) unsigned NOT NULL default '0',
PRIMARY KEY ( `ID_ATTACH` ) ,
UNIQUE KEY `ID_MEMBER` ( `ID_MEMBER` , `ID_ATTACH` ) ,
KEY `ID_MSG` ( `ID_MSG` )
) ENGINE = MYISAM AUTO_INCREMENT =4 DEFAULT CHARSET = latin1;



MySQL said:

#1050 - Table 'attachments' already exists
I've put my forum in maintenance mode atm.
I hope someone can understand what I would have to do so I can use
my old sql database and keep everyone's account and all the posts.

GMax  8)
Title: Re: importing MYsql database to SMF 1.1.8
Post by: Zagrom on February 19, 2009, 05:45:04 pm
what web host are you using?
If you cant directly add it via
SMF that you can try to do it
with your web host
Title: Re: importing MYsql database to SMF 1.1.8
Post by: Neighbours-Unite on March 02, 2009, 04:11:48 pm
I noticed a day later that I had posted this in the wrong board, sorry for that.

After several attempts I had to reinstall a backup of the original forum
and had to put the themes back to it's original state (basicly over write with original)
After that I had everything back again and was also able to update my forum.

Thank god it all worked and the problem is solved.


GMax  8)
Title: Re: importing MYsql database to SMF 1.1.8 (SOLVED)
Post by: welllyn07 on October 10, 2009, 12:38:52 am
I think, the solution here is to have a connection pool on each node, initialized lazily by the first task that needs it, and stored and accessed in the node through NodeRunner.setPersistentData() and NodeRunner.getPersistentData(). Right?




_________________
Multivariate testing (http://www.webtrends.com/products/optimize.aspx)