Advertisement:

Author Topic: VB 4.1.11 to SMF 2.0.2 converting posts error  (Read 8108 times)

Offline rollntider

  • Semi-Newbie
  • *
  • Posts: 10
VB 4.1.11 to SMF 2.0.2 converting posts error
« on: April 08, 2012, 12:17:06 AM »
Converting members... Successful.
Converting administrators... Successful.
Converting categories... Successful.
Converting boards... Successful.
Assigning boards to categories... Successful.
Converting topics... Successful.
Converting posts (this may take some time)...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 'ORDER BY null' at line 203

I looked at the forum some topics there... some arent... help? thanks

Offline mr.Curiosity

  • Jr. Member
  • **
  • Posts: 108
  • Gender: Male
    • tarry.bychoo on Facebook
Re: VB 4.1.11 to SMF 2.0.2 converting posts error
« Reply #1 on: April 09, 2012, 02:58:19 AM »
Can you Post a picture of that error on at line 203 ?



Zelite poptpuno besplatno reklamirati svoj server?
Posjetite  www.reklamiraj-server.netne.net
Ocekujemo Vas!

mentalist

  • Guest
Re: VB 4.1.11 to SMF 2.0.2 converting posts error
« Reply #2 on: May 01, 2012, 12:46:18 PM »
Which MySQL version is that server? MySQL seems to have an issue with the SMF database layer (ORDER BY NULL will automatically be added if there's no ORDER defined).

let's try a "workaround", in vbulletin41_to_smf.sql find:
Code: [Select]
FROM {$from_prefix}post AS p
INNER JOIN {$from_prefix}thread AS t
ON t.threadid = p.threadid;

replace with:
Code: [Select]
FROM {$from_prefix}post AS p
INNER JOIN {$from_prefix}thread AS t
ON t.threadid = p.threadid
ORDER BY p.postid;

Offline nhocksiano

  • Newbie
  • *
  • Posts: 1
Re: VB 4.1.11 to SMF 2.0.2 converting posts error
« Reply #3 on: June 18, 2012, 08:07:39 AM »
I have a problem too, My SQL version is 5.5.25