jDownloadsownloads.com



Author Topic: Site crash error: Match User Groups from jDownloads Version:3.1  (Read 5926 times)

0 Members and 1 Guest are viewing this topic.

Offline filipetorres

  • Newbie
  • *
  • Posts: 2
Hi,
I installed the plugin Match User Groups from jDownloads Version:3.1, published it and follow steps below:
1. Created new Joomla! Access Group called "Usuários Automação" and assign to a Joomla! User Group also called "Usuários Automação" created previously;
2. Edited an existent user to assign to "Usuários Automação" Joomla! User Group;
3. In jDownloads > Groups, I created a new group with the name "Usuários Automação", not added any user and save it;

Afterwards both my frontend and backend become offline and show the same crash error:
Code: [Select]
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 3 SQL=SELECT user_id FROM t8pjl_user_usergroup_map WHERE group_id IN ()
Please, help me.

My system information:
Joomla 3.1.5
jDownloads for Joomla 3.1 Version:1.9.2.8 Beta
MySQL 5.5.23-55
PHP 5.3.27
Webserver Apache

Offline Arno

  • Administrator
  • ***
  • Posts: 12.239
    • jDownloads.com
Hi,
sorry for my late reply.

To your problem: you are until today the first user with a problem like this. So i think it is not really a bug.
But perhaps has it to do with your special characters in your user group name.
Have you tried to use here only simple characters (A-Z a-z) ?
Best Regards / Gruß
Arno
Please make a Donation for jDownloads and/or write a review on the Joomla! Extensions directory!

Offline filipetorres

  • Newbie
  • *
  • Posts: 2
Hi,
sorry for my late reply.

To your problem: you are until today the first user with a problem like this. So i think it is not really a bug.
But perhaps has it to do with your special characters in your user group name.
Have you tried to use here only simple characters (A-Z a-z) ?

Hi Arno,
Joomla deals very well with accented and special characters by using UTF-8.
This plugin crashes a entire site (frontend and backend) with database query error caused by an specific file: match_user_groups_jdownloads.php.
Do you think that it's not a bug caused by this plugin? Sorry, I disagree.
I work with Joomla since 2005 and I never see a simple plugin crashes whole site. Never.
This plugin should deal with different character sets, not only A-Z a-z, like any plugin.

Anyway, I recover the site with previous backup and try again, using only A-Z a-z characters and finally works fine.
Please advise users in download page about this plugin limitation, in order to avoid this bug crashes other sites.

Thanks for your help.

Offline Arno

  • Administrator
  • ***
  • Posts: 12.239
    • jDownloads.com
Hi Filipe,

i have tested it before a few minutes here again, but can not reproduce your error.
And i have also used your group names (Usuários Automação) for group and level name (see first pic).

So it seems that here exists a other problem. When i see your posted MySQL Error, it exists not a correct value for the query here
SELECT user_id FROM t8pjl_user_usergroup_map WHERE group_id IN () <--

By the way, when you will in future remove an error like this, it is enough to deactivate the plugin in phpmyadmin in the #__extension table (see second pic).

Quote
I work with Joomla since 2005 and I never see a simple plugin crashes whole site. Never.
I work also since 2005 with it. ;)
In your case have your site crashed, because this plugin is a "system plugin" and worked all the time in background.

Please excuse me, when you have special trouble with this plugin, but i check all my extensions very extensive before i publish it.
Please mind, that also until today nobody else has posted a problem like yours.
« Last Edit: 28.10.2013 23:00:31 by Arno »
Best Regards / Gruß
Arno
Please make a Donation for jDownloads and/or write a review on the Joomla! Extensions directory!