IPB 2.3 Conversion Question

Started by bros, July 15, 2008, 12:05:21 AM

Previous topic - Next topic

bros

#20
Quote from: ThorstenE on July 16, 2008, 03:46:59 PM
Quote from: bros on July 16, 2008, 03:08:26 PM
I think the permissions for admin in smf_permissions might have been wiped.
SMF has no special permission-settings for Admins. Users with 1 as ID_GROUP have full permissions.

try the following query in PHPMyAdmin:
UPDATE smf_members SET ID_GROUP = '1' WHERE memberName = 'yourusername';

change smf_ to your table prefix and yourusername to your admin's name ..

afterall you can check the ID_GROUP for the user with:

SELECT ID_GROUP FROM smf_members WHERE memberName='yourusername';
Result should be 1


Thanks. That worked.

But I just logged into the admin panel, and there are no usergroups. Not even administrator. Hm.

Edit: I made an administrator mask and it came out as ID 1.

Now time to remake the membergroups :D

SleePy

Well thats a big bug. I will send myself a notice to look at it friday (geez I am building up a lot of work to do friday).

Remember some cavets while making membergroup that SMF by default assumes.
It assumes the group id of 1 is the admin group. The group id of 3 is the moderator group and nobody can be added to this group (nor would it grant board access). Group 2 is a global moderator group but SMF doesn't assume anything with it. There needs to be at least 1 post group. Otherwise it may cause errors with SMF.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

bros

Quote from: SleePy on July 16, 2008, 06:05:50 PM
Well thats a big bug. I will send myself a notice to look at it friday (geez I am building up a lot of work to do friday).

Remember some cavets while making membergroup that SMF by default assumes.
It assumes the group id of 1 is the admin group. The group id of 3 is the moderator group and nobody can be added to this group (nor would it grant board access). Group 2 is a global moderator group but SMF doesn't assume anything with it. There needs to be at least 1 post group. Otherwise it may cause errors with SMF.

Yep. Already set up a post count group to prevent any errors :D

I noticed that it assigned it to Administrator when I saw the (?) next to it :D

Now I need to remake the membergroups.

At least the other admins will help :P

bros

Okay.

People are telling me that it is showing that they have PMs, then they go to their inbox, and they have none.

In the DB, it shows that there are PMs there.

SleePy

Well we can try to see if there is enough data from it to fix them. If there isn't enough data it would remove the personal messages.

Go to Admin -> Forum Maintenance
Then click Find and Repair Errors link. This may take a while to run, but it should be all automated with javascript (just like the converter was).
As well after that click the Recount totals and Stats link

If there is enough data for it to correct the pms, it would be able to restore them. If there isn't, it would delete them.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

bros

Quote from: SleePy on July 17, 2008, 01:21:19 AM
Well we can try to see if there is enough data from it to fix them. If there isn't enough data it would remove the personal messages.

Go to Admin -> Forum Maintenance
Then click Find and Repair Errors link. This may take a while to run, but it should be all automated with javascript (just like the converter was).
As well after that click the Recount totals and Stats link

If there is enough data for it to correct the pms, it would be able to restore them. If there isn't, it would delete them.

Congratulations, no errors found! Thanks for checking.

Maintenance Completed.

People still can't see PMs

SleePy

And they are showing in the database? Which table where you looking at?

We could force all users pm unread count to zero.

Just run the following phpmyadmin command:
UPDATE smf_members
SET unreadMessages = 0;


That would force all users unread personal message count to 0. But it wouldn't bring back the old pms to showing again
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

ThorstenE

INSERT INTO `smf_membergroups` VALUES (1, 'Administrator', '#FF0000', -1, 0, '5#staradmin.gif');
INSERT INTO `smf_membergroups` VALUES (2, 'Global Moderator', '#0000FF', -1, 0, '5#stargmod.gif');
INSERT INTO `smf_membergroups` VALUES (3, 'Moderator', '', -1, 0, '5#starmod.gif');

schould fix the group problem.. it will re-create all standard groups

SleePy

You forgot the default post group that uses id of 4  ;)
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

bros

Quote from: SleePy on July 17, 2008, 01:51:30 AM
And they are showing in the database? Which table where you looking at?

We could force all users pm unread count to zero.

Just run the following phpmyadmin command:
UPDATE smf_members
SET unreadMessages = 0;


That would force all users unread personal message count to 0. But it wouldn't bring back the old pms to showing again

smf_personal_messages has 1400 pages.

same with pm_recipients

bros

#30
Quote from: ThorstenE on July 17, 2008, 01:52:24 AM
INSERT INTO `smf_membergroups` VALUES (1, 'Administrator', '#FF0000', -1, 0, '5#staradmin.gif');
INSERT INTO `smf_membergroups` VALUES (2, 'Global Moderator', '#0000FF', -1, 0, '5#stargmod.gif');
INSERT INTO `smf_membergroups` VALUES (3, 'Moderator', '', -1, 0, '5#starmod.gif');

schould fix the group problem.. it will re-create all standard groups

Already recreated them :D

another admin might be coming here soon to also ask some questions

SleePy

In one of the tables (I don't have SMF on hand at the moment). there is a labels column.
What are they set to?
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

bros

Quote from: SleePy on July 17, 2008, 01:05:14 PM
In one of the tables (I don't have SMF on hand at the moment). there is a labels column.
What are they set to?


I don't have access to the DB atm, but there is nothing under labels in My Messages

SleePy

I was just wondering if possibly the default label is off and it isn't able to find them in the inbox.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

bros

#34
Quote from: SleePy on July 17, 2008, 01:42:43 PM
I was just wondering if possibly the default label is off and it isn't able to find them in the inbox.

Labels are set to 0, at least on the first page

And a few are -1

in pm_recipients

No label in the personal_messages one. Or whatever it is called

SleePy

Run this sql query:

UPDATE smf_pm_recipients
SET labels = '-1';


That should force all labels to be defaulted to the inbox.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

bros


Advertisement: