- Posts: 6
COMMUNITY FORUM
Attachment bug: SQL error
- Erlend Kraus
-
Topic Author
- Offline
- New Member
Less
More
15 years 7 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.
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.
- Lefteris
-
- Offline
- Moderator
Less
More
- Posts: 8743
15 years 7 months ago #73303
by Lefteris
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
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
-
Topic Author
- Offline
- New Member
Less
More
- Posts: 6
15 years 7 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.
- Absolute Textures
-
- Offline
- New Member
Less
More
- Posts: 8
15 years 7 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.
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.
- Lefteris
-
- Offline
- Moderator
Less
More
- Posts: 8743
15 years 7 months ago #73306
by Lefteris
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
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.
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.
- Absolute Textures
-
- Offline
- New Member
Less
More
- Posts: 8
15 years 6 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 :)
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.
- tonino
-
- Offline
- New Member
Less
More
- Posts: 2
15 years 4 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
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.
- Barçın Gökbörü
-
- Offline
- New Member
Less
More
- Posts: 5
15 years 4 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
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.
- Ian Powney
-
- Offline
- New Member
Less
More
- Posts: 11
15 years 1 month 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
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.
- PM Muthumbi
-
- Offline
- New Member
Less
More
- Posts: 15
15 years 1 month 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
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.
- kurchania
-
- Offline
- New Member
Less
More
- Posts: 1
14 years 10 months ago #73312
by kurchania
Replied by kurchania on topic Attachment bug: SQL error
Hello my friend ,
Let the K2 Sef Handle everything .in Sh404Sef configuration in By component tab change sh404sef plugin setting of k2 change :-
Use sh404sef plugin if available
to
Use component or core plugin
if you use 2 sh404sef plugin for same k2 than for download header cannot modify.
Let the K2 Sef Handle everything .in Sh404Sef configuration in By component tab change sh404sef plugin setting of k2 change :-
Use sh404sef plugin if available
to
Use component or core plugin
if you use 2 sh404sef plugin for same k2 than for download header cannot modify.
Please Log in or Create an account to join the conversation.
- Peter Tran
-
- Offline
- New Member
Less
More
- Posts: 5
14 years 5 months ago #73313
by Peter Tran
Replied by Peter Tran on topic Attachment bug: SQL error
Never mind.
I got the right version now.
Thanks,
Peter
abhijeet said:Hello my friend , Let the K2 Sef Handle everything .in Sh404Sef configuration in By component tab change sh404sef plugin setting of k2 change :-
Use sh404sef plugin if available
to
Use component or core plugin
if you use 2 sh404sef plugin for same k2 than for download header cannot modify.
I got the right version now.
Thanks,
Peter
abhijeet said:Hello my friend , Let the K2 Sef Handle everything .in Sh404Sef configuration in By component tab change sh404sef plugin setting of k2 change :-
Use sh404sef plugin if available
to
Use component or core plugin
if you use 2 sh404sef plugin for same k2 than for download header cannot modify.
Please Log in or Create an account to join the conversation.