phpBB • Free and Open Source Forum Software

by **dpaquin** » Thu Mar 03, 2011 8:04 pm

Hello phpBB Folk,

Not sure if this is a known issue, but when I installed phpBB Digests 2.2.15 on my 3.0.8 phpBB board there was an issue with new user registrations. It would seem that the phpbb_config entry for user_digest_no_post_text was not created for some reason, as the following error came up when a user tried to create an account:

Code: Select all: SQL ERROR [ mysqli ] Column 'user_digest_no_post_text' cannot be null [1048]

I added a new phpbb_config entry and the error seemed to go away. Would this commonly come up with the combination of 2.2.15 and 3.0.8?

by **MarkDHamill** » Thu Mar 03, 2011 9:21 pm

Yes. The UMIL installer program should be able to make these changes for you. I am guessing you did not run that program.

by **dpaquin** » Mon Mar 07, 2011 6:01 pm

That would be run when I called the digests_install.php file and made it do the Install action, correct? When I browse to the digests_install.php file now my only option is to Uninstall.

Also, the digests don't seem to be going out at the moment (another result of this problem). The digests would be called in the cron.php script, right? When I run the mail_digests.php file manually the emails are sent out properly however (suggesting it's just a cron problem).

by **MarkDHamill** » Mon Mar 07, 2011 6:17 pm

Try this. Use phpMyAdmin or similar tool to change the attributes of the user_digest_no_post_text column in the phpbb_users table so it does not allow nulls. I am guessing your installation of MySQL has a policy that makes columns not so declared null by default. The digest UMIL installer does not tell it one way or the other whether the column can be null or not.

It looks like you ran digests_install.php earlier or you would not be asked if you want to uninstall. This makes me think something is wrong with how your database is set up.

cron.php does not control digests being sent out because it is not guaranteed to send items in the queue out at a specific time. As the DIY instructions say, you need to read /contrib/readme.html to learn these and other secrets.

by **dpaquin** » Mon Mar 07, 2011 7:20 pm

Aha - that readme file is exactly what I needed. I've tried the setup again and things are working perfectly now.

All of the columns are set to not null (and always have been) so I'm not sure what the issue was originally caused by (aside from that missing key). Anyways, thanks for all the help and the quick replies!

by **sbloomer** » Sat Jul 09, 2011 2:11 pm

Strangely enough this happened to me as well after I had to undergo a complete reinstall. I noticed that this entry was missing from the digest_install.php file