Skip to content

Instantly share code, notes, and snippets.

View cfalzone's full-sized avatar

Christopher Falzone cfalzone

  • Aquent
  • Erie County, PA
View GitHub Profile
[28/01/13 10:43:53:698 EST] ERROR viewtools.BrowserAPI: Thre Exception Getting Link Map for com.dotmarketing.portlets.links.model.Link@dfaf7c2d
java.lang.NullPointerException
at com.dotmarketing.business.VersionableAPIImpl.isLive(VersionableAPIImpl.java:178)
at com.dotmarketing.beans.WebAsset.isLive(WebAsset.java:73)
at com.dotmarketing.beans.WebAsset.getMap(WebAsset.java:244)
at com.dotmarketing.portlets.links.model.Link.getMap(Link.java:257)
at com.dotmarketing.viewtools.BrowserAPI.getFolderContent(BrowserAPI.java:273)
at com.dotmarketing.portlets.browser.ajax.BrowserAjax.getFolderContent(BrowserAjax.java:266)
at com.dotmarketing.portlets.browser.ajax.BrowserAjax.openFolderContent(BrowserAjax.java:254)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[20/02/13 16:17:00:981 EST] FATAL startup.StartupTasksExecutor: Unable to execute the upgrade task : Task00780UUIDTypeChange
com.dotmarketing.exception.DotDataException: Error on rename of './dotcms_prod_22/#sql-51e5_24' to './dotcms_prod_22/cms_role' (errno: 150)
at com.dotmarketing.startup.AbstractJDBCStartupTask.executeUpgrade(AbstractJDBCStartupTask.java:193)
at com.dotmarketing.startup.StartupTasksExecutor.executeUpgrades(StartupTasksExecutor.java:260)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:117)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4187)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4496)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
sed 's/latin1/utf8/' aquent_195backup.sql >aquent_195backup_utf8.sql
alter database aquent_dotcms charset=utf8;
--Identifiers
update identifier set asset_type = 'links' where id in (select identifier FROM links) and asset_type not like 'links';
update identifier set asset_type = 'htmlpage' where id in (select identifier FROM htmlpage) and asset_type not like 'htmlpage';
update identifier set asset_type = 'file_asset' where id in (select identifier FROM file_asset) and asset_type not like 'file_asset';
delete from identifier where host_inode = '0' and asset_type = 'links' and id in (select identifier FROM links);
delete from identifier where host_inode = '0' and asset_type = 'htmlpage' and id in (select identifier FROM htmlpage);
delete from identifier where host_inode = '0' and asset_type = 'file_asset' and id in (select identifier FROM file_asset);
--HTML Pages
delete from htmlpage_version_info where identifier in (select id from identifier where asset_type = 'htmlpage' and id not in (select identifier from htmlpage));
--Identifiers
update identifier set asset_type = 'links' where id in (select identifier FROM links) and asset_type not like 'links';
update identifier set asset_type = 'htmlpage' where id in (select identifier FROM htmlpage) and asset_type not like 'htmlpage';
update identifier set asset_type = 'file_asset' where id in (select identifier FROM file_asset) and asset_type not like 'file_asset';
delete from identifier where host_inode = '0' and asset_type = 'links' and id in (select identifier FROM links);
delete from identifier where host_inode = '0' and asset_type = 'htmlpage' and id in (select identifier FROM htmlpage);
delete from identifier where host_inode = '0' and asset_type = 'file_asset' and id in (select identifier FROM file_asset);
--HTML Pages
delete from htmlpage_version_info where identifier in (select id from identifier where asset_type = 'htmlpage' and id not in (select identifier from htmlpage));
[06/03/13 11:42:24:143 MST] ERROR [/].[jsp]: Servlet.service() for servlet jsp threw exception
org.dom4j.DocumentException: aurora.healthonecares.photobooks.com Nested exception: aurora.healthonecares.photobooks.com
at org.dom4j.io.SAXReader.read(SAXReader.java:484)
at org.dom4j.io.SAXReader.read(SAXReader.java:291)
at com.dotmarketing.viewtools.XmlTool.read(XmlTool.java:160)
at com.dotmarketing.viewtools.XmlTool.read(XmlTool.java:151)
at com.dotmarketing.viewtools.XmlTool.read(XmlTool.java:214)
at org.apache.jsp.xmltest_jsp._jspService(xmltest_jsp.java:67)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
private void cleanHostFromSitemapFiles(Host host){
FolderAPI folderAPI = APILocator.getFolderAPI();
FileAPI fileAPI = APILocator.getFileAPI();
Folder folder = null;
try {
folder = folderAPI.findFolderByPath(XML_SITEMAPS_FOLDER, host, systemUser, true);
} catch(Exception e) {
Logger.error(this, "Not able to find the folder", e);
@cfalzone
cfalzone / server.jsp
Last active December 15, 2015 00:59
server.jsp
<%@page import="java.text.SimpleDateFormat"%>
<%@page import="java.text.DateFormat"%>
<%@page import="java.util.Calendar"%>
<%@page import="com.liferay.portal.util.ReleaseInfo"%>
<%@page import="com.liferay.portal.language.LanguageUtil"%>
<%@page import="com.dotmarketing.util.UtilMethods"%>
<%@page import="com.dotmarketing.util.Config"%>
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
@cfalzone
cfalzone / gist:5356502
Last active December 16, 2015 01:39
Just an example using Twiter4J in a Velocity ViewTool
public class TwitterTool implements ViewTool {
private Twitter twitter;
private boolean inited = false;
public void init(Object initData) {
try {
twitter = new TwitterFactory().getInstance();
inited = true;
} catch (Exception e) {
@cfalzone
cfalzone / days-in-month.vtl
Created April 16, 2013 16:20
Getting the number of days in the month in Velocity
## Get a Date object for today
#set($today = $date.getDate())
## Get a Calendar Object
#set($cal = $date.getCalendar())
## Set the Calendar Object to today
#set($_x = $cal.setTime($today))
##get the number of days in the month: