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 / Category in bronze - 1064 You have an error in...

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. Category in bronze - 1064 You have an error in...

Category in bronze - 1064 You have an error in...

More
9 years 6 months ago - 9 years 6 months ago #15099 by tovilio
Category in bronze - 1064 You have an error in... was created by tovilio
I uninstalled adsmanager free in order to install bronze version, as I need to eliminate the watermark on images. With bronze version I experience the following issue:
"1064 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 ')' at line 1 SQL=INSERT INTO yc3r4_adsmanager_adcat(adid,catid) VALUES (11,)
In my opinion this issue comes from the fact that the free version had on the left a field containing all the categories and on the right an empty field. By selecting a category on the left, this appeared on the right. With the bronze version, the field on the right has completely disappeared as you can see in the image I am attaching.

So in reality the insertion cannot be saved as it didn't contain any category. Why the field on the right disappeared and what can I do to put it back? Thank you.
Last edit: 9 years 6 months ago by tovilio.
More
9 years 6 months ago #15116 by loic
Replied by loic on topic Category in bronze - 1064 You have an error in...
Hello,

The component doesn't seems to recover the category id.

Could you tell me what you are doing to make this error occur ?

Also, when you upgrade AdsManager, you don't need to uninstall it, you can install the upgrade while a version is already installed.

Best regards.
More
9 years 6 months ago - 9 years 6 months ago #15233 by tovilio
Replied by tovilio on topic Category in bronze - 1064 You have an error in...
The error occurs when I create a new insertion. I am not allowed to specify in which category the insertion should be inserted. The error occurs even if I don't uninstall it and go directly for the upgrade.
File Attachment:

Best Regards.
Last edit: 9 years 6 months ago by tovilio.
More
9 years 6 months ago #15329 by loic
Replied by loic on topic Category in bronze - 1064 You have an error in...
Hello,

One of the fields for the categorie selection is missing.

Could you send me an URL to your website and an admin account to support @ juloa.com (remove the spaces) ?

I will check that.

Best regards.
More
9 years 6 months ago #15345 by tovilio
Replied by tovilio on topic Category in bronze - 1064 You have an error in...
I sent you the mail.

Thank you. :)
More
9 years 6 months ago #15385 by loic
Replied by loic on topic Category in bronze - 1064 You have an error in...
Hello,

I found the error and answered you by email, for the other users that might have this issue, here is the fix.

In 'components/com_adsmanager/helpers/category.php', line 281, cut this line:
$defaultoptions = array("root_allowed"=>true,"display_price" => false,"separator" => " > ","id" => $name);

And paste it just before this bloc line 278 to 280:
if (strpos($name,"[]") === false) {
	$name = $name."[]";	
}

It will solve the problem.

Best regards.
The following user(s) said Thank You: Wakini
  1. forum
  3. Support
  5. AdsManager Support
  7. Category in bronze - 1064 You have an error in...
Time to create page: 0.157 seconds
Powered by Kunena Forum