A little something about everything

This is caused by a database design issue in PIWIK, you can fix it by opening MySQL workbench or phpmyadmin and editing the database table column as follows.

As you can see we've edited the piwik_log_link_visit_action.idlink_va design "Data Type" from INT(11) to BIGINT(11). 

INT is too small to run larger segments, so we need to switch it to BIGINT, the number just specifies the columns "display width" when output.

BIGINT

8 Bytes, -2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807)

INT 

4 Bytes, -2^31 (-2,147,483,648) to 2^31-1 (2,147,483,647)

After you've done this apply and rerun your reports from either opening the piwik stats page or by command line, cron job, task manager task if you have one of these setup.

If using windows server, you can setup a batch file to run via task manager every 15 minutes or as needed depending on traffic and number of sites your run stats for. Here is what you update.bat file should looke like

mode con: cols=140 lines=40
php "(Drive):\PathtoPWIKwebsite\console" core:archive
timeout 30

Now set windows task manager to run this every x number of minutes.

That's it your done.

This error can be caused by not installing the related Visual C++ Redistributable for Visual Studio

• For PHP 7.x use Visual C++ Redistributable for Visual Studio 2015 (x86 or x64 respectively)
• https://www.microsoft.com/en-us/download/confirmation.aspx?id=48145
• For PHP 5.6 use Visual C++ Redistributable for Visual Studio 2011 (x86 or x64 respectively)
• http://www.microsoft.com/en-us/download/details.aspx?id=30679
• For PHP 5.4 use Visual C++ Redistributable for Visual Studio 2009 (x86 or x64 respectively)
• http://www.microsoft.com/en-us/download/details.aspx?id=5582

Quick step by step of how to export a mailbox directly from exchange 2013 ECP/EAC.

1. Be sure you have a share setup and ready to export to
• This will require access to the server directly if you have not already done so. So \\SERVERNAME\SHARE for example.
2. Login to your SERVER via ECP
• Select Permissions
• Double click(Edit) "Recipient Management"
• Select + under "Roles" and choose "Mailbox Import Export"
• Select + under "Members" and choose the user you want to be able to manage mailbox exports with.
• Click "Save"
• Click "Recipents"
• Chose the mailbox/user you wish to export to .pst 
• Choose "∙∙∙" then select "Export to PST File"
• Choose the type of export, main mailbox or archive then choose next
• Enter the share you wish to export to ie \\SERVERNAME\SHARE\mailbox(archive).pst
• Choose if you want a notification once its done.
3. Once its complete the PST file will be in the share.

In order to target a div you can do so by id or by class, for example

<div id="centerme" class="centerit">some content</div>

here is the css:

#centerme {
left: 50%;
top: 50%;
transform: translate(-50%, -50%);
/* in some cases you may want to give it a width and height first */
height:100%;
max-height: 10rem;
width: 100%;
max-height: 20rem;
}
/* another option only vertical via class rather than id */
.centerit {
top: 50%;
transform: translateY(-50%);
}
/* or only horizontal  */
.centerit {
left: 50%;
transform: translateX(-50%);
}

That's it!

Simple script to show and hide multiple div's

Example:

Spotlight 1, Spotlight 2, Spotlight 3

<script language="javascript">
function getElementsByClass( searchClass, domNode, tagName) {
	if (domNode == null) domNode = document;
	if (tagName == null) tagName = '*';
	var el = new Array();
	var tags = domNode.getElementsByTagName(tagName);
	var tcl = " "+searchClass+" ";
	for(i=0,j=0; i<tags.length; i++) {
		var test = " " + tags[i].className + " ";
		if (test.indexOf(tcl) != -1)
			el[j++] = tags[i];
	}
	return el;
}
function ShowHide(bioname) {
	var bios = getElementsByClass('bio');
	for(i=0; i<bios.length; i++)
		bios[i].style.display = 'none';
	document.getElementById(bioname).style.display='block';
}
</script>
<style>
#bio2,#bio3 {
	display: none;
}
</style>
<p>Simple script to show and hide multiple div's</p><p>Example:</p>
<p>
<a href="#" onclick="ShowHide('bio1');">Spotlight 1</a>,
<a href="#" onclick="ShowHide('bio2');">Spotlight 2</a>, 
<a href="#" onclick="ShowHide('bio3');">Spotlight 3</a></p>
<div id="bio1" class="bio" style="width:400px;margin:10px;padding:10px;border:1px solid #000;box-shadow: 0 0 5px #000;"><h4 style="color:#000;">Spotlight 1 content</h4>
</div>
<div id="bio2" class="bio" style="width:400px;margin:10px;padding:10px;border:1px solid #f00;box-shadow: 0 0 5px #f00;"><h4 style="color:#f00;">Spotlight 2 content</h4>
</div>
<div id="bio3" class="bio" style="width:400px;margin:10px;padding:10px;border:1px solid #0f0;box-shadow: 0 0 5px #0f0;"><h4 style="color:#0f0;">Spotlight 3 content</h4>
</div>