Duplicate posts after impex and cleaner

[KahruPt]

So I locked my old form and I am ready to transfer live, BTW thank Steve for your help on previous questions.
I Impex'ed and used the cleaner.php, but when I go to; maintenance/update counters and update everything, I still have multiple posts on all of my threads.
Please help.
Thank you

[Steve Machol]

This means you did multiple imports and unfortunately the only way to fix this is to reinstall and start all over. Sorry.

[KahruPt]

I only imported once, is there another way to fix this, I have already done allot to get this going live

[Steve Machol]

No sorry, I do not know of any way that Impex could have imported posts twice without doing a multiple import nor do I know of any other way to fix this.

Best I can do is most this to the Import forum and maybe Jerry will see it and have a suggestion.

[KahruPt]

Thanks, I appreciate If Jerry can help, I will hold my go live for one more day, I have done allot with styles and mods to this install before finding out about this Dup issue.
Thanks

[Jerry]

I don't know what system your coming from or the history of this, though it's very rare (near impossiable on most systems with dupe_check turned on) to get dupe data with out removing the import id's and running the module again.

I would advise, taking a backup of the database, then running the :

"Remove duplicate forums/threads/posts."

From the ImpEx "Database cleanup & restart" if that doesn't do it, then it's a re-import.

[KahruPt]

Ok tryed deleting duplicate threads and that did not work, so I deleted all imported data for the reimport.
Now when I run the "check and update database" I get this error message.

Possibly custom tables or incorrect prefix :

phpbb_phpbb_attach_quota NOT found.
phpbb_phpbb_attachments NOT found.
phpbb_phpbb_attachments_config NOT found.
phpbb_phpbb_attachments_desc NOT found.
phpbb_phpbb_auth_access NOT found.
phpbb_phpbb_banlist NOT found.
phpbb_phpbb_categories NOT found.
phpbb_phpbb_config NOT found.
phpbb_phpbb_confirm NOT found.
phpbb_phpbb_disallow NOT found.
phpbb_phpbb_extension_groups NOT found.
phpbb_phpbb_extensions NOT found.
phpbb_phpbb_forbidden_extensions NOT found.
phpbb_phpbb_forum_prune NOT found.
phpbb_phpbb_forums NOT found.
phpbb_phpbb_groups NOT found.
phpbb_phpbb_posts NOT found.
phpbb_phpbb_posts_text NOT found.
phpbb_phpbb_privmsgs NOT found.
phpbb_phpbb_privmsgs_text NOT found.
phpbb_phpbb_quota_limits NOT found.
phpbb_phpbb_ranks NOT found.
phpbb_phpbb_search_results NOT found.
phpbb_phpbb_search_wordlist NOT found.
phpbb_phpbb_search_wordmatch NOT found.
phpbb_phpbb_sessions NOT found.
phpbb_phpbb_smilies NOT found.
phpbb_phpbb_themes NOT found.
phpbb_phpbb_themes_name NOT found.
phpbb_phpbb_topics NOT found.
phpbb_phpbb_topics_watch NOT found.
phpbb_phpbb_user_group NOT found.
phpbb_phpbb_users NOT found.
phpbb_phpbb_vote_desc NOT found.
phpbb_phpbb_vote_results NOT found.
phpbb_phpbb_vote_voters NOT found.
phpbb_phpbb_words NOT found. Failed Check database permissions and connection, or table prefix to ensure its correct

[Jerry]

Looks like you have the source table prefix in twice in your ImpExConfig.

[KahruPt]

Thanks for your help that worked.
I have another question though
How do I give My Admins the same access as the original admin account, I believe I have to update something on the config.php ? I have 3 Admins that need full access, what parameters do I use
Thank you very much for all of your help, I am glad I chose Vbulletin for my forum.

[Steve Machol]

You need to set the appropriate permissions:

Admin CP -> Usergroups -> Administrator Permissions

You may need to make yourself a Super Admin in order to do this. Edit this section of config.php:

// ****** SUPER ADMINISTRATORS ******
// The users specified below will have permission to access the administrator permissions
// page, which controls the permissions of other administrators
$superadministrators = 'x';

...and replace x with your userid (not user name.)