Hello, after upgrading from 2.0.19 to 2.1.1 I cannot install any package or theme. Php version is 8.0. We are on shared server. Error msg: "This page is not working now. HTTP ERROR 500". Any idea how to solve it?
Quote from: hustreamload on April 09, 2022, 09:53:26 AMHello, after upgrading from 2.0.19 to 2.1.1 I cannot install any package or theme. Php version is 8.0. We are on shared server. Error msg: "This page is not working now. HTTP ERROR 500". Any idea how to solve it?
That error usually indicates a server problem. Who is your host?
Can you downgrade php to 7.4., give it another try to install mods and see how it will go?
A HTTP 500 is a server side error, and should always be logged in the server error log.
The log should include further information, so if you have access to the log you should see what exactly gets logged when that error comes up.
Quote from: Aleksi on April 09, 2022, 10:06:16 AMA HTTP 500 is a server side error, and should always be logged in the server error log.
The log should include further information, so if you have access to the log you should see what exactly gets logged when that error comes up.
hello, the server does not show any error:
(https://images2.imgbox.com/bf/8e/NXG7X7co_o.jpg) (https://imgbox.com/NXG7X7co)
Quote from: Doug Heffernan on April 09, 2022, 10:05:00 AMThat error usually indicates a server problem. Who is your host?
Can you downgrade php to 7.4., give it another try to install mods and see how it will go?
Hello, I've switched back the server to php7.4:
(https://images2.imgbox.com/62/2f/hms1BNZh_o.jpg) (http://"http://"https://imgbox.com/hms1BNZh"")
The error msg has been changed:
array(14) {
- => array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(590) ["function"]=> string(9) "log_error" } [1]=> array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(494) ["function"]=> string(12) "smf_db_error" } [2]=> array(3) { ["file"]=> string(45) "/home/strea334/public_html/Sources/Errors.php" ["line"]=> int(138) ["function"]=> string(12) "smf_db_query" } [3]=> array(3) { ["file"]=> string(45) "/home/strea334/public_html/Sources/Errors.php" ["line"]=> int(298) ["function"]=> string(9) "log_error" } [4]=> array(1) { ["function"]=> string(17) "smf_error_handler" } [5]=> array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(1027) ["function"]=> string(22) "mysqli_stmt_bind_param" } [6]=> array(3) { ["file"]=> string(45) "/home/strea334/public_html/Sources/Errors.php" ["line"]=> int(129) ["function"]=> string(19) "smf_db_error_insert" } [7]=> array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(590) ["function"]=> string(9) "log_error" } [8]=> array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(494) ["function"]=> string(12) "smf_db_error" } [9]=> array(3) { ["file"]=> string(47) "/home/strea334/public_html/Sources/Packages.php" ["line"]=> int(928) ["function"]=> string(12) "smf_db_query" } [10]=> array(3) { ["file"]=> string(43) "/home/strea334/public_html/Sources/Subs.php" ["line"]=> int(6001) ["function"]=> string(14) "PackageInstall" } [11]=> array(3) { ["file"]=> string(47) "/home/strea334/public_html/Sources/Packages.php" ["line"]=> int(91) ["function"]=> string(11) "call_helper" } [12]=> array(3) { ["file"]=> string(44) "/home/strea334/public_html/Sources/Admin.php" ["line"]=> int(499) ["function"]=> string(8) "Packages" } [13]=> array(3) { ["file"]=> string(36) "/home/strea334/public_html/index.php" ["line"]=> int(187) ["function"]=> string(9) "AdminMain" } } Error loop.
Out host is hosting24.com
Can you clear the error log and try to install a mod again and post here the error that will be logged in at the error log page, but please post it inside the code tags. i.e:
error code here
You mentioned that you upgraded to 2.1.1. from 2.0.19. Can you please tell us how did you upgrade your forum? Did you actually run the upgrade.php file?
The process was the following: through the file manager I uploaded the upgrade zip-file, extracted there, and then run upgrade.php. As this error apperaed after the installation I have repeated the whole process an hour later, but the result was the same.
Where can I find the error log? In the DB? Or you think of the server side...because the server's error log is empty, as I mentioned it
Quote from: hustreamload on April 09, 2022, 01:01:12 PMThe process was the following: through the file manager I uploaded the upgrade zip-file, extracted there, and then run upgrade.php.
Did you just extracted it there somewhere randomly, or did you overwrite your forum files with those from the large upgrade 2.1.1. package?
Quote from: hustreamload on April 09, 2022, 01:03:20 PMWhere can I find the error log? In the DB? Or you think of the server side...because the server's error log is empty, as I mentioned it
If the error on the server side is empty, have a look at the error log in your forum 's Admin Panel and see if any error has been logged in there.
If you get a 500 error, and it's not logged somewhere you can see - then I would suggest you ask your host about that. 500 errors really should be logged, and are usually useful in pinpointing issues.
I have deleted all earlier error log of the forum in the forum admin panel. Then I tried to install the Tinyportal , the result was the same:
"array(14) {
- => array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(590) ["function"]=> string(9) "log_error" } [1]=> array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(494) ["function"]=> string(12) "smf_db_error" } [2]=> array(3) { ["file"]=> string(45) "/home/strea334/public_html/Sources/Errors.php" ["line"]=> int(138) ["function"]=> string(12) "smf_db_query" } [3]=> array(3) { ["file"]=> string(45) "/home/strea334/public_html/Sources/Errors.php" ["line"]=> int(298) ["function"]=> string(9) "log_error" } [4]=> array(1) { ["function"]=> string(17) "smf_error_handler" } [5]=> array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(1027) ["function"]=> string(22) "mysqli_stmt_bind_param" } [6]=> array(3) { ["file"]=> string(45) "/home/strea334/public_html/Sources/Errors.php" ["line"]=> int(129) ["function"]=> string(19) "smf_db_error_insert" } [7]=> array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(590) ["function"]=> string(9) "log_error" } [8]=> array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(494) ["function"]=> string(12) "smf_db_error" } [9]=> array(3) { ["file"]=> string(47) "/home/strea334/public_html/Sources/Packages.php" ["line"]=> int(928) ["function"]=> string(12) "smf_db_query" } [10]=> array(3) { ["file"]=> string(43) "/home/strea334/public_html/Sources/Subs.php" ["line"]=> int(6001) ["function"]=> string(14) "PackageInstall" } [11]=> array(3) { ["file"]=> string(47) "/home/strea334/public_html/Sources/Packages.php" ["line"]=> int(91) ["function"]=> string(11) "call_helper" } [12]=> array(3) { ["file"]=> string(44) "/home/strea334/public_html/Sources/Admin.php" ["line"]=> int(499) ["function"]=> string(8) "Packages" } [13]=> array(3) { ["file"]=> string(36) "/home/strea334/public_html/index.php" ["line"]=> int(187) ["function"]=> string(9) "AdminMain" } } Error loop."
The server side error log is still empty.
The error log in the forum is more than interesting:
(https://images2.imgbox.com/31/cc/QqHFtFnO_o.jpg) (https://imgbox.com/QqHFtFnO)
I'm not flori, he is another, normal user.
The Backtrace information is following:
(https://images2.imgbox.com/7a/83/ZePwKK97_o.jpg) (https://imgbox.com/ZePwKK97)
Some translation from Hungarian: A hiba típusa = Type of the error; Hibaüzenet= Error message; A hibát okozó oldal címe= The address of the page causing the error
Thanks for your help.
So it's trying a database query to see if the package is installed and the query fails, then it tries to log that the query failed, and fails again - hence error loop.
Do you have an smf_log_packages table and what columns are in it?
smf_log_packages in pdf are attched
+ forum maintenance has not found any error....
$packagesdir = do you have this line in your Settings.php file? if so does it have a value path listed that is found on your server? does the folder actually exist there?
Regarding the error about the path to the attachment directory being incorrect, can you download and run the repair_settings.php tool?
What is repair_settings.php? (https://wiki.simplemachines.org/smf/Repair_settings.php)
That should fix it.
Quote from: Illori on April 09, 2022, 03:52:19 PM$packagesdir = do you have this line in your Settings.php file? if so does it have a value path listed that is found on your server? does the folder actually exist there?
Yes, the value is:
$packagesdir = '/home/strea334/public_html/Packages';
and this is its content on server:
(https://images2.imgbox.com/fc/ba/V3HQxuuS_o.jpg) (https://imgbox.com/V3HQxuuS)
as you see, incl. Tinyportal2.2.1, which cannot be installed (nor any other mod)
The error message after trying to install any mod:
array(14) {
- => array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(590) ["function"]=> string(9) "log_error" } [1]=> array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(494) ["function"]=> string(12) "smf_db_error" } [2]=> array(3) { ["file"]=> string(45) "/home/strea334/public_html/Sources/Errors.php" ["line"]=> int(138) ["function"]=> string(12) "smf_db_query" } [3]=> array(3) { ["file"]=> string(45) "/home/strea334/public_html/Sources/Errors.php" ["line"]=> int(298) ["function"]=> string(9) "log_error" } [4]=> array(1) { ["function"]=> string(17) "smf_error_handler" } [5]=> array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(1027) ["function"]=> string(22) "mysqli_stmt_bind_param" } [6]=> array(3) { ["file"]=> string(45) "/home/strea334/public_html/Sources/Errors.php" ["line"]=> int(129) ["function"]=> string(19) "smf_db_error_insert" } [7]=> array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(590) ["function"]=> string(9) "log_error" } [8]=> array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(494) ["function"]=> string(12) "smf_db_error" } [9]=> array(3) { ["file"]=> string(47) "/home/strea334/public_html/Sources/Packages.php" ["line"]=> int(928) ["function"]=> string(12) "smf_db_query" } [10]=> array(3) { ["file"]=> string(43) "/home/strea334/public_html/Sources/Subs.php" ["line"]=> int(6001) ["function"]=> string(14) "PackageInstall" } [11]=> array(3) { ["file"]=> string(47) "/home/strea334/public_html/Sources/Packages.php" ["line"]=> int(91) ["function"]=> string(11) "call_helper" } [12]=> array(3) { ["file"]=> string(44) "/home/strea334/public_html/Sources/Admin.php" ["line"]=> int(499) ["function"]=> string(8) "Packages" } [13]=> array(3) { ["file"]=> string(36) "/home/strea334/public_html/index.php" ["line"]=> int(187) ["function"]=> string(9) "AdminMain" } } Error loop.
There is no error log about this!
Is there any interesting in this msg?
Quote from: Doug Heffernan on April 09, 2022, 03:56:35 PMRegarding the error about the path to the attachment directory being incorrect, can you download and run the repair_settings.php tool?
What is repair_settings.php? (https://wiki.simplemachines.org/smf/Repair_settings.php)
That should fix it.
I have fixed the attachment directory path, but the error remains
Try this for testing.
Hello, thanks, but this option was always on...
Another topic: there are no more errors in connection with the attachment directory
It is strange, but I can install new themes, but no mods, however the method seems to be the same...
I have reinstalled the forum from zero, but the error remained the same. Any idea what to change in DB?
You are trying to run vanilla 2.1.1 now? No mods? If so...
You had a LOT of old mod activity recorded in 2.0... I have no idea what might cause this, but I do know that you don't need all of that old 2.0 history.
I would:
- Ensure you have backups...
- Truncate the log_packages table
- empty the packages folder except for index.php & .htaccess
This would wipe out all package history, enabling you to start from a clean slate.
If *this* still fails, I'd look closer at the DB structure of log_packages to ensure it's correct.
Quote from: shawnb61 on April 10, 2022, 03:30:37 AMYou are trying to run vanilla 2.1.1 now? No mods? If so...
You had a LOT of old mod activity recorded in 2.0... I have no idea what might cause this, but I do know that you don't need all of that old 2.0 history.
I would:
- Ensure you have backups...
- Truncate the log_packages table
- empty the packages folder except for index.php & .htaccess
This would wipe out all package history, enabling you to start from a clean slate.
Hello, thanks for the advice.
I have deleted the logs in log_packages table, and emptied the packages folder. But the error is still with us :'( :
array(14) {
- => array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(590) ["function"]=> string(9) "log_error" } [1]=> array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(494) ["function"]=> string(12) "smf_db_error" } [2]=> array(3) { ["file"]=> string(45) "/home/strea334/public_html/Sources/Errors.php" ["line"]=> int(138) ["function"]=> string(12) "smf_db_query" } [3]=> array(3) { ["file"]=> string(45) "/home/strea334/public_html/Sources/Errors.php" ["line"]=> int(298) ["function"]=> string(9) "log_error" } [4]=> array(1) { ["function"]=> string(17) "smf_error_handler" } [5]=> array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(1027) ["function"]=> string(22) "mysqli_stmt_bind_param" } [6]=> array(3) { ["file"]=> string(45) "/home/strea334/public_html/Sources/Errors.php" ["line"]=> int(129) ["function"]=> string(19) "smf_db_error_insert" } [7]=> array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(590) ["function"]=> string(9) "log_error" } [8]=> array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(494) ["function"]=> string(12) "smf_db_error" } [9]=> array(3) { ["file"]=> string(47) "/home/strea334/public_html/Sources/Packages.php" ["line"]=> int(928) ["function"]=> string(12) "smf_db_query" } [10]=> array(3) { ["file"]=> string(43) "/home/strea334/public_html/Sources/Subs.php" ["line"]=> int(6001) ["function"]=> string(14) "PackageInstall" } [11]=> array(3) { ["file"]=> string(47) "/home/strea334/public_html/Sources/Packages.php" ["line"]=> int(91) ["function"]=> string(11) "call_helper" } [12]=> array(3) { ["file"]=> string(44) "/home/strea334/public_html/Sources/Admin.php" ["line"]=> int(499) ["function"]=> string(8) "Packages" } [13]=> array(3) { ["file"]=> string(36) "/home/strea334/public_html/index.php" ["line"]=> int(187) ["function"]=> string(9) "AdminMain" } } Error loop.
Quote from: shawnb61 on April 10, 2022, 03:30:37 AM...
If *this* still fails, I'd look closer at the DB structure of log_packages to ensure it's correct.
What should I send for you?
The error is in the url or the way the test is made
the request looks like
/index.php?action=admin;area=packages;get;sa=download;server=1;package=17/mod=97;
and the php // To download something, we need a valid server or url.
if (empty($_GET['server']) && (!empty($_GET['get']) && !empty($_REQUEST['package'])))
fatal_lang_error('package_get_error_is_zero', false);
but the $_GET['server'] is not a request parameter, so this will always fail with it...
$_GET['server'] absolutely is a parameter here, because SMF parses the URL manually to split on ;. As it has for the last 18 years. It's also not relevant.
The backtrace is the same as before, it points to the query where SMF looks up if the mod is already installed or not and then fails - and then fails upon trying to log this fact.
Next step is to look at the *structure* of the smf_log_packages table rather than the content... sadly I didn't notice this topic after the OP had posted the *content*, otherwise I'd have said something sooner.
Quote from: Arantor on April 10, 2022, 09:00:59 AM$_GET['server'] absolutely is a parameter here, because SMF parses the URL manually to split on ;. As it has for the last 18 years. It's also not relevant.
The backtrace is the same as before, it points to the query where SMF looks up if the mod is already installed or not and then fails - and then fails upon trying to log this fact.
Next step is to look at the *structure* of the smf_log_packages table rather than the content... sadly I didn't notice this topic after the OP had posted the *content*, otherwise I'd have said something sooner.
I have 2-3 days old backup, so if you need something that I have already deleted or changed (like log-packages table), I can send you. I'm only a "normal" user, so pls explain me step by step, what to do
In phpMyAdmin, go to the smf_log_packages table, go to the structure tab and post a screenshot of what that says - then we can compare the table structure to what it should be, maybe that's the problem.
Here you are:
(https://images2.imgbox.com/3e/f6/6B3ttKkb_o.jpg) (https://imgbox.com/6B3ttKkb)
I have never used the mod source inside the forum, I download everything from here, the SMForum.
I have deleted all earlier packages, and uploaded only 3: 2 portals (Tiny + EzPortal), + another type (Stop Forum Spam). After that I tried to install each of them, but the result was the same. I have asked my admin partner, but he got the same as well
I tried to go back to 2.0.19 with full install, but there are problems with my password (however it remained the same), then with the db, so I stopped the installation. The forum is working properly now, but is not comfortable, there is no portal, no chat, nor smileys....What do you recommend? Should I delete everytjhing from public.html, the whole DB, and try to make a full install from the last backup on basis 2.0.19?
Quote from: hustreamload on April 10, 2022, 11:57:53 AMI tried to go back to 2.0.19 with full install, but there are problems with my password (however it remained the same), then with the db, so I stopped the installation. The forum is working properly now, but is not comfortable, there is no portal, no chat, nor smileys....What do you recommend? Should I delete everytjhing from public.html, the whole DB, and try to make a full install from the last backup on basis 2.0.19?
How did you try to go back to 2.0.19 with full install? Did you overwrite the files only? If that was the case, then that will explain any database problems because I do not see any mention of reverting back the database as well.
The lack of mods can be explained that when you overwrote your forum files when you tried to downgrade to 2.0.19, they were all automatically uninstalled.
At this point I would hold on deleting the forum and doing a re install if I were you.
P.s. Can you run this query and post back the results?
SELECT value FROM smf_settings WHERE variable = 'smfVersion';
See, I wouldn't be doing any of this rolling back stuff, I'd be adding more debugging statements around 928 of Packages.php to see what database query it is that's breaking and what the actual MySQL error was that dies when trying to insert it into the database.
I wonder if the fact it's not English is part of the problem.
Quote from: Doug Heffernan on April 10, 2022, 12:09:18 PMQuote from: hustreamload on April 10, 2022, 11:57:53 AMI tried to go back to 2.0.19 with full install, but there are problems with my password (however it remained the same), then with the db, so I stopped the installation. The forum is working properly now, but is not comfortable, there is no portal, no chat, nor smileys....What do you recommend? Should I delete everytjhing from public.html, the whole DB, and try to make a full install from the last backup on basis 2.0.19?
How did you try to go back to 2.0.19 with full install? Did you overwrite the files only? If that was the case, then that will explain any database problems because I do not see any mention of reverting back the database as well.
The lack of mods can be explained that when you overwrote your forum files when you tried to downgrade to 2.0.19, they were all automatically uninstalled.
At this point I would hold on deleting the forum and doing a re install if I were you.
P.s. Can you run this query and post back the results?
SELECT value FROM smf_settings WHERE variable = 'smfVersion';
Thanks, if we could go further with 2.1.1 is our goal as well, and I see, that the forum is working. Earlier there was no problem when we stepped back 1-2 versions in case of problems with the new versions, so I tried the reinstall of 2.0.19 only with overwriting the files...as yo wrote.
But the problem with installation of mods appeared earlier, when I have upgraded the forum....and remained the same. And installation of 2.0.19 was intterupted at the beginning, after that I made a succesful full install of 2.1.1. But the error remained the same.
Quote from: Arantor on April 10, 2022, 12:27:03 PMSee, I wouldn't be doing any of this rolling back stuff, I'd be adding more debugging statements around 928 of Packages.php to see what database query it is that's breaking and what the actual MySQL error was that dies when trying to insert it into the database.
I wonder if the fact it's not English is part of the problem.
If you recommend I can try a full install in English, however since 15 years teher was no problem with the language
Quote from: hustreamload on April 10, 2022, 12:31:13 PMso I tried the reinstall of 2.0.19 only with overwriting the files...as yo wrote.
There are big changes between the 2.0.19 and 2.1.x versions. Reuploading back only the files is not enough to roll back. A backup copy of the database made from before the upgrade should be restored too.
My thoughts are that maybe the upgrade was not done properly/thoroughly. Can you please run the sql query I posted above and let us know the reslut?
I don't think the problem is SMF's language but I think the query fails for some reason (which isn't clear) and the message that comes back from MySQL can't be inserted for some reason.
In fact let's do the simplest possible thing - get back to 2.1.1 and establish that it is generally working (you can login, you can post).
Then edit Subs-Db-mysql.php
// This is the error message...
$query_error = mysqli_error($connection);
// This is the error message...
$query_error = mysqli_error($connection);
die($query_error);
It's not elegant, it's very temporary but what will happen is that when you try to install a package, whatever it was getting deeply hung up on will be output.
@Doug Heffernan the database had 2.1 columns inside smf_log_packages; verifying the smfVersion doesn't help you with that. And, if you look at the backtrace, the fatalling error was a SELECT against smf_log_packages where the columns being queried do in fact exist and the schema looks good against a known-working SMF 2.1.1.
Quote from: Arantor on April 10, 2022, 12:43:17 PM@Doug Heffernan the database had 2.1 columns inside smf_log_packages; verifying the smfVersion doesn't help you with that. And, if you look at the backtrace, the fatalling error was a SELECT against smf_log_packages where the columns being queried do in fact exist and the schema looks good against a known-working SMF 2.1.1.
Be that as it may, I remember vaguely another topic here a while back where the user issues were due to the 2.1. upgrade not being done properly. And the OP here had this to say when I asked about how they did the upgrade.
Quote from: hustreamload on April 09, 2022, 01:01:12 PMThe process was the following: through the file manager I uploaded the upgrade zip-file, extracted there,
And now they tried to roll back by uploading the files only. Personally I think it does not harm to get a confirmation on the status of database. Just an idea.
Quote from: Doug Heffernan on April 10, 2022, 12:50:32 PMPersonally I think it does not harm to get a confirmation on the status of database. Just an idea.
smfVersion is no confirmation of anything. The only thing you can actually trust is looking at the actual schema, which we did previously for the table that we know is relevant.
Quote from: Doug Heffernan on April 10, 2022, 12:09:18 PMQuote from: hustreamload on April 10, 2022, 11:57:53 AMI tried to go back to 2.0.19 with full install, but there are problems with my password (however it remained the same), then with the db, so I stopped the installation. The forum is working properly now, but is not comfortable, there is no portal, no chat, nor smileys....What do you recommend? Should I delete everytjhing from public.html, the whole DB, and try to make a full install from the last backup on basis 2.0.19?
How did you try to go back to 2.0.19 with full install? Did you overwrite the files only? If that was the case, then that will explain any database problems because I do not see any mention of reverting back the database as well.
The lack of mods can be explained that when you overwrote your forum files when you tried to downgrade to 2.0.19, they were all automatically uninstalled.
At this point I would hold on deleting the forum and doing a re install if I were you.
P.s. Can you run this query and post back the results?
SELECT value FROM smf_settings WHERE variable = 'smfVersion';
Hello, here is the result:
(https://images2.imgbox.com/fc/45/JbyKAqiX_o.jpg) (https://imgbox.com/JbyKAqiX)
Quote from: Arantor on April 10, 2022, 12:43:17 PMI don't think the problem is SMF's language but I think the query fails for some reason (which isn't clear) and the message that comes back from MySQL can't be inserted for some reason.
In fact let's do the simplest possible thing - get back to 2.1.1 and establish that it is generally working (you can login, you can post).
Then edit Subs-Db-mysql.php
// This is the error message...
$query_error = mysqli_error($connection);
// This is the error message...
$query_error = mysqli_error($connection);
die($query_error);
It's not elegant, it's very temporary but what will happen is that when you try to install a package, whatever it was getting deeply hung up on will be output.
@Doug Heffernan the database had 2.1 columns inside smf_log_packages; verifying the smfVersion doesn't help you with that. And, if you look at the backtrace, the fatalling error was a SELECT against smf_log_packages where the columns being queried do in fact exist and the schema looks good against a known-working SMF 2.1.1.
hello, I have replaced the code, as you suggested. The installation is again unsuccessful, but the error message has been changed: "MySQL server has gone away"
Quote from: hustreamload on April 10, 2022, 05:00:48 PMHello, here is the result:
Thank you. Nothing wrong with the upgrade.
Quote from: hustreamload on April 10, 2022, 05:12:58 PMbut the error message has been changed: "MySQL server has gone away"
This error inidicates that this is server related. It looks like the server timed out and closed the connection when you are trying to install a mod.
Are you on a shared hosting or do you manage your own dedicated/vps box?
This is a shared server. But in the last 10 years we had not such probleme with them, last week with 2.0.19 all install process ran properly.
And "MySQL server has gone away" message appears only after that I edited Subs-Db-mysql.php on Arantor's suggestion. Before that error message was that:
"array(14) {[0]=> array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(590) ["function"]=> string(9) "log_error" } [1]=> array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(494) ["function"]=> string(12) "smf_db_error" } [2]=> array(3) { ["file"]=> string(45) "/home/strea334/public_html/Sources/Errors.php" ["line"]=> int(138) ["function"]=> string(12) "smf_db_query" } [3]=> array(3) { ["file"]=> string(45) "/home/strea334/public_html/Sources/Errors.php" ["line"]=> int(298) ["function"]=> string(9) "log_error" } [4]=> array(1) { ["function"]=> string(17) "smf_error_handler" } [5]=> array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(1027) ["function"]=> string(22) "mysqli_stmt_bind_param" } [6]=> array(3) { ["file"]=> string(45) "/home/strea334/public_html/Sources/Errors.php" ["line"]=> int(129) ["function"]=> string(19) "smf_db_error_insert" } [7]=> array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(590) ["function"]=> string(9) "log_error" } [8]=> array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(494) ["function"]=> string(12) "smf_db_error" } [9]=> array(3) { ["file"]=> string(47) "/home/strea334/public_html/Sources/Packages.php" ["line"]=> int(928) ["function"]=> string(12) "smf_db_query" } [10]=> array(3) { ["file"]=> string(43) "/home/strea334/public_html/Sources/Subs.php" ["line"]=> int(6001) ["function"]=> string(14) "PackageInstall" } [11]=> array(3) { ["file"]=> string(47) "/home/strea334/public_html/Sources/Packages.php" ["line"]=> int(91) ["function"]=> string(11) "call_helper" } [12]=> array(3) { ["file"]=> string(44) "/home/strea334/public_html/Sources/Admin.php" ["line"]=> int(499) ["function"]=> string(8 ) "Packages" } [13]=> array(3) { ["file"]=> string(36) "/home/strea334/public_html/index.php" ["line"]=> int(187) ["function"]=> string(9) "AdminMain" } } Error loop."
It is strange, that other admin functions are working, incl. theme installation.
What mod are you trying to install?
What happens when you execute this query in the SQL tab in phpmyadmin?
SELECT version, themes_installed, db_changes
FROM smf_log_packages
WHERE package_id = 'vbgamer45:autoembedmediapro'
AND install_state != 0
ORDER BY time_installed DESC
LIMIT 1
Hello, the error is independent from the mod: there are 2 portals and 2 other mods uploaded (TinyPortal 2.2.1 ,Stop Forum Spam 1.1, Simple Audio Video Embedder 6.0.6, EzPortal), each of them results the same error. (Tinyportal was the first, when it failed, I tried another portal to know, if tinyportal mod caused the failure. Then I tried more simple mods, but all of them failed)
On your SQL query the answer:
(https://images2.imgbox.com/12/88/EJ9pOBXU_o.jpg) (http://"https://imgbox.com/EJ9pOBXU")
Hello, I have renamed my upgraded DB, then uploaded the last backup of the old 2.0.19 DB, then deleted the files in public html, and reinstalled SMF 2.0.19. Thanks guys, but 2.1.1 coludn't run properly, without mods I dont want to go further.
The only question, how to import from the 2.1.1 DB the new messages of the last 5 days to a 2.0.19 DB? I have exported messages, and wanted to import that ql, but it failed.
Plus info: I can not upgrade anymore to 2.1.1, because at the 4th or 5th step a blank screen appeared, couldn't step back, had to reinstall the old smf.
You can not... there is no path backwards that keeps new data.
2.1 runs fine on hundreds of systems at this point, both upgrades and new installations. Your failures with 2.1 mean that either you did something non-standard and damaging or your system is unique and has something very different about it that is causing 2.1 to fail.
I can't recreate your reported issue, after trying 3 differently set up servers.
Hello Kindred, it is clear, that it is our faiure. Minimum 5 of your team tried to help us, me and my team are very grateful for that, thanks a lot'
I just wanted to tell you, what happened, after I reinstalled my old forum, and tried the upgrading process once more.
BR, and thanks!
Were all attempts done using the default theme? If not, could you try that?
Were you using English as the language? If not, could you try that, too?
One last question... One theory is you can't do .zips for one reason or another...
Can you load a mod that has a .tgz format archive?
Note that Stop Forum Spam lets you choose between a .zip and a .tgz. Can you try the .tgz one?
Quote from: shawnb61 on April 11, 2022, 09:48:37 PMOne last question... One theory is you can't do .zips for one reason or another...
Can you load a mod that has a .tgz format archive?
Note that Stop Forum Spam lets you choose between a .zip and a .tgz. Can you try the .tgz one?
Hello shawnb61, as I wrote above (https://www.simplemachines.org/community/index.php?msg=4119829) I have already switched back the forum to 2.0.19, based on a relative fresh backup, because without mods I dindn't want to go further.
Thanks for your help, but so I cannot test the 2.1.1 forum.
BR
hustreamload