Show all posts by user
Modules are small packages that increase or change the functionality of Phorum in some way, without changing any of the main Phorum code.
Re: PHP 8.x - 1 year ago
Well, that's what I experienced after updating my server to PHP 8.0. If you can manage to have PHP errors shown (either directly on the requested web page of your Phorum installation, or e.g. in Server PHP log files), you will see many errors which show that the Phorum source code is kind of outdated and not PHP 8.0 ready. Unfortunately, there seems to be no Phorum developer who can engagby Ulf Dunkel - Phorum Support
Re: Fatal error in /include/db/mysql/mysqli.php - 1 year ago
Thanks for your honest and quick reply, Scott. I totally understand this. But I cannot go back to older PHP versions for several reasons. I'd be more than happy if you find some spare time to fix the PHP issues with PHP 8 (hopefully before PHP 9 is released). Best, Ulfby Ulf Dunkel - Phorum Support
Re: Fatal error in /include/db/mysql/mysqli.php - 1 year ago
Thank you, Scott. I checked everything with my phpmyadmin maintenance tools and it reports that all tables are fine so far. I guess I'm lost using PHORUM with PHP 8 as long as no developers are maintaining the PHORUM source code any longer.by Ulf Dunkel - Phorum Support
Re: Fatal error in /include/db/mysql/mysqli.php - 1 year ago
QuoteScott FineganTry rebuilding the tables using mysql maintenance utility. Where do I find the mentioned mysql maintenance utility, please?by Ulf Dunkel - Phorum Support
Phorum code should be fixed for newer versions of PHP - 1 year ago
Today I ran into an error which says "Array and string offset access syntax with curly braces is deprecated". I had to fix at least /include/upload_functions.php, line 107 from $last = strtolower($val{strlen($val)-1}); to $last = strtolower($val); I guess there's much more in the code to be fixed for newer PHP releases.by Ulf Dunkel - Phorum Support
Re: Fatal error in /include/db/mysql/mysqli.php - 1 year ago
Thank you for your detailed reply. I only have one 'hooks' row and the 'describe phorum_settings' command shows data as mentioned by you. So I guess my issue sticks somewhere else. What else could I try instead?by Ulf Dunkel - Phorum Support
Re: Fatal error in /include/db/mysql/mysqli.php - 2 years ago
I found a solution myself and like to share it with others: - Because I had no chance to access my Phorum's admin interface, I simply renamed the mods folder on my server to mods_OFF. That didn't help in the first place. Then I emptied the whole cache folder and voilà - the Phorum pages showed up properly again. Then I created a new mods folder and copied the mods one by one, cby Ulf Dunkel - Phorum Support
Re: Fatal error in /include/db/mysql/mysqli.php - 2 years ago
I have no idea how to disable used mods for the phorum as I cannot access any phorum pages on my browser right now. I have access to the MySQL database though. This is the whole error message: <!-- Fatal error: Uncaught mysqli_sql_exception: Duplicate entry `hooks´ for key `phorum_settings.PRIMARY´ in /phorum/include/db/mysql/mysqli.php:149 Stack trace: #0 /phorum/include/db/mysqlby Ulf Dunkel - Phorum Support
Fatal error in /include/db/mysql/mysqli.php - 2 years ago
Dear Phorum developers. I have moved one of my Phorum installations to a new place and now I always run into this error: <b>Fatal error</b>: Uncaught mysqli_sql_exception: Duplicate entry 'hooks' for key 'P5_iC_settings.PRIMARY' in /<myserver>/phorum/include/db/mysql/mysqli.php:149 mysqli.php, line 149, reads: $res = mysqli_query($conby Ulf Dunkel - Phorum Support
Re: Field 'recent_author' doesn't have a default value - 5 years ago
I now have tried successfully the following patch. /include/db/mysql.php 3108: {$PHORUM['groups_table']} AS PHORUM_groups, 3112: usergroup.group_id = PHORUM_groups.group_id AND 3113: PHORUM_groups.group_id = forumgroup.group_id AND 3299: $users[$perm[0]]['PHORUM_groups'][$perm[1]] = $perm[1]; /include/db/mysqli.php 1875: $sql = "SELECT DISTINCT user.user_by Ulf Dunkel - Phorum Support
Re: Field 'recent_author' doesn't have a default value - 5 years ago
Thank you for your quick reply, Scott. MySQL 8 is released since January 2021. I always thought it to be a good idea that developers are ahead, not behind. ;-)by Ulf Dunkel - Phorum Support
Re: Field 'recent_author' doesn't have a default value - 5 years ago
If I completely clear the sql_mode variable in my mysqld.cnf file (sql_mode = ''), I still get an error like this: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups, phorum_user_group_xref AS usergroup, pho' at line 4 (1064): SELECT DISTINCT uby Ulf Dunkel - Phorum Support
Re: Field 'recent_author' doesn't have a default value - 5 years ago
I still have no progress for fixing this issue because I really do not understand how I should have to set up my mysql settings. I now have set the SQL mode in /etc/mysql/conf.d/mysql.conf.d/mysqld.cnf to sql_mode = 'ONLY_FULL_GROUP_BY,NO_ENGINE_SUBSTITUTION' This gives the following result when I try to add a new Phorum message or reply: You have an error in your SQL syntax; cheby Ulf Dunkel - Phorum Support
Re: Field 'recent_author' doesn't have a default value - 5 years ago
I am able again to write new postings, but whenever I want to reply to a posting, I still get a similar error. When I retry to send my reply, I am informed that the same reply has already been sent. So I would like to know what do I have to change in my MySQL settings in order to no longer run into these conflicts, please.by Ulf Dunkel - Phorum Support
Re: Field 'recent_author' doesn't have a default value - 5 years ago
I have added sql_mode = 'ONLY_FULL_GROUP_BY,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO' to my mysqld.cnf file, thus removing the parameters STRICT_TRANS_TABLES + NO_ENGINE_SUBSTITUTION which were set before. Now creating new topics works for me again. Maybe it would be better to update the Phorum MySQL commands accordingly.by Ulf Dunkel - Phorum Support
Re: Field 'recent_author' doesn't have a default value - 5 years ago
Hi Scott, thank you for digging into this. What can I do myself to solve this problem?by Ulf Dunkel - Phorum Support
Field 'recent_author' doesn't have a default value - 5 years ago
Hi folks, I run Phorum 5.2.23 with mysql Ver 8.0.23 on Ubuntu 20.04.1 for Linux on x86_64 ((Ubuntu)). Since my last Server update, I frequently run into issues when creating new topics: Phorum Database Error Sorry, a Phorum database error occurred. Please try again later! Error: Field 'recent_author' doesn't have a default value (1364): INSERT INTO phorum_messages (foby Ulf Dunkel - Phorum Support
Re: MySQL Database issues after server upgrade (to PHP 7) - 9 years ago
Hi Scott, thank you for your question. I checked my last two backups. The column wasn't there. In another Phorum installation (on calamus.net), everything is fine.by Ulf Dunkel - Phorum Support
Re: MySQL Database issues after server upgrade (to PHP 7) - 9 years ago
Thank you for that listing, Oliver. My one looks like this: -- phpMyAdmin SQL Dump -- version 4.5.4.1deb2ubuntu2 -- -- -- Host: localhost -- Erstellungszeit: 25. Okt 2016 um 15:34 -- Server-Version: 5.7.13-0ubuntu0.16.04.2 -- PHP-Version: 7.0.8-0ubuntu0.16.04.2 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; -- -- Datenbank: `P5_iCalamus`by Ulf Dunkel - Phorum Support
Re: MySQL Database issues after server upgrade (to PHP 7) - 9 years ago
Here is another issue of this kind - can you please give me some advice what to do in order to fix it? A database error occured in your Phorum installation. Error message: -------------- Unknown column 'moderator_data' in 'field list' (1054): INSERT INTO P5_iC_users (username, signature, moderator_data, settings_data) VALUES ('134998by Ulf Dunkel - Phorum Support
Re: Running getimagesize() on the image data failed - 9 years ago
Excellent! Done.by Ulf Dunkel - Phorum Support
Re: Running getimagesize() on the image data failed - 9 years ago
Then getimagesize() will surely always fail. Although it is rather weird that Dropbox encapsulates the .png URI request into a webpage. Anyway ...by Ulf Dunkel - Phorum Support
Re: Running getimagesize() on the image data failed - 9 years ago
Hi Oliver, doesn't seem to be an issue with local (aka uploaded to my server) images, as you might see here:by Ulf Dunkel - Phorum Support
Running getimagesize() on the image data failed - 9 years ago
In my current Phorum installation, I now saw this error message: "Running getimagesize() on the image data failed". Is my Ubuntu 16.04 installation missing some tool that might be used by getimagesize() or is getimagesize() deprecated in PHP 7.0? Here is a Phorum link where I saw this error:by Ulf Dunkel - Phorum Support
Re: Module: Last Forum Post - 9 years ago
Thank you for the workaround, but following your recommendation, I have downgraded to 5.2.20. :)by Ulf Dunkel - v5/v6 Modules/Add-Ons
Re: Module: Last Forum Post - 10 years ago
This module still uses ./include/format_functions.php which is deprecated in the current 3.0-dev version of Phorum.by Ulf Dunkel - v5/v6 Modules/Add-Ons
Re: MySQL Database issues after server upgrade (to PHP 7) - 10 years ago
No, always the same error: script '/[...]/phorum/error.php' not found or unable to statby Ulf Dunkel - Phorum Support
Re: MySQL Database issues after server upgrade (to PHP 7) - 10 years ago
Thank you for pointing me at this, Thomas. I switched the setting to "Errors will be emailed to the system email address" and could see the issue. Here it is: A database error occured in your Phorum installation. Error message: -------------- Field 'password' doesn't have a default value (1364): INSERT INTO P5_iC_users (username, signature, modeby Ulf Dunkel - Phorum Support
MySQL Database issues after server upgrade (to PHP 7) - 10 years ago
I have updated my Ubuntu server to 16.04 which also brought PHP 7. After fixing most migration issues, I now see that various issues with my (uptodate) Phorum installations occur: I can no longer register as a new user. Error message: QuotePhorum Database Error Sorry, a Phorum database error occurred. The error message has been written to the phorum-sql-errors.log error log. Please try agby Ulf Dunkel - Phorum Support