Login or create new account.

By registering on joomprod.com, you will have immediate access to all our free products and to the public side of our support forum.

Enjoy our subscriptions.

Each of our subscriptions allow you to enjoy the private side of the support forum and all the update of our products for a period ranging from 3 months to 1 year.

Payment And immediate download.

After subscribing to one of our subscription, the products are immediately downloadable.

Login

Or Register
Accueil / forum / Public Forum / Main Forum / adsmanager table

Support Availability Because we must sleep sometimes

Working days: Monday to Friday.
Reply time: Depending on the complexity of your support issue it's usually between a few hours to 48 hours.

Support is only guaranteed to paid subscribers

AdsManager - End of life

It is with great regrets that we have chosen to end the developpement of Adsmanager and its other associated components.

AdsManager is born 10 years ago and, as of today, the number of new subscriptions and downloads have fallen and we cannot maintain the component anymore.

All active subscribers will be able to continue enjoying support until the end of their subscription.

The components will be free and no support will be provided anymore for the other users.

×

Notice

The forum is in read only mode.

× OLD Forum post could be checked here : forum.joomprod.com

adsmanager table

  • claudioverga
  • Topic Author
  • Offline
  • User
  • User
More
12 years 3 months ago #6127 by claudioverga
adsmanager table was created by claudioverga
hello to all
I would like to put in my classifieds site, 2 tables module AdsManager table,
and assign each table a single category. when, in the administrative side of the module,
check the desired category from the public side of the browser gives me an error.

how can I do to solve this problem?

thank you
More
12 years 3 months ago #6130 by Ads4ever
Replied by Ads4ever on topic adsmanager table
Hello,

Which kind of error do you face ?

Founder of ITechnoDev
  • claudioverga
  • Topic Author
  • Offline
  • User
  • User
More
12 years 3 months ago #6143 by claudioverga
Replied by claudioverga on topic adsmanager table
1054 - Unknown column 'momentanei' in 'where clause' SQL=SELECT a.*,p.id as parentid,p.name as parent,c.id as catid, c.name as cat,u.username as user FROM owzeq_adsmanager_ads as a INNER JOIN owzeq_adsmanager_adcat as adcat ON adcat.adid = a.id LEFT JOIN owzeq_users as u ON a.userid = u.id INNER JOIN owzeq_adsmanager_categories as c ON adcat.catid = c.id LEFT JOIN owzeq_adsmanager_categories as p ON c.parent = p.id WHERE 1 AND adcat.catid IN (momentanei) AND c.published = 1 and a.published = 1 GROUP BY a.id ORDER BY a.views DESC,a.date_created DESC ,a.id DESC LIMIT 0, 3
More
12 years 3 months ago #6165 by loic
Replied by loic on topic adsmanager table
Hello,

If you hadn't modify the files of adsManager, could you try to reinstall it ?
  • claudioverga
  • Topic Author
  • Offline
  • User
  • User
More
12 years 3 months ago #6295 by claudioverga
Replied by claudioverga on topic adsmanager table
I'm sorry but I have not tried it yet...
I'll let you 'know as soon as I install it again

ciao
  • claudioverga
  • Topic Author
  • Offline
  • User
  • User
More
12 years 3 months ago #6298 by claudioverga
Replied by claudioverga on topic adsmanager table
I found the error; I wrote the name in the appropriate field of the class, instead you must enter the number of the corresponding category. however, 'is another problem arose: if I want to include in a single table more' categories, how do you?
we assume to include the categories corresponding to the number 1 and 2 or 1 and 5?

thank you
Moderators: perry
Time to create page: 0.052 seconds
Powered by Kunena Forum