1 Reply by mph

(3 replies, posted in Installation)

Since the computer was a fresh install I didn't think of that.  I cleared the cache, no difference.

The apache logs don't show any errors.  mysqlcheck shows no errors with the database or tables.

I was able to copy the old version (2.3.7)  off the old drive.  I made a new virtual host, and it works fine.  Trying to use the new version it doesn't work.  What I didn't notice before, because it's been so long since I've messed with the company setup is that what I'm trying to restore is not the first company.  I.E. when I orginally setup my databases I had a test company prefixed with 0_, the comany is use on a regular basis is prefixed with 1_.  The config_db.php file only has the definition for 0_.  The tables in the original database are 1_.

I've tried changing the config_db.php file in several ways, including copying the file from the old version, to try to get it to read the new database.  No luck.  I also massaged the mysql dump file mass substituting 0_ in place of the 1_.  Again, no luck.

I can't get it to work even if i restore the test company data first, re-create my company and restore the database in either version.  Yet copying the old database and software works.

Edit:  What is it that makes a company the default and how do I change my company to the default?

Go to forum: Installation

2 Topic by mph

(3 replies, posted in Installation)

My compter crashed recently.  I rebuilt it, installed the latest version (2.3.9) of the software.  Then I restored the yesterday's backup from 2.3.7.

Now when I login, the screen goes white.  Nothings shows up.

Any Ideas of what might be wrong?

Thanks in advance.

MPH

Go to forum: Installation

3 Reply by mph

(2 replies, posted in Banking and General Ledger)

Double entry accounting is really nothing more than "if it's going somewhere, it must come from somewhere" and vice versa.  I've been using it for since 2003  with GNUCash.

All accounting jargon aside...  If I sell $100 worth of product, put it in the bank, then pay myself that same $100.  My bank account balance should zero, not the $200 my balance is showing.  All of the customer balances are working out exactly as expected.  Additions, subtractions for inventory vs. services all look good.  The bank account balance looks fine, that is until I pay myself.

The way I figure it, I'm either missing a transaction, or just plain doing something wrong.  What I need is a process flow.  Every accounting package is a little different.  Someone with experience would be able to pick up on the nuances without much trouble.  Me on the other hand, no so.  I tried looking through the documentation, all I could find was the database relations. 

I'll figure it out.

Thanks,

MPH

Go to forum: Banking and General Ledger

4 Reply by mph

(7 replies, posted in Setup)

SOLVED: "I Hope".

  To make a short story long. wink  It was a memory problem.  There must be some specific address used when converting to PDF within Firefox.  I was starting to see some other weird problems, changed the memory and all is well with Firefox FrontAcounting and PDF.

I suppose stranger things have happened.

Go to forum: Setup

5 Topic by mph

(2 replies, posted in Banking and General Ledger)

Okay, I'm new to accounting.   But I don't think I'm this dumb... Well, I guess that's to be proven. LOL

All my bank accounts show only debits.  Customers make payments that show up as debits in the bank account, I pay myself occasionally, they also show up as debits in the bank account.  According to the software, I'm WAY beyond broke. wink

  I've set up 3 or 4 separate databases to see what I'm doing wrong.  I generate invoices under the sales tab.  I make customer payments under the same tab.  It shows FROM customer TO bank account, yet when I make the payment, it shows up as a debit.

  What am I doing wrong???

Go to forum: Banking and General Ledger

6 Reply by mph

(7 replies, posted in Setup)

I'm running it on a Linux box.  To be honest IMHO from version 3.6 on up, Firefox seem to be getting flakier.

Go to forum: Setup

7 Reply by mph

(7 replies, posted in Setup)

Since I've started using SeaMonkey I've had no problems. I really didn't have too many addons in Firefox.  The major one I would expect would have been noscript, but that didn't seem to bother it too much.  Firefox 4 had the same problems even without addons.  However FF 4 did fix the youtube problems.

  I guess I'll keep using SeaMonkey.  Now that I'm using it, it's no big deal anymore.  There's always something... wink

