MySQL error after update to Joomla 3.3.6

[water]

Im still getting  Error: 1064 - You have an error in your SQL syntax

Is this related to pagination ? sorry but cant get this problem fix I just updated JD to new beta 3.2.14 and still same error

[Arno]

Hi Water,
when you get by update an sql error, nothing is changed in your jD.
So you have still the old version.

What was exactly the error message?
What is your currently jD version? (see jD control panel)

[water]

Hi Water,
when you get by update an sql error, nothing is changed in your jD.
So you have still the old version.

What was exactly the error message?
What is your currently jD version? (see jD control panel)

here is the error I get. and also a screenshot of jd 3.2.14 I installed update yesterday. Let me know if its something else I need to do. Thank you

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=SELECT cat.description FROM surqa_categories cat WHERE cat.id=

[gelöscht durch Administrator]

[Arno]

Hi Water,

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=SELECT cat.description FROM surqa_categories cat WHERE cat.id=

Sorry but this error has nothing to do with jDownloads.
As you can see above, the table name is '_categories'. In jDownloads exist not a table like this. But Joomla has a table with this name.
By which situation have you get this error?
Why think you that it has to do with the pagination issue?

[water]

Thank you Arno for your reply. This is very confuse. I had same problem before and i had to complete install joomla from scratch. now after update from joomla 3.3.4 to 3.3.6 I have this problem again. I understand you say JD doesn't have  '_categories' this is very strange because I see categorie on JD URL, I attach two pictures so you can see. If you have a chance you can check my page http://sajomacity.com/index.php?option=com_jdownloads&view=categories&Itemid=141 And click any category to see error.

Thank you



[gelöscht durch Administrator]

[Arno]

Hi,
please send me login data for your backend via PM.
When possible also for phpmyadmin.

because I see categorie on JD URL,

The 'category' in the url has nothing to do with the database table name in your error message.

I had same problem before and i had to complete install joomla from scratch. now after update from joomla 3.3.4 to 3.3.6 I have this problem again.

With 'problem' mean you the sql error message?
Before you have updated to Joomla 3.3.6 has it works without the sql error, so he comes first after your update?

[water]

yes i have no problem before. after update problem happened. I will send you PM with the login information

[Arno]

Hi Water,
i have checked your backend and here are my results:

1. your described problem here has nothing to do with the 'pagination issue' above. So i will move your issue to a new thread.
2. i think that your problem has not 'really' to do with jDownloads.
  The reasons are:
  - as you can see in the error message, the query will get a result from the Joomla DB table 'categories'
  - jDownloads use only a own DB table with name 'jdownloads_categories'
3. that you get the error when you click on a categories title, can be a hint that a content or system plugin creates this error.
   So you should reflect what for plugins have you installed in the last time and deactivate this step by step to check the results.    

[gelöscht durch Administrator]

[water]

Hmm this is very frustrating I disable every plugin I think I have installed also disable module and Components but same problem. I am not sure if it has to do with JD of plugin because i only installed maybe 3 or 4 extension on my site but i disable everything and still same problem. I also update Granty framework today because i had v.4.1.25 now i have latest v.4.1.26 same problem. what else can i do to make sure JD is not the problem? any recommendation? Arno feel free to go on my site backend and disable any extension you think can be causing problem. and let me know. @ ColinM if you reading this and can help I will give you access to my site backend and phpMyAdmin I just want to fix this problem

Thank you for helping me Arno and colinm

[Arno]

Hi,
i think the only way is to have a complete backup from your site (without the jDownloads files and .
This could i restore here locally (on my PC) and check it then with a debugger.
But this is much work.

So i think you should use for the moment the backup from your Joomla 3.3.4 version (which seems to work as you have told before).
Maybe is it then also possible (with activated Joomla debug option) to find out the source for your problem.

By the way: nobody else has reported a problem like yours with jD and Joomla 3.3.6.

[water]

Yeah this is very strange. I don't know why this is happening to me only

[water]

Unfortunately I did not have a backup I know I should of made one but since it was a fresh install and I am still working setting up the site I did not bather making a backup. But here is what I did. I uninstalled all components and plugin i remember i installed. I also went to PHPMyAdmin and drop the table for those components and plugin. I uninstalled JD and Drop all table on phpmyadmin. I re-installed jd enable the categories already there but when i enable any file inside category problem happen. category with no file activate in work but if I publish a file inside category problem happen. Any Idea? can you check that. if you want you can go to phpmyadmin and drop the table also look at category that have published file inside you see problem but if you check category with no file publish problem no there

http://sajomacity.com/index.php?option=com_jdownloads&view=categories&Itemid=141 Main Download

http://sajomacity.com/index.php?option=com_jdownloads&view=category&catid=4&Itemid=141 no publish file inside here

http://sajomacity.com/index.php?option=com_jdownloads&view=category&catid=2&Itemid=141 Here i have published file

extrange. if you go to category that has no publish file inside it goe insinde no error and if you click drop down in the corner and select all download you can see published file in other category. Look at picture attack

[gelöscht durch Administrator]

[Arno]

Hi,
it is clear that you get not the error for the 'All Downloads' page. Here is not listed any categories.

Please create a backup from your jDownloads data and use for this the jD backup function in the Tools page.
Then send me the file via e-mail.
I need not the assigned files (i hope).

Create also von your '_extension' table a backup via phpmyadmin and sent this too.

[water]

Hi,
it is clear that you get not the error for the 'All Downloads' page. Here is not listed any categories.

Please create a backup from your jDownloads data and use for this the jD backup function in the Tools page.
Then send me the file via e-mail.
I need not the assigned files (i hope).

Create also von your '_extension' table a backup via phpmyadmin and sent this too.

ok i have a backup from JD data files not sure if you mean backup DB for Jd. I did made backup of jd DB. Ok I sent it to you let me know if you need more information let me know

[water]

I noted if i unpublished the file inside any category jd look like its working and when i activate the file problem start to happen this is driving me crazy. jejeje