Managed to upgrade my forum today and in the process of turning it back on and allowing users to register again for the first time in about 5 years.
Everything seems to be working fine except the new registrations.
I completed the image capture, entered my details and when I submitted it spat up an error saying to turn on error log checking which I did. I then
repeated the process and when trying to create my test account it said failed, please check the error log.
Silly question, where do I find that?
Qmiqrogroove - 2-12-2025 at 11:47 AM
According to the address you gave me earlier, the configured log path for your site is
/../logs/php_error_log
It's a slightly odd value, but you can change that in the PHP config as needed.
I can't help find the file though. If you have a host support channel they might be willing to explain the system.Club-K - 2-12-2025 at 07:15 PM
When I connect via ftp to my site there is a logs directory on the same level as the public_html (if that makes sence). It has 4 files in it.
* club-k.co.nz-Jan-2025.gz
* club-k.co.nz-ssl_log-Feb-2025.gz
* club-k.co.nz-ssl_log-Jan-2025.gz
* ftp.club-k.co.nz-ftp_log-Feb-2025.gz
under the public_html I cant see anything related to errors/logs?
under the Forums I cant see anything related to errors/logs?
miqrogroove - 2-13-2025 at 01:33 AM
Try adding this somewhere in your config.php file:
ini_set('error_log', 'error_log');
This should override the host-specified log file path and create the log in the forum directory.Club-K - 2-13-2025 at 10:23 PM
Uploaded the modified config. Will test later tonight/over the weekend and report back. Club-K - 2-14-2025 at 09:25 AM
Tried again with the code you sent and the create new login failed at the same point again.
see attached error log which I located where you said it would be
Attachment: error_log (1kB) This file has been downloaded 16 times
miqrogroove - 2-14-2025 at 11:26 AM
That error is related to a poorly-designed database customization. For reference,
The first step provided in those instructions actually makes the database incompatible with user registration. Not a great way of doing things.
To resolve the error, ask the database to fill in for new users with this query and Insert Raw SQL:
Code:
ALTER TABLE $table_members MODIFY COLUMN notepad text NOT NULL DEFAULT ''
Club-K - 2-14-2025 at 07:40 PM
micro. you kind of lost me.
since the upgrade to 1.9.12 i haven't installed any new hacks
I have made a couple of small visual changes but nothing to add or alter the database structure.
I don't think I have ever installed a notepad on my forum (new or old).
I do use notepad to edit forms or templates as required.
I did go into the members forum the other day to update the avatar links but the error existed before then.
I jumped into phpmyadmin and had a look at the members database.
There is a field called notepad.
Only 1 user, myself has anything in there and all it says is tsett.
Could I just delete that field and would that fix the problem?miqrogroove - 2-15-2025 at 12:20 PM
YesClub-K - 2-16-2025 at 12:45 AM
And how per say does one do that.
I've had a look in phpmyadmin at the xmb_members table, looked at structure, can click the line for notepad but there doesn't seem to be a delete
option anywhere. Is drop the same thing?
miqrogroove - 2-16-2025 at 12:51 PM
For help with customization, please consult the MySQL manual or maybe someone else can help out here. If not, the solution I posted above should be
adequate.Club-K - 2-17-2025 at 04:22 AM
Yes drop was what I was looking for.
You may mark as resolved as I am now able to create logins again.
Thanks
Q
