On a CentOS 6.x linux box, typing the following will show the MySQL version
or if not the root user, then
mysql -u root -p -v
(Which says user the root user, prompt for the password, then get the version).
Act! (now owned by Swiftpage) will have an updated emarketing platform builtin to the next release of Act! 16.1. I know many who will be eager to test this out.
There are changes to the Australian Privacy Laws.
Details here: www.oaic.gov.au.
This does raise some questions around where you’re hosting data. If you’re using the ‘cloud’ (Google Drive/Apps, hosted CRM, Virtual Servers etc) then you may want to read up and make sure you’re not setting yourself up for a problem.
The Perfect Web Development Environment for Your New Mac. Great set of instructions, worked for me.
Have Talend Open Studio running on a Windows server, however, when we run a job, it gives an error similar to the below:
Execution failed : Failed to generate code.
[No .class file created for file org\talend\designer\codegen\translators\processing\TMapMainJava$1.class in C:/Talend/TOS_DI-Win32-r111943-V5.4.1/workspace/.JETEmitters/runtime because of an IOException: C:\Talend\TOS_DI-Win32-r111943-V5.4.1\workspace\.JETEmitters\runtime\org\talend\designer\codegen\translators\processing\TMapMainJava$1.class (Access is denied)
It turns out that the windows file permissions are not set correctly, by giving the Windows Users Full permissions to the file mentioned in the error message, the error resolves. Note that if this is the case there may be a number of files with the wrong permissions.
I’m needing to do a sql query to show just the opportunities from the current month, the sql snippet for the WHERE clause to do this is the following:
WHERE MONTH(opportunities.date_closed) = MONTH(NOW()) and YEAR(opportunities.date_closed) = Year(now())
Using SugarCRM (this client is using Enterprise 6.5.15) and we want the last two hundred items in the tracker table. The problem is that the `tracker`.`date_modified` field is in UTC time, not the local time zone, which is +10:00.
The solution is to use the CONVERT_TZ MySQL command, as shown in the example below. It will convert between timezones for you.
SELECT `users`.`user_name` AS "User",
`tracker`.`module_name` AS "Module",
`tracker`.`item_summary` AS "Summary",
`tracker`.`action` AS "Action",
CONVERT_TZ(`tracker`.`date_modified`,'+00:00','+10:00') AS "Modified"
INNER JOIN `tracker` ON
`users`.`id` = `tracker`.`user_id`
WHERE `tracker`.`deleted` = 0
ORDER BY `tracker`.`date_modified` DESC
…digitally signing allows them to confirm you as the sender and verify the message was not tampered with en route…
We want to record a ‘Year’ value on a record in SugarCRM, but we don’t have a day and month to do with it, you can’t use a field that is of a ‘date’ type as that requires a full date (year, month, day).
You can use an ‘Integer’ field type tho. The downside is that it displays a thousands separator. i.e. it’ll show 2,014 instead of 2014.
To fix this, tick the Disable Format check box in Studio. This will remove the thousand separator.
[The four horsemen of mediocrity](http://sethgodin.typepad.com/seths_blog/2014/01/the-four-horsemen-of-mediocrity.html)
I’m using GeekTool to display some key time zones on my wallpaper, which happens to include world map.
The key to this is to add Shell Geeklets using a command similar to this:
env TZ=Pacific/Auckland date +'%l:%M %p %A'
I was just sent a link to this (source). Funny :).