SQL Error While Importing My backup

[1Chope]

Hello, Please I got the following error while importing my backup database

-- -- Dumping data for table `smf_ads` -- INSERT INTO `smf_ads` (`ADS_ID`, `NAME`, `CONTENT`, `BOARDS`, `POSTS`, `CATEGORY`, `HITS`, `TYPE`, `show_index`, `show_board`, `show_threadindex`, `show_lastpost`, `show_thread`, `show_bottom`, `show_welcome`, `show_topofpage`, `show_towerright`, `show_towerleft`, `show_betweencategories`, `show_underchildren`) VALUES (2, 'Adsense Post', '

\r\n \r\n', '', '1,2', '', 10219, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), (3, 'Adsense Up', '

This should be from smf ads mode, my former hosting is currently offline so I changed hosting, installed SMF 1.11 and tried to import my SQL.
Can sombody please help me with this??

[Akyhne]

What error?

[1Chope]

Thanks for your help Akyhne

Here is exactly what I recieved

Error
SQL query:

-- -- Dumping data for table `smf_boards` -- INSERT INTO `smf_boards` (`ID_BOARD`, `ID_CAT`, `childLevel`, `ID_PARENT`, `boardOrder`, `ID_LAST_MSG`, `ID_MSG_UPDATED`, `memberGroups`, `name`, `description`, `numTopics`, `numPosts`, `countPosts`, `ID_THEME`, `permission_mode`, `override_theme`, `twitter_enable`, `topblock`, `is_blog`, `blog_alias`, `twitter_tpl_enable`, `twitter_tpl_text`) VALUES (1, 4, 0, 0, 1, 961, 961, '-1,0,2,9,4,5,6,7,8', 'Jobsngr.com', 'This is a special board for The general forum issues.The Complaint,suggestions and any other discussion partaining the forum.', 15, 22, 0, 0, 0, 1, 1, 'This is a Special Forums/Board For Issue concerning This Forum JobsNigeria (Jobsngr)', 0, '', 0, ''), (16, 4, 1, 1, 2, 921, 921, '-1,0,2,4,5,6,7,8,9', 'New Members Introduction', 'New members.Introduce your self here.', 32, 80, 0, 0, 0, 0, 1, '', 0, '', 0, ''), (4, 2, 0, 0, 3, 968, 968, '-1,0,2,9,4,5,6,7,8', ' GENERAL JOBS FORUM', 'General Forums For Jobs And vacancies In Niger[...]

MySQL said:

#1054 - Unknown column 'twitter_enable' in 'field list'

[Akyhne]

That sounds odd, because you have a 'twitter_tpl_enable' column, but not a 'twitter_enable' column.

Maybe the modder at some point changed names of the columns? Have you been using several versions of that mod in the past?

[1Chope]

Yes , I upgraded to 2.0RC3 but the backup I was installing was from former version which I was version 1.1.8 so I actually downlaoded version 1..8 from SMF Archive and install it, so I am worreid it is not working

[1Chope]

I don't know what to do next,since modes are the problem, is there anyway to rmove all of them? I don't need them afterall as I will upgrade to version 2.0 RC3 immidiatly after the database import.

[Akyhne]

What you should do is to install the SMF 1.1.8, then upgrade that to SMF2.

You also have to make sure, the ad mod you use, comes in a SMF2 version.
If not, you will have to find an alternative.

EDIT:

I don't know what to do next,since modes are the problem, is there anyway to rmove all of them? I don't need them afterall as I will upgrade to version 2.0 RC3 immidiatly after the database import.

You can basically just leave out the creation of the ad table. Just delete it from the backup, both table creation and input.

[1Chope]

What you should do is to install the SMF 1.1.8, then upgrade that to SMF2.

You also have to make sure, the ad mod you use, comes in a SMF2 version.
If not, you will have to find an alternative.

Will 1.18 database backup work in Version 2.0RC3?
Won't I import the database before the upgrade?

You can basically just leave out the creation of the ad table. Just delete it from the backup, both table creation and input.

Hornestly I dont know how,I only needs the post and members data in my database, I don't need any mode if it is what is causing the trobles.

How do I remove it.please can I post the database for you to see??Or if security risky I will send it to you via PM.

Thanks for your help so far.

[Akyhne]

You can not "import" a 1.1.8 database to a 2.0 forum. If you only have a 1.1.x database backup, you need to make a clean installation of a 1.1.x forum. It's a bit complicated task to do, if you are not having a running 1.1.x forum.
After getting the 1.1.8 forum running with your old database, you need to upload a SMF 2 RC3 package to your SMF 1.1.x forum, then run the upgrade process.

We need some more information from you.

[1Chope]

Thanks Akyhne. I have soleved the problem, I manually removed the twitter Mode tabel, dropped the new installed database and Imported the old one, I worked like a charm, you did Great.
Thanks
Wanchope

[Akyhne]

You are welcome