installing update

Update cbupd-0000448: addQueryTypePicklistTocbQuestion::addQueryTypePicklistTocbQuestion
Adding Query Type picklist to cbQuestion.

Fatal error: Uncaught Error: Call to a member function FetchRow() on bool in /home/XXXXXXX/include/database/PearDatabase.php:607 Stack trace: #0 /home/XXXXXXX/build/changeSets/2022/addQueryTypePicklistTocbQuestion.php(50): PearDatabase->fetch_array(false) #1 /home/XXXXXXX/modules/cbupdater/dowork.php(85): addQueryTypePicklistTocbQuestion->applyChange() #2 /home/XXXXXXXX/index.php(471): include_once('/home/gogo/vt.g...') #3 {main} thrown in /home/XXXXXXXX/include/database/PearDatabase.php on line 607


coreBOS 8.0 (d6be0b01020221005)

FYI
Lorenzo

Hi All
I don't understand how to create a custom field like Term and Conditions in quote module.

in quote Module i can Choose Termand condition in a Field (tandc
vtiger_quotes:tandc:tandc:Quotes_Terms_and_Conditions:I~O)

and this choose fill automatically the field (terms_conditions Text Area 65535
vtiger_quotes:terms_conditions:terms_conditions:Quotes_Terms_&_Conditions:V~O)

is possible to create other field like this, and ( i suppose the answer) using html format?

i Would like this, because i use quote e gendoc to send the Quote, but i need to insert something like service description

Other way is to create a Fake product whit a long description, and print this description.

or i don't know how gendoc can generate the pdf document and in the same time add specific sheet of an other formatted pdf.

i hope anyone has an idea.
regards
Lorenzo

Hi All
Is This only a warning?
tnx to all
Lorenzo


Update cbupd-0000446: delUitype105UserImageField::delUitype105UserImageField
Delete uitype 105 to support image fields on Users module.
ADORecordSet_empty   S  UPDATE vtiger_field SET uitype='69' WHERE vtiger_field.fieldid=?;  Array ( [0] => 514 )
 F  ALTER TABLE vtiger_seattachmentsrel DROP FOREIGN KEY fk_2_vtiger_seattachmentsrel
ADORecordSet_empty S DROP TABLE vtiger_salesmanattachmentsrel
Changeset delUitype105UserImageField applied!
Failed Queries Log
ALTER TABLE vtiger_seattachmentsrel DROP FOREIGN KEY fk_2_vtiger_seattachmentsrel
Total Number of queries executed : 3
Queries Succeeded : 0
Queries Failed : 1

Attached Files

Thumbnail(s)
   

Hello,

I would like to change InventoryDetails reference field to something more relevant than the entity's number. It is important especially in the mobile interface where only 1 field is shown in 'listview'.
Any help is appreciated.

Thank you.

This is a custom workflow task from PDFMaker, so maybe there is an issue there. They've copied the stock e-mail task and all the variables. Now when I set an e-mail address in the 'From' field, the e-mails still get sent with the e-mail address that is set globally in the outgoing mail server settings in the 'From' header. Is this expected behavior? Any way to change it?

I want to hide some fields, purely visually. So I want users to have the same rights on those fields, I want workflows and other code to be able to have the same rights on the fields as they have now: I only want to have the fields hidden from the regular detailview. Now I can set their 'presence' column to 1, but that doesn't feel like the way to go. I don't want to disable them in the profile, since that might disable access to the fields for that profile, while it can be needed for some background processes.

So: purely visually. What is the best way to do that.

Hi All for your information

