Concierge installation not working and can no longer see content
Hi
I've just installed Concierge 2.0.1.zip and I have a number of issues:
I can't see the content tree at all in the left hand pane
If i search for content and select an item I get an error
I can't see anywhere in user permissions to enable the Concierge section, albeit I have check in and check out options in User Types.
I have since uninstalled the package so that the site would at least be operational, but I still can't see the tree and the check in and check out options still seem to be there
Can someone please help as this couldn't have happened at a worse time. Also, any idea what I should be doing with the Concierge 2.0.1 UPDATE.zip, as it won't install and other posts seem to imply you need to copy it somewhere?
Exception message: 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 '1 TICKETID FROM CONCIERGELOCKUNLOCK WHERE NODEID = 1838 ORDER BY TICKETID DESC' at line 1
at MySql.Data.MySqlClient.MySqlStream.OpenPacket()
at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteScalar()
at MySql.Data.MySqlClient.MySqlHelper.ExecuteScalar(MySqlConnection connection, String commandText, MySqlParameter[] commandParameters)
at MySql.Data.MySqlClient.MySqlHelper.ExecuteScalar(String connectionString, String commandText, MySqlParameter[] commandParameters)
at umbraco.DataLayer.SqlHelpers.MySql.MySqlHelper.ExecuteScalar(String commandText, MySqlParameter[] parameters)
at umbraco.DataLayer.SqlHelper`1.ExecuteScalar[T](String commandText, IParameter[] parameters)
ok mine is fixed. if you've been fiddling with licenece.dll in the bin folder, make sure the Umbraco.Licensing.pdb still there in your bin folder. if this is removed, the content and media tree (+ more) willlook blank/ not load.
I have the same issue, it seems the Concierge does not support MySQL??? That's weird, considering that I paid PRO license and there was no warning about incompatibility with MySQL. Please advise.
Sorry for not replying sooner. We were going to make some changes to it to support mySQL, but the customer didn't need it in the end, so it got put on ice. I'll let you know if that changes.
Concierge installation not working and can no longer see content
Hi
I've just installed Concierge 2.0.1.zip and I have a number of issues:
Claire
Futher to the above, we are running Umbraco 4.7 on .Net 4.
The error I get on the tree is:
Event Type: Warning
Event Source: ASP.NET 4.0.30319.0
Event Category: Web Event
Event ID: 1309
Date: 12/07/2011
Time: 12:05:50
User: N/A
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 12/07/2011 12:05:50
Event time (UTC): 12/07/2011 11:05:50
Event ID: 4d0c9b00b70740d082db4fbd3f3ae5f4
Event sequence: 28
Event occurrence: 1
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/ROOT-1-129549423155512500
Trust level: Full
Application Virtual Path: /
Application Path: c:\inetpub\wwwroot\
Machine name: XXXX
Process information:
Process ID: 2488
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: MySqlException
Exception message: 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 '1 TICKETID FROM CONCIERGELOCKUNLOCK WHERE NODEID = 1838 ORDER BY TICKETID DESC' at line 1
at MySql.Data.MySqlClient.MySqlStream.OpenPacket()
at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteScalar()
at MySql.Data.MySqlClient.MySqlHelper.ExecuteScalar(MySqlConnection connection, String commandText, MySqlParameter[] commandParameters)
at MySql.Data.MySqlClient.MySqlHelper.ExecuteScalar(String connectionString, String commandText, MySqlParameter[] commandParameters)
at umbraco.DataLayer.SqlHelpers.MySql.MySqlHelper.ExecuteScalar(String commandText, MySqlParameter[] parameters)
at umbraco.DataLayer.SqlHelper`1.ExecuteScalar[T](String commandText, IParameter[] parameters)
tion:
Request URL: http://xxx/umbraco/webservices/TreeDataService.ashx?rnd=1b16a30d172e48f78c8e2c2eefc5c6d4&id=1063&treeType=content&contextMenu=true&isDialog=false&rnd2=67.7
Request path: /umbraco/webservices/TreeDataService.ashx
User host address: xxx
User:
Is authenticated: False
Authentication Type:
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 1
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at MySql.Data.MySqlClient.MySqlStream.OpenPacket()
at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteScalar()
at MySql.Data.MySqlClient.MySqlHelper.ExecuteScalar(MySqlConnection connection, String commandText, MySqlParameter[] commandParameters)
at MySql.Data.MySqlClient.MySqlHelper.ExecuteScalar(String connectionString, String commandText, MySqlParameter[] commandParameters)
at umbraco.DataLayer.SqlHelpers.MySql.MySqlHelper.ExecuteScalar(String commandText, MySqlParameter[] parameters)
at umbraco.DataLayer.SqlHelper`1.ExecuteScalar[T](String commandText, IParameter[] parameters)
Did you get an answer to this?
ok mine is fixed. if you've been fiddling with licenece.dll in the bin folder, make sure the Umbraco.Licensing.pdb still there in your bin folder. if this is removed, the content and media tree (+ more) willlook blank/ not load.
I have the same issue, it seems the Concierge does not support MySQL??? That's weird, considering that I paid PRO license and there was no warning about incompatibility with MySQL. Please advise.
Sorry for not replying sooner. We were going to make some changes to it to support mySQL, but the customer didn't need it in the end, so it got put on ice. I'll let you know if that changes.
is working on a reply...