Cannot install mods

[Doug Heffernan]

@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.

The 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.

[Arantor]

Personally 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.

[hustreamload]

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?

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?

Code Select Expand

SELECT value FROM smf_settings WHERE variable = 'smfVersion';

Hello, here is the result:

[hustreamload]

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

Code (find) Select Expand

    // This is the error message...
    $query_error = mysqli_error($connection);


Code (replace) Select Expand

    // 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"

[Doug Heffernan]

Hello, here is the result:

Thank you. Nothing wrong with the upgrade.

but 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?

[hustreamload]

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.

[shawnb61]

What mod are you trying to install?

What happens when you execute this query in the SQL tab in phpmyadmin?

Code Select Expand

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

[hustreamload]

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:

[hustreamload]

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.

[Kindred]

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.

[hustreamload]

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!

[shawnb61]

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?

[shawnb61]

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?

[hustreamload]

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?

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