Can't add USERs, Database error

New Member Joined: Oct 30, 2005 Posts: 4

New to the Nuke/PHP/SQL thing, and I'm trying to setup the server on a local machine first to work out the bugs before I try doing it on a remote site. The problem I am running into now is that I cannot add users to my site without going into the SQL database and entering a username and password myself (they work fine then).

Running PHP-Nuke 7.9, PHP 5, SQL 5, CNB YA 4.4.2. I have phpMyAdmin too, can kind of find my way around in it and think I have a hang of it all.

If I try to "register" or if I go through the control panel and "add user" I get the same worthless message:

ERROR: There was a problem with the database

Well thanks. So somewhere in that 500k worth of database there is a problem. Guess CNB never said anything about verbose errors in the docs.

Reading around it sounds like this error is coming from having a bad nuke_users table. So I deleted it and ran cnbya.php with the First Install option. Well that failed, cause it's just an ALTER TABLE. So I remade a table with 1 field and ran again. CNB only added a agreedtos field. So now it's looking like I have to remake the table, but the question is what fields do I need so that CNB won't give me an error next time I add a user?

Sells PC To Pay For Divorce Joined: Posts: 5661

well ever thought of starting over?
Since your working local it doesnt mind realy,just delete the tables and start new..

Posted: Mon Oct 31, 2005 3:12 pm

I would start over, but the thing is, I'm already at the start. I've got the SQL table provided with PHP-Nuke 7.9 and I've added CNB YA 4.4.2, and upgraded the table from 4.4.1 to 4.4.2 (like CNB YA said I needed to). And it doesn't work.

EDIT: Changed PHP-Nuke from 4.9 to 7.9 typo!

Posted: Mon Oct 31, 2005 3:15 pm

Huh 4.9 ?...i thought that was mistyped but i guess not..
Ehh phpnuke is currently at 7.9 !
But i suggest 7.6 Smile

Posted: Mon Oct 31, 2005 4:36 pm

I'm not even going to try to act like I am knowledgable enough to make an arguement about 7.9 vs 7.6. I am making a website with a target audience of around 50-100 people, so it doesn't have to be anything fancy. Why do you recommend 7.6 over 7.9, I'm assuming it's more stable. Other than that, what was introduced to phpnuke since 7.6 that would make 7.7-7.9 worthwhile? I'm willing to try anything cause functionality is the key, and 7.9 isn't doing it.

Posted: Mon Oct 31, 2005 4:45 pm

well for starters,i dont think cnd will on a low version.
and yes i use 7.6 and thats what i recommend but if people want to use 7.7,7.8,7.9 its fine by me but using one of the first versions around is not recommended at all.

Posted: Mon Oct 31, 2005 5:46 pm

Well I gave up trying to get it to work and started uploading to the Linux host (using windows here). After finally connecting to the MySQL host and creating the tables, VIOLA the CNB YA works. Whatever... Thanks for the help hitwalker, even though I guess all I needed was to use Linux Very Happy

Posted: Mon Oct 31, 2005 5:58 pm

well under normal enviroments nuke runs without any problems.
And windows isnt normal..

New Member Joined: Jan 20, 2006 Posts: 2

I had the same trouble in windows.

In my case, the database did not have default values for bio and ublock.
A quick change of the table to add a default null value made it work.

New Member Joined: Jan 31, 2006 Posts: 2

Hello

i have the same problem. Which files do i have to replace/add in the MySQL-Table? Where can i download them? Sorry for my bad english, i´m just a german Smile

Posted: Tue Jan 31, 2006 2:46 pm

I added default (null) values for table structure

(prefix may be different)

nuke_users -> bio
nuke_users -> ublock

Basically open phpa

select database

select nuke_users

click pen looking object next to bio

type "NULL" in the default field

save

repeat with ublock

Posted: Wed Feb 01, 2006 6:30 am

Thx for your response, but doesnt work for me. any other tips?