Go to forum: Setup

8 Reply by mph

(7 replies, posted in Setup)

I seem to be having more issues with this version of firefox.  I'm getting errors on youtube as well.  This must be a firefox issue.  I'm seriously thinking of reverting back to a previous version of the browser.  Seamonkey has been continuously working well with both frontaccounting and youtube.  Not that I use youtube all that much, but it appears to be a decent benchmark.

Go to forum: Setup

9 Topic by mph

(7 replies, posted in Setup)

Please excuse me if this has been posted before.  I've done some searching, but could not find what I'm looking for.

I just updated from 2.2.1 to 2.3.3.  However I didn't get a chance to test what I'm having a problem with before the upgrade. 

I'm running Linux using firefox 3.6.15.  The problem is when I create or view PDF files, it will work the first couple of times.  After that, the popup window is blank.  I can navigate to the directory where the PDF files are generated and view them via acrobat every time.  I've tried Seamonkey, another mozilla product with no problem.  I can view PDF files as many times as I want.  This would lead me to believe that it's a browser issue.

Has anyone else run into this?

Thanks,

Go to forum: Setup

10 Reply by mph

(12 replies, posted in Accounts Receivable)

Okay,

  What is it with me and emailing roll smile  I tried to send the modified file to contributions@frontaccounting.com

Mail Delivery Failure:

Arrival-Date: Tue, 26 Oct 2010 18:41:52 -0400

Last-Attempt-Date: Tue, 26 Oct 2010 18:41:52 -0400
Remote-MTA: dns; frontaccounting.com
Diagnostic-Code: smtp; 550 No Such User Here
Action: failed
Final-Recipient: rfc822; contributions@frontaccounting.com
Status: 5.0.0

Go to forum: Accounts Receivable

11 Reply by mph

(12 replies, posted in Accounts Receivable)

Absolutely!

  It'll just take me a little longer.  It was late (for me) last night when I got it working.  I've yet to change where the text / html content types go in the header.  I should be able to do that fairly easily tonight. 

  I have used patches for my own stuff, but have never submitted one before.  Other than documenting what I've done and trying to keep the code as fluid as possible with the original style.  Are there any other requirements / guidelines I should / could use?

Regards,

MPH

Go to forum: Accounts Receivable

12 Reply by mph

(12 replies, posted in Accounts Receivable)

Janusz,

I've got it figured out!!! 

The suhosin security patch for PHP was blocking the emails before the ever got to postfix(My email server).  This would explain why I couldn't find any info in it's log files.  I didn't find it until I increased the debug level in the postfix config file.
from /var/log/messages:

Oct 24 20:12:02 myserver suhosin[4627]: ALERT - mail() - double newline in headers, possible injection, mail dropped (attacker '10.x.x.x', file '/home/user/workspace/frontaccounting/reporting/includes/class.mail.inc', line 138)

Rather than remove a security measure, I decided to "massage" the code a little.  I removed all of the double "\n"s that I could find in the header and it still was failing.  Once I separated the body from the header, I was getting the emails.  However, for some reason there were extra line feeds in the uuencoded data which rendered the attachment useless.  Adobe said it was corrupt or improperly decoded.  So, I changed the chunking to a length of 72(which really is moot, it just wants a value) and added a "\n" for the EOL, and it everything is working great!!
The \n may not be right since I haven't tested it on a windows box yet.  I would think it's okay because email is email.  Both Windows and Linux read the same email very close to the same.

Thank You for your help and pointing me in the right direction.

Regards,

MPH

Go to forum: Accounts Receivable

13 Reply by mph

(12 replies, posted in Accounts Receivable)

Addendum:

  After a little more research (Following your instructions) It appears to be a problem with the $this->email header.  I've changed the other 2 variables and it works fine.  Any other combination including the header fails.  I don't have time to dig any further at the moment, hopefully later this evening.

