Welcome, Guest
Username: Password: Remember me

TOPIC: Error when adding a new ad with promotion

Error when adding a new ad with promotion 1 year 7 months ago #5176

  • Pablo
  • Pablo's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 12
  • Karma: 0
Hi,

I tested adding a new ad using 60 days for promotion, using the OFFLINE payment type. This is the error message I get:

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 SQL=SELECT name,type FROM joo_jomcl_premium WHERE id IN()

This is the URL string in case it helps:

www.declasicos.com/index.php?option=com_...rderid=0&Itemid=1546

thanks
The administrator has disabled public write access.

Error when adding a new ad with promotion 1 year 7 months ago #5179

  • Super User
  • Super User's Avatar
  • Offline
  • Administrator
  • Posts: 2756
  • Thank you received: 291
  • Karma: 40
We assume that you have select "NO" for the repeat always field for your Membership. Kindly edit your membership and select "YES" and save it and check.

If still you have issues, please send the below details to This email address is being protected from spambots. You need JavaScript enabled to view it. . So that we will check and fix it.

1. Your site URL.
2. Your Joomla admin username and password.
3. Your site FTP details.

Thanks.
The administrator has disabled public write access.

Error when adding a new ad with promotion 1 year 7 months ago #5181

  • Pablo
  • Pablo's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 12
  • Karma: 0
Dear admin:

I've tested again the ad and it didn't fail. That's all right even thouhg I don't know why it failed the 1st time.

Now I have the following questions:

1) After promoting an ad, selecting Offline Payment (the most common way here), I get this screen:
Advert ID : 17
Advert Title : Vendo BSA
Amount : 22.5 $

The email I get as a customer is:
"Hello pablo,
Your Promotion is not upgraded!
Advert ID : 17
Advert Title : Vendo BSA
Amount : 22.5 $
Offline payment informations :
Advert Link : www.declasicos.com/index.php?option=com_...84:pablo&Itemid=1546"

I'd strongly need to customize this email, as well as the screen. The question is how I can do it.

2) when creating an ad, I'd need to make mandatory Price, description, location and contact fields....how can I do it?

Thanks in advance"!
The administrator has disabled public write access.

Error when adding a new ad with promotion 1 year 7 months ago #5183

  • Super User
  • Super User's Avatar
  • Offline
  • Administrator
  • Posts: 2756
  • Thank you received: 291
  • Karma: 40
Dear Customer,
Open the below file,
 Root -> language -> en-GB -> en-GB.com_jomclassifieds.ini

Find the below code and replace the content :
PLG_ADVERT_ID="Advert id : "
PLG_ADVERT_TITLE="Advert title : "
PLG_ADVERT_AMOUNT="Amount : "

In the same file Find the below code and edit it to change the mail content:
OFFLINE_PAYMENT_EMAIL_BODY="Hello %s,<br/>Your %s is not upgraded!<br/>Advert ID : %d<br/>Advert Title : %s<br/>Amount : %s<br/><strong>Offline payment informations : %s </strong><br/>Advert Link : %s<br/>Thanks"

- We made your Price, location and contact fields mandatory. But we use Joomla's editors for description. So it is not possible for us to make it mandatory.

Thanks.
The administrator has disabled public write access.
Time to create page: 0.204 seconds