404 Error - Not Found

[rrudeboy]

Import > Import... error: No input file specified.
any ideas ?

[rrudeboy]

ps. trying to import the MyBB database into vBulletin.

[rrudeboy]

nobody ?!...... getting a bit desperate here.

[Steve Machol]

You have the wrong info entered in your ImpExConfig.php file. We have no way of knowing what your correct info is but please refer back to the instructions:

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

Also please wait at least 12 hours before bumping your posts. :)

From the forum rules:
http://www.vbulletin.com/forum/showthread.php?t=42918


Please wait a reasonable amount of time before bumping posts. For style changes and general 'how-to' questions this should be 24 hours. For specific troubleshooting issues, use 12 hours as a guideline.

[rrudeboy]

sorry Steve, but i checked the ImpExConfig.php countless times... and it keeps giving me the same error, i am correct if i am "sending" it to my MyBB database on my host ? would a copy 'n paste help ?

after ~5 hours i would like to resolve it so i can move on... heck i even give somebody access to my web host space to verify settings.

[Steve Machol]

The MyBB database needs to be on the same server as vB. Then you need to edit the ImpExConfig.php file correct. If you do that, you cannot get that error. I suggest reading the documentation again. :)

[Baba Wawa]

r-boy,

How are you doing today?

Please let us know.

[rrudeboy]

okay.... new day (not really) but still same issue. i will provide more info:

old database settings screenshot (http://bb.roeiboot.com/temp/rb_berry.JPG)

new database settings screenshot (http://bb.roeiboot.com/temp/rb_eb.JPG)



// ****** DATABASE TYPE ******
// This is the type of the database server on which your vBulletin database will be located.
// Valid options are mysql and mysqli, for slave support add _slave. Try to use mysqli if you are using PHP 5 and MySQL 4.1+
// for slave options just append _slave to your preferred database type.
$config['Database']['dbtype'] = 'mysql';

// ****** DATABASE NAME ******
// This is the name of the database where your vBulletin will be located.
// This must be created by your webhost.
$config['Database']['dbname'] = 'roeiboo_eb';

// ****** TABLE PREFIX ******
// Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = '';




# TARGET - The target is the vBulletin database (where the data is going to)
#
####

$impexconfig['target']['server'] = 'localhost';
impexconfig['target']['user'] = 'roeiboo_rude';
$impexconfig['target']['password'] = '**********';
$impexconfig['target']['database'] = 'roeiboo_eb';
$impexconfig['target']['tableprefix'] = '';

# If the system that is being imported from uses a database,
# enter the details for it here and set 'sourceexists' to true.
# If the source data is NOT stored in a database, set 'sourceexists' to false

$impexconfig['sourceexists'] = true;

####
#
# SOURCE - The source is the old forum database (where the data is coming from)
#
####

# mysql / mssql
$impexconfig['source']['databasetype'] = 'mysql'; // mysql OR mssql
$impexconfig['source']['server'] = 'mysql38.************.com';
$impexconfig['source']['user'] = 'roeiboo_rude';
$impexconfig['source']['password'] = '**********';
$impexconfig['source']['database'] = 'roeiboo_berry';
$impexconfig['source']['tableprefix'] = '';


anybody see anything wrong ?

(mod, please change thread title, which i did 3 times but it does not "stick")

[Steve Machol]

Probably this:

$impexconfig['source']['server'] = 'mysql38.************.com';

As I said the MyBB data needs to be on the same server at vB, i.e., 'localhost'. You will need to move that data to the vB server.

The only consistently reliable method of backing up and restoring a database is with shell access via telnet or ssh. This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeout errors and an incomplete backup file.

Please see the instructions here:

Backup:
http://www.vbulletin.com/docs/html/maintenance_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/maintenance_ssh_restore

If you don't have telnet or SSH access, some people have reported success with these scripts:

MySQLDumper:
http://www.mysqldumper.de/en/index.php

MySQLHotxcopy:
http://www.vbulletin.com/forum/showthread.php?t=134821&highlight=mysqlhotcopy

[rrudeboy]

Steve; both databases are on the same "space" at my webhost, is that what you mean ? i am not sure how to move the old database to the same "space" i guess..

tks.

[Steve Machol]

Sorry I have know idea what you mean by 'same space'. However if the MyBB database really is on the same server, then you should be using 'localhost' instead of 'mysql38.************.com'.

[rrudeboy]

Sorry I have know idea what you mean by 'same space'. However if the MyBB database really is on the same server, then you should be using 'localhost' instead of 'mysql38.************.com'.

i mean my web host, ************.. both databases have been created there and both have the same "address" 'mysql38.************.com' i have tried setting one, the other and both to localhost.. all with the same result :]

[Steve Machol]

If you really are getting that error when using 'localhost' for the source server, then this means that your other source info is not correct. Those really are the only options. You cannot get that error is the MyBB data is on the same server as vB and you have the correct source info entered in ImpExConfig.php.

[rrudeboy]

you can see what i entered where... and both entires as localhost should work ?

(getting a bit desperate..)

[Steve Machol]

Yes, I can. However we have no way of knowing what the correct info is for your databases. As I said the only way you can get that error is if the MyBB database does not exist on this server (or is empty) or you have the wrong source db info entered.

[rrudeboy]

wow, finally a new error :}

