I have a forum running 1.1.21 and since a recent server migration I'm getting thousands of php errors due to not having 5.4, and I believe it's causing numerous 504 errors due to the php version incompatibility. I have 5.6.4 but it isn't cutting it.
I have two questions... first...can I upload the extracted upgrade files as a folder, or do they have to uploaded individually, and is there a best place to position them in the forum file structure?
Second...should I consider upgrading in steps, or is it just as likely to work going from 1.1.21 directly to 2.1.4? The server runs AlmaLinux 9, and I have access to all php versions from 5.6.4 up to 8.3.17 if it makes any difference.
I've read countless threads here, and I'll back everything up, both on the server, and on my laptop. I'll also uninstall all mods and delete the files before the upgrade, along with any themes.
TIA
Yes, you can upgrade directly from SMF 1.1.x to SMF 2.1.4 using the large upgrade package. If you run into any hiccups along the way, just ask here and people will help you out.
https://wiki.simplemachines.org/smf/Upgrading
Quote from: ducpainter on March 03, 2025, 12:02:44 PMI have two questions... first...can I upload the extracted upgrade files as a folder, or do they have to uploaded individually, and is there a best place to position them in the forum file structure?
The files from the upgrade package should be uploaded inside whatever folder your forum files reside so they can overwrite them. For a detailed guide on how to perform the upgrade please see the below link:
Upgrading SMF (https://wiki.simplemachines.org/smf/Upgrading)
Quote from: ducpainter on March 03, 2025, 12:02:44 PMSecond...should I consider upgrading in steps, or is it just as likely to work going from 1.1.21 directly to 2.1.4? The server runs AlmaLinux 9, and I have access to all php versions from 5.6.4 up to 8.3.17 if it makes any difference.
You can upgrade directly to 2.1.4. I have performed quite several such upgrades and I've never had any problems. Another option is to upgrade first to 2.10.19 and then to 2.1.4.
Good luck with the upgrade.
Maybe I'm not explaining myself very well. I'll try again.
I understand the files have to go into the folder with the forum files. My question is can I upload those files as a folder rather than individual files?
You should be able to use your host control panel file manager to upload the zip and extract it in the forum directory.
Quote from: Sir Osis of Liver on March 03, 2025, 12:20:11 PMYou should be able to use your host control panel file manager to upload the zip and extract it in the forum directory.
Thanks for that.
Wish me luck...I'm somewhat of a Luddite.
The important thing is that you manage to overwrite all the old files, the method of actual transfer does not really matter. But you do need to get the folder structure right, and all the files in the right places.
You probably can upload multiple files at once through your hosting control panel or any FTP client.
For specifics, you may want to consult your host.
Well, I didn't have any luck getting the upgrade to start.
I uploaded the zip file via my control panel to the home directory, and extracted it there, but when I try to point to the file, it either says file not found, or just goes to the forum home page.
I did mention I was a Luddite...correct?
did you override the existing files with the ones in the upgrade package? without us knowing exactly what you did it is hard to help.
Probably not.
What folder in the file system do the original files reside?
The upload and overwrite of the files are best done manually imo, rather than extracting them through the file manager. That said, after you have downloaded the large upgrade package to your pc, unzip it first. Then ftp them to the folder that holds your current forum files keeping the structure intact and select the overwriting option when prompted by the ftp client.
Link to your forum?
If you have the typical server setup your forum should be in /public_html. Look for Settings.php, that's in the forum root.
Thanks for your help, but I'm just not finding the stuff you're pointing me to.
Either my installation is weird, or I'm just too stupid to figure it out, which is the most likely explanation.
I guess I'll have to pay someone to figure it out. If any of you support people are interested, let me know.
Did you find Settings.php? Do you have a backup copy? It will contain paths to your forum install.
I find settings.php in the httpdocs directory.
According to my admin server settings page the SMF directory is... /var/www/vhosts/ducatimonsterforum.org/httpdocs
I just am not finding that in my ftp client. Remember I said I was a Luddite?
I will add that since I cleaned out all the fluff from my packages manager I haven't had a 504 error all day.
The php errors are still rampant.
Looks like that's where your forum is installed. 1.1.21 will run in php 5.6 but will log a lot of errors. 5.6 went eol over six years ago. Don't think it will run in php 7, definitely not in php 8. Supported versions of php are 8.1, 8.2, 8.3, 8.4. Anything below 8.1 is eol. 2.1.4 supports 8.1 and 8.2. Check your PMs.
Replied
Quote from: Sir Osis of Liver on March 03, 2025, 08:59:51 PMLooks like that's where your forum is installed. 1.1.21 will run in php 5.6 but will log a lot of errors. 5.6 went eol over six years ago. Don't think it will run in php 7, definitely not in php 8. Supported versions of php are 8.1, 8.2, 8.3, 8.4. Anything below 8.1 is eol. 2.1.4 supports 8.1 and 8.2. Check your PMs.
...and that's why I want to upgrade to 2.1.4
Ok, the forum is installed in /httpdocs, you uploaded the upgrade package one level above that. Do you have a local backup of your database?
Quote from: Sir Osis of Liver on March 03, 2025, 09:15:27 PMOk, the forum is installed in /httpdocs, you uploaded the upgrade package one level above that. Do you have a local backup of your database?
No. I can copy it and download it. Does that work?
You should be able to d/l a database backup in your host control panel, or with phpmyadmin. The sql files in /httpdocs are from June 2022, you need to dump the current database. Looks like it's around half a gb, so control panel is best bet. Do that now if you can, the upgrade modifies the database extensively, don't want to try it without a backup.
Quote from: Sir Osis of Liver on March 03, 2025, 09:25:10 PMYou should be able to d/l a database backup in your host control panel, or with phpmyadmin. The sql files in /httpdocs are from June 2022, you need to dump the current database. Looks like it's around half a gb, so control panel is best bet. Do that now if you can, the upgrade modifies the database extensively, don't want to try it without a backup.
Give me a minute.
I do have a full backup of the site including everything on the server. I'll see if I can back up the db separately.
I want to thank you for your help in advance.
I made a copy. Download is a no go. I can put the forum in maintenance mode, make another, and save it on the server, but there's no option to download.
See if you can save it to /httpdocs/db_backup.
Quote from: Sir Osis of Liver on March 03, 2025, 09:41:40 PMSee if you can save it to /httpdocs/db_backup.
I tried, but I honestly don't think I know how to do that.
I'm using Plesk for a control panel, and it only allows copying within if you get my drift.
Where did you save it on server?
Quote from: Sir Osis of Liver on March 03, 2025, 09:54:15 PMWhere did you save it on server?
In my Plesk control panel in the domain section for ducatimonsterforum.org Are you familiar with Plesk? It's the only way an ancient Luddite like myself can administer a website.
It's really kind of humorous that since I started this thread I've been inundated with spammers trying to register wanting to 'Talk to Admin'
Wait...I figured out how to do a sql dump to my 'puter.
Is that what you were looking for?
Yes, you should have a local database backup, that's where your content is stored (that and /attachments). Dump it two or three times, check that the byte count is the same to confirm it's complete.
I've only used Plesk on couple of forums, it's difficult compared to cPanel or DirectAdmin, which are more common on shared servers. There are a couple of things you'll need to do before attempting upgrade. 2.1.4 requires php 7.0 or higher, you're at 5.6.40, and mysql 5.6 or higher, you're at 5.0.11. If you can't upgrade them in Plesk, ask your host support to do it. 2.1.4 will run in php 5.6 with a lot of errors, so it's best to upgrade php before upgrading the forum. Don't know if the 2.1.4 upgrade will run in 5.6.
Going offline shortly, will get back to this tomorrow.
I have all php handlers provisioned up to 8.3.17. I don't think that will be an issue.
I'll do some more test dumps to ascertain byte count.
Talk tomorrow afternoon. I need to work on my BAC.
Thanks again, sir osis.
Quote from: ducpainter on March 03, 2025, 07:57:43 PMducatimonsterforum.org
A bit off topic, but you've got a very nice forum there. I was hit with a wave of nostalgia as it reminded my of my 'Bella' back in my younger, happy and care free days. Those were the times. (Yes, I did name my Ducati, until it made my then girlfriend jealous :D)
Quote from: Doug Heffernan on March 04, 2025, 12:45:51 PMQuote from: ducpainter on March 03, 2025, 07:57:43 PMducatimonsterforum.org
A bit off topic, but you've got a very nice forum there. I was hit with a wave of nostalgia as it reminded my of my 'Bella' back in my younger, happy and care free days. Those were the times. (Yes, I did name my Ducati, until it made my then girlfriend jealous :D)
No worries about being off topic, and thanks very much.
It started quite a while ago, was vibrant for quite some time, and now it's pretty quiet. It is a pretty good source of technical info for the Ducati's from the mid 90's till the teens when Ducati revamped their designs. They still use the desmo system, but the bikes are very different.
I've delayed upgrading due to custom mods to the theme that were done by an Admin with the skill. He's no longer active and the members like the look. With 2.1.4 I can get a lot of that look back with a theme and some mods. I'm tired of having to babysit the server. I will say that since I removed unused mods, and themes, my 504 errors have ceased. Naturally the .php errors haven't, so I think it's time to upgrade while I'm motivated, and halfway there.
Quote from: ducpainter on March 04, 2025, 02:01:51 PMIt started quite a while ago, was vibrant for quite some time, and now it's pretty quiet. It is a pretty good source of technical info for the Ducati's from the mid 90's till the teens when Ducati revamped their designs. They still use the desmo system, but the bikes are very different.
I agree. It has a lot of interesting content from what I saw. They don't make them old school anymore like the mid 90's 900SS/SP, which I personally think is one of the most beautiful bikes ever made.
Quote from: ducpainter on March 04, 2025, 02:01:51 PMI've delayed upgrading due to custom mods to the theme that were done by an Admin with the skill. He's no longer active and the members like the look. With 2.1.4 I can get a lot of that look back with a theme and some mods. I'm tired of having to babysit the server. I will say that since I removed unused mods, and themes, my 504 errors have ceased. Naturally the .php errors haven't, so I think it's time to upgrade while I'm motivated, and halfway there.
What mods are you using on your current forum? Maybe their upgraded versions can be found at our Mods Database? Regarding the upgrade, I think it high time that you do it as the version that you are using is very old and it has a lot of security issues, not to mention the bugs. Also the php version that is supported by your forum version is riddled with security vulnerabilities.
My favorite is the Terblance SBK...748/916/996/998. I have a 996 turned 853 for the track, which is an overbored 748, and a 93 SS as a backup track bike.
Simple Portal, Stop Spammer, and Simple A/V embedder. I had tapatalk, but I uninstalled it in preparation for my failed upgrade attempt. There were old mods, and themes, that had been abandoned and never deleted. My understanding is 2.1.x is more android friendly. I'd just as soon not have it.
I've searched the mod site for replacements for the mods I'm using now and found some that will work. I may or may not add Tiny Portal, as Simple doesn't appear to work with 2.1.x. I've also found a theme that is pretty close to the customized theme we were running.
In the long run this upgrade will be good all around.
Back online. Your forum is still running in php 5.6, mysql 5.0 - https://ducatimonsterforum.org/phpinfo.php
SimplePortal was not updated to 2.1, but I believe EZPortal (https://custom.simplemachines.org/index.php?mod=1461) will replace it and inherit the SP settings. You can replace Stop Spammer with Stop Forum Spam (https://custom.simplemachines.org/index.php?mod=4311), but this mod (https://custom.simplemachines.org/index.php?mod=4278) is simpler, very effective, and utilizes the built-in verification questions feature. There's a 2.1 version of A/V Embedder (https://custom.simplemachines.org/index.php?mod=2681).
Quote from: Sir Osis of Liver on March 04, 2025, 04:43:31 PMBack online. Your forum is still running in php 5.6, mysql 5.0 - https://ducatimonsterforum.org/phpinfo.php
SimplePortal was not updated to 2.1, but I believe EZPortal (https://custom.simplemachines.org/index.php?mod=1461) will replace it and inherit the SP settings. You can replace Stop Spammer with Stop Forum Spam (https://custom.simplemachines.org/index.php?mod=4311), but this mod (https://custom.simplemachines.org/index.php?mod=4278) is simpler, very effective, and utilizes the built-in verification questions feature. There's a 2.1 version of A/V Embedder (https://custom.simplemachines.org/index.php?mod=2681).
I haven't pushed the button.
Thanks for the recs. I'll investigate, and likely follow them. You've been immensely helpful...particularly with the map you drew, and coaxing me along to see what I was somewhat blind in acknowledging.
I'm going to try the upgrade tomorrow after a fresh backup and sql dumps.
It'll be fine. ;D
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.
Quote from: Sir Osis of Liver on March 04, 2025, 05:19:20 PMYour 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.
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.
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?
Quote from: ducpainter on March 05, 2025, 02:15:59 PMI 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.?
2.1.4
Not being very expert in these things is there anyplace special to place it?
Quote from: ducpainter on March 05, 2025, 02:36:41 PM2.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.
Quote from: Doug Heffernan on March 05, 2025, 02:38:55 PMQuote from: ducpainter on March 05, 2025, 02:36:41 PM2.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?
I guess I can't figure out how to create a table. [bangshead] ;D
Can anyone give me some pointers on the values and the fields for this new table?
TIA
Quote from: ducpainter on March 05, 2025, 03:54:12 PMI guess I can't figure out how to create a table. [bangshead] ;D
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.
I'll pick it up again... tomorrow.
Thanks for your input.
I have little experience with all this.
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.
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.
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.
Quote from: Sir Osis of Liver on March 05, 2025, 08:52:45 PMim_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.
Ok, looks like upgrade_1-1.sql required im_recipients -
---# 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 -
---# 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 -
---# 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;
---#
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.
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.
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.
I've put you in maintenance mode, dump the database. When you've confirmed that I'll run the upgrade.
Oh...so that was you.
I thought I was losing it. ;D
Did you empty the error log before dumping the database?
probably not.
I'll do it again.
Give me a minute
Warning! You do not appear to have a version of PHP installed on your webserver that meets SMF's minimum installations requirements.
Please ask your host to upgrade.
Ok...
database copied, error log cleared, there's an sql dump on the server, but for some reason my ftp client is telling me the certificate in wrong...not sure if that has anything to do with anything. You can save it or leave it there. At least it exists.
You're up.
When I did the backup it reverted to the old php settings.
Try now
Don't do anything ...........
Table 'dmf_smf-.smf_instant_messages' doesn't exist
Running........
Just got a warning message from my host that has an issue with the HTTPS_DOMAIN service.
In the past, the only solution has been to restart the server. That would likely break ther upgrade...no?
I did nothing, I see nothing.
Ok, you're at 2.1.4. Check if everything's working.
You'll need to find a new theme.
I would install the verification image mod first, set up 20-30 verification questions. Then install ezportal, see if it inherits the SP settings.
2.1.4 does not officially support php 8.3, but shouldn't be any major problems. You can downgrade to 8.1/8.2.
Restarting the server will not affect the upgrade unless host restores a backup, the upgrade is complete.
I shudder to ask, but who is your host?
I saw that, and I can't thank you enough.
I searched themes, and greyed out is kinda close. Do you know if Curve will work in 2.1.4 on the included theme to get somewhere's near to the look? I'm more concerned with colors...remember I'm a painter
I can back down the php version. Not sure if my host gives me such detailed choices. Let me know if that's preferred.
Default theme is Curve2, that's what you're seeing now. You can look through 2.1 themes here (https://custom.simplemachines.org/index.php?action=themes;major_smf_versions%5B2.1%5D=2.1). Any theme can be customized.
You can run the forum in php 8.3, just keep an eye on the error log. You might have problems with mods that don't support php 8.x.
Are you concerned about the errors?
Just a question
s
What php version would you prefer?
You shouldn't log any errors, it's a clean install. 2.1.4 officially supports php 8.1/8.2. Either one is fine.
Going offline til tomorrow. Try not to break anything. :P
I did some thing...
backed up to 8.2.
Don't think I busted anything. ;D ...although that's my MO
Thanks again.
Quote from: Sir Osis of Liver on March 05, 2025, 10:27:24 PM<snip>
I shudder to ask, but who is your host?
Godaddy
We were with mediatemple, and they were great. Godaddy swallowed them up, and it's well...Godaddy.
BTW
/var/www/vhosts/ducatimonsterforum.org/httpdocs/Sources/Security.php (Line 166)
Type of error: Undefined
Error messageSelect
2: Undefined array key "id_member"
Quote from: ducpainter on March 06, 2025, 11:50:21 AMGodaddy
It leaves a lot to be desired imo.
Quote from: ducpainter on March 06, 2025, 11:50:21 AM/var/www/vhosts/ducatimonsterforum.org/httpdocs/Sources/Security.php (Line 166)
Type of error: Undefined
Error messageSelect
2: Undefined array key "id_member"
Is that the complete error message?
Like I said...it used to great. Since the upgrade I can't connect via FTP because the server uses one ssl, and the domain uses a different one. I'll have to contact godaddy and get run arpound for a bit. ::)
I truncated the message slightly by removing Guest, the IP address...this
d7d66a84e4684a86e83443ff9296094e
and 'Type of error:Undefined'
After looking through the error log I'm finding others. Lots of this one
8192: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead<br />File: /var/www/vhosts/ducatimonsterforum.org/httpdocs/Sources/Load.php(225) : runtime-created function<br />Line: 3
Which is the same error I was getting with 1.1.21. I believe those were while I was running php 8.3. I've backed it down to 8.2, on the advice of Sir Osis, and I'm not seeing those errors now
ETA...if you'd like now that it's upgraded I will start a new thread in the proper support section. Your call. Also, Can I safely clean out the packages from the package manager like all the old 1.0, and 1.1.x updates?
I have been paid to transfer 10 different sites out of goDaddy to ICD Soft st this point....
GoDaddy has always been bad --- they've just gotten worse than bad in the last 5 years
GoDaddy :P Are you running a vps?
Your attachments should be failing to load with 404s. Upgrader is supposed to add a .dat extension to all hashed filenames, but sometimes it doesn't. I have a script to fix that, will see if I can find it.
You have a lot of crap in /httpdocs, should do some cleanup. (Over 2.5 gigs of database dumps from June 2024.)
What did you do to /attachments? You had 2502 files before upgrade, now there are 107, and most of those are avatars that shouldn't be there.
Quote from: Kindred on March 06, 2025, 02:32:32 PMI have been paid to transfer 10 different sites out of goDaddy to ICD Soft st this point....
GoDaddy has always been bad --- they've just gotten worse than bad in the last 5 years
I'll keep that in mind.
You'll get no argument from me. I'm locked in for a while longer.
Quote from: Sir Osis of Liver on March 06, 2025, 03:47:08 PMWhat did you do to /attachments? You had 2502 files before upgrade, now there are 107, and most of those are avatars that shouldn't be there.
I didn't touch anything, as I haven't been able to log in via FTP since the upgrade due to ssl cert issues. I did download all the file before the upgrade so I might have whatever is missing.
Quote from: Sir Osis of Liver on March 06, 2025, 03:43:14 PMGoDaddy :P Are you running a vps?
Your attachments should be failing to load with 404s. Upgrader is supposed to add a .dat extension to all hashed filenames, but sometimes it doesn't. I have a script to fix that, will see if I can find it.
You have a lot of crap in /httpdocs, should do some cleanup. (Over 2.5 gigs of database dumps from June 2024.)
Yes. VPS wirh AlmaLinux 9.5 Like I said earlier, we were with mediatemple, and they were great. When Godaddy first bought them nothing changed. It was still great. The only reason I stayed with them on this renewal was they told me the server had php 5.4, and I like the Plesk cp. Since I wanted to keep the old look I stayed.
Turns out they lied to me about the php version. [bangshead], and here we are. ;D
I can use the file manager in my control panel to remove the backups, but feel free. I also want to get rid of all the Tiny Portal stuff, and old updates for 1.1.x in the package manager. Let me know.
I have a backup of /attachments from Mar 3, will upload it now and run the .dat script. Not sure what was done with avatars. There are 2400 files in /custom_avatar. That directory is created by the 2.1.4 upgrade and avatars are moved from /attachments to /custom_avatar. Looks like that was done correctly, but no idea what happened to attachments, most of them are missing.
You have registration disabled, create an admin account for me and PM the login.
Done
Make me admin.
Looks like the upgrade went a bit sideways. It ran successfully with no errors but things aren't quite right. This is what I've done so far:
- Uploaded attachments from backup to /attachments
- Uploaded avatars from from backup to /custom_avatar
- Added .dat extension to all attachment files.
- Deleted avatars from /attachments.
Quote from: Sir Osis of Liver on March 06, 2025, 04:42:09 PMMake me admin.
Looks like the upgrade went a bit sideways. It ran successfully with no errors but things aren't quite right. This is what I've done so far:
- Uploaded attachments from backup to /attachments
- Uploaded avatars from from backup to /custom_avatar
- Added .dat extension to all attachment files.
- Deleted avatars from /attachments.
I did...I thought. Let me check.
I'm not surprised. Going from 2015 to 2025 in milliseconds will screw with lots of stuff.
Try now.
Cleared error log, let's let it run for a while. Will try installing ezportal.
Already did that.
Didn't pick up the settings from simple. Got a message to ask for an importer from the author.
It's on the list.
Ezportal installs but doesn't work, not in main menu, no admin panel. Just see it in permissions. Installs fine on 2.1.4 test install.
Cleaning up.
Where we at?
It doesn't work on your forum, no idea why. Installs without errors, but it's not in ACP or main menu. You can ask in mod support topic -
https://www.simplemachines.org/community/index.php?topic=271882.0
I've left it installed.
Getting a lot of these -
Guest
216.244.66.196
fda25c918408e92dcd903dc7f0b9bd41
https://ducatimonsterforum.org/index.php?topic=10531.msg1467559
/var/www/vhosts/ducatimonsterforum.org/httpdocs/Sources/Load.php (Line 3199)
Backtrace information
Type of error: General
Error message Select
2: Trying to access array offset on value of type null
Now running mysqli client API library version - mysqlnd 8.2.27
I have no idea why either.
I may contact the developer...or not.
So many changes from where we were and now.
Not really worried.
My goal is to find someone to implement what was.
I do not have the skills.
You know that.
Not on my computer, will have another look tomorrow. Just let it run and see if any problems are reported.
Any problems with the forum? Error log looks ok. Pretty sure I deleted the sql dumps from /httpdocs, they've come back.
I'm thinking the problem with ezportal is a conflict with another mod. What I'd like to do is uninstall all mods, remove hooks with repair_settings, upload clean files, install ezportal first. Will try that tonight if everything else is ok.
Seems to be running fine.
The ezportal files are there, but aren't actually installed according to the package manager. I had it installed, but I read in the mod thread that you could request an importer from simple portal. I was hoping to do that rather than build it all over again. I haven't done that yet because I'm trying to decide which way to go with the theme.
The default theme on the old forum was modified with css. I have all the values that were used. I'm trying to figure where they go in index.css. The file I have is style.css. They look like different formats. I may try to rename it and replace the default copies with the renamed file to see what happens.
There's also the option of the curve color changer, but that only works on the default theme, and not copies, and I don't know how flexible it is.
The 1.1 css in style.css is not compatible with a 2.1 (or 2.0) theme, you'll have to customize your theme from scratch. Curve color changer may work, you'd have to try it -
This mod is mainly for the default theme, custom themes might be compatible depending on the author of the custom theme.
Not sure but I believe ezportal will inherit the SP settings. It's not installing correctly, will try to fix that now. Don't do anything with the forum til I'm done.'
Quote from: Sir Osis of Liver on March 07, 2025, 09:28:27 PMThe 1.1 css in style.css is not compatible with a 2.1 (or 2.0) theme, you'll have to customize your theme from scratch. Curve color changer may work, you'd have to try it -
This mod is mainly for the default theme, custom themes might be compatible depending on the author of the custom theme.
Not sure but I believe ezportal will inherit the SP settings. It's not installing correctly, will try to fix that now. Don't do anything with the forum til I'm done.'
Are you familiar with the color changer? Can you specify colors, or are there canned pallettes?
Crap. >:( Disabled hooks and forum is down. Let me fix that first.
Wut? ;D
While we're waiting, did you uninstall SimplePortal prior to upgrade and remove all content?
Quote from: Sir Osis of Liver on March 07, 2025, 10:13:27 PMWhile we're waiting, did you uninstall SimplePortal prior to upgrade and remove all content?
No. It gave me warnings so I didn't. IIRC I tried, and it crashed the forum, so I restored from backup and I didn't uninstall anything that gave a warning,
That may be why ezportal won't install correctly. I've posted in mod support topic, will see what they tell me. If it's no go you can try TinyPortal.
Right now, that's the least of my worries.
My main concern is to have a working forum, and to try and emulate the previous look.
Tried running 2.1.4 repair utility, got a 504 gateway timeout and now forum won't load at all. You'll have to ask host support to fix it.
Dood...
Godaddy support is more than useless.
504 is fixed. Crashed again when I tried installing ehportal, I believe it's a SP fork, but gave me wsod. Uploading backup now.
Now I'm getting this --
SMF file version (2.1.4) does not match SMF database version (1.1.6).
Run the SMF upgrader to fix this.
Did you or GD restore an old backup?
I'm going to try to revert to my 1.1.21 install.
Didn't go exactly like I hoped.
Quote from: Sir Osis of Liver on March 07, 2025, 10:53:14 PMNow I'm getting this --
SMF file version (2.1.4) does not match SMF database version (1.1.6).
Run the SMF upgrader to fix this.
Did you or GD restore an old backup?
Yeah...When you told me to contact my host I thought you were done.
Did you dump the 2.1.4 database after upgrade completed?
What I'd really like to do is to revert to 1.1 21.
I understand all the security issues, but we don't sell anything, or collect money, and if anyone uses the same password for everything they're an idiot.
Quote from: Sir Osis of Liver on March 07, 2025, 10:59:43 PMDid you dump the 2.1.4 database after upgrade completed?
No, but I have backups...on the server
Let me try something.
Looks like you've reverted to php 5.6, mysql 5.0 and imported a very old database. You have to replace the 2.1.4 files with 1.1.21 files if you want to get back to square one, assuming you have the 1.1.21 database.
Quote from: Sir Osis of Liver on March 07, 2025, 11:03:05 PMLooks like you've reverted to php 5.6, mysql 5.0 and imported a very old database. You have to replace the 2.1.4 files with 1.1.21 files if you want to get back to square one, assuming you have the 1.1.21 database.
I have a backup of the forum with the old files and database, and sql dumps of the database.
It'll be fine. ;D
Computers suck. 8)
Forum is back up. Do you want to remove repair settings php?
Between the two of us we could crash the world. ;D
Should have waited til I got an answer on the hooks problem, none of the support people are online right now. Sometimes you have a day where nothing works.
Quote from: Sir Osis of Liver on March 07, 2025, 11:10:45 PMShould have waited til I got an answer on the hooks problem, none of the support people are online right now. Sometimes you have a day where nothing works.
We're all excitable boys.
There I was when all of a sudden. ;)
Soooo...can you remove the repair settings file?
I'm not sure where it is.
Ok, at what point did you make that database backup?
March 8 GMT 12:12 am
Looks like it's running fine. I had tried installing ehportal (https://web-develop.ca/index.php?action=downloads;area=stable_eh_portal) before the wheels came off, it was ported from SP and should inherit SP settings, but it crashed the forum. Installs fine on 2.1.4 test install.
Just installed it on a different 2.1.4 test forum, you can see it here (https://www.thekrashsite.com/smf21/).
Yup The backup seemed to fix it
Take a look at ehportal at the link I just posted.
I'm beat, going offline. Won't be back on til tomorrow late.
Quote from: ducpainter on March 07, 2025, 11:14:23 PMSoooo...can you remove the repair settings file?
I'm not sure where it is.
It's best, security wise to always remove the aforementioned file immediately after it has been used.
It can be removed by running repair_settings, button at bottom, if you can't find the file.
Something didn't go right with this upgrade, but don't have access to the database. Would really like to see what's in there.
Repair_settings at the bottom of what?
Can you work with an sql dump?
I removed repair_settings couple days ago. Would like to have a look at your 1,1.21 database as it was when I ran the upgrade. If you have no objection, upload it to a temp directory in /httpdocs. There's some concern here that the database is damaged. Forum is running clean, not logging any errors, but the upgrade didn't run correctly, and there's an obvious problem with portals.
Lemme see if I can figure that out.
I'll get back to you.
httpdocs/Temp
Let me know if that's what you wanted.
Sorry...that's the 2.1.4 database.
Give me a minute.
Look now.
Quote from: Sir Osis of Liver on March 09, 2025, 10:50:28 PMI removed repair_settings couple days ago. Would like to have a look at your 1,1.21 database as it was when I ran the upgrade. If you have no objection, upload it to a temp directory in /httpdocs. There's some concern here that the database is damaged. Forum is running clean, not logging any errors, but the upgrade didn't run correctly, and there's an obvious problem with portals.
Wondering if the portal issue is related to the tp references in themes?
Not on my computer, will have a look tomorrow. Portal files are ignored if the mod isn't installed. Something's not right in the database.
Quote from: Sir Osis of Liver on March 09, 2025, 10:50:28 PMThere's some concern here that the database is damaged. Forum is running clean, not logging any errors
That doesn't make sense at all to me. If the database would have been damaged, then it would have been impossible for the upgrade to have been completed in the first place, let alone running clean afterwards.
Quote from: Sir Osis of Liver on March 09, 2025, 10:50:28 PM, but the upgrade didn't run correctly
Was the aforementioned missing table the only error that you got with the upgrade?
There were two missing table errors, upgrader was looking for two 1.0 tables that don't exist in 1.1 or later. Kicking that around with shawn here (https://www.simplemachines.org/community/index.php?topic=591159.0). Upgrade completed but attachments and avatars were a mess, and we're now unable to install a portal. The forum's on a GoDaddy vps, server is slow, database is large, and we've since had a 504 gateway timeout running a routine maintenance task.
Quote from: ducpainter on March 09, 2025, 11:09:31 PMLook now.
Is the 2 gig backup the files and database of 1.1.21 install that we upgraded? Anything else in there besides the forum?
Quote from: Sir Osis of Liver on March 10, 2025, 01:16:12 PMQuote from: ducpainter on March 09, 2025, 11:09:31 PMLook now.
Is the 2 gig backup the files and database of 1.1.21 install that we upgraded? Anything else in there besides the forum?
Yes.
Shouldn't be.
.
D/ling the sql.zip now, will see if I can get it running in test install on my server.
That's the 2.1.4 database, I need the 1.1.21 db that was upgraded.
[bangshead] Uploading now.
FTP was being balky, so I uploaded via control panel.
It's 2.1 gig on my computer, and 1.9 in httpdocs/Temp?
Wow, what a mess. The 2.1.4 database has lots of crap in it. Had same problem disabling hooks, board index would not load, logging a lot of errors. Removed all hooks manually from settings table, and a lot of other junk, and it now loads normally. Was also able to install ehportal and it appears to have inherited at least some of the SP content. You can see it here (https://www.thekrashsite.com/ducati/). What I'd like to do is clean up the 1.1.21 database and upgrade it on my server to 2.1.4. The database you're currently running is pretty squirrelly, and I think you'll be playing whack-a-mole with it going forward if it isn't fixed.
Just want the 1.1.21 database, not the full backup.
Try that one.
Quote from: Sir Osis of Liver on March 10, 2025, 11:24:14 PMWow, what a mess. The 2.1.4 database has lots of crap in it. Had same problem disabling hooks, board index would not load, logging a lot of errors. Removed all hooks manually from settings table, and a lot of other junk, and it now loads normally. Was also able to install ehportal and it appears to have inherited at least some of the SP content. You can see it here (https://www.thekrashsite.com/ducati/). What I'd like to do is clean up the 1.1.21 database and upgrade it on my server to 2.1.4. The database you're currently running is pretty squirrelly, and I think you'll be playing whack-a-mole with it going forward if it isn't fixed.
What about content?
Don't think content is affected, the problems we're having on your production forum seem to be coming from settings. Have an idea, will try it on my clone.
Quote from: Sir Osis of Liver on March 11, 2025, 04:31:10 PMDon't think content is affected, the problems we're having on your production forum seem to be coming from settings. Have an idea, will try it on my clone.
That 1.1.21 database has been migrated probably 4 or 5 times. Who knows what evil lies in the hearts of godaddy. The only reason I stayed there was for Plesk, and php 5.4, and they lied about 5.4.
...and I really hope you can work with that file. It's my last hope.
Disclaimer: There are probably a number of reasons why this is a really bad idea, but can't think of any offhand. Don't believe I've ever seen this suggested in support, but it seems to workCleared up a number of problems with the 2.1.4 database last night by manually removing a lot of hook settings, unused mod settings, and a couple of settings I didn't recognize that apparently came from 1.1.9. That fixed the problem with board index not loading after disabling hooks, and was able to install portals with some difficulty. Package manager was reporting odd errors and looking for ftp access, but it did the installs at some point. Ran table diagnostics in phpmyadmin, everything came back OK.
Then I got the big idea. (https://thekrashsite.com/pics/idea.gif) What would happen if I replaced the settings table with a clean table from a 2.1.4 test install? This was the procedure -
- Uninstall all mods (only ehportal was installed)
- Run repair_settings (couldn't hurt)
- Rename smf_settings table to sav_settings (just in case)
- Import smf_settings from clean install
- Run repair_settings to fix paths.
It's running here (https://www.thekrashsite.com/ducati/index.php) in GreyedOut theme with EZPortal installed, your content should be intact except for attachments, haven't uploaded them to clone. You can login, see what works or not, don't change any settings.
Attachments don't work, it doesn't see them. There's also a problem with ezportal installing incorrectly. I'll have a look at the 1.1.21 database soon as I have time.
Not seeing 1.1.21 db in /Temp.
The 885 mb file isn't what you want? httpdocs/Temp/dmf_smf-_2025-03-05_12-56-03.sql
That should be it, d/ling it now. Attachments are trashed on clone and your production forum. The upgrade didn't handle them correctly, and forum reports no attachments. id_thumb and id_msg in attachments table are 0 for all attachments. Will see if I can get the 1.1.21 db running in a clone.
Keep in mind...we are separated by a common language. ;D
I'm assuming at this point that the 1.1.21 install was running normally before upgrade, and except for logging a lot of php 5.6 errors everything was working. I'll install it in php 5.4, if it's ok will have to see what's wrong with the database that messed up the upgrade. Should get to it tomorrow.
Looking forward to what you find.
Thanks again for all you're doing.
I have to admit, I'm not liking the portal you linked to. I'd really like to get closer to the look we had, with the ability to add mods without crashing stuff...and yeah...I get where you're coming from with the..."The database you're currently running is pretty squirrelly, and I think you'll be playing whack-a-mole with it going forward if it isn't fixed."
Carry on.
...and now it's throwing 504 errors...yay.
It's loading for me. 504 is a server error, gateway timeout. Not the first time it's happened. At some point you'll need to move to a better host.
I have the 1.1.21 database. smfVersion in settings is 1.1.6. Are you sure this is the database that was running in your forum when we ran upgrade?
It's the one I copied off the server. I didn't have any other databases on my computer.
Why do you ask?
Quote from: Sir Osis of Liver on March 12, 2025, 12:47:43 PMI have the 1.1.21 database. smfVersion in settings is 1.1.6. Are you sure this is the database that was running in your forum when we ran upgrade?
you have to remember this version does not get updated when you use the package manager to upgrade your install.
index.php displays 1.1.21. Have it running here (https://www.thekrashsite.com/ducati11/), css doesn't load, repair_settings doesn't fix it, tried old and new versions. Don't remember much about 1.1, there's no /Themes/default/css directory, css files are in /Themes/default. Path is correct. Will work on it tonight.
There were extensive handwritten mods to css for that theme, which IIRC was modified from the forum default. There's a css stylesheet in httpdocs?
It's a clean set of files, should be loading /default/style.css, it's called in index.template.php -
<link rel="stylesheet" type="text/css" href="', $settings['theme_url'], '/style.css?fin11" />
Path to default theme is correct, file is there. Will get back to it tonight.
OK
Just getting back to this. Bad news is, attachments table in your 1.1.21 database backup has same problem as upgraded database. All id_msg and id_thumb fields are set to 0 for 2400 attachments. If you don't have another backup, there's no way to recover the attachments. Do you have a 30 day backup utility running in your GoDaddy account?
No. I do daily backups and it only saves 3
Well, then you're screwed. There's no way to recover the attachments with what we have. The 1.1.21 database was damaged before upgrade, no idea how. You can ask GD support if they can recover an earlier database from server backups. Otherwise the 1.1.21 install seems to be running normally here (https://thekrashsite.com/ducati11/index.php), no errors. Paths were a mess, wasn't able to run repair_settings, fixed paths in db manually. Took a couple of hours dicking around to get it where it is now. You can login as admin and see if everything's working. You can post new attachments, but none of the old ones will be displayed. The rest of your content should be intact.
That's unfortunate...support, and godaddy, should never be used together.
I don't know what to do, and I don't even know what my options are. Do I even have any?
Quote from: ducpainter on March 13, 2025, 06:21:04 AMI don't know what to do, and I don't even know what my options are. Do I even have any?
Did your attachments work fine before you upgraded your forum? If they did, I find the following very strange:
Quote from: Sir Osis of Liver on March 12, 2025, 10:01:39 PMAll id_msg and id_thumb fields are set to 0 for 2400 attachments.
In that case your attachments shouldn't have worked at all. I know from experience that a damaged database would make the normal and error free functioning of a forum impossible, let alone let an upgrade be completed. And from what I've read in this topic your forum functioned error free before the upgrade.
Anyways, back your question if you have options, yes you do imo. This will require a revert back to your previous version and doing a proper upgrade. That would mean that you will loose whatever new content you had acquired from the time of the upgrade till now though.
As far as I know, other than php errors regrading the e modifier being deprecated...no errors, and the forum was behaving normally. Other than not being able to install some mods the upgraded forum isn't throwing errors.
I was having 504 errors, but that shouldn't be related to a damaged db?
There isn't all that much activity on the board these days so not much would be lost.
I need to think on this.
Quote from: Sir Osis of Liver on March 12, 2025, 11:50:44 PMWell, then you're screwed. There's no way to recover the attachments with what we have. The 1.1.21 database was damaged before upgrade, no idea how. You can ask GD support if they can recover an earlier database from server backups. Otherwise the 1.1.21 install seems to be running normally here (https://thekrashsite.com/ducati11/index.php), no errors. Paths were a mess, wasn't able to run repair_settings, fixed paths in db manually. Took a couple of hours dicking around to get it where it is now. You can login as admin and see if everything's working. You can post new attachments, but none of the old ones will be displayed. The rest of your content should be intact.
It looks like everything is OK.
I'm not sure I'm understanding what attachments you're referring to.
Are those attachments only stored in the db?
Quote from: ducpainter on March 13, 2025, 08:01:18 AMI was having 504 errors, but that shouldn't be related to a damaged db?
No, that's server related. It's no indication of a damaged database.
On a side note, I unmarked your topic from being solved so it can receive more attention.
Quote from: Sir Osis of Liver on March 12, 2025, 11:50:44 PMWell, then you're screwed. There's no way to recover the attachments with what we have. The 1.1.21 database was damaged before upgrade, no idea how. You can ask GD support if they can recover an earlier database from server backups. Otherwise the 1.1.21 install seems to be running normally here (https://thekrashsite.com/ducati11/index.php), no errors. Paths were a mess, wasn't able to run repair_settings, fixed paths in db manually. Took a couple of hours dicking around to get it where it is now. You can login as admin and see if everything's working. You can post new attachments, but none of the old ones will be displayed. The rest of your content should be intact.
After a second look the only thing I can see is smileys aren't displaying, but I think that's because we had a custom smiley set.
I have that file.
At 11;10 am I got an email about the site running on your server couldn't connect to the db.
Those are random server errors, shouldn't happen often.
Are old attachments being displayed on your production forum?
Quote from: Sir Osis of Liver on March 13, 2025, 04:47:39 PMThose are random server errors, shouldn't happen often.
Are old attachments being displayed on your production forum?
I'm not seeing anything that isn't being displayed, other than smileys, and there's some text issues with apostrophes, but I'm still not sure what you exactly mean by attachments.
Small words without too much technicality...please ;D
Looking at the 1.1.21 clone (https://thekrashsite.com/ducati11/) on my server, I'm uploading attachments and avatars that I dumped from your original install before running upgrade. Other than the theme and mods, content on the clone should be the same as on your original forum. Attachments are files (mostly images) that were attached to posts in reply editor, you should see a thumbnail below the post, if you click on it you see fullsize image.
I have to say...if I lose images I'm not too concerned.
What's weird is I have had the forum set to not allow any uploads from the beginning.
All the images have to be linked from somewhere on the web. We did host some images from certain posts, but they're not online any longer.
Not sure if that's pertinent, or not.
The 1.1.21 database had attachments disabled, I'd have to assume those 2400 attachments were from long ago, and you may have run maintenance task to remove them. Embedded images loading from external links are different, some load, others don't. There are a lot of Photobucket pics, those were made unavailable by Photobucket a few years ago, iirc.
The 1.1.21 clone is running normally, everthing I've checked is working - posts, PMs, registration, attachments, etc.. No errors are being logged. Cleaned up the database, it's now back to 41 core tables, and cleaned up settings table. Will run 2.1.4 upgrade now and see what happens.
Go for it bro.
Running now. I'm inclined to think that for some reason you ran attachment maintenance tasks, which removed all existing attachments. id_thumb and id_msg are just to neatly and thoroughly zeroed out for it to be a random glitch.
Quote from: Sir Osis of Liver on March 13, 2025, 05:58:19 PMRunning now. I'm inclined to think that for some reason you ran attachment maintenance tasks, which removed all existing attachments. id_thumb and id_msg are just to neatly and thoroughly zeroed out for it to be a random glitch.
I don't think I did that, but to be perfectly honest...
I have no clue what you just said.
Upgrade is complete, I've installed GreyedOut theme. Check if everything's working.
your server, or mine?
That's the clone on my server. Haven't done anything to your production install. Couldn't anyway, don't have access to database.
You'll have to decide on a portal to replace SimplePortal. These are available for 2.1 -
- EhPortal (https://web-develop.ca/index.php) - Ported from SP, this will be most similar. It's supported by Chen Zhen on his own support forum.
- ezPortal (https://custom.simplemachines.org/index.php?mod=1461) - supported here (https://www.simplemachines.org/community/index.php?topic=271882.0)
- TinyPortal (https://custom.simplemachines.org/index.php?mod=97) - supported here (https://www.simplemachines.org/community/index.php?topic=27642.0).
- Light Portal (https://custom.simplemachines.org/index.php?mod=4244) - supported here (https://www.simplemachines.org/community/index.php?topic=572393.0).
Can try them on clone, you have admin access.
Not so sure I want a portal.
We used Simple portal because it provided a better navigation than the breadcrumb system of SMF.
To be honest...I don't really want a 'front page' and I, personally, don't find the SMF breadcrumb system distasteful.
Can you make it say Ducati Monster Forum instead of Greyed Out?
Quote from: Sir Osis of Liver on March 13, 2025, 06:30:52 PMThat's the clone on my server. Haven't done anything to your production install. Couldn't anyway, don't have access to database.
I will fix that when it's time.
Following along in the thread with shawn...what's his issue with mariadb? Is SMF limited?
Quote from: ducpainter on March 13, 2025, 08:20:01 PMCan you make it say Ducati Monster Forum instead of Greyed Out?
The Greyed Out logo is an image (/Themes/GreyedOut/images/custom/logo.png) -
logo.png
If you remove it forum title wll be displayed (Admin > Server Settings) as it is now, or you can replace it with a custom image you can create in a graphics editor. You can play with the forum title formatting in index.css. Look for .header_logo_area h1.forumtitle.
Quote from: ducpainter on March 13, 2025, 08:38:18 PMFollowing along in the thread with shawn...what's his issue with mariadb? Is SMF limited?
The original upgrade on your GoDaddy vps running mysql failed with same errors, it was not because of mariadb. Shawn was able to replicate the error in mariadb but not mysql.
Quote from: Sir Osis of Liver on March 14, 2025, 01:08:39 PMQuote from: ducpainter on March 13, 2025, 08:38:18 PMFollowing along in the thread with shawn...what's his issue with mariadb? Is SMF limited?
The original upgrade on your GoDaddy vps running mysql failed with same errors, it was not because of mariadb. Shawn was able to replicate the error in mariadb but not mysql.
Where does that put us...back to the db errors?
The upgrade errors do not affect the forum and are easy to get around. For reasons unknown the upgrader looks for two 1.0 tables that don't exist in 1.1, the correct tables are already in 1.1, so they don't need to be renamed. Upgrade runs fine when the to RENAMEs are edited out.
Quote from: Sir Osis of Liver on March 14, 2025, 01:20:58 PMFor reasons unknown the upgrader looks for two 1.0 tables that don't exist in 1.1, the correct tables are already in 1.1, so they don't need to be renamed. Upgrade runs fine when the to RENAMEs are edited out.
A clarification... The reasons are known & are explained in the other thread. That's the 1.0 to 1.1 script, that is normally rerun at that start of an upgrade from 1.1 to any subsequent release, to ensure you're starting from a valid 1.1 starting point. This is normally not a problem, since
the upgrader is designed to allow reruns; it traps the rename error that is produced by MySQL & ignores it. The problem is that MariaDB is literally producing a different error; further, the error it produces is indistinguishable from a real error, so it cannot be ignored.
The issue cannot be independently reproduced in MySQL - I have run many 1.1 upgrades with the exact same scripts, with many versions of MySQL and PHP.
It's a definite issue with MariaDB 1.1 upgrades.
In the past, we've seen lots of MariaDB upgrader errors, but normally, once you get past the upgrade, it generally works OK-ish.
MariaDB has some syntax quirks we run across occasionally. They are usually fixed when encountered, e.g.:
https://github.com/SimpleMachines/SMF/pull/8192
https://github.com/SimpleMachines/SMF/pull/7658
https://github.com/SimpleMachines/SMF/pull/6319
https://github.com/SimpleMachines/SMF/pull/6096
I.e., there is no guarantee you won't find some additional MariaDB errors.
Have we figured out why the ezportal 'controls' don't show in the admin cp?
I also installed the curve color changer and can't figure out how to access it.
I've installed ezportal on clone, it installs correctly, there's an ezportal link in ACP to access portal config. Curve color changer is intended for use with Curve2, may or may not work in custom themes. You can change colors by editing css manually.
Curve color changer does not work in Greyed Out theme.
Quote from: Sir Osis of Liver on March 14, 2025, 01:05:31 PMQuote from: ducpainter on March 13, 2025, 08:20:01 PMCan you make it say Ducati Monster Forum instead of Greyed Out?
If you remove it forum title wll be displayed (Admin > Server Settings) as it is now, or you can replace it with a custom image you can create in a graphics editor.
Removing it from httpdocs/themes/greyed out/images/custom doesn't work. Still says Greyed out.
I can't find it anywhere else.
Quote from: Sir Osis of Liver on March 14, 2025, 08:59:18 PMCurve color changer does not work in Greyed Out theme.
I understand that, but it's more likely I don't know how. Maybe I was expecting something not code based.
Ok, the upgrade on your GoDaddy vps is borked, the original database was a mess. I cleaned it up and it upgraded successfully and is running fine on my server. There are two things we can do to get your production forum properly upgraded:
- I can upload the cleaned up 1.1.21 database to your server, you can import it into your production database, and we can run the upgrade again on your server. I expect to get the same errors, but they are easily fixed and upgrade should be successful.
- The alternative is I can upload the upgraded 2.1.4 database from the clone to your server, you can import it into the 2.1.4 production install, run repair_settings, upload clean files, and you should be same as the clone, which is fine. I would like to run the upgrade again on your server just out of curiosity, but it's not necessary.
I installed curve color changer in clone, it doesn't work in Greyed Out. If you don't like the theme, find a different one that's closer to what you want, there are plenty to choose from.
Forum title is displaying correctly on prod forum.
pm incoming
Thanks to Sir Osis of Liver for all his help, as well as Doug Heffernan.