HTML in signatures a problem with UBB import?

[Parker Clack]

I am having problems with importing members and messages in the forum from UBB to my vBulletin forum and I was curious as to whether or not I allow HTML in a members signature could have anything to do with this? It appears that it downloads about 800 members ( I have over 11,000) and then it chokes and gives me database errors.

I also have additional stuff that is added a members profile because of this too. There is HTML code in their member.cgi file so I am wondering if this could be a problem too. There are a couple of items that I have added that put an extra "yes" in their profile too.

It does the same thing with messages that have been posted and this appears to be the ones that have HTML in their signatures.

Does the import script only allow certain predefined information to be passed on to the database or could it be written to import all that is in the messages and the member information files or just ignore that which isn't used in the database for vBulletin?

Also, does this program allow you to use HTML in it at all?
I have the option set in my control panel to allow HTML but it still says that HTML is off in the Forum Rules: section.

Thanks,
Parker

[Edited by Parker Clack on 05-05-2000 at 07:15 PM]

[werehere]

My forum had html in signatures as well, and most members do have them. No problem for me with it, just so you know?:)

[John]

Try the latest import.php file in the members area, 'Latest Development Version'. It may fix your problems. If not, please could you post some of the database errors that you are getting.

John

[darien]

Anybody know what this means and how to get around it?

The UBB member import seems to bomb after about 3400 of our 9000 members are imported. How long does it generally take to get an answer from support? Thanks in advance for any help anyone can provide. We decided to move to this board because it supported UBB import, and I think I'm starting to see that it only "kinda" supports that maybe.

Signed Frustrated



Database error in vBulletin Control Panel: Invalid SQL: SELECT title FROM usertitle WHERE minposts<= ORDER BY minposts DESC LIMIT 1
mysql error: You have an error in your SQL syntax near 'ORDER BY minposts DESC LIMIT 1' at line 1
mysql error number: 1064
Date: Friday 12th of May 2000 01:29:53 PM
Script: /vbulletin/upload/admin/import.php?step=3&startat=1000&wipe=no&perpage=1000&ubbmembersdir=/home/httpd/html/cgi-bin/Members&ubbsettingsdir=/home/httpd/html/cgi-bin/forums&ubbnoncgidir=/home/httpd/html/forums&ubbnoncgiurl=http://www.fanforum.com/forums/
Referer:

[werehere]

How long does it generally take to get an answer from support?

I think if you look above your post you will see that there was a suggestion given by the developers, and since there were not any other people posting problme, what were they supposed to answer?

Give them a few to respond!

[John]

Did my suggestion for trying the development version in the members area help at all? Or did it just give the same error?

I am sorry for the perceived delay in support. I will try to work out any problems that you have been having so that you can get your board going as soon as possible.

John