enter cust. #.... then this


Warning: Cannot modify header information - headers already sent by (output started at /hsphere/local/home/roeiboot/everythingberry.net/forums/impex/ImpExConfig.php:1) in /hsphere/local/home/roeiboot/everythingberry.net/forums/impex/impex_auth.php on line 23

then it goes back to cust. # screen....

update: now it's:


Connection to source server failed. Check username and password.

[Steve Machol]

That error means you have a problem in your ImpExConfig.php file, either a blank space or line at the beginning of the file or it was not saved correctly as a text file.

[rrudeboy]

yes, there was a space at line one, fixed that... then the pw/username error. don't see how its wrong, but time's up... going to a ball game (Reds vs. Indians)

and so close to the solution... whoa.

[Baba Wawa]

r-boy,

Sorry you're still having trouble. But you are surely getting closer.

I was wondering where skamerica might be. Now I know it's somewhere in Ohio. :)

Have a good time at the game! I'll look for you later.

[rrudeboy]

(Reds lost..)

finally get back at it... and stunned already, checked the username and password.. definitely correct as entered.

[Baba Wawa]

r-boy,

I guess that means you are closer to Cincinnati than to Cleveland?

Would you consider this - undo this first effort at importing, back up, and start over?

You've had so many problems with this attempt that it's probably hard for you to tell what's going on. A fresh start might feel a lot better. And based on what you've learned, it might well go a lot more smoothly.

Just a thought.

[rrudeboy]

r-boy,

I guess that means you are closer to Cincinnati than to Cleveland?

yea, i'm in central Ohio..



Would you consider this - undo this first effort at importing, back up, and start over?

You've had so many problems with this attempt that it's probably hard for you to tell what's going on. A fresh start might feel a lot better. And based on what you've learned, it might well go a lot more smoothly.

Just a thought.

how do i undo the first attempt ? i am trying to import the database, not a backup...

(did a lot of searching, and Steve responds to most... and in all he says both databases need to be on the same server, which mine are..)

i'm very much confused.

[rrudeboy]

okay... i'm "in", changed 'localhost' to the actual address.... we'll see from here.

*fingers crossed*

[Steve Machol]

You need to clear out the import data and session and start all over again.

[rrudeboy]

You need to clear out the import data and session and start all over again.

yea, i don't know what that means (no offense Steve, but in general you are kind of vague in my eyes :]

as said i am in, and the first import "Check and update database" i get:



Altering tables

ImpEx will now Alter the tables in the vB database to include import id numbers.
This is needed during the import process for maintaining refrences between the tables during an import.If you have large tables (i.e. lots of posts) this can take some time. They will also be left after the import if you need to link back to the origional vB userid.

