Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
Importing vbulletin to simple press no table prefix
Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Feb 9, 2013 - 8:59 pm

lol. no need to debate meaning of localhost anymore... understand your situation now...

should be no need to unlock root...  we do not attempt to use it... so to verify, in you wp-config.php file, you have a proper db user, db name and db pw set up? 

but Andy authored the importer though I think the vbulletin addon was authored by a user...  will need to see if Andy has any ideas in the morning (night long upon the UK)...

Avatar
Linda Carter
Member
Free Members
sp_UserOfflineSmall Offline
Feb 9, 2013 - 9:33 pm

Whew, glad to hear I'm not stranded out here with a weird, unsolvable problem.  

I assume my wp-config is properly configured.  (I x'd out half of it here for security.)  

/** The name of the database for WordPress */
define('DB_NAME', 'xxxxxx_wp648');

/** MySQL database username */
define('DB_USER', 'xxxxxx_yesahnew');

/** MySQL database password */
define('DB_PASSWORD', 'xxxxxxxxxxxxxxxxx');

/** MySQL hostname */
define('DB_HOST', 'localhost');

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Feb 9, 2013 - 9:37 pm

nope. we are here to help... ;)

and I assume (sorry if dumb question) but the data you entered in the vbulletin input fields in our plugin match what is in the vbulletin config file?

this one is bit odd, because as I said, I think the vbulletin addon was user contributed, but has worked many, many times...  but our different db converters also ask for the wp db info too - so was bit surprised that vbulletin did not too...

but Andy will be around tomorrow morning and may have more insight though he seemed as confused as I in earlier posts...

Avatar
Linda Carter
Member
Free Members
sp_UserOfflineSmall Offline
Feb 9, 2013 - 9:51 pm

Yes, I've just been copying the data straight over from the config file. 

Thanks!

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Feb 10, 2013 - 3:14 am

Steve is not quite right. As the importer plugin is being run in the base WP environment we do not need to collect the WP connection data as we already have that so it is only the source DB connection data we need.

For reasons unknown (because of the errors you DO see) - the importer seems to be throwing an error over something. This calls our error handler as normal but it seems that the php mysql functions being used IN the error handler are attempting to be connected with the root user and this is why it makes no sense to me. These should be connecting with the WP database user name/password.

Perhaps another question for your host - and maybe a good one to ask - is if, for any reason, they have blocked the use of the php mysql extension functions...?

andy-signature.png
YELLOW
SWORDFISH
Avatar
Linda Carter
Member
Free Members
sp_UserOfflineSmall Offline
Feb 10, 2013 - 9:23 am

The host asks:

PHP mysql functions are enabled and working. Both Wordpress Vbulletin wouldn't load if these extensions weren't enabled. Can you ask the developers for a specific location this extension stores the db user & password?

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Feb 10, 2013 - 1:38 pm

As I already said - this is a WordPress plugin so it inherits connection data from WordPress which is contained in the wp-config.php file.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Linda Carter
Member
Free Members
sp_UserOfflineSmall Offline
Feb 11, 2013 - 9:57 am

My host just asked me for logins to WP so that he could run the import and see what's going on, and now something else has come up.  I uninstalled Simple:Press, then went to reinstall, and now when it starts that process, it kicks me over to the login screen.  I re-enter my logins and the screen goes white.  That's in IE.  In Chrome, it ran through the installation, but when I hit "Import" I get a message that I don't have sufficient permissions.  

saponitown.com/wp/wp-admin

un:  coop4
cificap87^23
 

I know someone said this script has run many many times before, successfully.  We're on cpanel.  Is anyone aware of it running successfuly on that?  Could the script need to have WP un/pw entered, like they are on the other scripts (what had Mr Papa confused)?

Should I just wipe out this WP installation and do a fresh install?  

 

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Feb 11, 2013 - 11:20 am

i really don't know what to say except that you clearly have some weird things going on there.
The hosting control panel isn't going to make any difference to anything. And none of the importer scripts collect the WP credentials - as I said - there is no need. The vBulletin importer script is not the most commonly used and - as we have said - was not written by us. But it has been used to my knowledge quite a few times as I know I have had the issue of the prefix come up before (seems some do and some don't).

Does this login issue happen every time you try this or did you not try and repeat the exercise? And is the 'permissions' message using Chrome one of those unhelpful and somewhat bewildering WP messages - just a sort of white box on grey with no way to get out of it?

andy-signature.png
YELLOW
SWORDFISH
Avatar
Linda Carter
Member
Free Members
sp_UserOfflineSmall Offline
Feb 11, 2013 - 11:28 am

Yes, it's a white box on grey.  The login issue is a brand new development.  In IE, it was telling me I don't have sufficient privilieges to proceed.  I'm going to try and wipe out this WordPress installation and start from scratch all over again.  Doesn't the options table store a lot of stuff?  I've got another host who can do a free move for me.  I suppose I'll try that eventually, just try it somewhere else and see what happens. 

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 619
Members: 17362
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625