Mochabomb

Had to fix some parts of the site today:
* mod security – body limit was gagging up phpmyadmin – vtiget with 300+ tables hitting the limit in modsecurity_crs_10_config.conf: SecResponseBodyLimit 524288 – changed to larger…

Also fixed some suphp stuff, and fixed the db names for the vtiger forms – things ought to be better now – pages are working.. Thanks for commenting – an sorry to everyone that visited a broken page..

Vtiger form demo here: http://mochabomb.com/Demo/cms/index.php?option=com_vtwebform&module=Lead

Anything else broken, please comment below – thanks!

The fastest way to update your password if you forget is to edit the MYSQL database file. I tried a number of other things and then this finally worked. Thanks to another posting!

1. Open phpMyAdmin
2. Select the correct database
3. Edit “vtiger_users” table
4. Edit the field user_password=’adpexzg3FUZAk’
5. Edit the filed user_hash=’21232f297a57a5a743894a0e4a801fc3′
6. Edit the filed confirm_password=’adoY/6Mlw8kqg’
7. login with admin/admin

This is taken from here at the VTiger forum

Today I added a custom column to our vtiger install we use at Direct Finance – a custom data field: Loan Purpose. I added this custom field to Accounts, Leads and Contacts and Potentials – then mapped them to eachother (so data was kept as lead was converted).

Now in looking at leads, accounts, or contacts, I want to sort by that new field – but it’s not sortable by default – neither are the created and modified times – would be useful to sort by date modified or created…

1. Using phpmyadmin ( or something like it ) find the field name in the table of interest – for vtiger_accounts it was a new custom field called cf_461 – make sure to use the database field name, not the field label.

2. Edit Accounts.php, Contacts.php, and Leads.php (note the file name is the module name ending in “s” ) this is the line to modify:
var $sortby_fields = Array('accountname','city','website','phone','smownerid');
to something like:
var $sortby_fields = Array('cf_461','createdtime','accountname','city','website','phone','smownerid');

Now you can sort by your new custom field – or any field in that module when a custom view is created.

Needed to create custom views that included the Invoice ID – seems to make sense.

The user “rexkenley” fixed it and posted here (Thanks!!!)

Just ensure that the field label is blank when inserting this into the vtiger_field table

INSERT INTO `vtiger_field` ( `tabid` , `fieldid` , `columnname` , `tablename` , `generatedtype` , `uitype` ,
`fieldname` , `fieldlabel` , `readonly` , `presence` , `selected` , `maximumlength` , `sequence` , `block` ,
 `displaytype` , `typeofdata` , `quickcreate` , `quickcreatesequence` , `info_type` )
VALUES ('23', NULL , 'invoiceid', 'vtiger_invoice', '1', '80', '', 'Invoice ID', '1', '0', '0', '100', '1', '69', '1', 'I~O',
 '1', NULL , 'BAS'