PacketFence
Bug Tracking System

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0001815PacketFenceupgradepublic2014-07-17 07:412014-07-17 08:38
Reporteralexx 
Assigned To 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionno change required 
PlatformZENOSZENOS VersionZEN
Product Version4.2.2 
Target VersionFixed in Version 
Summary0001815: 4.3.0 Update
DescriptionSince I update my 4.2.2 ZEN to 4.3.0 I can not seen any user. In the logfiles I can find that:

[root@rbnac logs]# tail -f httpd.admin.log
Jul 17 13:21:29 httpd.admin(1713) INFO: Changes successfully commited (pfappserver::Base::Controller::Crud::Config::_commitChanges)
Jul 17 13:21:36 httpd.admin(1713) ERROR: Use of uninitialized value in transliteration (tr///) at /usr/share/perl5/vendor_perl/HTML/FormHandler/BuildFields.pm line 133.
 (pfappserver::__ANON__)
Jul 17 13:21:54 httpd.admin(1713) ERROR: Use of uninitialized value in transliteration (tr///) at /usr/share/perl5/vendor_perl/HTML/FormHandler/BuildFields.pm line 133.
 (pfappserver::__ANON__)
Jul 17 13:21:54 httpd.admin(1713) INFO: Changes successfully commited (pfappserver::Base::Controller::Crud::Config::_commitChanges)
Jul 17 13:22:02 httpd.admin(1713) WARN: database query failed with: Unknown column 'p.portal' in 'field list' (errno: 1054), will try again (pf::db::db_query_execute)
Jul 17 13:22:02 httpd.admin(1713) WARN: database query failed with: Unknown column 'p.portal' in 'field list' (errno: 1054), will try again (pf::db::db_query_execute)
Jul 17 13:22:02 httpd.admin(1713) WARN: database query failed with: Unknown column 'p.portal' in 'field list' (errno: 1054), will try again (pf::db::db_query_execute)
Jul 17 13:22:02 httpd.admin(1713) ERROR: Database issue: We tried 3 times to serve query person_view_all_sql_custom called from pf::db::db_data and we failed. Is the database running? (pf::db::db_query_execute)
Steps To Reproduce[root@rbnac logs]# tail -f httpd.admin.log
Jul 17 13:21:29 httpd.admin(1713) INFO: Changes successfully commited (pfappserver::Base::Controller::Crud::Config::_commitChanges)
Jul 17 13:21:36 httpd.admin(1713) ERROR: Use of uninitialized value in transliteration (tr///) at /usr/share/perl5/vendor_perl/HTML/FormHandler/BuildFields.pm line 133.
 (pfappserver::__ANON__)
Jul 17 13:21:54 httpd.admin(1713) ERROR: Use of uninitialized value in transliteration (tr///) at /usr/share/perl5/vendor_perl/HTML/FormHandler/BuildFields.pm line 133.
 (pfappserver::__ANON__)
Jul 17 13:21:54 httpd.admin(1713) INFO: Changes successfully commited (pfappserver::Base::Controller::Crud::Config::_commitChanges)
Jul 17 13:22:02 httpd.admin(1713) WARN: database query failed with: Unknown column 'p.portal' in 'field list' (errno: 1054), will try again (pf::db::db_query_execute)
Jul 17 13:22:02 httpd.admin(1713) WARN: database query failed with: Unknown column 'p.portal' in 'field list' (errno: 1054), will try again (pf::db::db_query_execute)
Jul 17 13:22:02 httpd.admin(1713) WARN: database query failed with: Unknown column 'p.portal' in 'field list' (errno: 1054), will try again (pf::db::db_query_execute)
Jul 17 13:22:02 httpd.admin(1713) ERROR: Database issue: We tried 3 times to serve query person_view_all_sql_custom called from pf::db::db_data and we failed. Is the database running? (pf::db::db_query_execute)
Additional InformationNo User in the local Database on the website
TagsNo tags attached.
fixed in git revision
fixed in mtn revision
Attached Files

- Relationships

-  Notes
(0003566)
fdurand (administrator)
2014-07-17 08:25

Hi Alex,

the database schema must be updated. (cf db directory)

Regards
Fabrice
(0003567)
alexx (reporter)
2014-07-17 08:28

I had have deleted the person.pm, I delete the entries with p.portal and p.source
(0003568)
alexx (reporter)
2014-07-17 08:28

Hi,

how should I do the Database Update? thx alexx
(0003569)
fdurand (administrator)
2014-07-17 08:30

https://github.com/inverse-inc/packetfence/blob/devel/UPGRADE.asciidoc [^]
(0003570)
alexx (reporter)
2014-07-17 08:31

Thanks a lot, sorry i was blind ;-(

- Issue History
Date Modified Username Field Change
2014-07-17 07:41 alexx New Issue
2014-07-17 08:25 fdurand Note Added: 0003566
2014-07-17 08:28 alexx Note Added: 0003567
2014-07-17 08:28 alexx Note Added: 0003568
2014-07-17 08:30 fdurand Note Added: 0003569
2014-07-17 08:31 alexx Note Added: 0003570
2014-07-17 08:38 francis Status new => closed
2014-07-17 08:38 francis Resolution open => no change required


Copyright © 2000 - 2012 MantisBT Group
Powered by Mantis Bugtracker