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.

Accueil / forum / Public Forum / Main Forum / [RESOLVED] erreur mysql :rien n'est affiché??

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

[RESOLVED] erreur mysql :rien n'est affiché??

wafa
Topic Author
Offline
User

11 years 5 months ago - 11 years 5 months ago #1765 by wafa

[RESOLVED] erreur mysql :rien n'est affiché?? was created by wafa

bonjour

je n'ai rien apporté de modifications sur mon site, ces derniers jours mais tout d'un coup rien n'est affiché que ce message d'erreur:

0 SQL=SELECT 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 rg3sb_adsmanager_ads as a INNER JOIN rg3sb_adsmanager_adcat as adcat ON adcat.adid = a.id LEFT JOIN rg3sb_users as u ON a.userid = u.id INNER JOIN rg3sb_adsmanager_categories as c ON adcat.catid = c.id LEFT JOIN rg3sb_adsmanager_categories as p ON c.parent = p.id WHERE a.published = 1 AND c.published = TRUE AND c.id IN (29,34,36,37,35,31,30,33,32) AND c.id IN (29,1,42,10,23,16,7,38,57,4,5,6,2,3,50,8,51,9,12,13,11,14,15,22,21,20,19,18,17,28,27,26,25,24,34,36,37,35,31,30,33,32,39,40,41,49,46,45,47,48,58,59) GROUP BY a.id ORDER BY a. DESC LIMIT 0, 20

merci de m'aider à résoudre ce problème

tunisie annonce

AdsManager : 3.0.4
Joomla : Joomla! 3.4.1
Host : OVH

Last edit: 11 years 5 months ago by tompap.

The following user(s) said Thank You: adarr

loic
Offline
Gold

11 years 5 months ago #1766 by loic

Replied by loic on topic erreur mysql :rien n'est affiché??

Bonjour,

Sur quelle page étiez-vous quand vous avez eu ce problème ?

The following user(s) said Thank You: adarr

wafa
Topic Author
Offline
User

11 years 5 months ago #1767 by wafa

Replied by wafa on topic erreur mysql :rien n'est affiché??

en fait c'était sur cette page (consulter toutes les annonces) :
www.tunisie-annonce.biz/toutes_les_annonces

par contre en cliquant sur une annonce quelconque depuis la page d'accueil ça marche bien!

j'ai pu résoudre le problème en restaurant ma base de donnée à une date antérieure(hier),
j'ai pas pu identifier l'origine de ce problème.

merci

tunisie annonce

AdsManager : 3.0.4
Joomla : Joomla! 3.4.1
Host : OVH

The following user(s) said Thank You: adarr

wafa
Topic Author
Offline
User

11 years 5 months ago - 11 years 5 months ago #1801 by wafa

Replied by wafa on topic erreur mysql :rien n'est affiché??

loic wrote: Bonjour,

Sur quelle page étiez-vous quand vous avez eu ce problème ?

L'erreur mysql est toujours présent sur plusieurs pages !!
par exemple en voulant explorer cette page:
www.tunisie-annonce.biz/toutes_les_annon...expand=0&start=12100

juste après en naviguant sur toutes les autres catégories toujours une erreur mysql

0 SQL=SELECT 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 rg3sb_adsmanager_ads AS a INNER JOIN rg3sb_adsmanager_adcat AS adcat ON adcat.adid = a.id LEFT JOIN rg3sb_users AS u ON a.userid = u.id INNER JOIN rg3sb_adsmanager_categories AS c ON adcat.catid = c.id LEFT JOIN rg3sb_adsmanager_categories AS p ON c.parent = p.id WHERE a.published = 1 AND c.published = TRUE AND c.id IN (23,28,27,26,25,24) AND c.id IN (29,1,42,10,23,16,7,38,57,4,5,6,2,3,50,8,51,9,12,13,11,14,15,22,21,20,19,18,17,28,27,26,25,24,34,36,37,35,31,30,33,32,39,40,41,49,46,45,47,48,58,59) GROUP BY a.id ORDER BY a. DESC LIMIT 0, 20

on dirait une requete mysql dans adsmanager fait crasher la base de donnée ???

par contre en naviguant sur les annonces affichés sur la page d'accueil ça marche
aussi en naviguant la base depuis phpmyadmin tout est bien fonctionnel !!

c'est étrange!!

pleaase helpppp !

tunisie annonce

AdsManager : 3.0.4
Joomla : Joomla! 3.4.1
Host : OVH

Last edit: 11 years 5 months ago by wafa.

The following user(s) said Thank You: adarr

tompap
Offline
Gold

11 years 5 months ago #1833 by tompap

Replied by tompap on topic erreur mysql :rien n'est affiché??

Bonjour, il nous faudrait l'erreur SQL car la il n'y a que la requete pas l'erreur SQL

The following user(s) said Thank You: adarr

wafa
Topic Author
Offline
User

11 years 5 months ago - 11 years 5 months ago #1851 by wafa

Replied by wafa on topic erreur mysql :rien n'est affiché??

tompap wrote: Bonjour, il nous faudrait l'erreur SQL car la il n'y a que la requete pas l'erreur SQL

sur cette page par exemple:
www.tunisie-annonce.biz/toutes_les_annonces?order=3&expand=0&start=12100

ça affiche une requête sql et non pas une erreur , et ceci avec ?order=3
j'ai essayé avec ?order1 et ?order2 c'est ok

avec ?order=3 ça pose un problème d’exécution de la requête

tunisie annonce

AdsManager : 3.0.4
Joomla : Joomla! 3.4.1
Host : OVH

Last edit: 11 years 5 months ago by wafa.

The following user(s) said Thank You: adarr

Moderators: perry

Time to create page: 0.138 seconds