Import problems

[g3media]

Im trying to import my e107 forums to VB and im getting the following errors :(

Valid found tables :


Possibly custom tables or incorrect prefix :

banlist NOT found.
banner NOT found.
cache NOT found.
chatbox NOT found.
comments NOT found.
content NOT found.
core NOT found.
download NOT found.
download_category NOT found.
event NOT found.
event_cat NOT found.
flood NOT found.
forum NOT found.
forum_t NOT found.
headlines NOT found.
irc NOT found.
link_category NOT found.
links NOT found.
menus NOT found.
news NOT found.
news_category NOT found.
online NOT found.
parser NOT found.
plugin NOT found.
pm_blocks NOT found.
pm_messages NOT found.
poll NOT found.
rate NOT found.
rbinary NOT found.
session NOT found.
stat_counter NOT found.
stat_info NOT found.
stat_last NOT found.
submitnews NOT found.
tmp NOT found.
upload NOT found.
user NOT found.
userclass_classes NOT found.
w1n_lyrics NOT found.
wmessage NOT found.
ypslide_cfsaved NOT found.

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

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


any help would be great and thanks.

[Jerry]

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

cpg1410_

[g3media]

Ok i managed to import it to my Vb forums and it has missed parts of the information please see the links below.

http://www.13ghosts.co.uk/e107_plugins/forum/forum.php (current forums)
http://www.13ghosts.co.uk/forums/index.php (new import)

you will see it has copied the thread titles but no posts within.


thanks

[Jerry]

Ok added the prefix and it found one all the others it did not any more ideas?

thanks

Then it's not the correct table prefix, have a look at your source database.

[g3media]

Sorry i was editing it as you was posting please read again i have fixed that error got some new errors now.

[Jerry]

http://www.13ghosts.co.uk/forums/forumdisplay.php?s=&f=43&page=1&pp=20&sort=lastpost&order=desc&daysprune=-1

And it looks like a lot of your source users were guest posting or didn't have userids.

[g3media]

No they were not guest posting just had a custom user title as admin of the VB forum i should be able to see the posts and i cant :(
can you think of any ideas i could do?

thanks

[Jerry]

No they were not guest posting just had a custom user title as admin of the VB forum i should be able to see the posts and i cant :(

I'm not sure what you mean, it appears you're saying three things there.

I can see the posts and I'm not an admin.

[g3media]

ok all i need to do is set Default View Age to all and i will just make my users sign up again that is no problem
is there any way to batch set Default View Age to all forums at once?

again thanks for the great support.

[Jerry]

AdminCP -> Maintenance -> Execute SQL Query -> Automatic Query

All forums - Show all threads

[g3media]

Ok slowly getting now i try to do that and i get this You are not authorized to execute SQL queries

I bloody love this forum system :) support is great worth every penny.

[Jerry]

Admin CP -> Maintenance -> Execute SQL Query

There is a menu with predefined queries. You must have permission to execute queries in your includes/config.php file:


// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
// The users specified here will be allowed to run queries from the control panel.
// See the above entries for more information on the format.
// Please note that the ability to run queries is quite powerful. You may wish
// to remove all user IDs from this list for security reasons.
$config['SpecialUsers']['canrunqueries'] = '';

[g3media]

Just enter my user name in the blank
= '';

[Jerry]

Just enter my user name in the blank
= '';

Userid.

[g3media]

Thanks very much jerry for all your support, it seems to be OK if i come into any more problems i will post up.

Again thanks