Okey, I need huge help here...

I've written about this before, but now my site is getting ready to launch, and I can't launch it with the errors that it has got right now...

So this is my problem, when I change my password through the profile, I get this message, exactly as it should be... "Your profile has been updated, click here to go to forumindex", or something like that... But when I click the link for the forumindex, this is the page that I get (screenshot here). So, that's not good... Then, if I try to go to some other part of the site, this is how that will look (screenshot here).

I've heard about that error in the nuke-sql, and the text I get at error2 is "You have an error in your SQL syntax near '' at line 1", do we have a fix for this without having to erase all the info in the database? Just to fix the damaged part of it? I think that is what I need and that may be what is wrong with my site, so please... Please, please... Give me a fix for this someone, because I'll have to wait with the release of my site just to fix this, please help me out...

I've got one other idea also for this, if noone has a fix... I though that it should be possible to change the profile so that the "Change password"-part uses the same sql-tables that the Your Account-editing does, because if you change the password through the Your Account-site it'll work without errors, and then you don't even get logged out as you get if you edit it through the profile, is this possible? If so, it would be very, very kind if someone could write how to do this...

Thanks in advance!

Best Regards,
David Nilsson

First of all, if I have to guess, I would say you have Account Activation set in the Forum Admin Configuration to USer or Admin..this will not work with the Forum reg hack. You have to set it to NO Activation required.

If that doesn't work and you really need more help. I will need FTP access, SQL access and Admin Access to your Site. You can PM me the Information.

As for the Line 1 error in the nuke.sql table, I have not seen a fix for this that does not require a full install of the database again.
I have the same error in my Database and I do not have the same problem you have, so I don't think that is the issue.

mikem

Hmm, I'm afraid that the account activation was already set to off.

Mikem, I trust you, but actually, my passwords and so on is a bit to important to give away, so I'd like to wait a bit about that to see if someone has got any other solution, if not, I will think about it.

Thanks for the offer!

Best Regards,
David Nilsson

Thhat's fine David.

Basically what is happening in your situation is that the Forum registration is not getting written to the Database or it is not recognizing you as logged in.

I would try reinstalling the hack. Could also be the template sub3d you are using has something else written to the files from a previous developer of that template.

mikem

well, actually I have pm'd you all the info needed (not the mysql-thing though, because then you'll have to pass through a swedish admin-system which is pretty hard I guess, but if that's needed, I can fix that also, just tell me...)

Hey mikem, I wanted to tell you that I think you made a mistake when posting the private message with what I should change and that, because the change-from code and the change-to code was identically the same... Please try to send it again

Well, I think I get what you meant now... Proably you wanted to say that I should change

Code:

$sql = "SELECT pass FROM " . USERS_TABLE . " WHERE uid = $user_id";

into

Code:

$sql = "SELECT pass FROM " . USERS_TABLE . " WHERE uid = $user_id";

But I'm afraid that made no difference with my board...

ok we got a problem here., I can't paste the changed code, it keeps reverting back to your Old code you ahve posted..see what your post did above, must be a bug in our Forums..lemme try Quoting it.

I can't see any difference? Well, have you tried to copy your usercp_register into my server and still got the same error?

Originally Posted by zlaxzzor

I can't see any difference? Well, have you tried to copy your usercp_register into my server and still got the same error?

ok lemme try that

Originally Posted by mikem

ok we got a problem here., I can't paste the changed code, it keeps reverting back to your Old code you ahve posted..see what your post did above, must be a bug in our Forums..lemme try Quoting it.

Yeah, I noticed... though you got the same problem with that also.