Search options (Page 201 of 247)

Use the standard functions in the */includes/db/*.inc files or roll your own in your module and include them in the report. If such SQLs are going to be used exclusively in the specific report only, make the wrapper function in the report itself or use it inline.

Study the existing reporting/repXXX.php files and the variable input form parameters file reporting/reports_main.php.

If you wish to have your own class of reports (Reports and Analysis Menu), then append it to the first stanza in reporting/includes/reports_classes.inc:

// Standard report classess
define('RC_CUSTOMER', 0);
define('RC_SUPPLIER', 1);
define('RC_INVENTORY', 2);
define('RC_MANUFACTURE', 3);
define('RC_DIMENSIONS', 4);
define('RC_BANKING', 5);
define('RC_GL', 6);

define('RC_PAYROLL',7); // <------ Added now

Which URL works?

Ref: Forum Post

The Official Git Mirror clone url is:

git://devel.frontaccounting.com:git/fa-stable

The browseable url is:
http://devel.frontaccounting.com/git/?p=fa-stable.git

Hope the said port 9418 is open for such cloning.

The IP reverse resolves to my.frontaccounting.com

To troubleshoot, the PortScan will be handy:

<Scan>
    <Info>PortScan</Info>
    <Host>176.31.120.126
        <Hostname>my.frontaccounting.com</Hostname>
        <OpenPort>SSH [22]</OpenPort>
        <OpenPort>SMTP [25]</OpenPort>
        <SMTPServer>220 ks395322.kimsufi.com ESMTP Postfix (Debian/GNU)</SMTPServer>
        <OpenPort>HTTP [80]</OpenPort><OpenPort>imap [143]</OpenPort>
        <IMAPServer>[CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE STARTTLS AUTH=PLAIN AUTH=LOGIN] Dovecot ready.</IMAPServer>
        <OpenPort>587</OpenPort>
        <HTTPServer>Apache/2.2.16 (Debian)</HTTPServer>
        <HTTPTitle>400 Bad Request</HTTPTitle>
    </Host>
</Scan>

Fixes needed for negative stock to work and other cosmetic changes:

File: includes/db/sql_functions.inc
Fix: missing end of file closing php tag "?>"

File:  inventory/transfers.php
Fix: Change line 79 from:
global $Refs;
to
global $Refs, $SysPrefs;

File: sales/includes/ui/sales_order_ui.inc
Fix: Remove Line 138:
    global $SysPrefs;'
as it is no longer needed.

****** All these issues and others have been addressed in the subsequent commit. *******

I deactivated the cfdi extension for the Sandbox and then tried to delete the cfdi pkg in vain. It appears that there may be some openssl issue in verification. Try to bypass the signed pkg requirement in the first post in this thread and see if that is the problem.

Also please list the steps taken to make the Release.sig file so I can replicate here.

To the extent possible try to avoid using htaccess file and place it's contents in the apache conf directly with no overrides.

Well here is the code to make an unsigned pkg for FA:

# Install ar command
apt-get install binutils

# ar usage - not used here
# ar rcs _data customernotes.php hooks.php

MODULENAME=customernotes-2.3.21-1
WEBROOT=/var/www/frontac

mkdir -p ${WEBROOT}/modules/_cache/${MODULENAME}
# upload the _init and extn files
cd ${WEBROOT}/modules/_cache/${MODULENAME}
tar -czf _data customernotes.php hooks.php
tar -czf ../../${MODULENAME}.pkg _init _data
rm -rf ${WEBROOT}/modules/_cache/${MODULENAME}
# download the ${WEBROOT}/modules/${MODULENAME}-2.3.21-1.pkg

The _init/config file will contain the extension description and parameters and will need to be appended to the Extensions file and compressed to Extensions.gz and placed in the repo root. The Extensions.gz's sha1sum should be placed in the Release file and compressed to Release.gz and placed in the repo root.

The _init/files can be prepared by referring the FAWiki.

To stay within FA, use Quick Entries or use the TextCart Extension. Otherwise:

1. Take a backup of FA
2. Post a typical entry thru the FA web interface
3. take another backup of FA
4. Compare the backups using tools like WinMerge
5. Skip the normal audit trail and logging entries and focus on the meat of the insert / updates
6. Make a template out of the insert / update sqls making the timestamp entries NOW() where appropriate (and likewise for current date)
7. Export the record variables from your manual invoice system
8. Mailmerge with the sql template created in 6
9 upload the mailmerged sql statements in a MySQL client or append them to the backup and then restore it.
10. Make sure no entries are made / changed in FA in the meanwhile.

Attempting to visit http://repo.garrapato.com/ results in a "no content here" webpage instead of prompting for a username and password. If you have set no username and password for it's access, then comment out / remove the first two array elements. It should then work.

The extensions did not download within FA but only when manually the URLs were entered in FireFox.

http://repo.garrapato.com/2.3/ seems to be password protected though.

http://repo.garrapato.com/2.3/extensions/cfdi-2.3.0-1.pkg did successfully download after providing the credentials.

http://repo.garrapato.com/2.3/extensions/zen_import-2.3.15-1.pkg also was successfully downloaded without asking for the credentials again and it is the official signed pkg.

Expect you created the Extensions.gz and Release.gz properly (since it displays only a subset including yours), otherwise enable error display and check out the SHA1sums in them if you are manually making it.

Make sure that the FA webroot has the FA.pem file if you are using any official pkgs.

Also see if the same problem arises if FA is installed in the server's webroot:
from
http://garrapato.com/sandbox/fa/
to
http://garrapato.com/

You are using latin1 charset - try utf8 / utf8-general-ci

Did you actually compile the pkgs listed in the repo? If so, please list the method you used right from key creation to pkg creation and repo updation.