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
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)
Quote from: Arno on 10.10.2014 08:49:04
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
QuoteError: 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]
Hi Water,
QuoteError: 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?
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]
Hi,
please send me login data for your backend via PM.
When possible also for phpmyadmin.
Quotebecause I see categorie on JD URL,
The 'category' in the url has nothing to do with the database table name in your error message.
QuoteI 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?
yes i have no problem before. after update problem happened. I will send you PM with the login information
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]
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
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.
Yeah this is very strange. I don't know why this is happening to me only
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]
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.
Quote from: Arno on 13.10.2014 21:44:14
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
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
Quote from: water on 17.10.2014 07:11:35
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
This is the point why i think that you have an invalid plugin installed. This does the work only when a download is published.
Or you have changed something in a file from jDownloads?
Walter,
You probably know this already but just to help if you go to Extension Manager - Manage and set the Search to jd then you will see what you have - see example in attached pic.
If you have any other jD extensions other than those listed and most importantly they do not nave the same Version Number, then I suggest you disable them to see if the problem goes away. Also if you have installed a jDownloads extension from another supplier it is unlikely that it is yet compatible with the new releases.
Colin
[gelöscht durch Administrator]
Arno
QuoteOr you have changed something in a file from jDownloads?
No I even uninstalled JD and re installed then restore backup data for JD but no change to any jd files at all.
ColinM
QuoteAlso if you have installed a jDownloads extension from another supplier it is unlikely that it is yet compatible with the new releases.
No nothing installed from any other suppliers. I can give you access if you want and have a chance to look at my site. Searched for jd extension and everything look fine I attached a pic.
[gelöscht durch Administrator]
Hi,
after i have restored the jD backup file, i have see that the downloads in a category has not any links to the details view.
But the corresponding option is not deactivated... hm...
Edit: my mistake, it is deactivated. ;)
I think the best is to send me a ftp access via PM or e-mail. Then i can download the Joomla installation withg all extensions and test it here extensive and with a debugger. ;)
Arno I sent you ftp information via email. Let me know if you need anything else
Hi,
thanks. I will test it here in the next hours.
Hi,
i think i have found and fixed the bug.
It is in the SEOSimple system plugin. See first pic. >:(
So it was exactly what we have written before. We had told you that you should deactivate any (additional) plugin to test the result.
Sad to say that you have not done this. So i have now need some hours to find this bug in an extension from a other developer...
But i understand not what you have done with the jD configuration?
You have on your server two jD upload folders:
- downloads
- jdownloads
In the configuration backup which have you sended, the folder /***/***/sajomacity.com/new/jdownloads was defined.
But this folder seems not to be writable?
See second pic.
Edit:
anything seems not correct with your Joomla settings. When you click in the backend on 'System/System Information/Directory Permissions', you will see that some folders have wrong permission settings (not writable). See last pic. So it seems for me that the absolute path is not correct set.
[gelöscht durch Administrator]
QuoteIt is in the SEOSimple system plugin. See first pic. Angry
I don't know how I missed this one. I had remove everything I installed which is very few thing. I don't remember instal SEOSimple.. is this something new that come with joomla 3.x ? or maybe Granty Framework install it in the package? Im sure I did not installed any SEO in my site.
QuoteSo it was exactly what we have written before. We had told you that you should deactivate any (additional) plugin to test the result.
Sad to say that you have not done this. So i have now need some hours to find this bug in an extension from a other developer...
Sorry for missing this part and for making you do Extra work I appreciate your help and def will Re-donate again to you and your team because your support its great.
QuoteBut i understand not what you have done with the jD configuration?
You have on your server two jD upload folders:
- downloads
- jdownloads
Hmmm no sure if it has to do with previous jd configuration. Ok i try to explain maybe you understand. when i have joomla 1.5 I have a main download directory. name was downloads. i backup this directory and create a new directory and install joomla 3.x inside this new directory and make it main web site. I moved downloads directory into new joomla directory and in JD i tried to set downloads folder main path for all my files but i was having error. Remember before I posted something about space and my file name was changing from having space to not having space. So i though maybe because i configure jd to look for downloads as main path was causing this problem. I reconfigured jd to look for file in original path jdownloads. maybe this is why you see downloads and jdownloads. but i moved everything from downloads directory to jdownloads directory so downloads is no need.
I don't know if you understand what i said but I believe this is why the configuration have -downloads and jdownloads.
Quoteanything seems not correct with your Joomla settings. When you click in the backend on 'System/System Information/Directory Permissions', you will see that some folders have wrong permission settings (not writable). See last pic. So it seems for me that the absolute path is not correct set.
I am not sure about this. Can this be a problem because i have joomla installed in a subdirectory ? and any idea how i can fix permission ? can i fix this via FTP
It look like is working with the test category that is already published. Now another problem. when I try to publish my other unpublished categories. I get error. Error
Categories folder not found, so it is not possible to publish this category: Bachata.
Also i Unpublished test category and tried to publish it again and also giving me same error.
Hi
Have you fixed the write permission on the jdownloads folder? There will be problems until that is sorted. And yes you can set the file and folder permissions with ftp. I use FileZilla. If your server runs under CPanel you can also change file and folder permissions directly.
I run most of my test sites in a sub directory with no problem.
Colin
Water
I think it is established now that this is not a jD bug - so I have moved it to General
Colin
Quote from: water on 19.10.2014 05:03:39
It look like is working with the test category that is already published. Now another problem. when I try to publish my other unpublished categories. I get error. Error
Categories folder not found, so it is not possible to publish this category: Bachata.
Also i Unpublished test category and tried to publish it again and also giving me same error.
This is correct, as you have not the correct path stored in the jD configuration for the jD upload root folder. See first pic.
I have this also posted early above.
A second problem is, that you have also lose all permission settings. I think that this is a result from a not complete backup restoration. Pleae note that in the Joomla database table 'assets' is stored all permission settings.
When you will, i can try to install jD complete new in your Joomla.
I can then try to restore the backup file which you have sended it me for a few days. ::)
A other solution is to find out which path is be correct for the jD upload root folder in configuration...
[gelöscht durch Administrator]
Sorry Colin and Arno I was on out of the country on vacation and just got back today. Since I don't have anything installed on my site I think I will install joomla again. Any update on beta 3.2.15 ?
I think this is the best way to solve the problem.
But do this before:
1. deactivate the auto monitoring in jD
2. create a backup file with jDownloads (go to the jD Tools page)
3. rename the folder in which you have currently the files (like /jdownloads to /jdownloads_old)
4. when you have Joomla and jD new installed
1) go to the jD configuration and note down the upload root folder path
2) deactivate again the auto monitoring in jD
3) delete the new created upload root 'jdownloads' path
4) rename now again the old folder with your files to 'jdownloads' ( the path should be then the same as you have note down it above)
5) go to the jD Tools page and restore the backup file
6) go to the jD configuration and type in the path from 1)
Good luck!
The new beta 3.2.15 shall be published tomorrow (i hope).
Hi
Not sure that sequence will work if it is a new Joomla! install as well. This is because jDownloads records the User Group ID in sql Table <oldprefix>_jdownloads_usergroups_limits. So I would also include taking a copy of the Joomla User Group ids in <oldprefix>_usergroups as this has the user group id and name. I actually export the table using phpmyinfo to give a csv file which would look something like the pic when displayed as a spreadsheet, rearrange columns, remove unwanted columns (parent_id, lft & rgt) and then later add in the new ids.
When the completely new Joomla is loaded, then first step should be to re create the User Groups and record their new ids, preferably using the same user group names as otherwise it becomes very 'interesting'!! From the <oldprefix>_usergroups and <newprefix>_usergroups one can form a map of UserGroup Name Old_id and New_id. At step 4-5 after restoring the jD database then the UserGroup ids would need editing. Actually as the backup file is a text file then using say Notepad++ one could edit a
copy of the backup file. The relevant section for each jDownloads UserGroups starts with the list of field names followed by the corresponding VALUES
The field names start as
$db->setQuery("INSERT INTO #__jdownloads_usergroups_limits ( `id`,`importance`,`group_id`,`download_limit_daily`,`download_limit_daily_msg`,.............
and later in the entry there are the Values as something like
VALUES ( '13','27','22','0','{en-GB}You have reached.........
The group id is the third value, which in this example is '22' and in general it will need changing.
I will expand this to an article when I get some time and after it has been tried!!
Colin
PS you should also rename folder images/jDownloads to say images/jDownloadsORIGINAL before installing the new jDownloads and do similar as with jDownloads folder to restore.
[gelöscht durch Administrator]
Hi Colin,
many thanks for this important hints. 8)
Thank you Colin and Arno. I had installed joomla from scratch and also installed JD but I will follow with your step later on maybe tonight as I have to go to work right now. One think is it worth to restore. JD Backup? I mean I really don't care about the counting and all other stuff. I just want it to work. So I was thinking about creating my JD categories and move the files from the backup directory to the new directory.. That way I will probably save myself a big problem. What you guys think about it?
Hi
Effectively you are starting again. If you just put back the old files and folders with auto monitoring off, and then turn it on then jD will create the caategories and downloads for you. You may need to edit to get permissins etc set.
Colin
Quote from: ColinM on 29.10.2014 23:36:16
Hi
Effectively you are starting again. If you just put back the old files and folders with auto monitoring off, and then turn it on then jD will create the caategories and downloads for you. You may need to edit to get permissins etc set.
Colin
Thank you Colin. will do that