Hi all ,

i follow a lead here try to change as it say
below : i add up user_icq and user_aim in MySQL yet it still tell me this error when i try to edit my account ..
( i already change it to 100 for both )

--->user_icq must be shorter than 15 characters.
---->user_aim must be shorter than 18 characters.

https://xoops.org/modules/newbb/viewtopic.php?topic_id=20250&forum=27

1. In ../language/english/user.php change

define('_US_ICQ','Organisation');
define('_US_AIM','Department');
define('_US_YIM','Address');
define('_US_MSNM','City');
define('_US_LOCATION','County');
define('_US_OCCUPATION','Post Code');
define('_US_INTEREST','Phone');

2. In .. /modules/system/language/english/admin
users.php
findusers.php

change
define("_AM_ICQ","Organisation");
define("_AM_AIM","Department");
define("_AM_YIM","Address");
define("_AM_MSNM","City");
define("_AM_LOCATION","County");
define("_AM_OCCUPATION","Postcode");
define("_AM_INTEREST","Phone");

3. In ../user.php

define('_US_ICQ','Organisation');
define('_US_AIM','Department');
define('_US_YIM','Address');
define('_US_MSNM','City');
define('_US_LOCATION','County');
define('_US_OCCUPATION','Post Code');
define('_US_INTEREST','Phone');

4. in ../edituser.php

Find
if ($op == 'editprofile') {

About 23 lines after this, a line begins $icq_text
From (and including) that line, change the first and second number in brackets to increase the size of the text box appearing for users (I have used 40, 100 as default for all).

5. In MySQL, in xoops_users edit the field size to 100 (or whatever you set at maximum in 4 above) for ICQ, AIM, YIM etc. that you have amended (to allow for more text to be entered)

you will also need to modify /kernel/user.php


The above line creates a new variable in the XoopsUser object with the following settings:

name: user_icq
type: XOBJ_DTYPE_TXTBOX (textbox)
default value: null (empty)
required: false
length: 15

So to use your new db lengths you need to modify that line to:


You'll need to make a similar change to the line for 'user_aim'

tq bro, it work like a charm = )