Codezwiz >> Forums >> General PHP Nuke Help >> Problem creating new users

Hi

I've recently installed Nuke-PHP 7.9, on a Windows server 2003 box running MySQL 5.0.24, PHP 5.1.4 and install the database using phpMyAdmin 2.8.2.1.

All seems fine, the database installed correctly (though I did have to import nuke.sql using the latin charset as unicode didn't like the countries section) and everything that I've tested so far works without any problems. Except new user registration.

When I created the SU account, I opted to create a normal user with the same name. The normal user account didn't get created.

If I try to manually add a user via admin I get a blank page after clicking 'Add User'. If I create via 'Your Account' I get the email (also works to external addresses) but after activating the account does not exist. No errors are reported, and php.ini is set to report all except notify and code standards. Also have set config.php to report errors.

Having checked MySQL I notice that nuke_users_temp holds the new user account before activation, but it does not transfer to nuke_users after activation, just gets deleted.

nuke_users currently has just the anonymous account (id=1) and shows that the next increment is 2.

I've tried re-installing many times, also with 7.8.
I've also spent the best part of 2 days searching the various forums for an answer but am still empty handed.

Any ideas would be gratefully received.

Thanks.

I registered still no email. Maybe installing a mod like cnbya and turning on auto activate might give a temporary fix.

Hi floppydrivez,

Thanks for looking in to the problem. I can see from the MySQL database that you attempted to create an account, but due to using a hotmail account the email didn't get through to you. Another problem I need to find a fix for as I'm running my own email server on a dynamic IP address.

I've also noticed that I cannot create any other admin accounts, and there seems to be a little more information available for this problem. Hopefully I'll soon have the knowledge I need to fix it.

I have now patched 7.9 with 3.2b from NukeFixes, but still no luck (I have upgraded the database to include the extra table).

The database was originally created by importing the nuke.sql file from Nuke 7.9, and I'm thinking there may be some fields that are incorrect for the code.

I'll keep searching...

I suggest to you the raven nuke distro.

Its 7.6 based which is the most secure with some added goodies like sentinel and nsn groups.

Its the best I have found so far, of course that being only my opinion.
[ Register or login to view links on this board. ]

Here is the download link with more details [ Register or login to view links on this board. ]

Thanks for your advice, and links. WIll give it a go

Have taken your advice, deleted the old installation and database, created new database, follwed all instructions...then....

Using RavenNuke setup.php I hit a problem. Fortunately it tells me what the problem is.

Unable to Insert into nuke_users table. MySQL reported: Field 'bio' doesn't have a default value

So, I thought I'd add a space (' ') as default, but then I get:

SQL query:

ALTER TABLE `nuke_users` CHANGE `bio` `bio` TINYTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ' '

MySQL said:

#1101 - BLOB/TEXT column 'bio' can't have a default value

Can you shed any light on this, please.

My bio default is blank also. Theres no function asigned. Let me think on this one.

I would say try something stupid like 0, but that is totally shooting in the dark.

The problem for me is, I have never set up my own server. If your going to continue to use the raven distro (which I would suggest), I would post on raven's site and see if anyone has an answer. You can't be the first to have this problem.

Thanks for the info. I now have RavenNuke 7.6 v2.02.02 running.

I think the problem with Nuke-PHP and RavenNuke were the same, it's just that RavenNuke gave me the information needed to solve the issue.

I changed nuke_users bio to allow NULL default NULL
I also had to change nuke_users ublock to allow NULL default NULL

Everything seems ok so far, not sure if the change will cause any problems later in life.

Anyway, thanks again

Great! glad you got it working. Please be sure to keep us updated if it causes problems down the road.