SMF to Vbulletin ::: admin acct = insuff access

[bossboy]

SMF 1.1.4 To VBulletin 3.6.8

Receieving ONE email error:
Database error in vBulletin :


Invalid SQL:

SELECT *
FROM m3adatastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' userstats','birthdaycache','maxloggedin','iconcach e','eventcache','mailqueue');

MySQL Error : Table 'm3a_vbull.m3adatastore' doesn't exist Error Number : 1146
Haven't noticed any issues other than a kind of important one:

Administrator account does not have access to do certain things within the admincp. IE: edit the admin group.

Did I do something wrong when importing?
I did not associate the administrator userid to the new one :( Was this wrong?
Anyway to fix? or do I have to start ova?

Thanks for any help!

[Jerry]

Not having datastore table is fairly serious to the running of vBulletin, the SQL you have quoted isn't part of an import, most likely a config.php error.

The imported admin's permissions will have to be set up by the admin user that was created when vBulletin was installed.

[bossboy]

hmmm the error I got may have been when i first installed vbull fresh.
Once i was able to open it, and went thru all the steps, I started on the import. Not checking my email. So its possible that it came in when I first installed vbull.

My admin user that I created when installing vbull was "Administrator"

The imported user is: Administrator

I may have a problem here :P hehe.



Also, all users seem to be "banned".
When i tried to login with my regular acct, it said I had to change my password. That is fine, because I read this on someone else's post. But when I change the pw, it says I am banned.

[Steve Machol]

That is because you did not follow the instructions here to delete your imported usergroups and recheck the usergroup permissions:

http://www.vbulletin.com/docs/html/impex_cleanup

[bossboy]

That is because you did not follow the instructions here to delete your imported usergroups and recheck the usergroup permissions:

http://www.vbulletin.com/docs/html/impex_cleanup

I have read and re-read these instructions.
I have also followed them to a T (with exception to sending out the email to users). Just using my test account for now.

When my administrator account tries to make changes to a usergroup, i get :
Forbidden

You don't have permission to access /forums/admincp/usergroup.php on this server.


Admin acct username: Administrator

Administrator is part of the Administrators group.


Users still are banned after changing their password.

[Steve Machol]

That's not the same issue you posted before about being 'banned'. :)

This may be due to mod_security. Please see this thread for the fix:

http://www.vbulletin.com/go/modsecurity

[bossboy]

hehe. Thanks steve, I will check that out.

Sry, I have more than one issue.
I thought I had posted both :P users banned AND my admin acct doesn't seem to have proper admin access to do everything within CP.

I'll take a look at your link and get back to you :)

[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
$config['SpecialUsers']['superadministrators'] = 'x';

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

[bossboy]

Thank you.

Steve, the mod_security fix worked for allowing my Admin account to properly change settings in AdminCP.
He is already a part of the Administrators group and was put in properly in the config file as well. I checked that :) Thanks tho!


Banned users issue may be fixed. I will test with another acct shortly and report back.
Thank you.

[bossboy]

Hey,

Looks like the acct that I was testing with was in a custom group :( I just forgot about it. Every other account was in the registered users group. I forgot about this last one :( DOH. my bad.


I guess now all that is left, is to figure out what the below means :(
I got this when installing vbull initially.
everything seems to work fine....hmmm
MySQL Error : Table 'm3a_vbull.m3adatastore' doesn't exist Error Number : 1146

[Steve Machol]

If everything is working fine now, then you can ignore that error.