News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

import 2.0.6 database into 2.0.14 database, is it possible?

Started by VWells, February 10, 2018, 06:23:34 PM

Previous topic - Next topic

VWells

I have continued to attempt to import my data from the old version of the sm to the current version with no luck. Is it possible or am I peeing up a rope? :)

Sir Osis of Liver

There were no database changes from 2.0.6 to 2.0.15, so it should work if export/import is successful.  What's not working?
Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

VWells

Thanks for the reply! :)

I get error message that its a duplicate or not configured or something like that, so I tried manually inserting each section with same issue. let me try it and come back with exact error so I make more sense!

VWells

Error
SQL query:

--
-- Database: `omc1406305013633`
--
-- --------------------------------------------------------
--
-- Table structure for table `smf_admin_info_files`
--
CREATE TABLE  `smf_admin_info_files` (

`id_file` TINYINT( 4 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`filename` VARCHAR( 255 ) NOT NULL DEFAULT  '',
`path` VARCHAR( 255 ) NOT NULL DEFAULT  '',
`parameters` VARCHAR( 255 ) NOT NULL DEFAULT  '',
`data` TEXT NOT NULL ,
`filetype` VARCHAR( 255 ) NOT NULL DEFAULT  '',
PRIMARY KEY (  `id_file` ) ,
KEY  `filename` (  `filename` ( 30 ) )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =8;

MySQL said: Documentation

#1050 - Table 'smf_admin_info_files' already exists




and when I just past the actual lines I get:::


Error
SQL query:

INSERT INTO  `smf_admin_info_files`
VALUES ( 1,  'current-version.js',  '/smf/',  'version=%3$s',  'window.smfVersion = "SMF 2.0.15";',  'text/javascript' ) ;


MySQL said: Documentation

#1062 - Duplicate entry '1' for key 'PRIMARY'

VWells

ok so i finally figured out what I was doing wrong, so i was able to upload the database and link it to the current version, HOWEVER, it now says I have an out dated version and wont allow me to update to the current version.

Aleksi "Lex" Kilpinen

Slava
Ukraini!
"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

How you can help SMF

Advertisement: