Guess what! The problem is solved! But not until I practically deleted the whole site and started all over, restored the profile related database tables for a few times, messed with xoops_newblock table for some odd reason of c_type structure column missing (something obviously totally unrelated). In the end it turned out that Gravies was right and that I just didn't pick up a message quite well and wondered around instead.

What I mean is this. What finally solved the problem was checking the last entries in the xoops_user_profile module. As it appears, every times me or anyone else tried to register it created a yet another pretty much empty entry with the "posts" column filled with "-1". So, even if I restored the xoops_user_profile_field table, and any other related table for that matter as well as deleted the c_templates files it didn't solve the problem as those trash entries went in the way somehow. Deleting them solved the problem.

I wasted quite alot of time rebuilding my site from scratch (from db backup of course) and I should have probably lost alot less of time over this if I only figured to look into the end of the xoops_user_profiles table. Gravies mentioned something like that on IRC, but I thought he was talking about deleting those users from the XOOPS user admin area (with the status of "-1"). Well, I obviously misread him.

All in all, I am very happy to have this problem solved and that I can again welcome new users to my site. And the time I lost rebuilding the site wasn't really for nothing. The "recent blog entries" block that cause 500 internal server error was solved as well and I took the chance while I was at rebuilding to port my content from buggy wfsections 2.01 module to awesome new smartsection 1.1 beta for 2.2. It works like a charm.

Anyway, before I stop ranting here is one error I am still getting in MySQL debug when deleting users (which could possibly cause some trouble and should thus be killed ASAP):

Quote:

As you can see it's in "Queries module" section of the debug window and the error is in bold text.

According to the error it is in MySQL syntax and causes the inability to delete an user entry from xoops_user_profile table.

That is why I had to manually delete those bad registration profiles from it to resolve the above problem.

Extended profiles module of both 2.2.2 and 2.2.3 XOOPS is obviously still buggy. I hope the next release is finally "ironed out".

Thank you
Daniel

I have found a fix to the problem of not having the user_profile deleted when trying to delete a user. The problem is that the profile found in the User object doesn't have the key set so it can't delete itself using it's own key. In Kernel/User.php assignVars($vars) is used to fill either the User object's vars or the Profile vars however the "profileid" doesn't get set. I have edited the following code so that it gets set. I don't know if this introduces any other problems but I don't think so as there is no var "profileid" initiated as part of the creation of XoopsUser so AFAIK a value can't be assigned to it anyway.

function assignVars($vars) {
$uservars = array_keys($this->getVars());
foreach ($vars as $key => $value) {
/* edit the following line to remove || $key == "profileid" */
// if (in_array($key, $uservars) || $key == "profileid") {
if (in_array($key, $uservars)) {
$this->assignVar($key, $value);
}
/*
* Dynamic user profiles - Mith
*/
else {
$this->_profile->assignVar($key, $value);
}
/*
* Dynamic user profiles end
*/
}
}

I hope that makes sense.

guys, i'm having a problem with some crap on my website.
http://www.phalasteen.com/index.php (Apparently the Could not register new user. Issue is still happening)

anyway, I barely edited the site, a friend of mine registered yesterday, and when i told another friend o register, the message came out..

What should i do.
I don't have the extended profile or whatever.. i'm dyin

please help mates.

thx

Well here's the issue

if i register a user while i'm already logged on. It works.

But if i log off and try to register, it won't work.

PLLEEAASEE HELP!

extended profile needs to be installed for registrations to function (i think)

I have XOOPS V. 2.0.13.1

do i have to upgrade?


edit: recommend, to WHAT should I upgrade.

Same Problem here. I someone try to create an account with special characters in the password => Could not register new user.

(special characters like "," , etc. )

XOOPS IS A PIECE OF SHIT!

You're replying to a two and a half year old post and slagging the project with out any explanation as to why. What's your problem?

!!!