Skip to content

Instantly share code, notes, and snippets.

View betobaz's full-sized avatar

Betobaz betobaz

37 followers · 86 following
  • Betobaz
  • Veracruz, Mexico
View GitHub Profile
@betobaz
betobaz / app.js
Created December 16, 2011 22:41
node.js Upload file formidable
/**
* Module dependencies.
*/
var express = require('express')
, routes = require('./routes')
, stylus = require('stylus')
, util = require('util')
//, form = require('connect-form')
@betobaz
betobaz / modify_config_db_sugarcrm
Created March 24, 2012 15:37
modificación configuración base de datos sugarcrm
...
array (
'db_host_name' => <nombre del host>,
'db_host_instance' => <nombre de la instancia>,
'db_user_name' => <nombre de usuario>,
'db_password' => <password>,
'db_name' => <nombre de la base de datos>,
'db_type' => 'mssql', //El tipo de la base de datos
),
...
@betobaz
betobaz / sugar git init
Created March 24, 2012 15:38
sugar git init
#cd sugar_dir
#git init
#git add .
#git commit -m "primer commit de sugar de pruebas"
@betobaz
betobaz / gist:2184553
Created March 24, 2012 15:56
codigo para pasar la comprobación de archivos al actualizar sugar crm
handleUploadCheck('systemCheck', true);
if(!true) return;
upgradeP('systemCheck', false);
document.getElementById('form').step.value='2';
handlePreflight('systemCheck');
document.getElementById('form').submit();
@betobaz
betobaz / gist:2185627
Created March 24, 2012 17:56
comando silentupgrade
php.exe -f silentUpgrade.php [upgradeZipFile] [logFile] [pathToSugarInstance] [adminUser]
@betobaz
betobaz / gist:2186218
Created March 24, 2012 18:35
comando silentupgrade sustituyendo valores
php.exe -f silentUpgrade.php "c:\upgrades\SugarCE-6.2.x-to-6.4.0.zip" "c:\upgrades\silent_upgrade.log" "c:\xampp\htdocs\sugarcrm_test" "admin"
@betobaz
betobaz / gist:2186318
Created March 24, 2012 18:39
inicia silentupgrade sugarcrm
********************************************************************
***************This Upgrade process may take sometime***************
********************************************************************
@betobaz
betobaz / gist:2186431
Created March 24, 2012 18:43
success upgradesilent
********************************************************************
*************************** SUCCESS*********************************
********************************************************************
******** If your pre-upgrade Leads data is not showing ************
******** Or you see errors in detailview subpanels ****************
************* In order to resolve them ****************************
******** Log into application as Administrator ********************
******** Go to Admin panel ****************************************
******** Run Repair -> Rebuild Relationships **********************
********************************************************************
@betobaz
betobaz / Sugar moduleAuditAudit.php query to get change log
Created March 29, 2012 15:58
Sugar query to get change log
$query = "SELECT ".$focus->get_audit_table_name().".*, users.user_name FROM ".$focus->get_audit_table_name().", users WHERE ".$focus->get_audit_table_name().".created_by = users.id AND ".$focus->get_audit_table_name().".parent_id = '$focus->id'".$order;
@betobaz
betobaz / gist:2254176
Created March 30, 2012 19:13
Problema con la conversión de fecha en Sugar CRM CE 6.4.2 para el modulo de Audit
03/30/12 13:03:52 [3624][1][INFO] Query:SELECT cases_audit.*, users.user_name FROM cases_audit, users WHERE cases_audit.created_by = users.id AND cases_audit.parent_id = N'b3a8bf26-94ff-4746-9512-4f76021bafca' order by cases_audit.date_created desc
03/30/12 13:03:52 [3624][1][INFO] Query Execution Time:0.0003509521484375
03/30/12 13:03:52 [3624][1][ERROR] convert: Conversion of 2012-03-30 18:59:02.000 from Y-m-d H:i:s to Y-m-d H:i failed
03/30/12 13:03:52 [3624][1][ERROR] convert: Conversion of 2012-03-30 18:58:56.000 from Y-m-d H:i:s to Y-m-d H:i failed
03/30/12 13:03:52 [3624][1][DEBUG] Hook called: Audit::after_ui_frame