moderator - importmoderatorid OK
usergroup - importusergroupid OK
ranks - importrankid OK
poll - importpollid OK
forum - importforumid OK
forum - importcategoryid OK
user - importuserid OK
style - importstyleid OK
thread - importthreadid OK
post - importthreadid OK
thread - importforumid OK
smilie - importsmilieid OK
pmtext - importpmid OK
avatar - importavatarid OK
customavatar - importcustomavatarid OK
customprofilepic - importcustomprofilepicid OK
post - importpostid OK
attachment - importattachmentid OK
pm - importpmid OK
usernote - importusernoteid OK
phrase - importphraseid OK
subscription - importsubscriptionid OK
subscriptionlog - importsubscriptionlogid OKTesting source against : ::0.0.1


Valid found tables :


Possibly custom tables or incorrect prefix :

adminlog NOT found.
adminoptions NOT found.
announcements NOT found.
attachments NOT found.
attachtypes NOT found.
awaitingactivation NOT found.
badwords NOT found.
banned NOT found.
events NOT found.
favorites NOT found.
forumpermissions NOT found.
forums NOT found.
forumsubscriptions NOT found.
helpdocs NOT found.
helpsections NOT found.
moderatorlog NOT found.
moderators NOT found.
polls NOT found.
pollvotes NOT found.
posts NOT found.
privatemessages NOT found.
profilefields NOT found.
reportedposts NOT found.
reputation NOT found.
searchlog NOT found.
settinggroups NOT found.
settings NOT found.
smilies NOT found.
templates NOT found.
templatesets NOT found.
themes NOT found.
threadratings NOT found.
threads NOT found.
threadsread NOT found.
userfields NOT found.
usergroups NOT found.
users NOT found.
usertitles NOT found.
icons NOT found.

If you have all red tables, i.e. none correct this could possible be your table prefix :

mybb_
Failed Check database permissions and connection, or table prefix to ensure its correct

[Steve Machol]

The answer is on the error:

Failed Check database permissions and connection, or table prefix to ensure its correct

It's one of those. Possibly likely you are using a table prefix for your MyBB tables and did not enter that in the source table prefix setting in ImpExConfig.php.

Again, this will work when you use the correct info. That much hasn't changed. :)

[rrudeboy]

nevermind.... dangit :}

[Steve Machol]

Not sure I understand. Please explain.

[rrudeboy]

Not sure I understand. Please explain.

i posted something, then read what the import would do, and understood i did not want that (associate)

2 "issues" left...
1. it fails on import of attachments...
2. (more pressing) when i go into another tab in my browser to see if data got imported, nothing... :(

[rrudeboy]

my sub-forums are there (except for one) but no posts... (while Impex said import was successful) same with users, there are none :]

[Steve Machol]

Please follow the 'After the Import' instructions here:

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

[rrudeboy]

so i've been messing with an import from MyBB -> vBulletin since friday and after numerous problems with the ImpExConfig.php it finally imported tonight.. (ps. i am not a computer newbee, but i am new to MySQL/SQL and database stuff)

so now... some sub-forums are not imported, yet "succesfull" in Impex, users are not in the forum, yet "succesfull" in Impex, no avatars, yet "succesfull" in Impex. i see posts in sub-forums, but in the main forum index everything says 0...

now my main peeve.... i paid (just like most of you) for this, and so far the support via the forum has been... very disappointing, should i turn to vB support ?

where do i go from here ? yes, this forum is a hobby, and it's all on my dollar so nobody can/should complain.. but it juts gets frustrating.. :(

plz...

[Steve Machol]

I have already answered your other thread. Please do not start a new thread for the same issue. Thank you.

[rrudeboy]

Please follow the 'After the Import' instructions here:

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

i did... about 15 times.

[rrudeboy]

I have already answered your other thread. Please do not start a new thread for the same issue. Thank you.

oh come on man... there are different issues mentioned in this post, and i think for what we pay for vB we can start a thread or 2 (or more..)

[Steve Machol]

But the answer to this latest one is exactly the same as my reply on your other thread. And yes, it would help us tremendously to keep all the same import issues all in one thread so we can see what was done previously.