Update cbupd-0000443: dropForeignKeys::dropForeignKeys
Drop Foreign Keys
F
ALTER TABLE vtiger_account DROP FOREIGN KEY fk_1_vtiger_account
F
ALTER TABLE vtiger_accountbillads DROP FOREIGN KEY fk_1_vtiger_accountbillads
F
ALTER TABLE vtiger_accountscf DROP FOREIGN KEY fk_1_vtiger_accountscf
F
ALTER TABLE vtiger_accountshipads DROP FOREIGN KEY fk_1_vtiger_accountshipads
F
ALTER TABLE vtiger_activity DROP FOREIGN KEY fk_1_vtiger_activity
F
ALTER TABLE vtiger_assets DROP FOREIGN KEY fk_1_vtiger_assets
F
ALTER TABLE vtiger_campaignscf DROP FOREIGN KEY fk_1_vtiger_campaignscf
F
ALTER TABLE vtiger_contactaddress DROP FOREIGN KEY fk_1_vtiger_contactaddress
F
ALTER TABLE vtiger_contactdetails DROP FOREIGN KEY fk_1_vtiger_contactdetails
F
ALTER TABLE vtiger_contactscf DROP FOREIGN KEY fk_1_vtiger_contactscf
F
ALTER TABLE vtiger_contactsubdetails DROP FOREIGN KEY fk_1_vtiger_contactsubdetails
F
ALTER TABLE vtiger_faq DROP FOREIGN KEY fk_1_vtiger_faq
F
ALTER TABLE vtiger_faqcf DROP FOREIGN KEY fk_1_vtiger_faqcf
F
ALTER TABLE vtiger_invoice DROP FOREIGN KEY fk_2_vtiger_invoice
F
ALTER TABLE vtiger_invoicebillads DROP FOREIGN KEY fk_1_vtiger_invoicebillads
F
ALTER TABLE vtiger_invoicecf DROP FOREIGN KEY fk_1_vtiger_invoicecf
F
ALTER TABLE vtiger_invoiceshipads DROP FOREIGN KEY fk_1_vtiger_invoiceshipads
F
ALTER TABLE vtiger_invoicestatushistory DROP FOREIGN KEY fk_1_vtiger_invoicestatushistory
F
ALTER TABLE vtiger_leadaddress DROP FOREIGN KEY fk_1_vtiger_leadaddress
F
ALTER TABLE vtiger_leaddetails DROP FOREIGN KEY fk_1_vtiger_leaddetails
F
ALTER TABLE vtiger_leadscf DROP FOREIGN KEY fk_1_vtiger_leadscf
F
ALTER TABLE vtiger_leadsubdetails DROP FOREIGN KEY fk_1_vtiger_leadsubdetails
F
ALTER TABLE vtiger_notes DROP FOREIGN KEY fk_1_vtiger_notes
F
ALTER TABLE vtiger_parenttabrel DROP FOREIGN KEY fk_1_vtiger_parenttabrel
F
ALTER TABLE vtiger_parenttabrel DROP FOREIGN KEY fk_2_vtiger_parenttabrel
F
ALTER TABLE vtiger_pobillads DROP FOREIGN KEY fk_1_vtiger_pobillads
F
ALTER TABLE vtiger_poshipads DROP FOREIGN KEY fk_1_vtiger_poshipads
F
ALTER TABLE vtiger_potential DROP FOREIGN KEY fk_1_vtiger_potential
F
ALTER TABLE vtiger_potentialscf DROP FOREIGN KEY fk_1_vtiger_potentialscf
F
ALTER TABLE vtiger_pricebook DROP FOREIGN KEY fk_1_vtiger_pricebook
F
ALTER TABLE vtiger_pricebookcf DROP FOREIGN KEY fk_1_vtiger_pricebookcf
F
ALTER TABLE vtiger_productcf DROP FOREIGN KEY fk_1_vtiger_productcf
F
ALTER TABLE vtiger_products DROP FOREIGN KEY fk_1_vtiger_products
F
ALTER TABLE vtiger_purchaseorder DROP FOREIGN KEY fk_4_vtiger_purchaseorder
F
ALTER TABLE vtiger_purchaseordercf DROP FOREIGN KEY fk_1_vtiger_purchaseordercf
F
ALTER TABLE vtiger_quotesbillads DROP FOREIGN KEY fk_1_vtiger_quotesbillads
F
ALTER TABLE vtiger_quotescf DROP FOREIGN KEY fk_1_vtiger_quotescf
F
ALTER TABLE vtiger_quotesshipads DROP FOREIGN KEY fk_1_vtiger_quotesshipads
F
ALTER TABLE vtiger_quotestagehistory DROP FOREIGN KEY fk_1_vtiger_quotestagehistory
F
ALTER TABLE vtiger_salesorder DROP FOREIGN KEY fk_3_vtiger_salesorder
F
ALTER TABLE vtiger_salesordercf DROP FOREIGN KEY fk_1_vtiger_salesordercf
F
ALTER TABLE vtiger_service DROP FOREIGN KEY fk_1_vtiger_service
F
ALTER TABLE vtiger_sobillads DROP FOREIGN KEY fk_1_vtiger_sobillads
F
ALTER TABLE vtiger_soshipads DROP FOREIGN KEY fk_1_vtiger_soshipads
F
ALTER TABLE vtiger_ticketcf DROP FOREIGN KEY fk_1_vtiger_ticketcf
F
ALTER TABLE vtiger_troubletickets DROP FOREIGN KEY fk_1_vtiger_troubletickets
F
ALTER TABLE vtiger_vendor DROP FOREIGN KEY fk_1_vtiger_vendor
F
ALTER TABLE vtiger_vendorcf DROP FOREIGN KEY fk_1_vtiger_vendorcf
Changeset dropForeignKeys applied!
ERROR: Class dropForeignKeys called without update record in application!!

