webwiz 7.9 to vb3.6 problem

[shirazi]

Hello all,

I have my webwiz 7.9 *.mdb file converted to *.sql (using convert tools)

I've already installed vb 3.6 into "VB" database, also exported webwiz sql file to "WIZ" database.

here's my ImpExconfig.php content:

-----------------
$impexconfig['target']['databasetype'] = 'mysql';
$impexconfig['target']['server'] = 'localhost';
$impexconfig['target']['user'] = 'vb';
$impexconfig['target']['password'] = '****;
$impexconfig['target']['database'] = 'vb';
$impexconfig['target']['tableprefix'] = '';


$impexconfig['sourceexists'] = true;


$impexconfig['source']['databasetype'] = 'mysql';
$impexconfig['source']['server'] = 'localhost';
$impexconfig['source']['user'] = 'wiz';
$impexconfig['source']['password'] = '****';
$impexconfig['source']['database'] = 'wiz';
$impexconfig['source']['tableprefix'] = '';
-----------------


Now that I want to use it to import information to vbulletin,
the following errors apear:




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 OK

Valid found tables :


Possiablly custom tables or incorrect prefix :

ActiveUser NOT found.
Author NOT found.
BanList NOT found.
BookMark NOT found.
BuddyList NOT found.
Category NOT found.
Configuration NOT found.
DateTimeFormat NOT found.
EmailNotify NOT found.
Forum NOT found.
Group NOT found.
GuestName NOT found.
PMMessage NOT found.
Permissions NOT found.
Poll NOT found.
PollChoice NOT found.
Smut NOT found.
Thread NOT found.
Topic NOT found.

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





and yes! I know table problems!

just to let you know, webwiz table format is as follwings:

counters
tblauthor
tblbanlist
tblbuddylist
tblcategory
tblconfiguration
tbldatetimeformat
tblemailnotify
tblforum
tblgroup
tblguestname
tblpermissions
tblpmmessage
tblpoll
tblpollchoice
tblsmut
tblthread
tbltopic


Please help me how to fix it?!:mad:

[Steve Machol]

Try using 'tbl' for the source table prefix.

[shirazi]

Try using 'tbl' for the source table prefix.


tried already, not working.

same error! :(

[Steve Machol]

Are you sure you are getting the same error? You really couldn't be getting this if you made that change:

Author NOT found.
BanList NOT found.
BuddyList NOT found.
Category NOT found.
Configuration NOT found.
DateTimeFormat NOT found.
EmailNotify NOT found.
Forum NOT found.
Group NOT found.
GuestName NOT found.
PMMessage NOT found.
Permissions NOT found.
Poll NOT found.
PollChoice NOT found.
Smut NOT found.
Thread NOT found.
Topic NOT found.

[Jerry]

WIZ or wiz for the database ? Case sensitive.

[shirazi]

WIZ or wiz for the database ? Case sensitive.


"wiz", that's just a sample not real info.

btw, I think my webwiz tables structures are different from what Importer uses.
actually I'm not an expert with webwiz, are those tables same as all other webwiz 7.9 forums out there on the net?

[Jerry]

The importer is looking for the tables :


ActiveUser
Author
BanList
BookMark
BuddyList
Category
Configuration
DateTimeFormat
EmailNotify
Forum
Group
GuestName
PMMessage
Permissions
Poll
PollChoice
Smut
Thread
Topic


In my experience WebWiz uses the table prefix "tbl".

So it looks as if you are connecting to the wrong database, or your connecting to the correct one with no permissions.

[shirazi]

I remember when I was converting my MDB file to SQL, didn't set any username and password for MDB. was it important?

PS: I just copied MDB directly from windows server to my PC

[Jerry]

Ahhh that's it, I see now.

You lost all table capitalisation when you converted.

ActiveUser vr activeuser.

You can either change them all back or change all the SQL in ImpEx, I'd update the tablenames personally.

[Fireproof]

Hi Jerry,

My host is helping me with the import from WebWiz7.9 to VBulletin 3.6.5. We are having a similar problem finding the tables or something, but it appears that we've already addressed the capitalization issue.

- Type of import = CLEAN
- Source = WebWiz7.9 on MS SQL (there was no conversion from access)
- Target = vB 3.6.5


Here's what we are getting:

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 OK
tblActiveUser NOT found.
tblAuthor NOT found.
tblBanList NOT found.
tblBookMark NOT found.
tblBuddyList NOT found.
tblCategory NOT found.
tblConfiguration NOT found.
tblDateTimeFormat NOT found.
tblEmailNotify NOT found.
tblForum NOT found.
tblGroup NOT found.
tblGuestName NOT found.
tblPMMessage NOT found.
tblPermissions NOT found.
tblPoll NOT found.
tblPollChoice NOT found.
tblSmut NOT found.
tblThread NOT found.
tblTopic NOT found.

Any suggestions?

[Steve Machol]

I have responded to your support ticket. The table prefix is most likely wrong. It's probably: tbl_

[Fireproof]

Yep. Sorry for the trouble - was missing the underscore.