Mod installation not working

[Lucarella]

Hi guys, I hope you can help me solve a very strange problem...
I have always used the SMFPacks Shoutbox Pro in forum 2.0 without any problems. Now with the transition to SMF 2.1.4 I can't install the mod and I always get the same error:

Code Select Expand

708df778485c68b2ee944b49305ce5f5
 https://dd-crew.net/forum/index.php?action=admin;area=packages;sa=install2;package=Shoutbox_v2-0-4.zip;pid=0
 /home/ddcrewne/public_html/forum/Packages/temp/db_install.php (Linea 238)

Errore del Database: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-crew' at line 3

Code Select Expand

Tipo di errore
Database
Messaggio di errore
Errore del Database: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-crew' at line 3
File
/home/ddcrewne/public_html/forum/Packages/temp/db_install.php
Linea
238
URL della pagina che ha causato l'errore
https://dd-crew.net/forum/index.php?action=admin;area=packages;sa=install2;package=Shoutbox_v2-0-4.zip;pid=0
Informazioni di backtrace
#0: smf_db_error()
Chiamata da /home/ddcrewne/public_html/forum/Sources/Subs-Db-mysql.php nella linea 494
#1: smf_db_query()
Chiamata da /home/ddcrewne/public_html/forum/Sources/DbPackages-mysql.php nella linea 840
#2: smf_db_list_indexes()
Chiamata da /home/ddcrewne/public_html/forum/Sources/DbPackages-mysql.php nella linea 564
#3: smf_db_add_index()
Chiamata da /home/ddcrewne/public_html/forum/Packages/temp/db_install.php nella linea 238
#4: require()
Chiamata da /home/ddcrewne/public_html/forum/Sources/Packages.php nella linea 1064
#5: PackageInstall()
Chiamata da /home/ddcrewne/public_html/forum/Sources/Subs.php nella linea 6051
#6: call_helper()
Chiamata da /home/ddcrewne/public_html/forum/Sources/Packages.php nella linea 91
#7: Packages()
Chiamata da /home/ddcrewne/public_html/forum/Sources/Admin.php nella linea 499
#8: AdminMain()
Chiamata da /home/ddcrewne/public_html/forum/index.php nella linea 184
I also tried with the default theme, but nothing, always the same thing.
Looking at the guilty files, it seems that everything is ok, at least that's what the creator of the mod said and not even he can give me a solution.

In your opinion, what could the problem be?

[Sir Osis of Liver]

Are you using the current version 2.0.4?  Php version?

[Lucarella]

Yes, SMF 2.1.4 and PHP 8.0

[grega]

What is the content of
/home/ddcrewne/public_html/forum/Packages/temp/db_install.php
Line  238 ?

[Steve]

Are you using the current version 2.0.4?

@Lucarella - That's the latest version of Shoutbox Pro.

[Lucarella]

Sorry, I understood SMF's version...
Yes, I use the latest version, which is 2.0.4
I also attach the db_install file, so you can understand better.

Thank you

You cannot view this attachment.

[Lucarella]

Any idea on this problem?

[Deaks]

the issue is with the mod and not SMF you need to ask at:

https://www.smfhacks.com

[Lucarella]

Yes, I know and in fact I asked there first, only that no one was able to help me.
However, I think the problem comes from both, I see that on the test sites everything is fine. Only in the main forum is it not good

[Steve]

I see that on the test sites everything is fine.

Does this mean your test sites?

[Lucarella]

Yes, my test forums...

[Steve]

That would mean your production then of course. This would be beyond my abilities (sorry) but perhaps one of the other team members will be able to help.

[Sir Osis of Liver]

If the production forum and test forum are on same server, and mod installs successfully on test forum, then there's nothing wrong with the server config or mod installer.  You should try uploading clean files to the production install and see if that fixes the problem.  If not you can restore it from backup.

[Lucarella]

No, they are on different hosting

[Kindred]

in that case - if everything else is the same between your test and production sites -- then the problem sits at the host

[Sir Osis of Liver]

You should try uploading clean files to the production install and see if that fixes the problem.

[Lucarella]

By doing this, will I lose all the mods I have already installed and will I have to reconfigure everything from the beginning?
I was actually thinking of doing a different procedure...
Put the forum under maintenance and create a backup and upload it to the hosting I use for testing.
Install the shoutbox, and if all goes well, download everything and upload to the main forum.

Could it work?

Thank you

[Kindred]

you don't have to reconfigure anything. configurations are stored in the database

[grega]

But he will lose the mods applied to the files, if he reuplods the original forum files, or?

[Sir Osis of Liver]

you don't have to reconfigure anything. configurations are stored in the database

Uploading clean files removes all mods and customizations but it doesn't remove mod content from the database, so when mods are reinstalled they'll inherit the previous configurations.  As long as OP has a complete backup before beginning he can always restore forum to its current state.