Regards,

MPH
-----------
Janusz,

  Thanks for the info.  Here are the parameters being passed to the mail command.  They all look normal to me.  But I've not programmed anything this involved before.

Some of it may not look quite right as I've removed any personal information, email addresses etc...  I did verify that the original values are correct and the file pointed to does exist.

These are the variables and their values after executing the $ret = mail($mail, $this->subject, "", $this->header); statement.

$mail = Company Name Removed <my_email@address.com>

  $this->email
    to = Company Name Removed <my_email@address.com>

    cc =

    bcc =

    attachment = ../company/0/pdf_files/Invoice11.pdf

    boundry = a5bc2dd9d48cdbf1c107d47cadbcd068

    header = From: My Company <my_email@address.com>
                     MIME-Version: 1.0
                     Content-Type: multipart/mixed; boundary=a5bc2dd9d48cdbf1c107d47cadbcd068

                     This is a multi-part message in MIME format
                     --a5bc2dd9d48cdbf1c107d47cadbcd068
                     Content-Type: text/plain; charset=ISO-8859-1
                     Content-Transfer-Encoding: 8bit

                     Dear Test Customer

                     Attached you will find  Invoice No. 11

                     Kindest regards

                     Administrator
                     My Company
                     My Address
                     My City
                     00000
                     my_email@address.com
                     000.000.0000
                     --a5bc2dd9d48cdbf1c107d47cadbcd068
                     Content-Type: application/pdf; name=Invoice11.pdf
                     Content-Transfer-Encoding: base64
                     Content-Disposition: attachment; filename=Invoice11.pdf
       
                     Removed uuencoded data.

                     --a5bc2dd9d48cdbf1c107d47cadbcd068--

    subject = Invoice No. 11

    body = Content-Type: text/plain; charset=ISO-8859-1
                Content-Transfer-Encoding: 8bit

                Dear Test Customer

                Attached you will find  Invoice No. 11

                Kindest regards

                Me :)
                My Company
                My Address
                My City
                00000
                my_email@address.com
                000.000.0000

   ret = false

Thanks,

MPH

Go to forum: Accounts Receivable

14 Topic by mph

(12 replies, posted in Accounts Receivable)

Hi,

  I loaded  FA 2.2.11 a few nights ago.  I'm still poking my way around.

One problem that I can't seem to find my way around is: I can't email invoices.  I keep getting

Sending document by email failed

I did some digging around here and see that AF uses the mail function in PHP.  I can't find any entries let along errors in either the mail log or the PHP log.  I'm using postfix and can send email from the command line.  As a test I got a short PHP mailing script 

<?php
# The message
$message = "Line 1\nLine 2\nLine 3";
# Send
mail('my.email@mydomain.com', 'My Subject', $message);
?>

Which works fine.

What can I check next?

Thank You,

MPH

Go to forum: Accounts Receivable

15 Reply by mph

(11 replies, posted in Setup)

Sorry,

I got it.  I hand inadvertently deactivated the default inventory location.  Hard to ship to if you can't ship from. sad

Like I tell my wife,  I'm an idiot... but it's okay, I'm GOOD AT IT!!! big_smile

Go to forum: Setup

16 Topic by mph

(11 replies, posted in Setup)

Hi,

Please forgive my ignorance, but I'm new to AF and new to accounting. Actually an IT guy trying to help someone out.  I've done some poking around here and didn't find what I was looking for.  The https://frontaccounting.com/fawiki wasn't much help either.

Here's the problem:

  When I add a new customer, then the branch I get no errors, but when I try to create a direct invoice and select the new customer I get the following message. 

The selected customer and branch are not valid, or the customer does not have any branches.

I've tried to mimic other customers in the Training Co. to no avail.   What am I doing wrong here?

Any help would be greatly appreciated.

Thanks,

MPH

Go to forum: Setup