638
I have fixed the blank pages turning on the debug mode on and that showed an error in an archive in xoopsform, so I overwrote all files in XOOPS form, that fixed that part.
But new users are still unable to register, after the form is filled and you press send you get a message Can not register user. So I turned on MySQL debug and I get this error in the moment of trying to fill the form and register for the first time:
INSERT INTO x2_users (uid, uname, name, email, url, user_avatar, user_regdate, user_icq, user_from, user_sig, user_viewemail, actkey, user_aim, user_yim, user_msnm, pass, posts, attachsig, rank, level, theme, timezone_offset, last_login, umode, uorder, notify_method, notify_mode, user_occ, bio, user_intrest, user_mailok)
I compared the fields of MySQL tables of [color=000099]x2_users in phpmyadmin with a database of a different XOOPS 2.0.5 that is working perfectly and the fields are different, for example notify_method doesn´t exist in the site where I am having problems, nor does notify_mode and user_mailok exist.
How can I recover the structure of this table for it to work well in XOOPS 2.0.5 - without losing the 200 users I have?