phpLogCon installation problem : Field 'propvalue_text'

Everything which is related to the installation of phpLogCon.

phpLogCon installation problem : Field 'propvalue_text'

Postby noemie » Thu Feb 19, 2009 3:23 pm

Hello,
When I try to install phpLogCon with UserDB, I have the following errors

Database error: Invalid SQL: INSERT INTO phplogcon_config (propname, propvalue, is_global) VALUES ( 'ViewDefaultLanguage', 'en', 1)
mysql error: Field 'propvalue_text' doesn't have a default value
mysql error number: 1364
Date: 19.02.2009 @ 15:11
Script: /syslog/install.php?step=8
Referer: http://localhost/syslog/install.php?step=7
Database error: Invalid SQL: INSERT INTO phplogcon_config (propname, propvalue, is_global) VALUES ( 'ViewDefaultTheme', 'default', 1)
mysql error: Field 'propvalue_text' doesn't have a default value
mysql error number: 1364
Date: 19.02.2009 @ 15:11
Script: /syslog/install.php?step=8
Referer: http://localhost/syslog/install.php?step=7
Database error: Invalid SQL: INSERT INTO phplogcon_config (propname, propvalue, is_global) VALUES ( 'ViewUseTodayYesterday', '1', 1)
mysql error: Field 'propvalue_text' doesn't have a default value
mysql error number: 1364
Date: 19.02.2009 @ 15:11
Script: /syslog/install.php?step=8
Referer: http://localhost/syslog/install.php?step=7
Database error: Invalid SQL: INSERT INTO phplogcon_config (propname, propvalue, is_global) VALUES ( 'ViewEnableDetailPopups', '1', 1)
mysql error: Field 'propvalue_text' doesn't have a default value
mysql error number: 1364
Date: 19.02.2009 @ 15:11
Script: /syslog/install.php?step=8
Referer: http://localhost/syslog/install.php?step=7
Database error: Invalid SQL: INSERT INTO phplogcon_config (propname, propvalue, is_global) VALUES ( 'EnableIPAddressResolve', '1', 1)
mysql error: Field 'propvalue_text' doesn't have a default value
mysql error number: 1364
Date: 19.02.2009 @ 15:11
Script: /syslog/install.php?step=8
Referer: http://localhost/syslog/install.php?step=7
Database error: Invalid SQL: INSERT INTO phplogcon_config (propname, propvalue, is_global) VALUES ( 'MiscShowDebugMsg', '0', 1)
mysql error: Field 'propvalue_text' doesn't have a default value
mysql error number: 1364
Date: 19.02.2009 @ 15:11
(...)


Can anyone tell me what was wrong in my installation ?
Thanks !
noemie
New
 
Posts: 3
Joined: Thu Feb 19, 2009 3:15 pm

phpLogCon professional services

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

Re: phpLogCon installation problem : Field 'propvalue_text'

Postby rgerhards » Thu Feb 19, 2009 3:32 pm

Was this a fresh install or an upgrade? If it was a fresh install, did you select the userdb during the setup wizard or activate it some time later?
User avatar
rgerhards
Site Admin
 
Posts: 2647
Joined: Thu Feb 13, 2003 11:57 am

Re: phpLogCon installation problem : Field 'propvalue_text'

Postby noemie » Thu Feb 19, 2009 3:47 pm

It's a fresh install, but I've retried several times to configure the application by deleting the config.php file. (The first install was made without userDB).
The version used is the last one (2.5.24).
Thanks
noemie
New
 
Posts: 3
Joined: Thu Feb 19, 2009 3:15 pm

Re: phpLogCon installation problem : Field 'propvalue_text'

Postby rgerhards » Thu Feb 19, 2009 6:19 pm

mhhh... I was thinking if the database structures for the userdb were not generated. But in this case it should... Mhhh.... no idea on my side so far, but I guess Andre will jump in (but today are big carnival celebrations over here, so do not expect anything before tomorrow ;)).

Rainer
User avatar
rgerhards
Site Admin
 
Posts: 2647
Joined: Thu Feb 13, 2003 11:57 am

Re: phpLogCon installation problem : Field 'propvalue_text'

Postby noemie » Thu Feb 19, 2009 6:30 pm

I try to change the 'propvalue_text' column by removing the NOT NULL constraints the installation completed but then the application no longer worked :)
Thanks for your fast answer Rainer !
noemie
New
 
Posts: 3
Joined: Thu Feb 19, 2009 3:15 pm

Re: phpLogCon installation problem : Field 'propvalue_text'

Postby alorbach » Fri Feb 20, 2009 11:46 am

Hi,

I think there is a minor mistake in the table definition, I am going to fix this :)

best regards,
Andre Lorbach
User avatar
alorbach
Site Admin
 
Posts: 1129
Joined: Thu Feb 13, 2003 11:55 am

Google Ads



Return to Installation

Who is online

Users browsing this forum: No registered users and 0 guests

cron