News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

IPB 2.3 Conversion Question

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

Previous topic - Next topic
Print
Go Down Pages1 2 All
User actions

bros

July 15, 2008, 12:05:21 AM
I only have the database for an IPB board, can I convert it to SMF without using any files?

We weren't able to get the files off of the site before the hosting died, so we only have the database. Before we run the converter, we want to know if we will run into any problems.

ThorstenE

#1
July 15, 2008, 02:59:36 AM
yes, it should be possible.. you only have to emulate conf_global.php prom IPB, IPB23_to_smf.sql looks into it for these values:

Code Select
$INFO[sql_database]
$INFO[sql_tbl_prefix]

Code (conf_global.php) Select

<?php
$INFO['sql_database'] = 'database';
$INFO['sql_tbl_prefix'] = 'prefix_';
?>

change database to your database-name, and prefix_ to your table's prefix, then
put it in a new directory callled IPB for example and point to this directory while converting.

bros

#2
July 15, 2008, 03:25:07 PM
Converting members...
Notice: Undefined index: admin_group in /home/polarord/public_html/convert.php(974) : eval()'d code on line 4
Unsuccessful!
This query:
SELECT
m.id AS ID_MEMBER, SUBSTRING(m.name, 1, 80) AS memberName,
m.joined AS dateRegistered,
IF(m.mgroup = , 1, IF(m.mgroup = 3, 0, IF(m.mgroup > 5, m.mgroup + 3, 0))) AS ID_GROUP,
posts, m.last_visit AS lastLogin, SUBSTRING(m.members_display_name, 1, 80) AS realName,
SUBSTRING(me.yahoo, 1, 32) AS YIM, m.msg_total AS instantMessages,
SUBSTRING(mc.converge_pass_hash, 1, 64) AS passwd,
SUBSTRING(mc.converge_pass_salt, 1, 5) AS passwordSalt,
SUBSTRING(m.email, 1, 255) AS emailAddress,
IF (m.bday_year = 0 AND m.bday_month != 0 AND m.bday_day != 0, CONCAT('0004-', m.bday_month, '-', m.bday_day), CONCAT_WS('-', IF(m.bday_year <= 4, 1, m.bday_year), IF(m.bday_month = 0, 1, m.bday_month), IF(m.bday_day = 0, 1, m.bday_day))) AS birthdate,
SUBSTRING(me.website, 1, 255) AS websiteTitle,
SUBSTRING(me.website, 1, 255) AS websiteUrl, me.signature,
SUBSTRING(me.location, 1, 255) AS location,
SUBSTRING(me.icq_number, 1, 255) AS ICQ,
SUBSTRING(me.msnname, 1, 255) AS MSN, SUBSTRING(me.aim_name, 1, 16) AS AIM,
m.hide_email AS hideEmail, m.email_pm AS pm_email_notify,
SUBSTRING(IF(me.avatar_location = 'noavatar', '', me.avatar_location), 1, 255) AS avatar,
TRIM(BOTH ',' FROM mgroup_others) AS additionalGroups,
'' AS lngfile, '' AS buddy_list, '' AS pm_ignore_list, '' AS messageLabels,
'' AS personalText, '' AS timeFormat, '' AS usertitle, '' AS memberIP,
'' AS secretQuestion, '' AS secretAnswer, '' AS validation_code,
'' AS smileySet, '' AS memberIP2
FROM `polarord_smf1`.ibf_members AS m
LEFT JOIN `polarord_smf1`.ibf_member_extra AS me ON (m.id = me.id)
LEFT JOIN `polarord_smf1`.ibf_members_converge AS mc ON (m.id = mc.converge_id)
WHERE m.id != 0
LIMIT 0, 500;
Caused the error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 1, IF(m.mgroup = 3, 0, IF(m.mgroup > 5, m.mgroup + 3, 0))) AS ID_GROUP,
posts,' at line 4

SleePy

#3
July 15, 2008, 06:50:53 PM
You said you tried the ipb 2.3 converter.
Did it work as expected.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

bros

#4
July 15, 2008, 08:31:59 PM
Okay.

The 2.3 converter didn't work, because it was 2.2 :P

