cannot create new user, nuke 8.0, mysql 5

Nuke Cadet Joined: Oct 24, 2008 Posts: 6

I have been using phpnuke 8.0 since new. I have not been able to create a new user account since migrating to a new host. I am stuck with mysql 5.0.51a, since it is used by my host, lunarpages. I searched the Karakas forum and the only advice I find is to drop back to an earlier version of mysql, or to make modifications to the user table which mysql 5 will not allow. Can someone please help me rewrite the login/new user registration code to work with mysql 5. StocksAbroad.com is my site, which has deeply modified phpnuke, so migration to another sytem is nearly impossible.

Thanks much, Terry Hogan

Nuke Cadet Joined: Oct 24, 2008 Posts: 6

Given, that I have a login incompatibility, is there a possible workaround. Does anyone know of an extension, a new module, that would allow an alternative login procedure?

Captain Joined: Sep 13, 2003 Posts: 355

Have you asked for help in any MySQL-forum for your problem?

Nuke Cadet Joined: Oct 24, 2008 Posts: 6

Thanks Slackervaara, In the NukeCode forum they tell me there is no incompatibility between Nuke 8.0 and mysql 5.0.51a. I did check out the forum at mysql.com and didn't find anything.

I dropped and recreated the nuke_users_temp table and it did not help.

Captain Joined: Sep 13, 2003 Posts: 355

Have you tried to upload the Your Account module again? Maybe it is corrupt or something?

Nuke Cadet Joined: Oct 24, 2008 Posts: 6

Slackerware, yes I uploaded the 8.0 Your_Account module and there was no change. I get a white screen when I try to create a new user as admin, and I get the _error message when a user tries to create a new account.

Captain Joined: Sep 13, 2003 Posts: 355

I think you always can add new users through phpMyAdmin.
Go to nuke_users table and click on Insert Tab. You can add a new member from here by filling in the different data. After writing the password you have to choose MD5 from the box to the left.

Nuke Cadet Joined: Oct 24, 2008 Posts: 6

Slackervaara, I will be introducing thousands of new users, so a manual creation of new users through phpmyadmin will not work.

To test for compatibility with my host, I installed a fresh copy of nuke 8.0 in a subdirectory. The problem is exactly the same. A user cannot create a new account (the _error message appears when the new account is submitted). Admin gets a white screen when an attempt is made to create a new user.

Everything else works fine. I can create new admins, and admin login works fine. A lot of php code has been written for stocksabroad.com and it runs fine, with lots of interaction with mysql.

Can anyone point me to the likely source of the problem.

Posted: Tue Nov 11, 2008 1:33 pm

Can you give us what the error is when you try and create an account. That should allow us to narrow down the offending section of code.

Nuke Cadet Joined: Sep 03, 2008 Posts: 6

simrin wrote:

Can you give us what the error is when you try and create an account. That should allow us to narrow down the offending section of code.

Can you give us what the error

Nuke Cadet Joined: Sep 03, 2008 Posts: 6

simrin wrote:

Can you give us what the error is when you try and create an account. That should allow us to narrow down the offending section of code.

Can you give us what the error