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 / 1064 You have an error in your SQL syntax

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. Public Forum
  5. Main Forum
  7. 1064 You have an error in your SQL syntax
× OLD Forum post could be checked here : forum.joomprod.com

1064 You have an error in your SQL syntax

More
11 years 10 months ago #8690 by bymamo
1064 You have an error in your SQL syntax was created by bymamo
Hi!

I am new with adsmanager.
Joomla 3.3.6
Adsmanager 3.0.2
Version de PHP 5.4.32
Version de MySQL 5.5.37-cll

When I create new add display error:
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 jom_adsmanager_adcat(adid,catid) VALUES (3,)

Can you help me please?

Thanks and nice new year.
More
11 years 10 months ago #8740 by tompap
Replied by tompap on topic 1064 You have an error in your SQL syntax
I don't know how you manage to do that. Did you try to post in the backend ? Was a category selected ,
More
11 years 10 months ago #8766 by bymamo
Replied by bymamo on topic 1064 You have an error in your SQL syntax
You can try...
netter.es
frontend-> "Publicar nuevo"

You can see now with debug system a lot of duplicate database inquiries

With new joomla instalation and new Adsmanager instalation

Thanks
More
11 years 10 months ago #8774 by tompap
Replied by tompap on topic 1064 You have an error in your SQL syntax
I found the error there is a strict standard notice dispklayed inside the javascript checker so the category is not submitted correctly

<b>Strict Standards</b>: Non-static method TImage::displayImageUploaderFormChecker() should not be called statically, assuming $this from incompatible context in <b>/home/joyeriay/public_html/netter.es/components/com_adsmanager/views/edit/tmpl/default.php</b> on line <b>544</b><br />

Could you edit components/com_adsmanager/helpers/image.php
replace
function displayImageUploaderFormChecker($nbcats=1)
by
static function displayImageUploaderFormChecker($nbcats=1)

And the problem will disappear.

It will be bette also to change your error reporting configuration in adsmanager to "simple" or "maximum" instead of "development"
More
11 years 10 months ago #8780 by bymamo
Replied by bymamo on topic 1064 You have an error in your SQL syntax
Yes I did so and missing error 1064. Thanks :)
But it have some stops

Display a lot of duplications...

"
¡ 121 duplicaciones detectadas!
5 duplicaciones: #6 #13 #62 #116 #126
2 duplicaciones: #19 #131
4 duplicaciones: #20 #23 #32 #90
31 duplicaciones: #21 #24 #27 #30 #33 #36 #39 #42 #47 #52 #57 #68 #73 #80 #88 #91 #94 #97 #100 #103 #106 #109 #113 #121 #124 #135 #138 #144 #147 #153 #156
31 duplicaciones: #22 #25 #28 #31 #34 #37 #40 #43 #48 #53 #58 #69 #74 #81 #89 #92 #95 #98 #101 #104 #107 #110 #114 #122 #125 #136 #139 #145 #148 #154 #157
4 duplicaciones: #26 #51 #56 #96
2 duplicaciones: #29 #87
2 duplicaciones: #35 #99
7 duplicaciones: #38 #102 #108 #112 #137 #146 #155
2 duplicaciones: #41 #105
7 duplicaciones: #44 #65 #70 #77 #132 #141 #150
5 duplicaciones: #45 #66 #71 #133 #142
8 duplicaciones: #46 #67 #72 #79 #120 #134 #143 #152
4 duplicaciones: #49 #54 #59 #75
3 duplicaciones: #50 #55 #60
2 duplicaciones: #78 #151
2 duplicaciones: #84 #117
"

Thanks
More
11 years 10 months ago #8795 by tompap
Replied by tompap on topic 1064 You have an error in your SQL syntax
I think it's the old ads created during your test. If you remove all duplications. And create only new one is there some new duplication ?

I am not sure totally to understand what you mean by duplicated (duplicated ads ?)
Moderators: perry
  1. forum
  3. Public Forum
  5. Main Forum
  7. 1064 You have an error in your SQL syntax
Time to create page: 0.051 seconds
Powered by Kunena Forum