Now I am getting an error:
Converting moderators... Unsuccessful!
This query:

    INSERT INTO `polarord_smf1`.smf_moderators
    (ID_MEMBER, ID_BOARD)
    VALUES ('0', '8'),
    ('0', '10'),
    ('0', '11'),
    ('0', '12'),
    ('0', '13'),
    ('0', '15'),
    ('0', '16'),
    ('0', '21'),
    ('0', '24'),
    ('0', '25'),
    ('0', '26'),
    ('0', '27'),
    ('0', '30'),
    ('0', '32'),
    ('0', '33'),
    ('0', '35'),
    ('0', '36'),
    ('0', '37'),
    ('0', '38'),
    ('0', '39'),
    ('0', '40'),
    ('0', '41'),
    ('0', '43'),
    ('0', '44'),
    ('0', '44'),
    ('0', '45'),
    ('0', '46'),
    ('0', '47'),
    ('0', '48'),
    ('0', '49'),
    ('0', '51'),
    ('0', '53'),
    ('0', '54'),
    ('0', '55'),
    ('0', '59'),
    ('0', '60'),
    ('3', '29'),
    ('405', '209'),
    ('405', '221'),
    ('547', '29'),
    ('1200', '360'),
    ('1200', '221'),
    ('1200', '361'),
    ('1200', '362'),
    ('1200', '363'),
    ('1200', '364'),
    ('1419', '4'),
    ('1419', '232'),
    ('1419', '319'),
    ('1419', '358'),
    ('1419', '373'),
    ('2238', '166'),
    ('4332', '446'),
    ('4332', '447'),
    ('4332', '448');

Caused the error:

    Duplicate entry '8-0' for key 1

bros

#5
July 15, 2008, 09:54:27 PM
That error fixed itself

Converting permissions... Unsuccessful!
This query:

    INSERT INTO `polarord_smf1`.smf_membergroups
    (ID_GROUP, groupName, maxMessages, onlineColor, stars)
    VALUES
    (6 + 3, SUBSTRING('NpO Member', 1, 255), 1000, '', '');

Caused the error:

    Duplicate entry '9' for key 1

SleePy

#6
July 16, 2008, 12:51:53 AM
So we are working with the 2.2 converter attached in the first post of the ipb 2.2 topic now?

The converters are slightly different so I don't want to get confused on which one we are working with here.

The moderators error I can have it ignore. As well as the permission one.

Give this one a try. You should be able to just replace the file and then click try again on the browser and it should go through :)
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

bros

#7
July 16, 2008, 12:54:29 AM Last Edit: July 16, 2008, 12:56:21 AM by bros
Okay. Yeah, I was using the one attached to the topic

I uploaded that one.

Let's see what happens.

I'm redoing the conversion.

It did the first three properly, now it is converting topics.

If there are any problems, i'll tell you about them

bros

#8
July 16, 2008, 01:04:16 AM
Hm.

Here is a fun error

Notice: Undefined index: convert_script in /home/polarord/public_html/convert.php on line 791

Warning: Invalid argument supplied for foreach() in /home/polarord/public_html/convert.php on line 794

Notice: Undefined index: convert_script in /home/polarord/public_html/convert.php on line 806

Notice: Undefined index: convert_script in /home/polarord/public_html/convert.php on line 702
Successful.
Recalculating forum statistics...
Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2217

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2218

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 1189

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 1199

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2217

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2218

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 1207

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 1217

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2217

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2218

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 1230

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 1243

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2217

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2218

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 1289

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 1291

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2217

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2218

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 1297

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 1303

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2217

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2218

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 1314

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 1315

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2217

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2218

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 1323

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 1325

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2217

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2218

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 1331

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 1332

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2217

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2218

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 1338

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 1339

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2217

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2218

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2217

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2218

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 1363

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 1365

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2217

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2218

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 1371

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 1383

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2217

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2218

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2217

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2218

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 1408

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 1410

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2217

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2218

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 1454

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 1469

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2217

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2218

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 1498

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 1500

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 1513

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2217

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2218

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 1535

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 1540

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2217

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2218

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 1601

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 1603

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2217

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2218

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 1639

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 1658

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2217

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2218

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2217

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2218

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2217

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2218

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 1681

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 1682

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2217

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2218

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 2384

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2217

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2218

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2217

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2218

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/polarord/public_html/convert.php on line 2384

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2217

Notice: Undefined variable: result in /home/polarord/public_html/convert.php on line 2218
Successful.

SleePy

#9
July 16, 2008, 01:08:37 AM
Your session died..
It happens from time to time and your session gets to old and the browser deletes it.

I need to find a way to make a more user friendly error message though :P
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

bros

#10
July 16, 2008, 01:10:46 AM
Quote from: SleePy on July 16, 2008, 01:08:37 AM
Your session died..
It happens from time to time and your session gets to old and the browser deletes it.

I need to find a way to make a more user friendly error message though :P

Okay. let's refresh convert.php

I'll tell it to convert everything

bros

#11
July 16, 2008, 01:14:10 AM
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Incomplete.

let's see if it errors again!

bros

#12
July 16, 2008, 10:27:47 AM
Yay!

An error!

Recalculating forum statistics... Unsuccessful!
This query:

    INSERT INTO `polarord_smf1`.smf_categories
    (name)
    VALUES ('General Category');

Caused the error:

    Duplicate entry '255' for key 1

bros

#13
July 16, 2008, 10:31:07 AM
Clicked ttry again and it bypassed it

bros

#14
July 16, 2008, 10:56:37 AM
Either I can't see the membergroups, or every membergroup was wiped:
http://polarorder.net/index.php?action=mlist

SleePy

#15
July 16, 2008, 01:05:48 PM
As a guest I can't view that page.

Go to Admin -> Membergroups

Do your groups show (besides the SMF default ones)?

As for the duplicate error you had. Common conversion errors.
That topic explains what happens.

You can try the following tool after conversion to correct these.
[Beta] Correct high ID_CAT values
It simply recounts the id_cat to use lower values so you should have less issues (with things such as upgrading).
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

bros

#16
July 16, 2008, 01:15:54 PM
Quote from: SleePy on July 16, 2008, 01:05:48 PM
As a guest I can't view that page.

Go to Admin -> Membergroups

Do your groups show (besides the SMF default ones)?

As for the duplicate error you had. Common conversion errors.
That topic explains what happens.

You can try the following tool after conversion to correct these.
[Beta] Correct high ID_CAT values
It simply recounts the id_cat to use lower values so you should have less issues (with things such as upgrading).

I can't get into the admin panel. And no groups, not even the SMF default ones are showing in profiles

SleePy

#17
July 16, 2008, 03:01:23 PM
Does your user not have admin permissions?

In the database using phpMyAdmin.
Go to smf_members table.
Find your user and edit it. Set the ID_GROUP for that user to 1.

That should grant you full admin powers.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

bros

#18
July 16, 2008, 03:08:26 PM
Quote from: SleePy on July 16, 2008, 03:01:23 PM
Does your user not have admin permissions?

In the database using phpMyAdmin.
Go to smf_members table.
Find your user and edit it. Set the ID_GROUP for that user to 1.

That should grant you full admin powers.

Already been done.

I think the permissions for admin in smf_permissions might have been wiped.

ThorstenE

#19
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:
Code Select
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:

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

bros

#20
July 16, 2008, 05:11:58 PM Last Edit: July 16, 2008, 05:46:58 PM by bros
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:
Code Select
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:

Code Select
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

#21
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.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

bros

#22
July 16, 2008, 06:21:59 PM
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

#23
July 17, 2008, 12:59:07 AM
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

#24
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.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

bros

#25
July 17, 2008, 01:47:29 AM
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

#26
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:
Code Select
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

#27
July 17, 2008, 01:52:24 AM
Code Select
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

#28
July 17, 2008, 01:56:43 AM
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

#29
July 17, 2008, 01:59:25 AM
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:
Code Select
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
July 17, 2008, 01:59:54 AM Last Edit: July 17, 2008, 02:09:26 AM by bros
Quote from: ThorstenE on July 17, 2008, 01:52:24 AM
Code Select
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

#31
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?
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

bros

#32
July 17, 2008, 01:36:09 PM
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

#33
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.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

bros

#34
July 17, 2008, 08:28:27 PM Last Edit: July 17, 2008, 08:33:48 PM by bros
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

#35
July 17, 2008, 10:23:16 PM
Run this sql query:

Code Select
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

#36
July 18, 2008, 12:23:12 AM
That fixed it. Thank you
Print
Go Up Pages1 2 All
User actions
Advertisement: