PacketFence - BTS - PacketFence
View Issue Details
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 
fixed in git revision
fixed in mtn revision
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.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-07-17 07:41alexxNew Issue
2014-07-17 08:25fdurandNote Added: 0003566
2014-07-17 08:28alexxNote Added: 0003567
2014-07-17 08:28alexxNote Added: 0003568
2014-07-17 08:30fdurandNote Added: 0003569
2014-07-17 08:31alexxNote Added: 0003570
2014-07-17 08:38francisStatusnew => closed
2014-07-17 08:38francisResolutionopen => no change required

Notes
(0003566)
fdurand   
2014-07-17 08:25   
Hi Alex,

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

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

how should I do the Database Update? thx alexx
(0003569)
fdurand   
2014-07-17 08:30   
https://github.com/inverse-inc/packetfence/blob/devel/UPGRADE.asciidoc [^]
(0003570)
alexx   
2014-07-17 08:31   
Thanks a lot, sorry i was blind ;-(