bye all
Lorenzo

Ok all you geniuses

I am trying to fresh install on a godaddy server.  

I have done my best to meet all the requirements on the install page and have confirmed most PHP and Mysql settings with Godaddy tech.

I used Git Version control in Cpanel to make a repository from the corebos git which it made at
/home/**********/repositories/corebos

This is not in my public HTML part of the site but in the main directory.

I have not yet checked the permissions on this folder or run the install.

I am making sure that I am doing this correctly one step at a time so I don't screw it up

Do I work directly with this directory?  OR is this something I copy to some place else?  From what I understand the Git Version Control can update from Git whenever I want but I don't want to goof up the setup if I am supposed to work with a copy of it. (if that makes sense)

What should my next step be?

Thanks again for your wisdom and help

Below are my server settings for just to double check

cPanel Version 94.0 (build 19)
Apache Version 2.4.54
PHP Version 7.4.27
MySQL Version 5.6.51-cll-lve
Architecture x86_64
Operating System linux
Shared IP Address 173.201.176.176
Path to Sendmail /usr/sbin/sendmail
Path to Perl /usr/bin/perl
Perl Version 5.10.1

Attached Files

Thumbnail(s)
       

Hello,
Would like to ask for a help/advice, as I am not so familiar with Github version control.

Tried to update Corebos using "git pull corebos master". Somehow this ended with MERGE_MSG file opened in edit mode and I was unable to exit from it correctly, so terminated.
After this retied git pull and it showed the message that unfinished process is active, so I have deleted MERGE_MSG file and retried git pull.
Now system shows warning bellow:
---------------------
[root@dsrl corebos]# git pull corebos master
warning: Pulling without specifying how to reconcile divergent branches is
discouraged. You can squelch this message by running one of the following
commands sometime before your next pull:

git config pull.rebase false # merge (the default strategy)
git config pull.rebase true # rebase
git config pull.ff only # fast-forward only

You can replace "git config" with "git config --global" to set a default
preference for all repositories. You can also pass --rebase, --no-rebase,
or --ff-only on the command line to override the configured default per
invocation.

