Default Table Prefixes

[freebase69]

Can someone tell me what the default vBulletin SQL table prefixes are? You know from a default installation?

Thanks

[Steve Machol]

By default, vB does not use a table prefix.

[freebase69]

I could have sworn I saw something in there but when i check the MySQL in phpmyadmin I noticed that right away. Ok thanks again. I guess my problem lies somewhere else then why I cant import.


Thanks

[Steve Machol]

What specific errors or problems are you having?

[freebase69]

When I try to run the importer I get cannot connect to DB, check username and password. The Username and Password int he IMporter COnfig file match exactly to the vBulletin config file. I can't figure out why it wont connect.

[Steve Machol]

<Moved to Import forum>

It sounds like your source db info is wrong in your ImpExConfig.php file. Which system are you trying to import and what is the exact error message?

[freebase69]

I figured that out after playing with it for a while. Im doing a phpBB Plus import. I got the first module to work but I am now getting this error for the second module:

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /impex/db_mysql.php on line 248
Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT user_id,username
FROM phpbb_users
ORDER BY user_id
LIMIT 0,25
mysql error:

mysql error number: 0


Any ideas?

[Steve Machol]

That error usually means a corrupted table. Run this query in phpMyAdmin to fix it:

REPAIR TABLE phpbb_users;

[freebase69]

Ok I finally got everything to work and did the import as the instructions said to. One big problem though, well actually a few.

1. Half of my posts never made it.
2. Post counts are way off.
3. Users do not have access to the forums until I move them from imported users to registered users group. Granted I only have a fraction of the users that most people do but it is still a pain.

[Steve Machol]

1. Unforrtunately the only way to fix this is to clear the imported db info and redo the import.

2 & 3. Please read the Importing HOWTO thread:

http://www.vbulletin.com/forum/showthread.php?t=116398
Take special note of The End Game section. Following these steps should solve those issues.

[freebase69]

OK thanks. I reran everything a few times and the counts are still way off. Oh well I'm tired of fooling with it. It looks like most of the newer posts made it over so at least thats a starting point. I can always manually move one if I have to...blah... hehe.

I'm having other issues, not vBulletin forums, anyway so this will have to take a back seat.

One last question Steve, can you point in the right direction for skinning? Like a tutorial or FAQ or something.

Thanks

[Steve Machol]

How do you know the post counts are off? Have you checked each of the forum settings to make sure the forums are set to count posts?

Here is the online documentation for styles and templates:
http://www.vbulletin.com/docs/html/styles_and_templates

And here are color maps for vB3 in the online manual:
http://www.vbulletin.com/docs/html/main/color_maps_intro