Search options (Page 1 of 6)

I'm in the middle of moving servers so "The Plan" was to do the move then upgrade FA.  For now, I'll try replacing the 1 file as a stop-gap.

EDIT:  Replacing the file (for now) worked...  error message gone! 

Thanks for the help!

Chris

Has a solution to this problem been found?  Today I moved FA 2.3.24 from a hosted site to a VPS and now I'm getting this error alert at the top of the web page when I log in:

implode(): Invalid arguments passed in file: /var/www/html/accounting/includes/ui/ui_controls.inc at line 59

Printing PDF's does seem to work, though.

Thanks for any help/advice offered!

Regards,

Chris

Okay, that explains it nicely.  Thanks!

Chris

If you're in the middle of a transaction and haven't posted it, and for any reason you lose your connection to FA such that you have to start over, then yes the current data for that transaction will be lost.  One thing you can try, though, is to use the "back" button in your browser to get back to the page you were one and try refreshing it.  That may re-insert your data into the fields from your browser's cache.  It may not, too, though, so there's no guarantees.

Having said that, I'm unclear why FA running on a server using a dynamic IP would drop the connection?  The ISP's DNS server should always properly resolve the URL to the proper IP address, even if it changes.  Sounds to me like there's an issue with your ISP's DNS server.  What specific error message are you getting when the connection drops?  Are you sure it's a DNS problem and not a web server (apache or whatever) problem?

Hope that helps...

Regards,

Chris

If by "customization" you mean you have edited numerous PHP files, then deleting/recreating the database shouldn't effect that in any way, at least as far as I know.  But, if you have customized the database structure (added tables, fields, etc.), then you've got major problems in deleting/recreating the database.

Awhile back, I tried to modify an SQL script I found somewhere in the forums for "wiping clean" the database for an earlier version of FA.  That attempt failed miserably and totally trashed the database so that I had to start from scratch with a clean install.  Because of that personal experience, I would highly recommend that you do not try to "clean" the database any other way other than using FA itself to make any changes to the database contents.

Hope that's helpful...

Regards,

Chris

No, it means you have to escape commas in the description field.  that means you add "\" before each comma that's part of the "description" text so that the import module doesn't confuse those commas with field separators.  You can do this in any spreadsheet program and then save the file to cvs format for import into FA.  It's a bit of work, but using find and replace (find "," and replace with "\,") should help.

Hope that's helpful...

Regards,

Chris

I'm not 100% sure, but I think that module imports items, not sales transactions.  Can someone confirm whether this is correct?  However, if that's the case, that module could be used as the basis for developing a new module that would import sales transactions.  Not sure how much time/effort that would take, though.

Hope that's helpful...

Regards,

Chris

Errors will appear at the top of your screen, but also check tmp/errors.log and see if that provides any useful info.

Regards,

Chris

Yes, I think that's what he means.

There's another logical reason for having separate GL accounts for each bank account...  it would be extremely difficult to reconcile bank statements with the GL if accounts are intermixed in one GL account.  Having separate GL accounts would be much easier to manage/reconcile in the long run.

Hope that's helpful...

Regards,

Chris

@AlastairR:  While I understand your frustration (it bugs the heck out of me too, sometimes!), I also understand the locig of not allowing a cash account to go overdrawn.  Cash is cash!  While you're pocket/wallet can be empty, it can't have a negative amount of "cash" in it!  It's just not physically possible!

As Joe said, this only applies to accounts where the type has been set to "Cash" so setting it to anything else will solve the can't-be-negative problem.

Regards,

Chris

Okay, I uninstalled both the theme and the extension and then upgraded to FA 2.3.15.  I then went back and installed the extension and theme.  When I tried to activate the extension, I got this error message:

file(../modules/Dashboard/sql/update.sql): failed to open stream: No such file or directory in file: /var/www/accounting/admin/db/maintenance_db.inc at line 293Invalid argument supplied for foreach() in file: /var/www/accounting/admin/db/maintenance_db.inc at line 298

When I go to the Setup page, I get these error messages:

Debug mode database warning:
error code : 1146
error message : Table 'accounting.0_dashboard_widgets' doesn't exist
sql that failed was : SELECT DISTINCT column_id FROM 0_dashboard_widgets WHERE user_id ='1' AND app='system' ORDER BY column_id


mysql_fetch_array() expects parameter 1 to be resource, boolean given in file: /var/www/accounting/includes/db/connect_db.inc at line 89

So, obviously, there's still a problem.  No, I haven't used phpMyadmin to manually update the database, but will do that next.  I'm just posting this here to notify the author that this extension does not install automatically even if you're using FA 2.3.15 so something appears to need to be fixed.

No time do do the manual database update right now, so I'll do it later and report back about whether or not that works.

Regards,

Chris

Yes, I'm running FA 2.3.14 so thanks for that suggestion so I'll upgrade and see if that helps.  Btw, it would've been nice if "requires FA 3.1.15" had been included in the original post.  Just saying!

Regards,

Chris