From https://github.com/tsolucio/corebos
* branch master -> FETCH_HEAD
error: Your local changes to the following files would be overwritten by merge:
.github/SECURITY.md Popup.php Smarty/templates/AddProductToPriceBooks.tpl Smarty/templates/AddProductsToPriceBook.tpl Smarty/templates/AdvanceFilter.tpl Smarty/templates/BrowserVariables.tpl Smarty/templates/Components/Components.tpl Smarty/templates/Components/ComponentsJS.tpl Smarty/templates/Components/DetailViewPirvNext.tpl Smarty/templates/Components/Kanban/KanbanHeader.tpl Smarty/templates/Components/MasterDetail/GridBody.tpl Smarty/templates/Components/MasterDetail/GridHeader.tpl Smarty/templates/Components/Paint/index.tpl Smarty/templates/Components/Photo2Doc/index.tpl Smarty/templates/ComposeEmail.tpl Smarty/templates/CustomFieldMapping.tpl Smarty/templates/CustomView.tpl Smarty/templates/DetailView.tpl Smarty/templates/DetailViewUI.tpl Smarty/templates/EditViewUI.tpl Smarty/templates/EmailDetailView.tpl Smarty/templates/Header.tpl Smarty/templates/Inventory/EditViewUI.tpl Smarty/templates/KanbanView.tpl Smarty/templates/ListView.tpl Smarty/templates/ListViewButtons.tpl Smarty/templates/ListViewCustomButtons.tpl Smarty/templates/ListViewEntries.tpl Smarty/templates/ListViewSearch.tpl Smarty/templates/ListViewTUIGrid.tpl Smarty/templates/LoginHeader.tpl Smarty/templates/MailScanner/MailScannerEdit.tpl Smarty/templates/MailScanner/MailScannerRule.tpl Smarty/templates/MailScanner/MailScannerRuleEdit.tpl Smarty/templates/MassCreateGridView.tpl Smarty/templates/MergeFields.tpl Smarty/templates/PivotView.tpl Smarty/templates/Popup.tpl Smarty/templates/PrintEmail.tpl Smarty/templates/PrintReport.tpl Smarty/templates/RelatedListNew.tpl Smarty/templates/RelatedLists.tpl Smarty/templates/ReportContents.tpl Smarty/templates/RolePopup.tpl Smarty/templates/SelectEmail.tpl Smarty/templates/Settings.tpl Smarty/templates/Settings/LayoutBlockEntries.tpl Smarty/templates/Settings/LayoutBlockList.tpl Smarty/templates/Settings/OrderRelatedList.tpl Smarty/templates/TagCloudDisplay.tpl Smarty/templates/com_vtiger_workflow/ActionMenu.tpl Smarty/templates/com_vtiger_workflow/EditTask.tpl Smarty/templates/com_vtiger_workflow/ListWorkflows.tpl Smarty/templates/com_vtiger_workflow/TaskSummaryList.tpl Smarty/templates/com_vtiger_workflow/taskforms/Many2ManyRelation.tpl Smarty/templates/modules/Documents/dropzone.tpl Smarty/templates/modules/Import/Import_Step4.tpl Smarty/templates/modules/Mobile/Header.tpl Smarty/templates/modules/Mobile/Login.tpl Smarty/templates/modules/Mobile/PanelMenu.tpl Smarty/templates/modules/ModComments/widgets/DetailViewBlockComment.tpl Smarty/templates/modules/SMSNotifier/SMSNotifierSelectWizard.tpl Smarty/templates/modules/SMSNotifier/SMSNotifierServerNotAvailable.tpl Smarty/templates/modules/Utilities/clickhouse.tpl Smarty/templates/modules/Utilities/facebook.tpl Smarty/templates/modules/Utilities/mautic.tpl Smarty/templates/modules/Vtiger/Settings.tpl Smarty/templates/modules/Vtiger/phpversionfail.tpl Smarty/templates/modules/VtigerBackup/BackupServer.tpl Smarty/templates/modules/Webforms/DetailView.tpl Smarty/templates/modules/Webforms/EditView.tpl Smarty/templates/modules/Webforms/FieldsView.tpl Smarty/templates/modules/Webforms/HTMLView.tpl Smarty/templates/modules/Webforms/ListView.tpl Smarty/templates/modules/cbLoginHistory/index.tpl Smarty/templates/modules/cbMap/GenMapHeader.tpl Smarty/templates/modules/cbMap/MassUpsertGrid.tpl Smarty/templates/modules/cbQuestion/Builder.tpl Smarty/templates/modules/cbQuestion/Grid.tpl Smarty/templates/modules/evvtgendoc/BasicSettings.tpl Smarty/templates/showSetOfFields.tpl build/HelperScripts/addModComments.php build/HelperScripts/addPhoto2Document.php build/HelperScripts/addQuickRelatedList.php build/HelperScripts/bettersafe.sh build/HelperScripts/checkFieldUsage.php build/HelperScripts/coreBOSEventsLoader.php build/HelperScripts/deleteModule.php build/HelperScripts/evalwf.php build/HelperScripts/export_language_filesystem.php build/HelperScripts/export_package_database.php build/HelperScripts/export_package_filesystem.php build/HelperScripts/importpricebookcsv.php build/HelperScripts
-------------------

Please advice how to proceed.
Should I use git reset -- hard and retry git pull, or do something else.
With Best regards
Svermar

Hello,

I want to see the ToDos(Activities) in a block on the front page of Organizations but it is not available as a Related module block. I have also tested on the online demo and can confirm it. In the modules where you build your own relation it works but in Organizations the relation is already there(Activities) it is just not in the picklist in the Layout Editor.

Any help is appreciated.