I will try to reproduce your issue, Which version of Umbraco are you using? Did you try to connect with our demo site (http://demo.lecoati.com demo/demo)?

Antoine

Hi use Umbraco 6.1.3 and my own umbraco site.

On your demo site, it works great.

I have tested with Umbraco 6.1.3 and this Issue does not seem to be related.

In this version of uMobile, the logs are consulted directly in the table umbracoLog in bbdd. Maybe your database doesn't support the queries we are using here. Which kind of database are you using?

I have tested on two different servers with two different websites (umbraco 6.1.3).  I'm using MS SQL Server 2012 on the one server and MS SQL Server 2008 RS on the other server. But I have the same issue on both.

We are using the SQL instruction “row_number()” for the paging, it is not available for SQLserver 2002 but for 2008 yes ! The first query is:

SELECT id, userId, Datestamp, logComment, logHeader  FROM ( SELECT id, userId, Datestamp, logComment, logHeader, ROW_NUMBER() over (order by id desc) AS RowNum  FROM umbracoLog where Datestamp >= '01/01/2010' and  Datestamp <= '01/01/2014' ) AS SOD  WHERE SOD.RowNum BETWEEN 1 AND 10

If you can, try it and give me your feedback

Anyway, we are planning to modify those queries for something more generic and compatible in the next version of uMobile.

If I set "FROM umbracoLog" to "FROM [myDatabaseName].[dbo].[umbracoLog]" and exexute this in SQL Management Studio it works without Exceptions.

Thank you Sören,

I don't think that it is related with the "FROM" entity, I have changed the query with one which work with all SQL server version.

You can find it here: http://www.umobileapp.com/resources/build/uMobile_0.9.2.1.zip

Let me know if it works for you, I will include it in the next version.

In case is still no working, please consult the umbracoLog table, I have added some try/catch with [uMobile] tag

Hi Antoine,

it works not for me.

Ok, did you have a look in the umbracoLog table, maybe we can find some extra information, just look for a comment start with [uMobile]

There are only two entries with uMobile in the umbracoLog table, but this are entries with logHeader "New" and not from today.

Can you try with this new build and look again into the log table http://www.umobileapp.com/resources/build/uMobile_0.9.2.2.zip

Thanks you Sören !

Ok, If I click on Logs-Log manager I get the following message:

Error
Error retrieving data

In the log table I can find one new entry:
[uMobile] Logmanager call

Great :) something happens! So, let try with this build: http://www.umobileapp.com/resources/build/uMobile_0.9.2.3.zip

It's maybe a datetime parsing issue.

If the problem persists, I can prepare for you a simple extension for uMobile with this piece of code that you will be able to debug.

On my smartphone i get this error:
Error retrieving data (Logmanager)

In log table I get this entries:
[uMobile] Logmanager call get total
[uMobile] Logmanager call error: Umbraco Exception (DataLayer): SQL helper exception in ExecuteScalar
[uMobile] Logmanager call error (InnerException): Bei der Konvertierung eines varchar-Datentyps in einen datetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs.

The last entrie means in english:
During the conversion of a varchar data type to a datetime data type of the value is out of range.

Thank you Antoine! It works!!!!! Great job!

Great, thank you!

I hope that you will have a good experience with uMobile, we are working hard to add more new very useful features soon!

is working on a reply...