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:
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
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?
Are you using the current version 2.0.4? Php version?
Yes, SMF 2.1.4 and PHP 8.0
What is the content of
/home/ddcrewne/public_html/forum/Packages/temp/db_install.php
Line 238 ?
Quote from: Sir Osis of Liver on February 26, 2024, 07:43:30 PMAre you using the current version 2.0.4?
@Lucarella - That's the latest version of Shoutbox Pro.
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
db_install.php
Any idea on this problem? :-[
the issue is with the mod and not SMF you need to ask at:
https://www.smfhacks.com
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
Quote from: Lucarella on March 01, 2024, 05:15:31 PMI see that on the test sites everything is fine.
Does this mean
your test sites?
Yes, my test forums...
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.
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.
No, they are on different hosting
in that case - if everything else is the same between your test and production sites -- then the problem sits at the host
Quote from: Sir Osis of Liver on March 03, 2024, 12:14:55 PMYou should try uploading clean files to the production install and see if that fixes the problem.
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
you don't have to reconfigure anything. configurations are stored in the database
But he will lose the mods applied to the files, if he reuplods the original forum files, or?
Quote from: Kindred on March 05, 2024, 02:06:55 PMyou 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.
Hi guys, I'm writing to inform you that I finally managed to install the shoutbox.
To do this, however, I had to move the entire forum to another server (where I do my tests) and, after installing the shoutbox, bring everything back to the main server and everything works fine.
Thanks for your help
Thanks for letting us know. Your solution seems odd, though, at least to me. But hey, if it works for you ..... (https://i.imgur.com/LMFtZJF.png)
Well, the solution is indicative of the problem...
The live site server is misconfigured...
The solution is a work around, not a fix