Keyword

Attachment bug: SQL error

  • Erlend Kraus
  • Erlend Kraus's Avatar Topic Author
  • Offline
  • New Member
More
14 years 11 months ago #73302 by Erlend Kraus
Attachment bug: SQL error was created by Erlend Kraus
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 'AND published=1 AND trash=0 AND access<=0' at line 1 SQL=SELECT * FROM jos_k2_categories WHERE id= AND published=1 AND trash=0 AND access<=0
Warning: Invalid argument supplied for foreach() in public_html/components/com_k2/sef_ext/com_k2.php on line 99

Any idea how to solve it? first i uploaded Attachment everything was ok, then i removed it and replaced and error appeared.

Please Log in or Create an account to join the conversation.

More
14 years 11 months ago #73303 by Lefteris
Replied by Lefteris on topic Attachment bug: SQL error
Hi. Please try to be more specific. On what page are you getting this error? Also the file that raises the warning is the plugin for sh404SEF. Try to disable sh404SEF and see if that works.

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.

  • Erlend Kraus
  • Erlend Kraus's Avatar Topic Author
  • Offline
  • New Member
More
14 years 11 months ago #73304 by Erlend Kraus
Replied by Erlend Kraus on topic Attachment bug: SQL error
ignore my bug report - it was my own fault, in some reason, i had component sh404sef enabled on Joomla with k2 which has its onw sh404sef

Please Log in or Create an account to join the conversation.

More
14 years 11 months ago #73305 by Absolute Textures
Replied by Absolute Textures on topic Attachment bug: SQL error
Hi:

I have this issue as well.... how did you fix it. I am using sh404sef 1.0.20_Beta .
K2 2.1

It was working fine for a while then I stared getting that error.

Please Log in or Create an account to join the conversation.

More
14 years 11 months ago #73306 by Lefteris
Replied by Lefteris on topic Attachment bug: SQL error
Hi. Probably a sh404SEF plugin issue. Try to recreate the URL's through sh404SEF or disable the sh404SEF.

John Holman said:Hi:
I have this issue as well.... how did you fix it. I am using sh404sef 1.0.20_Beta .
K2 2.1

It was working fine for a while then I stared getting that error.

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.

More
14 years 11 months ago #73307 by Absolute Textures
Replied by Absolute Textures on topic Attachment bug: SQL error
Well disabling sh404 makes the links work but that is not the solution I am looking for.... I want to use sh404sef with k2..

Also deleting the com_k2.php sef file that was included with k2 makes the links work, but disables the sef urls which is the whole point :)

Please Log in or Create an account to join the conversation.

More
14 years 9 months ago #73308 by tonino
Replied by tonino on topic Attachment bug: SQL error
Hello my friend, I resolved in this way (I am no expert in php):
i have edit / components/com_k2/templates/default/item.php

look for the line of code n 354

I attach a file in text format because it is impossible to paste code on this forum

To me it worked!

Sorry for my English
Attachments:

Please Log in or Create an account to join the conversation.

  • Barçın Gökbörü
  • Barçın Gökbörü's Avatar
  • Offline
  • New Member
More
14 years 9 months ago #73309 by Barçın Gökbörü
Replied by Barçın Gökbörü on topic Attachment bug: SQL error
Thanks.
replacing by these codes it works.

tonino said:Hello my friend, I resolved in this way (I am no expert in php): i have edit / components/com_k2/templates/default/item.php

look for the line of code n 354

I attach a file in text format because it is impossible to paste code on this forum

To me it worked!

Sorry for my English

Please Log in or Create an account to join the conversation.

More
14 years 6 months ago #73310 by Ian Powney
Replied by Ian Powney on topic Attachment bug: SQL error
Thanks for your code - this has solved my headache. - Fixed the problem

tonino said:Hello my friend, I resolved in this way (I am no expert in php): i have edit / components/com_k2/templates/default/item.php

look for the line of code n 354

I attach a file in text format because it is impossible to paste code on this forum

To me it worked!

Sorry for my English

Please Log in or Create an account to join the conversation.

More
14 years 6 months ago #73311 by PM Muthumbi
Replied by PM Muthumbi on topic Attachment bug: SQL error
This refuses to work for me, am i missing out something? I have followed the steps but still i get Invalid argument supplied for foreach() in \components\com_k2\views\latest\view.html.php on line 120. Any help please i am really having a headache on this.

tonino said:Hello my friend, I resolved in this way (I am no expert in php): i have edit / components/com_k2/templates/default/item.php look for the line of code n 354

I attach a file in text format because it is impossible to paste code on this forum

To me it worked!

Sorry for my English

Please Log in or Create an account to join the conversation.


Powered by Kunena Forum