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 / [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é??

More
11 years 5 months ago - 11 years 5 months ago #1875 by tompap
Oui en effet dans la requete:

GROUP BY a.id ORDER BY a. DESC LIMIT 12100, 20

ORDER BY a..

Ce trois correspond à une requete depuis l'interface ou juste à un test comme ca ?
Last edit: 11 years 5 months ago by tompap.
The following user(s) said Thank You: adarr
More
11 years 5 months ago - 11 years 5 months ago #1879 by wafa
Replied by wafa on topic erreur mysql :rien n'est affiché??

tompap wrote: Oui en effet dans la requete:

GROUP BY a.id ORDER BY a. DESC LIMIT 12100, 20

ORDER BY a..

Ce trois correspond à une requête depuis l'interface ou juste à un test comme ça ?

En fait, c'est google webmaster tools qui a détecter 200 urls erronés
j'ai remarqué que le 3 est toujours présente sur toutes les url
je pense le 3 fait un tri pour ad_city

la date où les erreurs ont commencer ça tombe avec l’installation de la nouvelle version (2.9.5)

merci

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
More
11 years 5 months ago #1881 by tompap
Replied by tompap on topic erreur mysql :rien n'est affiché??
Quel était la version précédente 2.9.4 ou plus ancienne.

le 3 est normalement l'id du champ. je vais regarder le code.
The following user(s) said Thank You: adarr
More
11 years 5 months ago #1885 by wafa
Replied by wafa on topic erreur mysql :rien n'est affiché??

tompap wrote: Quel était la version précédente 2.9.4 ou plus ancienne.

le 3 est normalement l'id du champ. je vais regarder le code.


en fait la version précédente était le 2.6.5 (le plus ancien) avec joomla 1.5


mercii

tunisie annonce


AdsManager : 3.0.4
Joomla : Joomla! 3.4.1
Host : OVH
The following user(s) said Thank You: adarr
More
11 years 5 months ago #1897 by tompap
Replied by tompap on topic erreur mysql :rien n'est affiché??
Google avait peut etre mis en cache des Urls qui n'existent plus aujourd'hui, car l'url et les paramètres ont légerement changé. Je vais rajouter dans le code une protection pour éviter de générer l'erreur SQL. ==> pour version 2.9.6
The following user(s) said Thank You: wafa, adarr
More
11 years 5 months ago #1911 by tompap
Replied by tompap on topic erreur mysql :rien n'est affiché??
Remplacer la fonction getFilterOrder dans administrator/components/com_adsmanager/models/contents.php

par
function getFilterOrder($order)
    {
	    if ($order != 0)
		{
			$this->_db->setQuery( "SELECT f.name,f.sort_direction,f.type FROM #__adsmanager_fields AS f WHERE f.fieldid=".(int)$order." AND f.published = 1" );
			$sort = $this->_db->loadObject();
			if ($sort == null) {
				$filter_order = "a.date_created DESC ,a.id ";
			} else if (($sort->type == "number")||($sort->type == "price")) {
				$filter_order = "a.".$sort->name." * 1";
			}
			else {
				$filter_order = "a.".$sort->name;
			}
		}
		else 
		{
			$filter_order = "a.date_created DESC ,a.id ";
		}
		return $filter_order;
    }
The following user(s) said Thank You: wafa, adarr
Moderators: perry
Time to create page: 0.162 seconds
Powered by Kunena Forum