Incorrect Database Name

[CommanderMadi]

Now I am trying to upgrade from vb3.7.x to smf 2.0 RC3

I have followed the instructions in the manual, and I put the convert.php and vbulletin3tosmf.sql into the SMF Forum Root...

When I went through conversion process, and set the path for both the vb and smf

It gave that error:- Sorry, the database connection information used in the specified installation of SMF cannot access the installation of vBulletin 3. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: Incorrect database name ''

And I also noticed that I have made a separate directories for both the vb and the smf where the smf directory is Community while the vb directory was forum . I read that also in the conversion page:

If the two softwares are installed in separate directories, the MySQL account SMF was installed using will need access to the other database. Either way, both must be installed on the same MySQL server.

I think this is the problem, Can anybody tell me how to make the smf database get the access to the vb database as stated above..

Or if I am not true, What do you think I receive this error for?.

Thanks in Advance.

[CommanderMadi]

Now I am trying to upgrade from vb3.7.x to smf 2.0 RC3

I have followed the instructions in the manual, and I put the convert.php and vbulletin3tosmf.sql into the SMF Forum Root...

When I went through conversion process, and set the path for both the vb and smf

It gave that error:-

Code Select Expand

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of vBulletin 3. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: Incorrect database name ''
[/color]
And I also noticed that I have made a separate directories for both the vb and the smf where the smf directory is Community while the vb directory was forum . I read that also in the conversion page:

If the two softwares are installed in separate directories, the MySQL account SMF was installed using will need access to the other database. Either way, both must be installed on the same MySQL server.

I think this is the problem, Can anybody tell me how to make the smf database get the access to the vb database as stated above..

Or if I am not true, What do you think I receive this error for?.

Thanks in Advance.

[Norv]

If the two software applications are installed in separate databases (that doesn't mean directories, but yours are obviously in separate databases too), then what you can do is: look in your host's cpanel, find the databases section, and add the user you have for the SMF's database, to vbulletin's database. They need to have the same database user.

[CommanderMadi]

Hi and thanks for reply,

I could not wait for a reply so I re-uploaded the SMF forums to Directory "Community" And made it's database the same as the vbulletin database. and it also gives the same error

[Norv]

How did you make SMF's database the same with vbulletin's database?

Did you reinstall SMF, or?

[Norv]

Please, don't start more topics on the same issue. It's not a bug in SMF, which is what this board is about, I am merging it with your other topic.

[CommanderMadi]

Ok, sorry for the Bump , I made the same database for both by giving the SMF the database name and database username of that of the old existing vbulletin database.

[Norv]

Did you manage to install SMF, then? (to run the installer) as in http://your_domain/install.php , or how?

[CommanderMadi]

I will tell you what I have exactly done

1- I uploaded the SMF 2.0 RC3 to a directory named "Community" and Created a database called mydomain_smf with database user mydomain_smfuser
2-My Old vbulletin "4.0.3" not "3.7.x" { I wrote in that topic that it is vb3.7.x to get a quick reply honestly"but I read many posts here proving the success of vb4.0.3 to SMF 2.0 RC3.
3-My Old vbulletin has its unique database with unique directory where the database is called mydomain_vb and the directory is "forum" and the database user is mydomain_vbuser.
4-I did what you actually told me about when you said "Both Databases shall have access from the SMF database User" and I already did that.

But I still receive the very same error:-

Code Select Expand

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of vBulletin 3. This may either mean that the installation doesn't exist, or that the Database account used does not have permissions to access it.

The error that was received from the Database was: Incorrect database name ''

[Norv]

Please let me try to get this all straight: you uploaded SMF in a directory Community and created a database mydomain_smf with the database user mydomain_smfuser.
Did you install SMF? (that is, successfully run to the end the installation wizard install.php?) I read in your other topic that it didn't work. Did it work in the end? With what URL exactly? (http://mydomain/install.php or http://mydomain/Community/install.php or something else)

[CommanderMadi]

Actually I replied to my old topic saying that I solved it and now SMF is cleanly installed and working like charm on http://mydomain/Community/install.php

[Norv]

Okay, thank you. So it works on http://mydomain/Community/index.php now, on the database mydomain_smf with the database user mydomain_smfuser.

Please do verify in your cpanel who can access the database mydomain_vb.

[CommanderMadi]

The users who can access mydomain_vb are : mydomain_smfuser ( The mydomain_smf User ) and mydomain_vb ( The default User )

and it says in the error:-

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of vBulletin 3. This may either mean that the installation doesn't exist, or that the Database account used does not have permissions to access it.

The error that was received from the Database was: Incorrect database name ''


I am so curious and suspicious in the bold sentence above

[Norv]

First of all: it says "vBulletin 3". Can you please tell, you have by any chance downloaded the converter from "vbulletin 3" simply that? That's old, and it may be better if you try the converter from vbulletin 3.7, that's the one which is latest.

[CommanderMadi]

Woops . Very Sorry, did not see that coming through, I thought it is 3.x.x

I will try it and tell you

[Norv]

Also, please do note: if you have SMF 2.0 RC3, then grab the package for it, while if you have SMF 1.1.11, then the package to SMF 1.1.11. They won't work otherwise.

[CommanderMadi]

Yeah Babe Yeah Thanks My Friend. But here is another thing

Code Select Expand

Converting attachments... Unsuccessful!
This query:
SELECT
postid AS id_msg, counter AS downloads, filename, filedata, userid,
attachmentid
FROM `promasry_vb`.vb_attachment
LIMIT 0, 500;
Caused the error:
Unknown column 'postid' in 'field list'


[CommanderMadi]

I fixed the attachment issue from a post I found for you here

Now My boards are merged and everything is okay... But

1 Posts in 1 Topics by 1 Members. Latest Member: Madikingofkings

However latest posts by latest members are present and when I click them, It opens!

How can I fix that?

[Norv]

Please run Admin > Maintenance > Recount all forum statistics.

[CommanderMadi]

I actually do not know how to thank you.....

Great Support.
Great Forums Software.
Great Website.

That's all what I can say.....