Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Sign In
Not a member yet? Click here to register.

Suspected Bugs and Errors - 8

If you suspect you have found a bug or a code error post here.
4022 posts | Last Activity on 24-06-2020 22:27 by Falk
Falk
Falk 24-06-2020 22:27, 13 days ago
Re: Problems with userfields by registration (TEXT NOT NULL) Yes, perhaps crude. But will solve the issue instantly. You can also select to no include these user_fields to the registration so they only display when users edit their profiles.
It sounds odd, so without checking I know that VARCHAR can not exceed 255 if we want a optimal indexing of the table. Anything above should be TEXT.
E
Ernst74 24-06-2020 19:21, 13 days ago
Re: Problems with userfields by registration (TEXT NOT NULL) OK, that is the quick and dirty solution for the user fields. I have seen the user signature is by setup VARCHAR(500) but after deactivate and new activate of the field it is TEXT NOT NULL

Database fields with TEXT NOT NULL are general a problem at me with PHP-Fusion. I think i must change the STRICT mode from the MySQL server or PHP-Fusion will not work correct. On my own server is that no problem, but on a rented webspace nobody can change that.
Falk
Falk 24-06-2020 13:27, 13 days ago
Re: Problems with userfields by registration (TEXT NOT NULL) Make the ones you include to register mandatory.
E
Ernst74 23-06-2020 08:08, 14 days ago
Re: Problems with userfields by registration (TEXT NOT NULL) I have a lot of problems with userfields after the registration that have TEXT NOT NULL. This userfields are activated only for profile and not for the registration.

If a new person had make a registration for the site there is an error: Field 'XXXX' doesn't have a default value The error is when the registration copy the informations from the table new_users to the table users.
djdandi
Re: Settings do not exist, please check your config.php file or run setup.php again. The problem was again corrected by the server.
Falk
Re: Settings do not exist, please check your config.php file or run setup.php again. Do you have a copy of a old db_settings when the system worked?
If not, You can make a new install in a subdomain to your main domain.
Export db_settings and change to your domain & paths in the exported file, remember to also change the prefix to the old one.
Drop old db_settings and import the new db_settings that you have prepared.

Rob tells me that the issue can occur if your host upgrade the database handler, it may corrupt settings, so this is one way to solve it.
I also strongly recommend that you upgrade to latest 9 as well.
djdandi
Re: Settings do not exist, please check your config.php file or run setup.php again. The config.php file is compatible with the user. Where in the database can I find this prefix from the config.php file
I'm using version 9.03.00
Falk
Re: Settings do not exist, please check your config.php file or run setup.php again. Then it is one of the other, db user, db password or prefixes. Make sure your config.php match the user and pass and prefix set in your database config.
djdandi
Re: Settings do not exist, please check your config.php file or run setup.php again. I have repaired the tables but still nothing.
Falk
Re: Settings do not exist, please check your config.php file or run setup.php again. This is usually a hosting issue or as mentioned before, you might need to repair the table.

Quote

Check your phpMyAdmin if the tables are present, double check the config so nothing have changed on your hosting side from an update, database paths, prefixes
djdandi
Re: Settings do not exist, please check your config.php file or run setup.php again. Unfortunately, I have this problem again. I haven't changed anything in the files and the problem has been since yesterday. I previously had a problem with the username I changed and it worked but now I have no idea why it doesn't work.
C
Re: Settings do not exist, please check your config.php file or run setup.php again. Don't scare me. We're already post Stable.
djdandi
Re: Settings do not exist, please check your config.php file or run setup.php again. I've already solved the server-side problem - thanks
Falk
Re: Settings do not exist, please check your config.php file or run setup.php again.

Quote

Check your phpMyAdmin if the tables are present, double check the config so nothing have changed on your hosting side from an update, database paths, prefixes

Also, try to run a repair on settings table in phpmyadmin if all of the above is correct.
djdandi
Re: Settings do not exist, please check your config.php file or run setup.php again. Today I have the same problem. How did you fix it?
Falk
Falk 20-03-2020 23:47, 4 months ago
Re: Uncaught Error: Call to a member function rowCount() Great!
Yes, only adminnistration/forums_prune.php uses it atm. I will update for next patch.
Edit: Updated.
Wanabo
Wanabo 20-03-2020 23:20, 4 months ago
Re: Uncaught Error: Call to a member function rowCount() Thanks. I'll let you know if that fixed it.

Edit: Couldn't resist to try the modified code. Result: works!

Is it safe to remove function db_affrows() from pdo_functions_include.php?
Falk
Falk 20-03-2020 20:05, 4 months ago
Re: Uncaught Error: Call to a member function rowCount() I think it was meant to have backward compatibility but was never finnished, adjusted system instead.
Updated this, https://github.com/php-fusion/PHP-Fus...f92585207f , Should do the trick. Thank you!
Wanabo
Wanabo 20-03-2020 18:07, 4 months ago
Re: Uncaught Error: Call to a member function rowCount() Version 8.00.23
When I delete a thread through the moderator options "delete thread" this will fail.
(https://tele2.gebruikers.eu/forum/options.php?forum_id=33&thread_id=3104)

When I delete a thread by selecting a checkbox in viewforum it works ok!
(https://tele2.gebruikers.eu/forum/viewforum.php?forum_id=33)

The error message shown is:
Uncaught Error: Call to a member function rowCount() on null in /*/includes/db_handlers/pdo_functions_include.php:211\nStack trace:\n#0 /*/forum/options.php(115): db_affrows()\n#1 {main}\n thrown in /*/includes/db_handlers/pdo_functions_include.php on line 211', referer: */forum/options.php?forum_id=59&thread_id=2180

In options.php I find this line $del_posts = db_affrows(); which refers to pdo_functions_include.php
In pdo_functions_include.php I find:
Code
function db_affrows() {
 global $pdo;

 if ($pdo !== FALSE) {
 return $pdo->rowCount();
 }

 return NULL;
}



But I can't figure out what is wrong with it. The function db_affrows() can't be found elsewhere but in options.php
So I looked at the (working) code for deleting threads in viewforum.php.
This is different from options.php but does not use function db_affrows()

So can any one see what is wrong with function db_affrows()?
Or could any one rewrite the code for deleting threads in options.php by taking a look at the similar code in viewforum.php?

I compared the files with the newer 8.00.30, but the code is the same.
Falk
Falk 20-03-2020 17:16, 4 months ago
Re: After installing 8.00.30 Sounds very strange indeed, do a recursive file permission update from a solid FTP client.
You can view all discussion threads in this forum.
You can start a new discussion thread in this forum.
You cannot start on a poll in this forum.
You cannot upload attachments in this forum.
You can download attachments in this forum.