News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

[Converter] ProBoards v5/Forums.net to SMF 2.0.x

Started by Hauzer, May 24, 2014, 04:01:47 PM

Previous topic - Next topic

margarett

You need to check, in the database that you imported, if you find a "users" table.
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

KK_slimer

... I figured out my problem. Well, one of my problems. I'm only going to immortalize it here because it was so, so weird, and it took me forever to figure it out.

At some point, months ago, one of my users on hxxp:forums.net [nonactive] ended a post with "=/"

That emoticon broke the database. It was importing incorrectly and missing half its tables. I went into the .sql file with Notepad++ and deleted the emoticon, and now it is actually possible to import the database properly into the smf database (it was not doing that previously, but I had nothing to compare it to and had no idea). That emoticon was the source of all the trouble.

I also had to edit convert.php to comment out the parts with SQL_MAX_JOIN_SIZE, but that was a much easier error to solve.

I'm still working through some other issues (right now it's "Duplicate entry '0-0' for key 'last_message' ") but I think now that I've solved The Mystery Of The Life-Ruining Emoticon anything else will be an easy fix.

margarett

:o That's new. Thank you for letting us know and good luck ;)
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Hauzer

Hey KK_slimer! Thank you very much for your informative reply and the errors you're facing. I'm glad you've been able to solve your errors. If you need any assistance, we're always here. :)

WatchSteve

Hi all,

I am trying so hard to convert over to SMF from Forums.net.

I have a fresh install of SMF and I have my Forums.net backup.

I get everything set and I can't get past the first step.  :(

"I'm getting this error code: Sorry, the database connection information used in the specified installation of SMF cannot access the installation of Forums.net. This may either mean that the installation doesn't exist, or that the Database account used does not have permissions to access it."

I have no idea what needs to be done to fix it.  Any help would be greatly appreciated!  Thanks

The error that was received from the Database was: Table 'watchint_smf.User' doesn't exist

margarett

Howdy ;)
Do you have a database dump? If so, I have a converter for you to try ;) In that case, you also need to make sure that the MySQL user assigned to SMF's database is also allowed to access the database from your origin
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

WatchSteve

Hi!

Yes I have a complete database dump from Forums.net and I can access my database.  Now I'm have trouble uploading my SQL forums.net database to mt smf database.  :-\

I'm using the converter provided here :)

WatchSteve

Does anyone that has been able to complete this conversion know what forums.net writes the SQL in?

It doesn't seem to be compatible with mySQL.  I can't get my database uploaded.  Even my hosting service has tried for me with no luck.

margarett