[Steve Machol]

15 times? Really? :confused:

Where exactly are you not seeing these members? What is the URL to your forums? What is the exact result for each import module?

It would be a lot easier to help if you provided all relevant data. :)

[rrudeboy]

15 times? Really? :confused:

Where exactly are you not seeing these members? What is the URL to your forums? What is the exact result for each import module?

i do not see any users when i go in the forum. url: http://everythingberry.com/forums

[Steve Machol]

I think you meant this:

http://www.everythingberry.com/forum/

Are you talking about the Members List? If so There are two options you need to check to set whether or not members are viewable on memberlist:

1. By usergroup:

Admin CP -> Usergroups -> Usergroup Manager -> Edit -> Usergroup Options -> Viewable on the Memberlist -> Yes

2. By post count:

Admin CP -> vBulletin Options -> User Listing & Profile Viewing -> Minimum Posts

[rrudeboy]

I think you meant this:

http://www.everythingberry.com/forum/

we were both wrong.. it's http://everythingberry.net/forums (old habit, i used to be on .com)



Are you talking about the Members List? If so There are two options you need to check to set whether or not members are viewable on memberlist:

1. By usergroup:

Admin CP -> Usergroups -> Usergroup Manager -> Edit -> Usergroup Options -> Viewable on the Memberlist -> Yes

2. By post count:

Admin CP -> vBulletin Options -> User Listing & Profile Viewing -> Minimum Posts


could not find post count setting... but now the users show except for the 2 admins/mods (no biggie at this time)

[rrudeboy]

I'm planning on redoing the entire import... How do I clear the vB database ?
Getting upset with all this..

PotBB

[Steve Machol]

Not sure why you are doing that since your last post did not indicate any remaining issues. However the way to do that is to reinstall vB to a fresh database.

[rrudeboy]

Well.. There's postcount issue on the main forum page, no avatars, 1 sub forum missing and there's 2 rudeboy users :]

PotBB

[rrudeboy]

merged the 2 rudeboy's succesfully... still have the issues as mentioned in post #39 (http://www.vbulletin.com/forum/showpost.php?p=1739965&postcount=39).. all of which i would like to resolve before putting the forum back on-line...

(ps. also all imported links do NOT work)

fixed: the one sub-forum now shows... still the other issues needs fixing, anybody ?

[Steve Machol]

As far as I know, avatars are not imported. And what exactly is wrong with the post count? Your forums are closed to guests.

[rrudeboy]

As far as I know, avatars are not imported. And what exactly is wrong with the post count? Your forums are closed to guests.

okay on the avatars... bummer but okay.

in the main forum list all sub-forums show last updated: never, threads and post 0..

i have my reasons not to allow guests...

[Steve Machol]

I'm sure you have your reasons but the fact is that I cannot check this unless you allow access.

Try rebuilding the thread and forum counters in that order:

Admin CP -> Maintenance -> Update Counters

[rrudeboy]

I'm sure you have your reasons but the fact is that I cannot check this unless you allow access.

Try rebuilding the thread and forum counters in that order:

Admin CP -> Maintenance -> Update Counters

sweet... that worked, i would have sworn i did that numerous times before, only thing different is that there are a few new posts since i tried last.

one more thing, all imported links are no longer clickable links...

[Steve Machol]

Not sure what link you are referring to but if it's links to old threads and posts, then that is to be expected since those links are no longer valid.

[rrudeboy]

Not sure what link you are referring to but if it's links to old threads and posts, then that is to be expected since those links are no longer valid.

links posted by users and me, to various articles and other web sites...

[Steve Machol]

I would have to see a post or thread with this problem in order to help further.

[rrudeboy]

created test user,
name: Steve test
password stevetest

post: http://everythingberry.net/forums/showthread.php?t=231
(link in first post)

[Steve Machol]

I get this: 404 Error - Not Found

[rrudeboy]

Yes because I changed the forum url to what it was before: http://everythingberry.net/forum

PotBB