Welcome, Guest
Username: Password: Remember me

TOPIC: Survey Table Field Definition : Where is it defined?

Survey Table Field Definition : Where is it defined? 2 years 1 month ago #83672

  • utsi
  • utsi's Avatar
  • OFFLINE
  • Junior Lime
  • Posts: 25
  • Thank you received: 1
  • Karma: -2
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: 2 years 1 month ago by utsi.
The administrator has disabled public write access.

Re: Survey Table Field Definition : Where is it defined? 2 years 1 month ago #83676

  • utsi
  • utsi's Avatar
  • OFFLINE
  • Junior Lime
  • Posts: 25
  • Thank you received: 1
  • Karma: -2
Nevermind, I found it. For those facing similar problem, the size is defined in activate_functions.php file inside activateSurvey function.
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.087 seconds
Donation Image