Upgrade

[xevito]

I have got UBB working fine on the new server (development box) and that works perfectly.

Version: UBB.classic™ 6.7.0
I have VB version: vBulletin 3.0.7
and Impex version: ImpEx (current ver as of tonight)

I am running the script - all of them work bar the creation of forums when this happens:

26.09% :: Computer Video Magazine
26.09% :: Global Digital Videographers' Club
26.09% :: DVdoctor's very own forums
26.09% :: FAST-Dazzle support forums
26.09% :: AMD video editing systems, and more
26.09% :: Dead
26.09% :: Showreel magazine Forums.


Parse error: parse error, unexpected ',' in /usr/home/hexusv2/www1/temp/cgi-bin/vb/bleh/upload/admincp/impex/systems/ubb_classic/005.php(233) : eval()'d code on line 7

30.43% :: System Configurations
30.43% :: Movie-making Techniques
30.43% :: FAQ
30.43% :: Classified
30.43% :: Computer Video Magazine
30.43% :: DVD, VCD and MPEG

There seems to have been a slight problem with the database.
Please try again by pressing the refresh (javascript:window.location=window.location;) button in your browser.

An E-Mail has been dispatched to our Technical Staff (""), who you can also contact if the problem persists.

We apologise for any inconvenience

Any ideas? This is really killing me now.

I have tried reuploading of IMPEX - anything else I could try? helpie!

[xevito]

Also how do I put the menu in to the VB Admin Panel - at the moment, I run it from admincp/imp/install.php

[Steve Machol]

You need to rename the directory to 'impex' and make is a subdirectory of your main forum firectory, i.e.:

forums/impex/

Then it will show up in the Admin CP. Please view the online instructions here:

http://www.vbulletin.com/docs/html/impex

And please read the Importing HOWTO thread:

http://www.vbulletin.com/forum/showthread.php?t=116398

[Jerry]

Going to need to see the page source, the eval() error is going to be the ubb code that its trying to parse, though it looks like the real issue is going to be one of the forum inserts.

View the page source (of that frame) and look at the bottom to see what the error is.

[xevito]

You need to rename the directory to 'impex' and make is a subdirectory of your main forum firectory, i.e.:

forums/impex/

Then it will show up in the Admin CP. Please view the online instructions here:

http://www.vbulletin.com/docs/html/impex

And please read the Importing HOWTO thread:

http://www.vbulletin.com/forum/showthread.php?t=116398

Done, and I have read that thread... again!

[xevito]

Going to need to see the page source, the eval() error is going to be the ubb code that its trying to parse, though it looks like the real issue is going to be one of the forum inserts.

View the page source (of that frame) and look at the bottom to see what the error is.
Do you mean the MySQL error?

Database error in vBulletin:ImpEx Target 3.0.7:

Invalid SQL:
INSERT INTO forumpermission
(forumid, usergroupid, forumpermissions)
VALUES
(0, 5, 0), (0, 6, 0), (0, 7, 0)

mysql error: Duplicate entry '5-0' for key 2

mysql error number: 1062

Date: Monday 18th of April 2005 11:34:58 PM
Script: /temp/cgi-bin/vb/bleh/upload/impex/index.php (http://www1.hexus.net/temp/cgi-bin/vb/bleh/upload/impex/index.php)
Referer: /temp/cgi-bin/vb/bleh/upload/impex/index.php (http://www1.hexus.net/temp/cgi-bin/vb/bleh/upload/impex/index.php)
Username: DavidRoss


The UBB forums - I can give you a URL or a shot of them if that helps.

Thank you for all your help so far :)

[Jerry]

Ah so its a re-run of the module.

Must be a bug in clear_imported_forums() if you are importing into an empty vBulletin board, empty the forumpermissions tables.

[xevito]

Sorry, it happened on the first time too - how do I flush that specific table?

[Jerry]

It happened on a first run of an import into a clean install of vBulletin ?


TRUNCATE TABLE `forumpermission`;


That SQL will remove ALL the forum permissions.

Run that, then run the forum import to finish the old import, then run the SQL again to clean up once again to prepare for another pass, then rerun the module.

[xevito]

Yes I believe so - I did a clean install tonight, and it gave that error - but to be fair, I have had to try again.

I just did what you said:

Query OK, 0 rows affected (0.00 sec)


So that doesn't make sense?

[xevito]

More strange - when I went to see the forum listing page in Forum Manager it had all of the forums there?!

[Jerry]

So that doesn't make sense?

Nope, that dosn't make sense to me, that would mean that the table is empty already.

Do you have a back up of the installed vBulletin, before you started the import ?

[xevito]

It was a spanking new install - I wanted to migrate it over to VB

It was UBB before.

I have a backup of UBB of course

[xevito]

Right, current state of play -

new install of VB
new install of script

Import error is still happening - not sure why, also re-indexed all of the UBB forum incase that was a problem.

Anything else I can give you to help? I can give you access to the site/forums/ssh/ftp if that would help?

I *really* appreciate your help

[Jerry]

Raise a support ticket in the members area and I'll have a look at it, sounds like something fundamental.

[xevito]

I slogged my way through it and got it all working :) Yay!

Only problem now is the power cut on my system when doing a mailing - is there an easy way to start ity from userID1 and move up rather than 10,000 and move down?

[Jerry]

I slogged my way through it and got it all working :) Yay!

Only problem now is the power cut on my system when doing a mailing - is there an easy way to start ity from userID1 and move up rather than 10,000 and move down?

Emailing your users or importing them ?

[xevito]

Emailing

[Jerry]

Hmmm .. tricky.

How about adding a custom user group then add all users > 1 and < 10,000 to it (or what ever range is left to email) and send the email to just that group, then delete the group and move them back to registered ?