DB Errors (sql import seems to be missing items.)

[mkreafle]

This is a mono install.

Code: Select all

Table 'ugcc.news' doesn't exist
Description: HTTP 500. Error processing request.
Stack Trace:
MySql.Data.MySqlClient.MySqlException: Table 'ugcc.news' doesn't exist
  at MySql.Data.MySqlClient.MySqlStream.OpenPacket () [0x00000] 
  at MySql.Data.MySqlClient.NativeDriver.ReadResult (System.UInt64& affectedRows, System.Int64& lastInsertId) [0x00000] 
  at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet () [0x00000] 
  at MySql.Data.MySqlClient.MySqlDataReader.NextResult () [0x00000]
Version information:  Mono Version: 2.0.50727.42; ASP.NET Version: 2.0.50727.42

Also, before this I had to make a second servers table named SERVERS.
After that I could log in. Then it did a DB update. Then I received the error above.
Seems there is an issue with capitalization for me. Is there an updated sql file to import?

[Masher]

Please check the PM I've sent you. It includes a link to the latest beta that should resolve these issues. If not please let me know.

[mkreafle]

Am I wrong to guess that the remote monitor portion will not work on Vista 64? It makes the licrm but it's zero bytes... Nothing in it.
Any suggestions?

[mkreafle]

I am sorry. I don't want to be a pain, I just want to give you everything I find.
Header and Footer Editor.

adminhdrftr.aspx

Code: Select all

Could not find file "/media/webserver/servercontrol/header.inc".

Description: HTTP 500. Error processing request.

Stack Trace:

System.IO.FileNotFoundException: Could not find file "/media/webserver/servercontrol/header.inc".
File name: '/media/webserver/servercontrol/header.inc'
  at System.IO.FileStream..ctor (System.String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, Boolean anonymous, FileOptions options) [0x00000] 
  at System.IO.FileStream..ctor (System.String path, FileMode mode, FileAccess access, FileShare share) [0x00000] 
  at (wrapper remoting-invoke-with-check) System.IO.FileStream:.ctor (string,System.IO.FileMode,System.IO.FileAccess,System.IO.FileShare)
  at System.IO.File.OpenRead (System.String path) [0x00000] 
  at System.IO.StreamReader..ctor (System.String path, System.Text.Encoding encoding, Boolean detect_encoding_from_bytemarks, Int32 buffer_size) [0x00000] 
  at System.IO.StreamReader..ctor (System.String path) [0x00000] 
  at (wrapper remoting-invoke-with-check) System.IO.StreamReader:.ctor (string)
  at UGCC_Sharp.adminhdrftr.Page_Load (System.Object sender, System.EventArgs e) [0x00000] 
  at System.Web.UI.Control.OnLoad (System.EventArgs e) [0x00000] 
  at System.Web.UI.Control.LoadRecursive () [0x00000] 
  at System.Web.UI.Page.ProcessLoad () [0x00000] 
  at System.Web.UI.Page.ProcessPostData () [0x00000] 
  at System.Web.UI.Page.InternalProcessRequest () [0x00000] 
  at System.Web.UI.Page.ProcessRequest (System.Web.HttpContext context) [0x00000] 

Version information: Mono Version: 2.0.50727.42; ASP.NET Version: 2.0.50727.42

The issue is that Header.inc and Footer.inc have the first letter capitalized...

[Masher]

I am sorry. I don't want to be a pain, I just want to give you everything I find.

Not a problem, thanks for the heads up. Will fix.

In regards to the monitor and Vista x64--it should work. I've tested that scenerio. Likely it's having trouble getting hardware information. Can you check eventviewer and the log file for any errors? If there are none I'll have to get some other info from you.

[mkreafle]

Log file:

Code: Select all

2/12/2009 12:40:04 PM	UGCCMon Started (1.22) | Dbtype=mysql | Interval=60000ms
2/12/2009 12:40:04 PM	Running as user:  NT AUTHORITY\SYSTEM
2/12/2009 12:40:04 PM	License is not valid, monitor disabled
2/12/2009 12:40:05 PM	Gen==>Error getting hardware key

Event Viewer:

Code: Select all

Log Name:      Application
Source:        UGCCMon
Date:          2/12/2009 12:40:05 PM
Event ID:      0
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      ShadoVista64
Description:
Service cannot be started. System.Exception: License is not valid
   at UGCCMon.UGCCMon.OnStart(String[] args) in C:\ugccmon\Service1.cs:line 232
   at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="UGCCMon" />
    <EventID Qualifiers="0">0</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2009-02-12T17:40:05.000Z" />
    <EventRecordID>15760</EventRecordID>
    <Channel>Application</Channel>
    <Computer>ShadoVista64</Computer>
    <Security />
  </System>
  <EventData>
    <Data>Service cannot be started. System.Exception: License is not valid
   at UGCCMon.UGCCMon.OnStart(String[] args) in C:\ugccmon\Service1.cs:line 232
   at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)</Data>
  </EventData>
</Event>

I hope that is enough info for you.