MonitorWare Knowledge Base

I have installed phplogcon-2.5.16 everything seems to work bur when I go in to "Admin center" and change something and then pressing "Send changes"
I got the following error, any one know what I have done wrong?

The field is named propvalue and NOT propvalue_text in the table loggerconfig in my database.. is this a bugg or is it something I have done wrong? Can I change in some way? and does that affect something else?

Database error: Invalid SQL: UPDATE loggerconfig SET propvalue = 'en', propvalue_text = '' WHERE propname = 'ViewDefaultLanguage' AND is_global = 1
mysql error: Unknown column 'propvalue_text' in 'field list'
mysql error number: 1054
Date: 29.10.2008 @ 07:50
Script: /admin/index.php
Referer: http://192.168.2.11/admin/index.php
Database error: Invalid SQL: UPDATE loggerconfig SET propvalue = 'default', propvalue_text = '' WHERE propname = 'ViewDefaultTheme' AND is_global = 1
mysql error: Unknown column 'propvalue_text' in 'field list'
mysql error number: 1054
Date: 29.10.2008 @ 07:50
Script: /admin/index.php
Referer: http://192.168.2.11/admin/index.php
Database error: Invalid SQL: UPDATE loggerconfig SET propvalue = '1', propvalue_text = '' WHERE propname = 'ViewUseTodayYesterday' AND is_global = 1
mysql error: Unknown column 'propvalue_text' in 'field list'
mysql error number: 1054
Date: 29.10.2008 @ 07:50
Script: /admin/index.php
Referer: http://192.168.2.11/admin/index.php
Database error: Invalid SQL: UPDATE loggerconfig SET propvalue = '1', propvalue_text = '' WHERE propname = 'ViewEnableDetailPopups' AND is_global = 1
mysql error: Unknown column 'propvalue_text' in 'field list'
mysql error number: 1054
Date: 29.10.2008 @ 07:50
Script: /admin/index.php
Referer: http://192.168.2.11/admin/index.php
Database error: Invalid SQL: UPDATE loggerconfig SET propvalue = '1', propvalue_text = '' WHERE propname = 'EnableIPAddressResolve' AND is_global = 1
mysql error: Unknown column 'propvalue_text' in 'field list'
mysql error number: 1054
Date: 29.10.2008 @ 07:50
Script: /admin/index.php
Referer: http://192.168.2.11/admin/index.php
Database error: Invalid SQL: UPDATE loggerconfig SET propvalue = '0', propvalue_text = '' WHERE propname = 'MiscShowDebugMsg' AND is_global = 1
mysql error: Unknown column 'propvalue_text' in 'field list'
mysql error number: 1054
Date: 29.10.2008 @ 07:50
Script: /admin/index.php
Referer: http://192.168.2.11/admin/index.php
Database error: Invalid SQL: UPDATE loggerconfig SET propvalue = '0', propvalue_text = '' WHERE propname = 'MiscShowDebugGridCounter' AND is_global = 1
mysql error: Unknown column 'propvalue_text' in 'field list'
mysql error number: 1054
Date: 29.10.2008 @ 07:50
Script: /admin/index.php
Referer: http://192.168.2.11/admin/index.php
Database error: Invalid SQL: UPDATE loggerconfig SET propvalue = '1', propvalue_text = '' WHERE propname = 'MiscShowPageRenderStats' AND is_global = 1
mysql error: Unknown column 'propvalue_text' in 'field list'
mysql error number: 1054
Date: 29.10.2008 @ 07:50
Script: /admin/index.php
Referer: http://192.168.2.11/admin/index.php
Database error: Invalid SQL: UPDATE loggerconfig SET propvalue = '1', propvalue_text = '' WHERE propname = 'MiscEnableGzipCompression' AND is_global = 1
mysql error: Unknown column 'propvalue_text' in 'field list'
mysql error number: 1054
Date: 29.10.2008 @ 07:50
Script: /admin/index.php
Referer: http://192.168.2.11/admin/index.php
Database error: Invalid SQL: UPDATE loggerconfig SET propvalue = '0', propvalue_text = '' WHERE propname = 'SuppressDuplicatedMessages' AND is_global = 1
mysql error: Unknown column 'propvalue_text' in 'field list'
mysql error number: 1054
Date: 29.10.2008 @ 07:50
Script: /admin/index.php
Referer: http://192.168.2.11/admin/index.php
Database error: Invalid SQL: UPDATE loggerconfig SET propvalue = '0', propvalue_text = '' WHERE propname = 'TreatNotFoundFiltersAsTrue' AND is_global = 1
mysql error: Unknown column 'propvalue_text' in 'field list'
mysql error number: 1054
Date: 29.10.2008 @ 07:50
Script: /admin/index.php
Referer: http://192.168.2.11/admin/index.php
Database error: Invalid SQL: UPDATE loggerconfig SET propvalue = '80', propvalue_text = '' WHERE propname = 'ViewMessageCharacterLimit' AND is_global = 1
mysql error: Unknown column 'propvalue_text' in 'field list'
mysql error number: 1054
Date: 29.10.2008 @ 07:50
Script: /admin/index.php
Referer: http://192.168.2.11/admin/index.php
Database error: Invalid SQL: UPDATE loggerconfig SET propvalue = '30', propvalue_text = '' WHERE propname = 'ViewStringCharacterLimit' AND is_global = 1
mysql error: Unknown column 'propvalue_text' in 'field list'
mysql error number: 1054
Date: 29.10.2008 @ 07:50
Script: /admin/index.php
Referer: http://192.168.2.11/admin/index.php
Database error: Invalid SQL: UPDATE loggerconfig SET propvalue = '50', propvalue_text = '' WHERE propname = 'ViewEntriesPerPage' AND is_global = 1
mysql error: Unknown column 'propvalue_text' in 'field list'
mysql error number: 1054
Date: 29.10.2008 @ 07:50
Script: /admin/index.php
Referer: http://192.168.2.11/admin/index.php
Database error: Invalid SQL: UPDATE loggerconfig SET propvalue = '30', propvalue_text = '' WHERE propname = 'ViewEnableAutoReloadSeconds' AND is_global = 1
mysql error: Unknown column 'propvalue_text' in 'field list'
mysql error number: 1054
Date: 29.10.2008 @ 07:50
Script: /admin/index.php
Referer: http://192.168.2.11/admin/index.php
Database error: Invalid SQL: UPDATE loggerconfig SET propvalue = '3000', propvalue_text = '' WHERE propname = 'PopupMenuTimeout' AND is_global = 1
mysql error: Unknown column 'propvalue_text' in 'field list'
mysql error number: 1054
Date: 29.10.2008 @ 07:50
Script: /admin/index.php
Referer: http://192.168.2.11/admin/index.php
Database error: Invalid SQL: UPDATE loggerconfig SET propvalue = '', propvalue_text = '' WHERE propname = 'PrependTitle' AND is_global = 1
mysql error: Unknown column 'propvalue_text' in 'field list'
mysql error number: 1054
Date: 29.10.2008 @ 07:50
Script: /admin/index.php
Referer: http://192.168.2.11/admin/index.php
Database error: Invalid SQL: UPDATE loggerconfig SET propvalue = 'I\'d like to feel sad!', propvalue_text = '' WHERE propname = 'SearchCustomButtonCaption' AND is_global = 1
mysql error: Unknown column 'propvalue_text' in 'field list'
mysql error number: 1054
Date: 29.10.2008 @ 07:50
Script: /admin/index.php
Referer: http://192.168.2.11/admin/index.php
Database error: Invalid SQL: UPDATE loggerconfig SET propvalue = 'error', propvalue_text = '' WHERE propname = 'SearchCustomButtonSearch' AND is_global = 1
mysql error: Unknown column 'propvalue_text' in 'field list'
mysql error number: 1054
Date: 29.10.2008 @ 07:50
Script: /admin/index.php
Referer: http://192.168.2.11/admin/index.php
Database error: Invalid SQL: UPDATE loggerconfig SET propvalue = 'SYSLOG', propvalue_text = '' WHERE propname = 'DefaultViewsID' AND is_global = 1
mysql error: Unknown column 'propvalue_text' in 'field list'
mysql error number: 1054
Date: 29.10.2008 @ 07:50
Script: /admin/index.php
Referer: http://192.168.2.11/admin/index.php
Database error: Invalid SQL: UPDATE loggerconfig SET propvalue = '1', propvalue_text = '' WHERE propname = 'DefaultSourceID' AND is_global = 1
mysql error: Unknown column 'propvalue_text' in 'field list'
mysql error number: 1054
Date: 29.10.2008 @ 07:50
Script: /admin/index.php
Referer: http://192.168.2.11/admin/index.php
Database error: Invalid SQL: UPDATE loggerconfig SET propvalue = '0', propvalue_text = '' WHERE propname = 'DebugUserLogin' AND is_global = 1
mysql error: Unknown column 'propvalue_text' in 'field list'
mysql error number: 1054
Date: 29.10.2008 @ 07:50
Script: /admin/index.php
Referer: http://192.168.2.11/admin/index.php
Database error: Invalid SQL: UPDATE loggerconfig SET propvalue = '0', propvalue_text = '' WHERE propname = 'MiscDebugToSyslog' AND is_global = 1
mysql error: Unknown column 'propvalue_text' in 'field list'
mysql error number: 1054
Date: 29.10.2008 @ 07:50
Script: /admin/index.php
Referer: http://192.168.2.11/admin/index.php
Database error: Invalid SQL: UPDATE loggerconfig SET propvalue = '30', propvalue_text = '' WHERE propname = 'MiscMaxExecutionTime' AND is_global = 1
mysql error: Unknown column 'propvalue_text' in 'field list'
mysql error number: 1054
Date: 29.10.2008 @ 07:50
Script: /admin/index.php
Referer: http://192.168.2.11/admin/index.php
Database error: Invalid SQL: UPDATE loggerconfig SET propvalue = '', propvalue_text = '' WHERE propname = 'InjectHtmlHeader' AND is_global = 1
mysql error: Unknown column 'propvalue_text' in 'field list'
mysql error number: 1054
Date: 29.10.2008 @ 07:50
Script: /admin/index.php
Referer: http://192.168.2.11/admin/index.php
Database error: Invalid SQL: UPDATE loggerconfig SET propvalue = '', propvalue_text = '' WHERE propname = 'InjectBodyHeader' AND is_global = 1
mysql error: Unknown column 'propvalue_text' in 'field list'
mysql error number: 1054
Date: 29.10.2008 @ 07:50
Script: /admin/index.php
Referer: http://192.168.2.11/admin/index.php
Database error: Invalid SQL: UPDATE loggerconfig SET propvalue = '', propvalue_text = '' WHERE propname = 'InjectBodyFooter' AND is_global = 1
mysql error: Unknown column 'propvalue_text' in 'field list'
mysql error number: 1054
Date: 29.10.2008 @ 07:50
Script: /admin/index.php
Referer: http://192.168.2.11/admin/index.php

• Custom phpLogCon configuration?
• Maintenance Contract?
• Installation support?

Hi Jolin,

this is a bug in the default database template. Will fix this with the next release. During meantime, run this sql commands by using phpMyAdmin on your phpLogCon database:

Code: Select all

ALTER TABLE `logcon_config` ADD `propvalue_text` TEXT NOT NULL AFTER `propvalue` ;
ALTER TABLE `logcon_sources` ADD `MsgSkipUnparseable` BOOL NOT NULL DEFAULT '0' AFTER `MsgNormalize` ;
ALTER TABLE `logcon_sources` ADD `DBRecordsPerQuery` INT NOT NULL DEFAULT '100' AFTER `DBEnableRowCounting` ;


This will fix the problem for you for now.

best regards,
Andre Lorbach

For your information, the new Version 2.5.17 has the default database template fixed.
For all other new users expiriencing this problem, please switch to 2.5.17 or later before you install the userdb system.
Download is available from here: http://www.phplogcon.org/downloads

--
best regards,
Andre Lorbach