Skip to main content

How to add a new column to vtiger existing table


When we add a new column to existing vtiger table, we need do more than just adding a column to selected vtiger table. If you do so, you may unable to do some DB operation like insert update and deleted. This is the way how we can do this.

1. Add a new column to selected table as normal
2. Add a new row to "vtiger_field" table as fallow


  
"insert into vtiger_field values (tabid, fieldid, columnname, tablename,
generatedtype, uitype, fieldname, 
fieldlabel, readonly, presence, selected,maximumlength, sequence, 
block, displaytype, typeofdata, quickcreate,quickcreatesequence, info_type)"


When you set a value to "presence" field be make sure to select 0 or 2. Otherwise your selected field not populated with vtiger field list.
Labels:

Comments

  1. gumuruhsspjNovember 18, 2010 at 6:55 PM

    wow! That's I never realized it.
    But anyway, Wat about if we do creating Field
    from the User Interface.

    Well, go to Settings | Module Manager |
    Custom | Add Block. That's it!
    We add new fields from there.

    Have u ever used this to add new field as unique?

    ReplyDelete
  2. AnonymousApril 11, 2012 at 8:59 PM

    I did that, but when I create/modified a record, the change didn't save the information in the new field...what's wrong?

    ReplyDelete
  3. UnknownMay 19, 2013 at 6:23 AM

    Hello friends!
    Can you help me please.
    I created field in vtiger_field table with uitype 51. But when i choose value in my module, it does'n save value in vtiger_mymodulename.
    What can i do else?
    I hope you will help me. Thanks

    ReplyDelete
  4. singhFebruary 16, 2014 at 11:39 PM

    after that not show the field

    ReplyDelete

Post a Comment

Popular posts from this blog

How to extract vtiger DB data

Here is the code sample how extract data form vtiger DB with WHERE close. Sample:1 require_once('include/DatabaseUtil.php'); global $adb; $tabid = array('9','16'); $sql = "SELECT tabid, fieldname, fieldid, fieldlabel,columnname, tablename, uitype, typeofdata, presence FROM vtiger_field WHERE tabid in (" . generateQuestionMarks($tabid) . ")"; $result = $adb->pquery($sql, array($tabid)); // get result $noofrows = $adb->num_rows($result); // get number of rows $i=0; $data=array(); while($resultrow = $adb->fetch_array($result)) { $tabid=$resultrow['tabid']; $resultrow=['fieldlabel']; $data[$i]=array($tabid, $resultrow); } Sample:2 require_once('include/DatabaseUtil.php'); global $adb; $query = 'select idlists,from_email,to_email,cc_email,bcc_email from vtiger_emaildetails where emailid =?'; $result = $adb->pquery($query, array($focus->id)); $from_email = $adb->query_result($result,0,'from_...
Post a Comment
Read more

Ananda

Current Software Engineer at LM Jinasena and Company (PVT) LTD Past Software Engineer at Archmage (PVT) LTD Trainee software Engineer at Respere ( Sahana Company ) Education Faculty of Information technology, University of Moratuwa ( http://www.mrt.ac.lk/ )- 2005/2006 batch Dammissara National school Naththandia (2004-Maths section) Websites My Blog Facebook Ananda’s Summary I am a graduate of Faculty of Information technology University Of Moratuwa and keen on web development field and specialized on IT management. Ananda’s Specialties: Technology: Pervasive computing, mobile backend solutions, mobile solutions, GIS, neo-geography, Location based services, Web 2.0, Social web,FOSS, Disaster Management Solutions Organizational: Strategic Planning, Project Management, Business Development, New Product strategy Ananda’s Experience Software Engineer, LM Jinasena and Company (PVT) LTD L M Jinasena and Company (PVT) LTD Aug 2010 — Present Software Engineer, Archmage (PVT) LTD Archmage (...
Read more

Terminal Hand Book (Ubuntu)

Introduction In traditional UNIX environment using CLI (Command Line Interface) is more interesting and powerful other than using GUI. Specially if some one have to work with UNIX server edition without GUI he has to face big difficulty if he is poor with CLI. With new versions of ubuntu it is providing GUI interface to replace CLI commands. Any way still there are some hidden terminal commands that forgot to GUI, so that having good knowledge of CLI is important. 1. Commands for configure softwares Description Command Install software sudo apt-get install [PackageName] Install ALL the required components using 1 single command sudo tasksel Run .sh (shell commands) files sudo sh filename.sh 2.Monitor Ubuntu software processes Description Command List all process currently running ps aux List selected packge's processes ps aux | grep [package name] many more 3.Common File Operations Description Command Rem...
1 comment
Read more