Changing field length in MySQL for Vicidial_List

General and Support topics relating to ViciDialNow and GoAutoDial ISO installers

Moderators: enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, s0lid

Changing field length in MySQL for Vicidial_List

Postby ykhan » Wed Dec 02, 2009 5:02 pm

What are the risks of changing the field length in MySQL for fields like First Name etc? WHat will equire changing in admin.php, vicidial.php, or any other scripts?

Thanks
Yousaf Khan
For installation and Support.
VoIP to North America from $0.009/min
Phone: +1 (647) 891-5426
Email: ykhan@duologuecommunications.com
ykhan
 
Posts: 352
Joined: Thu Jun 08, 2006 4:47 pm

thanks

Postby brett05 » Wed Dec 02, 2009 6:18 pm

the filed is enought i think
for exemple for the name filed what you will put as name "255 character" :D
or i think the are no risk just change the vicidial.php and mysql table for this.
good chance
Jasperreports & Queuemetrics & SugarCRM integration - Customization and Add-ons
Freepbx||Billing||Centos||Opensuse||Debian||Centos||Fedora||Sangoma||Diguim
brett05
 
Posts: 571
Joined: Sun May 24, 2009 5:48 pm
Location: tunisia

Postby mflorell » Wed Dec 02, 2009 11:30 pm

You might have to change vicidial.php because there are most likely some MAXLENGTH parameters in the INPUT elements which would truncate that data.
mflorell
Site Admin
 
Posts: 18384
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby williamconley » Wed Dec 02, 2009 11:31 pm

The risks are very small for changing the length. Just don't add any new fields or change their types or names or order.

And do a backup or mysqldump before you do it.

And remember what it was before you changed it so you can change it back if need be.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20256
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Postby ykhan » Mon Dec 07, 2009 12:57 pm

Thanks, I will work on it and update the results soon.
Yousaf Khan
For installation and Support.
VoIP to North America from $0.009/min
Phone: +1 (647) 891-5426
Email: ykhan@duologuecommunications.com
ykhan
 
Posts: 352
Joined: Thu Jun 08, 2006 4:47 pm


Return to ViciDialNow - GoAutoDial

Who is online

Users browsing this forum: No registered users and 83 guests