Can you paste here some lines of the .sql file? Do you get an error?
I seem to remember having to edit the .sql file manually to fix some issues (not 100% sure anymore :( )
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

WatchSteve

Thanks Margarett!

Yes,  I was getting this error code: "CREATE DATABASE `id_5658312` /*!40100 DEFAULT CHARACTER SET latin1 */;
MySQL said: Documentation
#1044 - Access denied for user 'watchint'@'localhost' to database 'id_5658312' "

I looked at the sql file and realize that error was word for word the first line of the sql file so i removed it and then got this error

"ERROR 1064 (42000) at line 433482: 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 '50.160.175.99', '1', '1422331098', '2015-01-27 03:58:18', '0', '0', ''),
('14802' at line 37"

Here is a sample of the unedited sql file:

CREATE DATABASE `id_5658312` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `id_5658312`;

CREATE TABLE `Access_Log` (
  `user_id` int(8) NOT NULL,
  `ip` varchar(23) NOT NULL,
  `viewed_on` int(12) unsigned NOT NULL,
  `board_id` smallint(5) unsigned NOT NULL,
  `thread_id` int(10) unsigned NOT NULL,
  `is_staff` tinyint(1) NOT NULL,
  `is_invisible` tinyint(1) NOT NULL,
  PRIMARY KEY (`user_id`,`ip`),
  KEY `viewed_on_is_staff` (`viewed_on`,`is_staff`),
  KEY `board_id_viewed_on_is_invisible_is_staff` (`board_id`,`viewed_on`,`is_invisible`,`is_staff`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

INSERT INTO `Access_Log` VALUES
('0', '1.234.70.26', '1420151516', '0', '0', '0', '0'),
('0', '100.1.176.250', '1419773355', '0', '0', '0', '0'),
('0', '100.11.102.232', '1428274384', '0', '0', '0', '0'),
('152', '100.13.48.93', '1442110874', '3', '23046', '0', '0'),
('0', '100.2.11.87', '1420357299', '0', '0', '0', '0'),
('87', '100.2.158.242', '1432463857', '14', '0', '0', '0'),
('0', '100.2.158.242', '1437229989', '0', '0', '0', '0'),
('525', '100.3.158.182', '1431309233', '6', '0', '0', '0'),
('525', '100.3.161.223', '1437234341', '0', '0', '0', '0'),
('525', '100.3.164.91', '1449180648', '3', '0', '0', '0'),
('878', '100.3.174.236', '1432298728', '3', '18040', '0', '0'),
('125', '100.3.181.18', '1441738327', '0', '0', '1', '0'),
('0', '100.3.181.18', '1445979605', '0', '0', '0', '0'),
('0', '100.3.45.132', '1442673533', '0', '0', '0', '0'),
('230', '100.3.45.177', '1440028132', '12', '22055', '0', '0'),
('0', '100.3.45.177', '1439645338', '44', '21893', '0', '0'),
('719', '100.3.54.99', '1437738285', '0', '0', '0', '0'),
('0', '100.32.86.180', '1425381779', '0', '0', '0', '0'),
('14', '100.33.93.80', '1430100453', '6', '16906', '0', '0'),
('159', '100.35.104.149', '1447996153', '44', '26341', '0', '0'),
('848', '100.35.21.184', '1421619219', '15', '0', '0', '0'),
('0', '100.35.21.184', '1418599006', '0', '0', '0', '0'),
('0', '100.36.91.212', '1436138447', '14', '20104', '0', '0'),
('14', '100.37.208.189', '1446516482', '2', '25444', '0', '0'),
('739', '100.37.215.251', '1424829740', '15', '13738', '0', '0'),
('0', '100.37.215.251', '1424010949', '0', '0', '0', '0'),
('246', '100.40.128.110', '1436961426', '0', '0', '0', '0'),
('246', '100.40.128.179', '1438596317', '0', '0', '0', '0'),
('246', '100.40.128.185', '1432203219', '12', '18124', '0', '0'),
('0', '100.40.128.185', '1432548035', '0', '0', '0', '0'),
('0', '100.40.128.237', '1419330696', '0', '0', '0', '0'),
('246', '100.40.128.237', '1419532396', '0', '0', '0', '0'),
('246', '100.40.129.47', '1448970398', '0', '0', '0', '0'),
('246', '100.40.130.154', '1423139253', '0', '0', '0', '0'),
('246', '100.40.131.20', '1423738576', '0', '0', '0', '0'),
('246', '100.40.131.58', '1420203028', '11', '10852', '0', '0'),
('0', '100.40.133.11', '1431341820', '0', '0', '0', '0'),
('246', '100.40.133.11', '1431860017', '0', '0', '0', '0'),
('246', '100.40.134.213', '1437224051', '0', '0', '0', '0'),
('246', '100.40.135.31', '1447671934', '0', '0', '0', '0'),
('246', '100.40.136.241', '1428230245', '12', '16254', '0', '0'),
('246', '100.40.136.68', '1439118576', '12', '21618', '0', '0'),
('246', '100.40.136.82', '1430564039', '0', '0', '0', '0'),
('246', '100.40.137.54', '1421066848', '0', '0', '0', '0'),
('246', '100.40.138.169', '1439979300', '12', '22015', '0', '0'),
('246', '100.40.139.174', '1429522593', '0', '0', '0', '0'),
('246', '100.40.140.214', '1425981544', '12', '14925', '0', '0'),
('0', '100.40.140.214', '1425209947', '0', '0', '0', '0'),
('246', '100.40.141.96', '1427536014', '11', '15873', '0', '0'),
('0', '100.43.81.133', '1433781023', '0', '0', '0', '0'),
('0', '100.43.81.134', '1448260070', '2', '2165', '0', '0'),
('0', '100.43.81.139', '1433498646', '11', '3265', '0', '0'),
('0', '100.43.81.140', '1438223312', '2', '5458', '0', '0'),
('0', '100.43.85.23', '1448269633', '0', '0', '0', '0'),
('0', '100.43.85.27', '1449170166', '57', '23921', '0', '0'),
('0', '100.43.85.28', '1426692773', '0', '0', '0', '0'),
('0', '100.43.85.7', '1436537371', '0', '0', '0', '0'),
('0', '100.43.90.10', '1440701508', '44', '8434', '0', '0'),
('0', '100.43.90.11', '1439845899', '44', '1051', '0', '0'),
('0', '100.43.90.12', '1431507003', '11', '2024', '0', '0'),
('0', '100.43.90.13', '1448195067', '11', '22614', '0', '0'),
('0', '100.43.90.8', '1430737693', '26', '14193', '0', '0'),
('0', '100.43.90.9', '1433604592', '2', '1152', '0', '0'),
('0', '100.43.91.1', '1445489032', '57', '0', '0', '0'),
('0', '100.43.91.14', '1425326089', '32', '11100', '0', '0'),
('0', '100.43.91.22', '1432731337', '11', '15544', '0', '0'),
('464', '100.6.101.76', '1440155704', '0', '0', '0', '0'),
('0', '100.6.101.76', '1442835406', '0', '0', '0', '0'),
('464', '100.6.93.241', '1433245441', '0', '0', '0', '0'),
('0', '100.6.93.241', '1430823394', '0', '0', '0', '0'),
('0', '101.183.112.154', '1437953495', '128', '145', '0', '0'),
('0', '101.189.4.198', '1421149615', '0', '0', '0', '0'),
('0', '103.224.130.19', '1424589664', '0', '0', '0', '0'),
('0', '103.224.250.139', '1418683334', '0', '0', '0', '0'),
('0', '103.233.251.122', '1418314178', '0', '0', '0', '0'),
('0', '103.252.200.86', '1430001350', '138', '0', '0', '0'),
('0', '103.27.127.238', '1427173288', '0', '0', '0', '0'),
('1293', '103.60.176.238', '1443503500', '2', '23696', '0', '0'),
('1293', '103.60.176.6', '1439971767', '0', '0', '0', '0'),
('607', '104.10.43.2', '1422323734', '0', '0', '0', '0'),
('0', '104.11.178.139', '1418400192', '39', '0', '0', '0'),
('0', '104.128.48.202', '1418285595', '0', '0', '0', '0'),
('0', '104.129.196.81', '1419230700', '0', '0', '0', '0'),
('0', '104.129.198.65', '1429133746', '99', '2094', '0', '0'),
('0', '104.13.164.106', '1414027735', '0', '0', '0', '0'),
('682', '104.13.164.106', '1418534446', '0', '0', '0', '0'),
('0', '104.13.240.123', '1424652341', '57', '12564', '0', '0'),
('0', '104.131.211.150', '1441436371', '0', '0', '0', '0'),
('0', '104.131.214.217', '1418204097', '0', '0', '0', '0'),
('0', '104.131.214.80', '1442825287', '0', '0', '0', '0'),
('0', '104.131.222.135', '1437313470', '32', '0', '0', '0'),
('0', '104.143.218.188', '1426921759', '36', '13404', '0', '0'),
('479', '104.148.182.34', '1440101235', '15', '21322', '0', '0'),
('0', '104.151.22.217', '1418908351', '0', '0', '0', '0'),
('0', '104.154.117.42', '1432758280', '0', '0', '0', '0'),
('0', '104.154.28.201', '1438445744', '0', '0', '0', '0'),
('0', '104.154.79.30', '1446091143', '0', '0', '0', '0'),
('0', '104.156.229.120', '1425672046', '4', '14308', '0', '0'),
('0', '104.162.176.226', '1429206044', '2', '2142', '0', '0'),
('1043', '104.162.244.190', '1448840736', '57', '26841', '0', '0');

INSERT INTO `Access_Log` VALUES
('0', '104.168.62.49', '1426768045', '0', '0', '0', '0'),
('0', '104.168.67.25', '1426738791', '46', '0', '0', '0'),
('1398', '104.173.152.105', '1447993328', '20', '0', '0', '0'),
('0', '104.174.75.168', '1418162584', '0', '0', '0', '0'),
('0', '104.175.19.229', '1429339295', '0', '0', '0', '0'),
('330', '104.175.204.47', '1432199049', '0', '0', '0', '0'),
('871', '104.176.189.112', '1424999883', '0', '0', '0', '0'),
('347', '104.177.83.249', '1413915672', '0', '0', '0', '0'),
('382', '104.181.85.194', '1421732181', '36', '12062', '0', '0'),
('0', '104.182.130.126', '1443425733', '0', '0', '0', '0'),
('0', '104.193.9.137', '1433810329', '0', '0', '0', '0'),
('148', '104.2.11.47', '1428691012', '35', '16418', '0', '0'),
('31', '104.207.136.82', '1441464135', '11', '22772', '0', '0'),
('31', '104.207.136.94', '1445123291', '11', '0', '0', '0'),
('832', '104.219.177.5', '1428334381', '0', '0', '0', '0'),
('0', '104.223.31.76', '1436567740', '4', '610', '0', '0'),
('150', '104.228.172.102', '1428772107', '36', '16339', '0', '0'),
('502', '104.229.46.172', '1440295516', '15', '7179', '0', '0'),
('821', '104.231.112.181', '1436380746', '106', '20271', '0', '0'),
('0', '104.231.112.181', '1447101892', '106', '0', '0', '0'),
('0', '104.236.39.162', '1447384836', '89', '0', '0', '0'),
('929', '104.240.10.216', '1425161273', '15', '14427', '0', '0'),
('929', '104.240.11.126', '1432007545', '0', '0', '0', '0'),
('929', '104.240.11.249', '1427630964', '0', '0', '0', '0'),
('929', '104.240.12.11', '1425858633', '0', '0', '0', '0'),
('929', '104.240.12.157', '1424532101', '0', '0', '0', '0'),
('929', '104.240.12.45', '1422058679', '0', '0', '0', '0'),
('929', '104.240.13.229', '1436186412', '39', '20169', '0', '0'),
('929', '104.240.14.25', '1431661279', '44', '17845', '0', '0'),
('929', '104.240.14.90', '1436443900', '0', '0', '0', '0'),
('929', '104.240.15.173', '1424870388', '36', '13731', '0', '0'),
('929', '104.240.243.245', '1421973277', '3', '12145', '0', '0'),
('929', '104.240.243.251', '1422933941', '0', '0', '0', '0'),
('929', '104.240.8.212', '1431002846', '0', '0', '0', '0'),
('929', '104.240.9.202', '1436100766', '14', '20118', '0', '0'),
('929', '104.240.9.35', '1432695979', '11', '18376', '0', '0'),
('0', '104.255.65.11', '1436431504', '0', '0', '0', '0'),
('0', '104.255.67.238', '1430238752', '15', '912', '0', '0'),
('774', '104.3.236.250', '1414028363', '51', '3642', '0', '0'),
('774', '104.3.236.55', '1420925274', '36', '0', '0', '0'),
('774', '104.3.237.66', '1425615849', '3', '0', '0', '0'),
('774', '104.3.238.75', '1412653389', '44', '5754', '0', '0'),
('0', '104.33.198.48', '1443328158', '0', '0', '0', '0'),
('153', '104.33.198.48', '1446422756', '0', '0', '0', '0'),
('631', '104.33.35.240', '1415245439', '0', '0', '0', '0'),
('85', '104.35.149.154', '1412489154', '44', '5779', '0', '0'),
('0', '104.49.184.48', '1432692555', '136', '17338', '0', '0'),
('1159', '104.49.184.48', '1431436631', '0', '0', '0', '0'),
('386', '104.50.134.98', '1416002370', '67', '8078', '0', '0'),
('308', '104.53.112.117', '1442532550', '19', '0', '0', '0'),
('385', '104.53.140.10', '1444947918', '3', '24670', '0', '0'),
('542', '104.53.17.54', '1428617089', '0', '0', '0', '0'),
('0', '104.6.244.249', '1417700784', '0', '0', '0', '0'),
('352', '104.63.61.194', '1437331



Illori

QuoteERROR 1064 (42000) at line 433482:

can you provide us that line and a few lines above and below? without that line we cant tell you why it is having problems.


WatchSteve

Ok, I don't know why, but I attempted to upload the database again because before the error code also gave me the lines the error came from.

This time the file uploaded, but gave me a table error. (Wasn't thinking and didn't copy error)

But now when I access it through the converter at mywebsite.com/convert.php I get this error: The error that was received from the Database was: Table 'watchint_smf.User' doesn't exist

I'm so lost :-[

WatchSteve

Ok, I maybe making progress.  I wiped everything and started from scratch.

I took out the create database line in the beginning of the sql because I'm importing into a database already. (cause of first errors)

Now I get this sql error: There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 31 STR: /;


I search the sql file and that punctuation only shows up twice and here is code from the two times it's shown:

var sticky_thread_divider = (function() {
   return {
      init: function() {
            var plugin = proboards.plugin.get(''sticky_thread_divider'');
         var settings = (plugin)? plugin.settings : false;
         var location = proboards.dataHash.route.name;

         if (/(board?)$/.test(location)) {
         // clean up code later
                var isNumber = /^\d+$/;
            var announcementHeight,
                    stickyHeight,
                    announcementDividerColor,
                    stickyDividerColor,
                    announcementDividerImage = '''',
                    stickyDividerImage = '''';

And here:

function get_smilie_URLs()
{
    var smList = pb.plugin.get(''smilie_dropdown'').settings.list_your_smilies_here;
    smList = smList.split(/;[/b]?\r?\n/);
   
    var codes = new Array();
   
    for(s=0; s<smList.length; s++)
    {
        if(smList != '''' && smList.match(/=\s?["|'']/))
        {
            codes = smList.split(/=\s?["|'']/)[1].split(/["|'']/)[0];
        }
        else if(smList != '''')
        {
            codes = smList;
        }
    }





margarett

Why would an SQL file have such content? :o

At this point I'd have to check. If you want to, zip and password protect your dump, place it online somewhere (eg: dropbox) and PM me the link and the zip password ;)
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

WatchSteve

Quote from: margarett on December 06, 2015, 03:29:22 PM
Why would an SQL file have such content? :o

At this point I'd have to check. If you want to, zip and password protect your dump, place it online somewhere (eg: dropbox) and PM me the link and the zip password ;)

PM sent!  Thanks Margarett!

margarett

So I see the problem: like I got the last time I worked with a dump from Forums.net, it contains unescaped characters as well some \0 (NULL) characters throughout the backup. I'm still removing stuff...
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

WatchSteve

Quote from: margarett on December 06, 2015, 06:24:27 PM
So I see the problem: like I got the last time I worked with a dump from Forums.net, it contains unescaped characters as well some \0 (NULL) characters throughout the backup. I'm still removing stuff...

Awesome you found it!!

Will you be able to show me what I need to change?  This is a test import and when I do the live transfer I want to take a live dump and transfer to the new smf ;)

WatchSteve

You had any more luck with that file?

Forums.net is killing me  :-\

margarett

Still struggling with some binary data which always fails to import :(
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

WatchSteve

I really appreciate all your help preparing the database for upload!

Would this be a permanent fix in the converter or is this something that would have to be done for each upload?

Advertisement: