Thanks! That worked. Sorry, this is all new to me.
Oh bother. This must be due the hack. I don't know how to fix this either. These hacks are driving me mad! SMF seems much better and easier to keep updated. Can I edit/fix this in SQL so I can make the conversion?
Converting...
Converting ranks... Successful.
Converting groups... Successful.
Converting members... Unsuccessful!
This query:
INSERT INTO `cheval_smf1`.smf_members
(ID_MEMBER, memberName, realName, passwd, lastLogin, dateRegistered, location, posts, ID_GROUP, instantMessages, emailAddress, unreadMessages, MSN, AIM, ICQ, YIM, websiteTitle, websiteUrl, showOnline, timeOffset, hideEmail, avatar, signature, pm_email_notify, is_activated, lngfile, buddy_list, pm_ignore_list, messageLabels, personalText, timeFormat, usertitle, memberIP, secretQuestion, secretAnswer, validation_code, additionalGroups, smileySet, passwordSalt, memberIP2)
VALUES ('2', 'LuciferCihan', 'LuciferCihan', '9fc99ab5a8f9ab1023a03df00984c635', '1162426941', '1105464247', 'Hacked By LuciferCihan \" FICKE ALLE VON ARMENIAN,FRANZOSEN U DEUTSCHEN !!! FICK DICH 1000 MAL ISRAEL', '0', '1', '0', 'lcf@lcf.com', '0', 'Hacked By LuciferCihan \" FICKE ALLE VON ARMENIAN,FRANZOSEN U DEUTSCHEN !!! FICK DICH 1000 MAL ISRAEL', 'Hacked By Lucife', '', 'Hacked By LuciferCihan \" FICKE A', '', '', '1', '1', '1', '', 'acked By LuciferCihan \" FICKE ALLE VON ARMENIAN,FRANZOSEN U DEUTSCHEN !!! FICK DICH 1000 MAL ISRAEL', '0', '1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('3', 'Ingo', 'Ingo', '192c02071a66369482c58defdc6bbbc5', '1105465724', '1105465657', '', '0', '', '0', 'ingo.kosick@cityweb.de', '0', '', '', '', '', '', '', '1', '0', '1', '', 'schüß,
<br />Ingo', '1', '1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('4', 'vard7', 'vard7', '50cdad09753978c4992ed81a5bd19b33', '0', '1145359836', '', '0', '', '0', 'vard7@mailf.com', '0', '', '', '', '', 'http://mailf7.com', 'http://mailf7.com', '0', '-12', '0', '', '', '1', '1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('5', 'kreickmann', 'kreickmann', 'bf4d863f48b5cd6564d1a8f0a21f765f', '0', '1149637097', '', '0', '', '0', 'b.kreickmann@gmx.de', '0', '', '', '', '', '', '', '1', '0', '1', '', '', '1', '1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('6', 'borodpakt', 'borodpakt', 'ec6fb321527de2515e11a656e74eeac3', '0', '1157717832', '', '0', '', '0', 'borodpakt@medafo.info', '0', '', '', '', '', 'http://1jeuxvideo.com', 'http://1jeuxvideo.com', '1', '1', '1', '', '', '0', '1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('7', 'kotrenopf', 'kotrenopf', 'a0544d10723223f160132a920f77875d', '0', '1157850722', '', '0', '', '0', 'kotrenopf@norivo.info', '0', '', '', '', '', 'http://bestvhs.com', 'http://bestvhs.com', '1', '1', '1', '', '', '0', '1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('8', 'jtepiner', 'jtepiner', 'b36425a0160e384935b2f4bc1e3666ea', '0', '1158145156', '', '0', '', '0', 'jtepiner@medafo.info', '0', '', '', '', '', 'http://agrocery.com', 'http://agrocery.com', '1', '1', '1', '', '', '0', '1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('9', 'tedforpan', 'tedforpan', '755d6a6d62a4b36025d4a7a7b3308c04', '0', '1158315974', '', '0', '', '0', 'tedforpan@hiretin.info', '0', '', '', '', '', 'http://toysuk.net', 'http://toysuk.net', '1', '1', '1', '', '', '0', '1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('10', 'wkotohrof', 'wkotohrof', '8c6edc4f1871127938b99b886cf62d83', '0', '1158678052', '', '0', '', '0', 'wkotohrof@foteret.info', '0', '', '', '', '', 'http://softwaretoplist.com', 'http://softwaretoplist.com', '1', '1', '1', '', '', '0', '1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('11', 'dpirikont', 'dpirikont', 'b0f51d45dc7380ae841b33f45de1bfe8', '0', '1159262361', '', '0', '', '0', 'dpirikont@vitero.info', '0', '', '', '', '', 'http://magazinesde.info', 'http://magazinesde.info', '1', '1', '1', '', '', '0', '1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('12', 'lopatoketa', 'lopatoketa', '4f55c55897f1c6e9357012001c752739', '0', '1160103535', '', '0', '', '0', 'lopatoketa@ninoros.info', '0', '', '', '', '', 'http://caravelle.berisen.info', 'http://caravelle.berisen.info', '1', '1', '1', '', '', '0', '1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('13', 'frankern', 'frankern', '6718a7cee501a7ccdddc94e4206f10eb', '0', '1161144460', '', '0', '', '0', 'frankern@hiretin.info', '0', '', '', '', '', 'http://dating.kertam.info', 'http://dating.kertam.info', '1', '1', '1', '', '', '0', '1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('14', 'rojerge', 'rojerge', '2dc4757147382486700183a14ccf328e', '0', '1162105367', '', '0', '', '0', 'rojerge@betires.info', '0', '', '', '', '', 'http://homestead.mogesti.info', 'http://homestead.mogesti.info', '1', '1', '1', '', '', '0', '1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
Caused the error:
Unknown column 'pm_email_notify' in 'field list'