Megabss 2.0 to VB 3.6.8, can't import threads

[kabal22]

Hi,

I'm installing a clean version of a newly bought VB 3.6.8.
I'm trying to import from MegaBBS (using MS-SQL) to VB.
Usergroup, users, forums are imported OK but when I click on "Import Threads", 0 threads are imported

Of course, I can't continue the import process without that.

Please help !
Kabal

[Jerry]

Are you importing from MySQL or MSSQL back end ?

What is the structure of your threads table ?

[kabal22]

I'm importing from MS-SQL, the structure is the normal MegaBBS structure, nothing changed.

kabal

[Jerry]

All lower case table names ?

What version of MSSQL ?

Anything in the PHP or MSSQL error logs ?

[kabal22]

All tables are lowercase. MSSQL 2000.
Nothing special in the logs.

Seems there is just no rows the in the results query.

[kabal22]

I test importing from a MySQL database (MSSQL-MySQL) and it seems to work for the threads.
Maybe someting wrong with the MS-SQL importing script ?

[Jerry]

If the users work and this doesn't it can't be the system, must be the specifics of the thread SQL select, does the thread table have these fields :

threadid,
forumid,
TotalPosts,
datecreated,
lastactivity,
threadsubject,
anonymous,
closed,
timesviewed,
sticky,
haspoll,
pollid,
hasattachment,
lastposteranonymous,
lastpostermemberid,
lastposterisregistered,
lastposterguestname,
memberid,
isregistered,
guestname,
ownerstatus,
lastposterstatus

[kabal22]

I don't have : ownrtstatus & lastposterstatus.

[Jerry]

Ah version difference then.

file impex/systems/megaBBS/000.php

Remove ownrtstatus & lastposterstatus. from the SQL around lines 712-713 and the ending comma on 711.