Survey Table Field Definition : Where is it defined?

More
4 years 8 months ago - 4 years 8 months ago #83672 by utsi
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: 4 years 8 months ago by utsi.

Please Log in to join the conversation.

More
4 years 8 months ago #83676 by utsi
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.