Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Topics - apmuthu

Pages: [1] 2
1
Installation problems / Differences between v2.2.1 and v2.2.2
« on: December 27, 2012, 02:26:54 PM »
The attachments to this forum's posts is broken / disabled - 500KB allowed it says, but even a small file is disregarded and states that the upload folder is full - The upload folder is full. Please try a smaller file and/or contact an administrator.

Differences between FO v2.2.1 and v2.2.2

Most of my patches have not been included and some have been differently done (mail plugin info, etc). Minor db schema changes are there.

There are
1. one new file in the webroot - rebuild_sharing_table.php
2. two new files in one new folder,
3. Needless one HTML folder with one ser file in it that are temporrary and get created when needed and hence should not be part of any distribution - please repack distribution without this.

apmuthu.com/bugfixes/FO_221_to_222_files.7z

2
Installation problems / Event Class function call error fix
« on: December 27, 2012, 07:04:01 AM »
Line 2867 in application/controllers/ContactController.class.php calls function evt_add without second parameter.

The second parameter can be null as seen in a call at line 797 in application/controllers/AdministrationController.class.php

Hence we solve it by making it an optional parameter with a default of null.

function evt_add is defined in environment/classes/event/event.php in line 9 as:
   function evt_add($name, $data) {
which is changed to:
   function evt_add($name, $data=null) {
thereby solving the issue.


3
Installation problems / ContactController Issue
« on: December 27, 2012, 06:56:53 AM »
FengOffice v2.2.1:

Insert at Line 2633 in file application/controllers/ContactController.class.php
         $country = "";
so that $company_data in line 2642 can succeed when there is no $address in line 2634 available.


4
Installation problems / Solving for Missing Lang issue
« on: December 27, 2012, 06:53:19 AM »
Feng Office v2.2.1

18 hours of searching for the elusive bug - Missing lang in tabs names - finally done.

Administrator -> Tabs -> Try saving any changes to to the ordering / enablement and the resulting page will have it's tab panels named "Missing lang".

Solution:

1. Make the corrections stated in the posts:
topic=15792.0
and
topic=15791.0

2. Spelling mistake in the field name conditions must be corrected in:
Line 11 of application/models/tab_panels/TabPanels.class.php
        return self::findAll(array("condtitions" => "`enabled` = 1"));
should be
        return self::findAll(array("conditions" => "`enabled` = 1"));

Viola! The Missing lang bug is gone!

5
Installation problems / Solving Missing lang issue
« on: December 27, 2012, 06:45:37 AM »
FengOffice v2.2.1 and v2.2.2:

If we try to go to Administrator -> Tabs and save any changes, the tab names become "Missing lang".

Solution:

First make the corrections in the two posts:
hxxp://forums.fengoffice.com/index.php?topic=15792.0
and
hxxp://forums.fengoffice.com/index.php?topic=15791.0

Then make the following correction - spelling mistake in the conditions field:
Line 11 of application/models/tab_panels/TabPanels.class.php
       return self::findAll(array("condtitions" => "`enabled` = 1"));
should be
       return self::findAll(array("conditions" => "`enabled` = 1"));

Viola! The error goes away! That was 18 hours of searching for a bug successfully....

6
Installation problems / Error in mysql_real_escape_string
« on: December 27, 2012, 06:38:20 AM »
Since there is no db connection in scope and the title field is not editable,
Line 805 in application/controllers/AdministrationController.class.php
         $title = (mysql_real_escape_string($tab['title']);
should be
         $title = trim($tab['title']) ;

Fix needs to be done for v2.2.1 and v2.2.2

7
Installation problems / tab_panels table corrections
« on: December 27, 2012, 06:35:08 AM »
Lines 301-310 of public/install/installation/templates/sql/mysql_initial_data.php have it's ordering field unique with:

INSERT INTO `<?php echo $table_prefix ?>tab_panels` (`id`,`title`,`icon_cls`,`refresh_on_context_change`,`default_controller`,`default_action`,`initial_controller`,`initial_action`,`enabled`,`type`,`ordering`,`plugin_id`,`object_type_id`) VALUES
 ('calendar-panel','calendar','ico-calendar',1,'event','view_calendar','','',0,'system',8,0,11),
 ('contacts-panel','contacts','ico-contacts',1,'contact','init','','',0,'system',5,0,16),
 ('documents-panel','documents','ico-documents',1,'files','init','','',1,'system',4,0,6),
 ('messages-panel','messages','ico-messages',1,'message','init','','',1,'system',0,0,3),
 ('overview-panel','overview','ico-overview',1,'dashboard','main_dashboard','dashboard','main_dashboard',1,'system',-100,0,0),
 ('reporting-panel','reporting','ico-reporting',1,'reporting','index','','',0,'system',9,0,12),
 ('tasks-panel','tasks','ico-tasks',1,'task','new_list_tasks','','',1,'system',2,0,5),
 ('time-panel','time','ico-time-layout',1,'time','index','','',0,'system',7,0,0),
 ('webpages-panel','web pages','ico-webpages',1,'webpage','init','','',0,'system',6,0,4);

8
Feng Office 2 / FO v2.2.1 OpenVZ Template Released
« on: December 26, 2012, 02:23:43 PM »
The Debian Squeeze OpenVZ Template of FengOffice 2.2.1 - auto pre-installed at first boot - fully randomised MySQL passwords and application hashes / Seeds is now available.

Contact gnuacademy.org (GNUAcademy) for the template and planettel.com.sg (Planettel) for Support. It has all issues addressed till date.

The template is listed at the ProxmoxVE site - pve.proxmox.com/wiki/FengOffice

9
Installation problems / Missing entries in config/config.php
« on: December 26, 2012, 01:09:44 PM »
On FengOffice v2.2.1 installation, the generated config/config.php has 14 defines against only 11 in the config/empty.config.php - the Missing ones in it are:

define('DB_ENGINE', 'InnoDB');
define('COOKIE_PATH', '/');
define('SEED', '13312cdd121facd0bef7635bacbd5303');

The last SEED value is computed using:
md5($database_user.$database_pass.rand(0,10000000000))
This detail is in line 147 of public/install/installation/acInstallation.class.phpand public/install/installation/plugin_acInstallation.class.php

Undocumented defines available:
DEBUG_DB
DEBUG_TIME


10
Installation problems / Invalid Admin EMail ID accepted during install
« on: December 26, 2012, 01:04:20 PM »
During installation, in the final step we can enter any name instead of an email id and the install will finish successfully without checking if it has a valid email format or not.

However, we cannot login with the given credentials as the email id format is checked during login.

The fix is to manually correct it in the database table contact_emails table.

11
Installation problems / Upgrade Fix
« on: December 26, 2012, 01:36:56 AM »
The line 307 of file public\upgrade\scripts\NutriaUpgradeScript.class.php

            $new_config[] = "  define('SEED', '".DB_USER.DB_PASS.rand(0,10000000000)."');\n";

should be

            $new_config[] = "  define('SEED', '".md5(DB_USER.DB_PASS.rand(0,10000000000))."');\n";

12
Installation problems / Redundant Indexes
« on: December 26, 2012, 12:09:00 AM »
In Feng Office v2.2.1, there are quite a few redundant indexes and a missing Unique index that can be set right with (my db table extension is fo_):

Redundant Key issues:

ALTER TABLE `fo_contact_passwords` DROP INDEX `id`;
ALTER TABLE `fo_contact_permission_groups` DROP INDEX `contact_id`;
ALTER TABLE `fo_object_types` DROP INDEX `name`,
      ADD UNIQUE INDEX `nameclass` (`name`, `handler_class`, `table_name`);
ALTER TABLE `fo_searchable_objects` DROP INDEX `rel_obj_id`;
ALTER TABLE `fo_mail_account_contacts` DROP INDEX `ix_account`;



When ever a field is the first one in a Primary key or in any unique key, it should not be used as a key by itself as it would be redundant.

13
New Community Members / Hello from Chennai, India / Singapore
« on: March 07, 2010, 08:39:04 AM »
Greetings from Singapore and Chennai, India.

Nice community!

Why did OpenGOO change to FengOffice?
Was it because of the GOO or did China buy it up!

The default posting setting is centered instead of left justified - the Board Admin can change it so new users can benefit.

14
The latest version of OpenGOO - 1.6.2 - has been made available as an OpenVZ template for direct deployment in a container - check out the ProxMox Wiki Page for it here.

Dont forget to fix the bug listed in this forum posting.

15
Older versions / User Deletion by admin incomplete
« on: March 07, 2010, 07:46:07 AM »
When the admin deletes a user, the user is deleted from the og_users table (the autoincrement is unaltered) but the user's records in the og_user_passwords table remain undeleted.

Pages: [1] 2
anything
anything