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

Debugging PHP with Netbeans

Most of the PHP developers are complaining that they have not a good ID for PHP debugging and every time that they have to use var_dump() print statement or PHP die or exit commands to check the state of php script. But now we can use netbeans to overcome this issue with netbeans-xdebug. I tried this with Linux and feel that working it cool. Anyway still I had not a time to try out this with windows and hope that netbeans-xdebuger working fine with windows also. Now I am going to explain how we can enable netbeans-xdebuger in Ubuntu 1. First we should have a netbeans installation package (Download from here ) 2. After installing Netbeans we can install xdebuger. To do that open terminal and type fallowing commands. sudo apt-get install php5-dev php-pear sudo pecl install xdebug 3. Now you have installed xdebug successfully but not configure with PHP yet. To Configure xdebuger with php and netbeans ID. open php.ini file using this command; sudo gedit /etc/php5/apache2/php.ini A...
Post a Comment
Read more

Unix VS Linux

Free Software says that people have freedom to share software and related technology free without any hesitating. And also this may enable the rapid software development because all brains become to one stage and play the game. On a technical level, Free software grantees the right view and also modify source code if some one need different think as his view. In this post I am not going to deeply discuss about what Unix is and What Linux but here lats we talk about some interesting happenings around Unix and Linux What is Unix. In 1980, A computer scientist called Richard Stallman decided to create a venerable operating system called Unix. At the time Unix ran many of industrial and academic system in the world. He started developing Unix operating system and most of the world wide people join with him to success this operating system. Stallman called his version as "GNU" (Pronounced G-noo). This was start of GNU but not Unix, any way this was the new legendary of Unix so th...
1 comment
Read more