Survey Table Field Definition : Where is it defined?

More
5 years 1 week ago - 5 years 1 week ago #83672 by utsi
utsi created the topic: Survey Table Field Definition : Where is it defined?
I've found out that once a survey is activated, a table is created whose syntax is lime_survey_surveyid.

One issue I'm facing is that the IP address field length is assigned only 5 characters, i.e. varchar(5). This is resulting in partial IP address being stored. I've been searching for the code where the field length is defined for the IP address column.

So far I've looked through activate_functions.php, common_functions.php, ado-db-datadict.inc.php, and database.php files. I haven't been able to spot it anywhere although I think I'm looking in the right files. Maybe I'm missing something somewhere. Any help in the right direction is greatly appreciated.

Thanks,
Safdar
Last Edit: 5 years 1 week ago by utsi.

Please Log in to join the conversation.

More
5 years 1 week ago #83676 by utsi
utsi replied the topic: Survey Table Field Definition : Where is it defined?
Nevermind, I found it. For those facing similar problem, the size is defined in activate_functions.php file inside activateSurvey function.

Please Log in to join the conversation.

Did you already participate in our customer survey?

Don't miss your chance for great prices.

Please click here to participate:

Start now

Start now!

Just create your account and start using Limesurvey today.

Register now