Listing field type (Phone) does not work!

[PGGO]

I setup a <Phone> listing field type under Admin Panel; however, it does not show up in admin panel ether in front end (see snapshot).

[Vladimir]

Hello,

You can fix it manually using the following sql command:



ALTER TABLE `YOUR_DB_PREFIX_listing_fields` MODIFY COLUMN `Type` ENUM('bool','text','textarea','number','date','mix ed','price','select','radio','checkbox','file','ac cept','image','phone') NOT NULL DEFAULT 'text';

[PGGO]

Thanks a lot! it works

[Milea Ionut]

How can i show the "0" number in frontend? If i create an account i can insert it but it does not appear in frontend.

[Viktor]

Hello Milea Ionut,

If you want show 0 in profile you should go to ftp://includes>>classes>>rlAccount.class.php
find method registration and code at line ~411:



case 'phone':
$out = '';

/* code */
if ( $fields[$poss]['Opt1'] )
{
$code = (int)substr($account[$key]['code'], 0, $fields[$poss]['Default']);
$out = 'c:'. $code .'|';
}

/* area */
$area = (int)$account[$key]['area'];
$out .= 'a:'. $area . '|';

/* number */
$number = (int)substr($account[$key]['number'], 0, $fields[$poss]['Values']);
$out .= 'n:'. $number;

/* extension */
if ( $fields[$poss]['Opt2'] )
{
$ext = (int)$account[$key]['ext'];
$out .= '|e:'. $ext;
}

$data2['fields'][$key] = $out;
break;


and remove (int) where do you want see 0 in code or area or number. IF you want see 0 in all you can remove (int) from all. Then save and create new account.

[Milea Ionut]

Now is working! Thank you!

[Maaz Surchy]

Pardon me, but how to run that SQL command?

Because I got same problem and tried to fix it.

[Peter Jonsson]

yoursite.com/admin/index.php?controller=database

[Maaz Surchy]

Thanks Peter, I got this message: The query has been successfully implemented, 0 rows have been affected.

But still have same problem.

[Viktor]

Hello Maaz,

Would you please send me in PM ftp access details and I will fix it ASAP and send code for your problem.