Membership Pro deletes the initials ' 0 ' ?

Hi Dear,

I see that Membership Pro stores in database number without ' 0 's if these are at the beginning of a string (even if the relative fields is a text string).

Example.
Zip Code = 00146 --> in database it's stored as 146.
(in Joomla / Membership Pro, the value is 00146)

Or in a custom field (I have osm_vat_id), number like:

00907550742 become -> 907550742

That's not right to me unless you have some special setting with the field. Where do you see that? Is it when you export data? If so, I think it's the Excel program is trying to change the value to Number only

Try to view the record from within Membership Pro, the data should be displayed properly

Regards,

Tuan

Hi Tuan

I check that directly in the database launching the query:

SELECT name,field_value FROM `mydatabase_osmembership_fields` AS field INNER JOIN `mydatabase_osmembership_field_value` AS value ON field.`id` = value.`field_id` WHERE name = 'osm_VAT_ID'

to check VAT_ID (a custom field).

And I see that strings beginning with ‘ 0 ‘s are stored without them.

Ooops

I checked this on test site where subscription was imported from CSV (it was the sheet that deletes the ‘0’s, not Membership Pro!).

Sorry for the time stoolen by my distraction.

I know it does not cause by Membership Pro