Simpleboard 1.1.0 import error

[wildsmith]

I'm trying to import a Simpleboard forum but am getting the error:

ImpEx Database errormysql error: Invalid SQL:
SELECT *
FROM mos_sb_users
ORDER BY id
LIMIT 0,500
mysql error: Unknown column 'id' in 'order clause'
mysql error number: 1054
Date: Sunday 26th of February 2006 11:56:42 PM
Database: crag
MySQL error: Unknown column 'id' in 'order clause'

I think this needs to be using 'userid' rather than 'id' . I'm sure before I purchased vBulletin I found a thread here giving a solution for this but I can't find it now, perhaps I imagined it.

Is there a way for me to get this working?

Thanks.
Jon.

[Steve Machol]

The Simpleboard importer is designed to work with version 1.0.4. Can you allow access to this database? If so, fill out a support ticket at:

http://members.vbulletin.com/membersupport_contactform.php

Be sure to include the login info to your Admin CP, phpMyAdmin and FTP. Please also include a complete description of the problem.

[wildsmith]

I've submitted a support ticket. I'm not sure what access I can usefully give to the database, it is on a dedicated Win XP 2003 server with no web control panel for you to log in to.

If you have any further suggestions I'd be grateful.

Thanks,
Jon.

[wildsmith]

I hope none is going to mind me talking to myself here :rolleyes:

My mistake was supplying both the Mambo (mos_) and Simpleboard (sb_) prefix when what seems to work is just the Mambo one.

I get much further now and I think it's importing users but trying to import forums gives losts of 'invalid category object' and 'invalid forum object' messages.

Jon.

[wildsmith]

More progress, if I insert the code:

$try->set_value('mandatory', 'options', $try->_default_cat_permissions);

Just before the two instances of:

if($try->is_valid())

in the resume function of 004.php the error messages go away and the forums seem to import correctly. I need to do a more thorough check of what I've got now before I'd say all sorted though!

I'm not a php programmer by trade or hobby but it seems strange the origional code would work even for older versions of Simpleboard without that default setting for 'options'. Have the criteria for is_valid() changed and so broken this importer?

Good luck working it out!

[Jerry]

This happened because the core error checking was changed and there were a few systems that missed having their mandatory fields set.

[wildsmith]

This happened because the core error checking was changed and there were a few systems that missed having their mandatory fields set.

I can imagine that happening with so many import sources to support! Hope my bit of debugging was a help, I know a tiny bit more php & vb now.

With those extra lines of code everything is working well and I have all my forums, threads, posts etc imported perfectly which is a huge help so thank you for impex.

Jon.

[Jerry]

I can imagine that happening with so many import sources to support! Hope my bit of debugging was a help, I know a tiny bit more php & vb now.

With those extra lines of code everything is working well and I have all my forums, threads, posts etc imported perfectly which is a huge help so thank you for impex.

Jon.

Yup, you were the first to find that one, thanks :)