Search options (Page 1 of 2)

Shouldn't be too difficult - do you have a list of old and new?  Are you intending to change the part numbers on existing invoices and other movements or is this a "going-forward" event for invoices/movements from now-on?

W

You need to locate the file php.ini (on Debian it's typically at /etc/php5/apache2), edit the file and find the reference to register_globals.  Set the value to On and restart your web server. 

(Don't think it needs to be ON for FA though)

As you edit the file, you'll notice that setting register_globals carries a security risk.

W

In the absence of more informed contributors, have you had a look at https://frontaccounting.com/wbt/pages/download/update-guide.php ?

In your position, I'd create a fresh installation of 2.2.9 on a local (spare) server and work with that.  Once happy, push the necessary changes back to your main machine.

Whilst ignorant of the older versions of FA, my experience of making step changes in large database-backed systems is that the problems generally arise when a new, not NULL field having no default value is introduced and the restoration of data falls in a heap - fortunately easily remedied.

If you've made any changes to the reports, remember to transfer those onto the new system as well.

Hope it goes OK.

W

The first thing is probably to turn on debugging and have a look in the log files.  PHP has an unpleasant habit of showing a blank page when it's unhappy.

W

Can you use MySQL Query Browser to get the schema creation script (to verify that the table has its unique index set) and also query for the data itself (to verify the data).

For the first one, in MySQL query browser, right click on n_sales_orders and select "Copy CREATE statement to clipboard".  Paste and post the result.

For the second, use SELECT * FROM n_sales_orders s WHERE ord_date BETWEEN "2010-04-25" AND "2010-04-29" ;

(in each case, replace n with your company number.  In the latter case, use the dates between which your duplication occurred)

W

Just out of interest, is this the database on which you did that fairly innovative deletion of financial data?  If it is, could you do a backup and then re-install the FrontAccounts system and see if it then works correctly.

W

Looks like a permissions problem.  It would appear that your web server only allows files to be saved and opened above the server document root - perhaps because PHP is running in safe mode?  Use company 0 to check your configuration (on the setup menu).

W

You can't set up a product with its own discount structure.  You can however set up a range of sales types to cover the basics of many situations.  You can also edit the discount applied at the point of creating the invoice.

Not sure what you mean by "Financial Statement".  Could you explain a little more please?

W

Hi - If you go down the list of privileges - even for your full admin user - you'll almost certainly find that the check-box for tax-groups is un-checked.  It can be quite hard to spot.

W

I'm just wondering whether your initial install package was completely clean. 

If you haven't modified the code too much, and given the constraints you have it may be quickest to clear everything out and re-download & re-install the software.  I'm afraid it's so long since I used a shared host (I use virtual servers) that I can't remember even the common limitations. 

W

It's javascript that does some (most) of the clever visuals in your software.  Good designs (of which FA is one) have a fallback position so that if someone uses a browser without javascript, the software is still usable.

The suggestion was to turn off javascript temporarily, not as a fix, but to see if any errors were displayed.  Once the problems were resolved, javascript would be turned on again.  Also, have you had a look in your errors log (usually in tmp/errors.log)?