WordPress database error: [Duplicate entry '91002' for key 1]
INSERT INTO wp_bas_visitors (visit_ip, referer, osystem, useragent, lasthere) VALUES (644300602, 1, 547, 3795, '2008-11-20 15:15:30');

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND referer = referer_id AND osystem = os_id AND useragent = ua_]
SELECT * FROM wp_bas_visitors, wp_bas_refer, wp_bas_ua, wp_bas_os WHERE visit_id = AND referer = referer_id AND osystem = os_id AND useragent = ua_id

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' '2008-11-20 15:15:30', 0, 1584)' at line 1]
INSERT INTO wp_bas_log (visit, stamp, outbound, page) VALUES (, '2008-11-20 15:15:30', 0, 1584);

Open Intelligence » OpenReports - Help with OLAP examples

OpenReports - Help with OLAP examples

January 30th, 2008

New to OpenReports 3.0 is the ability to create OLAP reports. I’ve noticed a few users have been having trouble getting the example OLAP reports to run on Linux.

A common problem occurs with the Catalog Definition in datasources.xml. This must contain the full path to your Mondrian schema. In the example, the path is:

c:\openreports-tomcat\reports\SampleData.mondrian.xml

If you are running OpenReports on Linux, you must add file:// to the path to indicate the resource is a File, for example:

file:///usr/share/openreports-tomcat/reports/SampleData.mondrian.xml

Entry Filed under: All

3 Comments Add your own

  • 1. Jason Ngo  |  January 31st, 2008 at 4:08 am

    I have trouble configuring datasources.xml for MySQL instead of HSQL in the included examples. I modified URL, DatasourceInfo and Catalog following the recommended file:// convention. I still ended up with the following error.

    avax.servlet.ServletException: javax.servlet.jsp.JspException: Soap Fault code=Server.00HSBE02 fault string=XMLA Discover unparse results error fault actor=Mondrian

    Can you post an example datasources.xml for MySQL?

  • 2. D Beck  |  March 14th, 2008 at 3:42 pm

    Unfortunately after spending many hours searching for a solution I am still not able to run the OLAP examples on OR 3.0.1.
    I have the exact the same error as described in Jason’s post.
    Can somebody help?

  • 3. sailaja  |  May 30th, 2008 at 11:21 am

    i have downloaded openreports3.0 full version and i followed the installation guide and while deploying i am getting that struts-tags file not found so where exactly this file is to be added.if any one knows then please send reply.

Leave a Comment

Required

Required, hidden

Some HTML allowed:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>

Trackback this post  |  Subscribe to the comments via RSS Feed


Calendar

January 2008
M T W T F S S
« Dec   Aug »
 123456
78910111213
14151617181920
21222324252627
28293031  

Most Recent Posts

SourceForge.net Logo