Upgrading from 1.1.21 to...

[ducpainter]

Your host package is a bit off the beaten path, you've been running on an obsolete platform, but if you upgrade php and mysql before running the upgrade it should be ok.  Good luck.

I'm not sure what you mean by that. I think my host is far more modern than my 1.1.21 forum.

My server has all php versions available, but not sure about the mysql versions.

...and thanks. I'll need it.

[Sir Osis of Liver]

You'll probably need your host to upgrade mysql, that's not usually a control panel option.  Try upgrading php to 8.1 and run the 2.1.4 upgrade, just be sure you have a complete database backup.

[ducpainter]

I started the process and got this error

Table 'dmf_smf-.smf_im_recipients' doesn't exist

Can I use php myadmin and create it?

[Doug Heffernan]

I started the process and got this error

Table 'dmf_smf-.smf_im_recipients' doesn't exist

Can I use php myadmin and create it?

Yes, you can add it to the database through phpmyadmin. What version are you trying to upgrade to, 2.0.19 or 2.1.4.?

[ducpainter]

2.1.4

Not being very expert in these things is there anyplace special to place it?

[Doug Heffernan]

2.1.4

Not being very expert in these things is there anyplace special to placeit?

You can run the query from the SQL Tab there, after you select first the database that you've used to install your forum. Better yet, take the schema from the backup file with all its content as you won't loose any data like that.

[ducpainter]

2.1.4

Not being very expert in these things is there anyplace special to placeit?

You can run the query from the SQL Tab there, after you select first the database that you've used to install your forum. Better yet, take the schema from the backup file with all its content as you won't loose any data like that.

I think that's above my skill level.

I can figure out how to add a table, and try running the upgrade again?

[ducpainter]

I guess I can't figure out how to create a table. [bangshead]

Can anyone give me some pointers on the values and the fields for this new table?

TIA

[Doug Heffernan]

I guess I can't figure out how to create a table. [bangshead]

Can anyone give me some pointers on the values and the fields for this new table?

TIA

You can take the structure of a table from one of the install files of the smf install package, but that means that there will be no data in it and for this table you will need the data. Hence why I suggested that you copy the whole table structure along with the insert into table commands for its data from your backup file and then paste it at the SQL Box and run it.

[ducpainter]

I'll pick it up again... tomorrow.

Thanks for your input.

I have little experience with all this.

[Sir Osis of Liver]

Two things you can do:

- Try upgrading to 2.0.19.  If it works you should then be able to upgrade to 2.1.4 without issues.  (Probably won't work for same reason.)

- Import the attached table into your database, it's from a clean 1.1.21 install.  You'll have to edit the prefix so it's the same as your other tables.

[ducpainter]

I really appreciate that.

I tried it. The file you attached already exists.

The upgrader was looking for dmf_smf-.smf_im_recipients, which is odd because there are no instant messages in 1.1.21.

I think I'll try an incremental upgrade like you suggested. At this point I have nothing to lose. Tomorrow is another day.

[Sir Osis of Liver]

im_recipients is not a core table in 1.1, 2.0, or 2.1.  Thought that was a typo.  No idea why upgrader is looking for it.

[ducpainter]

im_recipients is not a core table in 1.1, 2.0, or 2.1.  No idea why upgrader is looking for it.

Me either, but I went in and edited the file to read 'im' and it successfully imported.

I'll try the upgrade again tomorrow.

Thanks again for all your help. Every time I mess with this stuff I learn something.

[Sir Osis of Liver]

Ok, looks like upgrade_1-1.sql required im_recipients -

Code Select Expand


---# Renaming personal message tables...
RENAME TABLE {$db_prefix}instant_messages
TO {$db_prefix}personal_messages;

RENAME TABLE {$db_prefix}im_recipients
TO {$db_prefix}pm_recipients;
---#


upgrade_1-0.sql is supposed to create it if it's not there -

Code Select Expand


---# Creating "im_recipients"...
CREATE TABLE IF NOT EXISTS {$db_prefix}im_recipients (
    ID_PM int(10) unsigned NOT NULL default '0',
    ID_MEMBER mediumint(8) unsigned NOT NULL default '0',
    bcc tinyint(3) unsigned NOT NULL default '0',
    is_read tinyint(3) unsigned NOT NULL default '0',
    deleted tinyint(3) unsigned NOT NULL default '0',
    PRIMARY KEY (ID_PM, ID_MEMBER),
    KEY ID_MEMBER (ID_MEMBER, deleted)
) ENGINE=MyISAM;
---#


Not sure how the upgrade scripts run, but apparently you need im_recipients so it can be renamed to pm_recipients.  That's odd because it's not a core table in 1.1.21.  Seems it was a valid table in 1.0 which was renamed in 1.1, the upgrader should know that.  You should have a pm_recipients table in your 1.1.21 database.  If so, you can try commenting out those lines in upgrade_1.1.sql -

Code Select Expand


---# Renaming personal message tables...
RENAME TABLE {$db_prefix}instant_messages
TO {$db_prefix}personal_messages;

-- RENAME TABLE {$db_prefix}im_recipients
-- TO {$db_prefix}pm_recipients;
---#



[ducpainter]

The _pm table is there. Do you think it will work with both the im, and pm tables in there?

I'm not sure I'm comfortable, or capable of, even finding the upgrader files you're referencing.

[Sir Osis of Liver]

im_recipients is not a valid table in 1.1.21 and later, it should be ignored.  You're still running in php 5.6, and looks like most of the files are 1.1, you haven't uploaded the complete 2.1.4 upgrade package.  I can edit the file and run the upgrade from here, but need to know what you've done so far.

[ducpainter]

What I've done...

I've uploaded the upgrade files to httpdocs, but removed upgrade.php to put the forum back online.

I removed all the backup files from the db that the upgrader created. I also restored the forum from a back up after the failed upgrade attempt.

I also modified the file you attached earlier to say im and imported it into the db...

...and likely a thousand other things I screwed up and managed to bail out of and keep the thing running.

Let me know if you want me to  edit out that new table, make a new db copy and put the thing in maintenance mode.

[Sir Osis of Liver]

I've put you in maintenance mode, dump the database.  When you've confirmed that I'll run the upgrade.

[ducpainter]

Oh...so that was you.

I thought I was losing it.