CUSTOM FIELDS... VARCHAR TUNING!

More
12 Sep 2012 10:47 - 12 Sep 2012 11:00 #156 by GammX1
GammX1 created the topic: CUSTOM FIELDS... VARCHAR TUNING!
Hi Davide,

Thanks for adding 'Custom Fields' option from TrackTime Pro 1.5.0 Stable...

Some DB tables fields are set by default too short then the added 'value' is not fully booked...

As you may know some custom fields to have booked must be up to 600 digits long ... Aka the GOOGLE APPS DNS TXT DKIM that looks like this:
v=DKIM1; k=rsa; p=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXKpHLYYp98x7UzsRhzvX2Qs/hvE3Nit37razXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXDO4pZMoxzPGov/S4EeQlyL2/9k20HqFBEJMEXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXQIDAQAB

Then I strongly recomend you to modify by default the following 'varchar' DB Tables fields values to:

#__tracktime_projects
pr_database_prefix = varchar(50)

and:

#__tracktime_projects_fields
pf_value = varchar(600)


Thanks again for your attention & close support,
Rgrds,
GammX1
Last Edit: 12 Sep 2012 11:00 by GammX1.

Please Log in or Create an account to join the conversation.

More
14 Sep 2012 12:13 #171 by admin
admin replied the topic: Re: CUSTOM FIELDS... VARCHAR TUNING!
Fields enlarged.

Please Log in or Create an account to join the conversation.

Time to create page: 0.180 seconds