Search options (Page 2 of 6)

If you click the "Post reply" or "quote" links, rather than using the "quick reply" textfiield, you'll be able to add attachments to your post.

OK. I figured that the script either fails to read some library/font etc. or it can't write the pdf data to disk. File permissions would have explained those.

What else could cause it to fail? Faulty code or faulty data. Unless you've messed with the code, I would look at the data. Does it get read as it should? Is it in the expected format (encoding)? Did you by any chance import the data from a previous install? Like, say, the 2.4 beta? The one which is supposed to be strictly UTF?

I had a similar problem once, but then that was on a ridiculously slow server. Back then I suspected that the backup queries were quite inefficient, but it made more sense to move to decent hardware than messing with the SQL. And the backups have worked ever since.

Perhaps someone with a better understanding of SQL and the FA database tables can shed some light on the issue, but until then you could always do a database dump from phpmyadmin (or the command line). It wouldn't (shouldn't!) be an option for regular users, and you'd have to restore the data using the same method. But you would have a backup, and that sure beats not having one.

Restoring a backup inserts data into the database. It's not a major security issue. It's how things work.

I guess you could prevent your users from uploading/downloading backups, but that won't stop them from overwriting each other’s data. That's why you don't want to give users access to the backups on a multi-user system in the first place.

Hmm... But that still puts the "S" into stock_master.

My idea was adding

if ($mb_flag == "S")
  $mb_flag ="D";

after

 
$mb_flag = strtoupper($mb_flag);

Found this. Do imported items actually get stored with an S? Then I guess they will be treated as inventory items.

includes/db/inventory_db.inc:

function is_inventory_item($stock_id)
{
$sql = "SELECT stock_id FROM ".TB_PREF."stock_master
WHERE stock_id=".db_escape($stock_id)." AND mb_flag <> 'D'";
$result = db_query($sql, "Cannot query is inventory item or not");
return db_num_rows($result) > 0;
}

If we have data stored with an S, it is already broken. If not, changing the core will not break anything. But we can't have two different representations for the same thing and only test for one. It should be simple enough for an upgrade script to change the database values.

setSourceFile() loads an existing pdf as a "background", onto which all output is "printed". I use it elsewhere for generating invoices, but here it's probably used to include a company letterhead.

It's probably cleaner to have separate functions for single and multiple contacts. In particular, it will establish which contact is the "primary" one and future developers won't have to guess.

About Bob's second question,

When I looked at the code, it seemed that the mail was generated and sent to each recipient (which was of course of little consequence, as there was never more than one).

I would suggest reorganising that bit to first create the message and then loop over the recipients while adding the "To" headers.

(CC is probably best avoided here, as it implies "FYI" rather than "Here's a message for you. Please do something with it". So, who is the "real" recipient, and who gets CC'ed?)

That's a bit tricky. If the printer is on the network, and the server is on the same network, you could print the file from there. Otherwise it has to go through the client. I have seen browser plugins to achieve this, but have not actually tried any of them.

I've been thinking about the problem in a slightly different context, and my best idea so far is to have the browser automatically save files of a particular type and monitor the destination directory to send print jobs to different printers based on file name.

Do you really need an account for 0-VAT? Wouldn't it make more sense with a separate sales account for those items? 4000-something.