Search options (Page 117 of 245)

In the file sales/sales_order_entry, line 762 to 765:

        if ($_SESSION['Items']->trans_type==ST_SALESORDER)
            submit_js_confirm('CancelOrder', _('You are about to cancel undelivered part of this order.\nDo you want to continue?'));
        else
            submit_js_confirm('CancelOrder', _('You are about to void this Document.\nDo you want to continue?'));

the "\n" in the translatable strings are listed as "\\n" in the lang/new_language_template/LC_MESSAGES/empty.po file and in the translation .po files.

Is this intentional?

The code however mitigates this using functions that replace them in files in the includes/ui/ folder:

Line 677 in ui_controls.inc: $msg ? '\''.strtr($msg, array("\n"=>'\\n')) . '\';' : 'null;');
Line 484 in gettext.inc: $this->_current_value = str_replace('\\n', "\n", $this->_current_value);
Line 276 in ui_input.inc: . strtr($msg, array("\n"=>'\\n')) . "');};"

In  sql/alter2.4rc1.sql, the last line:

ALTER TABLE `0_sys_prefs` CHANGE `value` `value` text NOT NULL default '';

should have the default removed. In the standard Chart sqls corresponding changes must be effected.

MySQL does not allow any defaults for TINYTEXT, MEDIUMTEXT, LONGTEXT and TEXT fields.
Windows MySQL v5 throws an error but Linux and other versions only raise a warning.

Such TEXT fields do not support default values of anything but NULL. As such, it's implicitly DEFAULT NULL.

Use TRIGGERS to UPDATE such TEXT fields to any desired default value.

create table my_text

(
   abc text
);

delimiter //
create trigger mytext_trigger before insert on my_text
for each row
begin
   if (NEW.abc is null ) then
      set NEW.abc = 'default text';
   end if;
end
//
delimiter ;

No explanation is given by the MySQL documentation.

TEXT columns are for things which can become more than 255 bytes long.

How to disable strict mode in MySQL 5 (Windows):

    Edit /my.ini and look for line

    sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

    Replace it with

    sql_mode='MYSQL40'

    Restart the MySQL service (assuming that it is mysql5)

    net stop mysql5
    net start mysql5

If you have root/admin access you might be able to execute

mysql_query("SET @@global.sql_mode='MYSQL40'");

The official pkg distribution for en_GB-general.sql has the field bank_trans.bank_trans_type_id which needs to be removed.

The field budget_trans.memo_ is missing in the official distribution. It should be:

DROP TABLE IF EXISTS `0_budget_trans`;
CREATE TABLE IF NOT EXISTS `0_budget_trans` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tran_date` date NOT NULL DEFAULT '0000-00-00',
  `account` varchar(15) NOT NULL DEFAULT '',
  `memo_` tinytext NOT NULL,
  `amount` double NOT NULL DEFAULT '0',
  `dimension_id` int(11) DEFAULT '0',
  `dimension2_id` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `Account` (`account`,`tran_date`,`dimension_id`,`dimension2_id`)
) ENGINE=InnoDB;

The order of the fields auto_update and inactive are switched in the currencies table.

The order of the fields cust_branch.branch_ref, debtors_master.debtor_ref, stock_category.inactive and suppliers.supp_ref needs to be corrected.

The tables dashboard_reminders and dashboard_widgets should not be in this CoA.
The deprecated table sys_types is present and needs to be removed.

The table tax_types has

UNIQUE KEY `name` (`name`,`rate`)

in the GB CoA that is not present in the standard CoA sqls - it should be there to avoid ambiguities in select boxes.

$SysPrefs->base_sales cannot be "-1". It can be either 0, 1 or 2. Hence change the field value to be so where the field sys_prefs.name='base_sales' AND category='setup.company'.

There is no grn_clearing_act account defined in the official GB CoA.