- Posts: 33
- Thank you received: 18
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
Login
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.
[SOLVED]Error: 0 - SQL=SELECT adext.*, a.*, p.name
11 years 6 months ago - 11 years 6 months ago #1601
by Jaumepif
[SOLVED]Error: 0 - SQL=SELECT adext.*, a.*, p.name was created by Jaumepif
I work with joomla 3.1.5 Community Builder 1.9 Paid Subscriptions 3.0.0 and Ads manager 2.9.4.
I have 3 users:
Free - No Ads
Profesional Junior - 3 Ads of category "Servicios" and 1 of "Category Actividades"
Profesional Senior - 10 Ads of category "Servicios" and 10 of "Category Actividades"
With Paid susbsiptions create the users and assign they to joomla users group (PJ - Junior or PS - Senior).
In Ads Manager I create an Ad category Servicios with this parameters:
Maximum number of ads = 3
Access Rights Read = Public
Access Rights Write =PJ
When I save 4th service of a user profesional junior then it show this error:
Error: 0 - SQL=SELECT adext.*, a.*, p.name as parent, p.id as parentid, c.name as cat, c.id as catid,u.username as user,u.name as fullname FROM dfhdr_adsmanager_ads as a LEFT JOIN dfhdr_paidsystem_ads as adext ON a.id = adext.id INNER JOIN dfhdr_adsmanager_adcat as adcat ON adcat.adid = a.id LEFT JOIN dfhdr_comprofiler as cb ON cb.user_id = a.userid LEFT JOIN dfhdr_users as u ON a.userid = u.id INNER JOIN dfhdr_adsmanager_categories as c ON adcat.catid = c.id LEFT JOIN dfhdr_adsmanager_categories as p ON c.parent = p.id WHERE ad_gmap_lat != '' AND c.id IN (1,2,9,10,11,3,4,5,6,7,
GROUP BY a.id ORDER BY a.date_created DESC ,a.id DESC LIMIT 0, 20
I have 3 users:
Free - No Ads
Profesional Junior - 3 Ads of category "Servicios" and 1 of "Category Actividades"
Profesional Senior - 10 Ads of category "Servicios" and 10 of "Category Actividades"
With Paid susbsiptions create the users and assign they to joomla users group (PJ - Junior or PS - Senior).
In Ads Manager I create an Ad category Servicios with this parameters:
Maximum number of ads = 3
Access Rights Read = Public
Access Rights Write =PJ
When I save 4th service of a user profesional junior then it show this error:
Error: 0 - SQL=SELECT adext.*, a.*, p.name as parent, p.id as parentid, c.name as cat, c.id as catid,u.username as user,u.name as fullname FROM dfhdr_adsmanager_ads as a LEFT JOIN dfhdr_paidsystem_ads as adext ON a.id = adext.id INNER JOIN dfhdr_adsmanager_adcat as adcat ON adcat.adid = a.id LEFT JOIN dfhdr_comprofiler as cb ON cb.user_id = a.userid LEFT JOIN dfhdr_users as u ON a.userid = u.id INNER JOIN dfhdr_adsmanager_categories as c ON adcat.catid = c.id LEFT JOIN dfhdr_adsmanager_categories as p ON c.parent = p.id WHERE ad_gmap_lat != '' AND c.id IN (1,2,9,10,11,3,4,5,6,7,
GROUP BY a.id ORDER BY a.date_created DESC ,a.id DESC LIMIT 0, 20 
11 years 6 months ago #1602
by Jaumepif
Replied by Jaumepif on topic Error: 0 - SQL=SELECT adext.*, a.*, p.name as pare
I uninstall Invoice component, Virtual money component and Paid System component and then error not show.
But now Ads manager not limit right.
I create the ad category "Servicios(junior)" with these parameters
Maximum number of ads = 3
Access Rights Read = Public
Access Rights Write =PJ
And then this user can creates 4 ads of categoy "Servicios(junior)".
What's wrong?
But now Ads manager not limit right.
I create the ad category "Servicios(junior)" with these parameters
Maximum number of ads = 3
Access Rights Read = Public
Access Rights Write =PJ
And then this user can creates 4 ads of categoy "Servicios(junior)".
What's wrong?
Time to create page: 0.153 seconds