Invoice Logo Not Being Applied

[Alexander Orlov]

Hi when uploading the invoice logo it then uploads to the required file but does not show on the invoices.

 

I am running the latest version of blesta so would any have any ideas on this.

[Paul]

Check if you have the GD extension in your PHP. TCPDF attempts to use GD to manipulate the logo in some circumstances, if it cannot do so it will not appear.

[Alexander Orlov]

thanks would that stop it from showing on the invoice settings page as well

[Greg-Mega]

I had the same issue, never did work out what it was that stopped it working. GD extension is in and working, permissions were good (it worked once the day prior then never again).

 

I ended up manually modifying the field in the company_data table I think it was, i think there was a row for inv_logo and inv_background, once I manually entered the path it all worked fine.

 

It also wouldn't display the picture for you to delete on the Invoice Settings page but there was no error when uploading \ saving changes.

[Alexander Orlov]

thanks for that could you PM me a sample of what you put within the database so I can make the required changes to my database.

[Greg-Mega]

I just had a look, under the `company_settings` table.

 

If you have multiple companies set up you'll have to work out which Company ID is the one you're modifying by looking in the `companies` table to get the ID.

 

Key: inv_background

Company ID: 1 (if you only have 1 Company)

Value: /home/accountname/public_html/billing/uploads/1/invoices/inv_background.jpg

 

Key: inv_logo

Company ID: 1 (if you only have 1 Company)

Value: /home/accountname/public_html/billing/uploads/1/invoices/inv_logo.jpg

 

Or you could just run:

UPDATE `company_settings` SET value = '/path/to/image' WHERE company_id = 1 AND key = 'inv_logo';

UPDATE `company_settings` SET value = '/path/to/image' WHERE company_id = 1 AND key = 'inv_background';

Change the path and Company ID as applicable.

[Alexander Orlov]

cheers for that

[Alexander Orlov]

just noticed I don't have the inv_logo one in

[Greg-Mega]

Did that fix it?

 

That's probably what it was for me, Blesta may only have been running an update query on a non existing record, I can't remember now it was a couple weeks ago. I remember being pretty convinced it wasn't anything to do with GD or file system permissions.

[Alexander Orlov]

not yet does the image have to be in the uploads file as I rather not place it their

[Alexander Orlov]

if I send you a copy of my database table for the company settings could you make the required changes?

[Greg-Mega]

not yet does the image have to be in the uploads file as I rather not place it their

 

Can you see the logo image you've uploaded? If you can't you might want to check your /tmp and /uploads directories are writable under Settings -> System -> Basic Settings. Because I could see the file being uploaded and renamed to inv_logo.ext or inv_background.ext but it wouldn't set it to it in the invoice settings. You may have a different problem if you can't see the file being uploaded and saved under your uploads directory.

[Alexander Orlov]

i am able to see the logo being uploaded to the uploads file so no idea what is going on.

[PauloV]

i am able to see the logo being uploaded to the uploads file so no idea what is going on.

Please check my solution here:

http://www.blesta.com/forums/index.php?/topic/2605-invoice-logo-is-uploaded-but-not-showing/#entry18887

[Alexander Orlov]

Hi

 

thanks for that but the only problem i have including uploading both files is the

 

UPDATE `company_settings` SET value = '/path/to/image' WHERE company_id = 1 AND key = 'inv_logo';

 

in the database that does not exist.

 

It was a new installation so could someone have a look at this for me if i sent over a copy of my database but removing admin details.

[Greg-Mega]

I will if you PHPMyAdmin export your company_settings table.

[Alexander Orlov]

cheers its been sorted with help from Greg on skype.

[Tyson]

This is the actual fix.

[Michael]

Patched up even though I don't have the issue because the code is there