Support

Home › Forums › Event Espresso Premium › Change invoice and receipt image

Change invoice and receipt image

Posted: August 22, 2022 at 9:40 pm

Viewing 5 reply threads


stateconadmin

August 22, 2022 at 9:40 pm

I would like to change the invoice and receipt image I have change it in General Setting —> Upload New Logo and saved. The image shows on the general setting page. However, when I go to a transaction and view the receipt or invoice it shows the old logo.


Tony

  • Support Staff

    •

August 23, 2022 at 2:43 am

Hi there,

The invoice payment method has an option to override the general settings image.

Go to Event Espresso -> Payment methods -> Invoice.

If it’s not enabled then temporarily enable it.

In those settings you’ll find a ‘Logo Image’ field, the old image is likely set there. Empty the field and save, it should switch to the image set in general settings then.


stateconadmin

August 23, 2022 at 6:31 am

Thank you that did the trick for the image of receipts and invoices. I am also seeing the following at the top of receipts but not invoices.

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 1]
SELECT OPT_DESC FROM {prefix}esp_question_price_opt WHERE id IN ()

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 1]
SELECT OPT_DESC FROM {prefix}esp_question_price_opt WHERE id IN ()

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 1]
SELECT OPT_DESC FROM {prefix}esp_question_price_opt WHERE id IN ()

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 1]
SELECT OPT_DESC FROM {prefix}esp_question_price_opt WHERE id IN ()

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 1]
SELECT OPT_DESC FROM {prefix}esp_question_price_opt WHERE id IN ()

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 1]
SELECT OPT_DESC FROM {prefix}esp_question_price_opt WHERE id IN ()

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 1]
SELECT OPT_DESC FROM {prefix}esp_question_price_opt WHERE id IN ()

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 1]
SELECT OPT_DESC FROM {prefix}esp_question_price_opt WHERE id IN ()

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 1]
SELECT OPT_DESC FROM {prefix}esp_question_price_opt WHERE id IN ()

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 1]
SELECT OPT_DESC FROM {prefix}esp_question_price_opt WHERE id IN ()

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 1]
SELECT OPT_DESC FROM {prefix}esp_question_price_opt WHERE id IN ()

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 1]
SELECT OPT_DESC FROM {prefix}esp_question_price_opt WHERE id IN ()

One other item, I can download the pdf for invoices but not receipts.
The error for downloading receipt is:

Unable to stream pdf: headers already sent

Thanks again for your help with the logo.

Stewart


Tony

  • Support Staff

    •

August 23, 2022 at 7:20 am

Hi Stewart,

Ok, so this:

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 1]
SELECT OPT_DESC FROM {prefix}esp_question_price_opt WHERE id IN ()

In English, is saying there is a problem with the query being used to pull details from the database and to break it down a little more:

SELECT OPT_DESC FROM {prefix}esp_question_price_opt WHERE id IN ()

Again, in English, pull OPT_DESC from the table {prefix}esp_question_price_opt WHERE the ID is in {nothing}.

So the problem with the query is it’s asking for values where the ID is nothing, meaning no value will exist, so it’s an error.

However, we (EventEspresso) do not use a esp_question_price_opt table within Event Espresso. I know from past experience that that table is from a 3rd party add-on called the Price Modifier add-on and that’s what is causing the above error.

Are you actively using that plugin or is one you’ve used in the past?

Note we don’t provide support for 3rd party add-ons so you’ll likely need to contact the author of that plugin (Aparna) to investigate this.


stateconadmin

August 23, 2022 at 7:45 am

Thank you, make great sense thanks for the explanation. I am using the add on price modifier and I will contact Aparna. Thanks again.


Tony

  • Support Staff

    •

August 23, 2022 at 1:21 pm

You’re most welcome 🙂

Just let me know if I can help.
Viewing 5 reply threads

The support post ‘Change invoice and receipt image’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Support forum for Event Espresso 3 and Event Espresso 4.
Documentation for EE3 and EE4
Documentation for Event Espresso 3 Documentation for Event Espresso 4

Status: closed

Updated by Tony 2 years, 4 months ago ago

Topic Tags

Notifications

This topic is: not resolved
Event Espresso