Search options (Page 48 of 246)

In the sql/en_US-new.sql standard chart, the fields with the word description in them are defined thus:

# grep description en_US-new.sql | grep -v KEY

  `description` varchar(60) NOT NULL DEFAULT '',
  `description` varchar(60) NOT NULL DEFAULT '',
  `description` varchar(60) DEFAULT NULL,
  `reason_description` char(100) NOT NULL DEFAULT '',
  `description` tinytext NOT NULL COMMENT 'usage description',
  `description` tinytext,
  `description` tinytext,
  `description` varchar(60) NOT NULL DEFAULT '',
  `description` varchar(200) NOT NULL DEFAULT '',
  `description` varchar(60) NOT NULL,
  `supplier_description` char(50) NOT NULL DEFAULT '',
  `description` tinytext,
  `description` varchar(60) NOT NULL,
  `description` varchar(60) NOT NULL DEFAULT '',
  `description` varchar(60) NOT NULL DEFAULT '',
  `description` tinytext,
  `description` varchar(50) DEFAULT NULL,
  `description` varchar(60) NOT NULL DEFAULT '',
  `description` varchar(200) NOT NULL DEFAULT '',
  `long_description` tinytext NOT NULL,
  `description` varchar(200) NOT NULL DEFAULT '',
  `long_description` tinytext NOT NULL,
  `description` tinytext,
  `description` varchar(60) DEFAULT NULL,
  `description` char(50) NOT NULL DEFAULT '',

In FA v2.5 alpha, it may be useful to classify the description field differently and standardize their field length / type uniformly.

In the following files that refer to supplier_description, there is no truncation occurring in the code (except where function text_row() is used):

inventory/purchasing_data.php
inventory/includes/db/items_purchases_db.inc
purchasing/includes/purchasing_db.inc
purchasing/includes/db/po_db.inc
reporting/rep209.php

Hence, a mere increase in field size is sufficient ordinarily.

However, where a form field restricts input size / max width using the function text_row() defined in includes/ui/ui_input.inc, changes in 4th (size) and 5th (max width) arguments will also be needed. This is so only in the first file listed above.

Please try with a windows machine and the latest Firefox. Also post the URL for the right and wrong PDF paths.

Refer my chart repo for any changes from the official package.

There is no data for the 0_security_roles table in it.
Refer my commit.

@joe: can correct it in the official package.

Change settings in browser for PDF viewer to be native viewers or specific programs - Acrobat / SumatraPDF.

Verify with the stock sql/en_US-new.sql for any schema changes and unused tables and field orders.

@joe: any fixes to the core?

Create a brand new theme with your icons in place and other customisations.

Upload your Dutch translations and paste the link here.
Compare with those in the FA24extensions repo and in Transifex.

For Windows, use the following and schedule them as desired:

FTP Code File

To transfer the file from C:\Users\Admin\Desktop\Test\myfile.zip to the /backupfolder in a remote FTP server we create a file , viz., myremote.ftp in the same folder where our file to be transferred resides having the following text contents:

open <IP of FTP Server>
<FTP Username>
<FTP Password>
lcd /D "C:\Users\Admin\Desktop\Test\"
cd /backupfolder
binary
mput <file to be backed up - wildcards accepted>
disconnect
quit

Windows Batch File

Create a file zipftp.bat to zip up the set of files to be backed up (to a remote FTP server with the above credentials) having the following text contents:

SET MYFILE="myfile.zip"
IF EXIST %MYFILE% DEL /F %MYFILE%
 
"C:\Program Files\7-Zip\7z.exe" a -tzip %MYFILE% myFAfolder
 
sleep 1
 
# A remote file is automatically overwritten when a local file that
# is PUT or MPUT has the same name as the remote file.
 
ftp -i -s:myremote.ftp

Use a Journal Voucher. When an advance is given it will be either in cash or by bank entry or notional / abstract value like royalty / goodwill / goods. Use the appropriate contra account that was the source of funding in the first place.

The file includes/errors.inc has a function frindly_db_error() that is responsible for this. Check the context in which this error appears and then trace it. The said function is called only from within the said file's other function check_db_error(). This means that you will need to watch the parameters that come into the latter function and check which db table record is duplicate based on the sql passed in.

Unless the whole page is refreshed (no need for Ajax then) as in a regular Submit, other parts of the page are generally not refreshed.

Ajax, by it's very purpose of use is intended to address small / localised tag specific changes on the occurrence of some event generally the change in a field value.

Multiple such Ajax updates can be triggered by such a change to simulate a full page refresh but alignments and overflow of content will need to be handled gracefully.