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 / Support / AdsManager Support / Mysql error

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.

  1. forum
  3. Support
  5. AdsManager Support
  7. Mysql error

Mysql error

More
11 years 2 months ago #13901 by raph17
Mysql error was created by raph17
I created home menu items for every category .Everything was fine but now i get this error when i click a subcategory
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 ') AND C.PUBLISHED = 1 AND A.PUBLISHED = 1 GROUP BY A.ID ORDER BY A.DATE_CREATE' AT LINE 1 SQL=SELECT ADEXT.*, A.*,P.ID AS PARENTID,P.NAME AS PARENT,C.ID AS CATID, C.NAME AS CAT,U.USERNAME AS USER FROM MOTO2_ADSMANAGER_ADS AS A LEFT JOIN MOTO2_PAIDSYSTEM_ADS AS ADEXT ON A.ID = ADEXT.ID INNER JOIN MOTO2_ADSMANAGER_ADCAT AS ADCAT ON ADCAT.ADID = A.ID LEFT JOIN MOTO2_USERS AS U ON A.USERID = U.ID INNER JOIN MOTO2_ADSMANAGER_CATEGORIES AS C ON ADCAT.CATID = C.ID LEFT JOIN MOTO2_ADSMANAGER_CATEGORIES AS P ON C.PARENT = P.ID WHERE 1 AND C.ID IN () AND C.PUBLISHED = 1 AND A.PUBLISHED = 1 GROUP BY A.ID ORDER BY A.DATE_CREATED DESC ,A.ID DESC LIMIT 0, 3
More
11 years 2 months ago #13930 by tompap
Replied by tompap on topic Mysql error
C.ID IN () => How did you manage to have this error ? Are you using some rootid ? I think you send me a mail about this two . Please avoid duplicated ticket (email/forum) to avoid double time on the next problem
The following user(s) said Thank You: raph17
  1. forum
  3. Support
  5. AdsManager Support
  7. Mysql error
Time to create page: 0.046 seconds
Powered by Kunena Forum