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 / [RESOLVED] i have an 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. [RESOLVED] i have an error

[RESOLVED] i have an error

More
11 years 8 months ago - 11 years 8 months ago #9835 by catalinads
[RESOLVED] i have an error was created by catalinads
Sometimes when i click home .. or a category i get :
1054 - Unknown column 'ordering' in 'field list' SQL=UPDATE v8mvs_adsmanager_ads SET ordering = 767 WHERE id = 1

that number after ordering is not the same all the time
I even deleted all my test ads... but still getting this
Last edit: 11 years 8 months ago by loic.
More
11 years 8 months ago #9836 by Ints
Replied by Ints on topic i have an error
I have the same problem.
Adsmanager 3.0.3
Joomla! 3.3.6
More
11 years 8 months ago #9850 by loic
Replied by loic on topic i have an error
Hello,

We have found fromwhere this error come from.

To solve this open the file 'components/com_adsmanager/lib/cron' and delete the line 39 to 52:
$db = JFactory::getDbo();
 
			$query = "SELECT id FROM #__adsmanager_ads";
			$db->setQuery($query);
 
			$ads = $db->loadObjectList();
 
			foreach($ads as $ad) {
				$query = "UPDATE #__adsmanager_ads
						  SET ordering = ".rand(0, 1000)."
						  WHERE id = ".(int)$ad->id;
				$db->setQuery($query);
				$db->query();
			}

This will solve the problem.

We integrated this fix for the next version.

Best regards
More
11 years 8 months ago #9877 by catalinads
Replied by catalinads on topic i have an error
Perfect. for me worked
More
11 years 8 months ago #9889 by Ints
Replied by Ints on topic i have an error
Yes, now it's working
More
11 years 8 months ago #9914 by loic
Replied by loic on topic i have an error
I'm glad this solved the problem :).

I update the topic subject to resolved.

Best regards.
  1. forum
  3. Support
  5. AdsManager Support
  7. [RESOLVED] i have an error
Time to create page: 0.078 seconds
Powered by Kunena Forum