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] Field each in categories visible

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] Field each in categories visible

[RESOLVED] Field each in categories visible

More
11 years 8 months ago - 11 years 8 months ago #9802 by sanida
[RESOLVED] Field each in categories visible was created by sanida
"Select which categories you want your field to appear."

I select, but everywhere visible. :(
Last edit: 11 years 8 months ago by loic.
More
11 years 8 months ago #9817 by loic
Replied by loic on topic Field each in categories visible
Hello,

It may be a conflict with your template.

Could you try to choose 'No' for the setting 'Do not reload edit page on category change' in the configuration of AdsManager ?

Best regards.
More
11 years 8 months ago - 11 years 4 months ago #9823 by sanida
Replied by sanida on topic Field each in categories visible
In the morning I have replaced the configuration file, the site works well, but with the Joomla -> Component -> AdsManager setting indicates the SQL error. Does not appear in the other.
SQL=ALTER IGNORE TABLE `video_adsmanager_ads` ADD `ordering` INT(10) NOT NULL default '0'


I put back the old configuration file, and it is good. :)
This error came forward while until the phpMyAdmin in the "Ordering" column had numbers instead of the zero. Now all zero, and all works all right. :) :)
Attachments:
Last edit: 11 years 4 months ago by sanida.
More
11 years 8 months ago #9833 by sanida
Replied by sanida on topic Field each in categories visible
I found it. This option is Paid System. Me "No" is selected
No change. :(
More
11 years 8 months ago #9848 by loic
Replied by loic on topic Field each in categories visible
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 #9851 by sanida
Replied by sanida on topic Field each in categories visible
"... 'components/com_adsmanager/lib/cron' and delete the line 39 to 52:..."

This will improve that which fields appear in which category?
  1. forum
  3. Support
  5. AdsManager Support
  7. [RESOLVED] Field each in categories visible
Time to create page: 0.081 seconds
Powered by Kunena Forum