- Rule not working ? Check it is enabled in the rules manager !
- If you like AltaUserPoints , Thank you for rating it at the JED:
extensions.joomla.org/extensions/extensi...stems/altauserpoints

[solved] Unable to sync users: 403 error

More
2 years 11 months ago - 2 years 10 months ago #45615 by sulpher
Hello,
I just been installed the component on an existing site and cannot sync users. There is a 403 error message in the browser console:


Failed to load resource: the server responded with a status of 403 ()
/administrator/components/com_altauserpoints/assets/synch/synch.php?start=0&run=1

How to fix this issue?

Thank you in advance.

Joomla 3.9.27
AltaUserPoints Version 1.1.14
PHP 7.4.18
Attachments:
Last edit: 2 years 10 months ago by nordmograph.

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

More
2 years 11 months ago #45621 by sulpher
Any response?

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

More
2 years 11 months ago #45623 by nordmograph
Hello,
This happens when a duplicate user is found in the #__alphauserpoints table.
Find this duplicate in phpmyadmin user and delete that entry.
Retry a sync. That should help.
Let me know.

- Need help? Post the URL of the related page (eventualy as confidential info), it will help solve your issue faster.
- An error, notice or warning? report the exact message including the line number
- If you get a white page , enable error reporting and / or check your server error logs.

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

More
2 years 10 months ago - 2 years 10 months ago #45625 by sulpher
Hello,

There are about 9200 users on the site.

I've followed this tutorial:
docs.joomla.org/J3.x:Duplicate_usernames_cause_update_issue

And checked username and email on duplication:
Code:
SELECT username FROM PREFIX_users GROUP BY username HAVING COUNT(*) > 1
and:
Code:
SELECT email FROM PREFIX_users GROUP BY email HAVING COUNT(*) > 1
In both cases I get this one:
MySQL returned an empty result set (i.e. zero rows).


So, there are no duplicates of users.

I've uninstalled AUP, removed its tables in phpmyadmin and installed the component again.
Then go AUP dashboard > sync users. There is the same error as on the pic in my previous message (403 error).
So, I am not able to sync users.
Please help.

AltaUserPoints Version 1.1.14
Joomla! 3.9.27
PHP Version 7.4.20
Last edit: 2 years 10 months ago by sulpher.

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

More
2 years 10 months ago - 2 years 10 months ago #45626 by sulpher
I've examined _alpha_userpoints table and there is just one entry:


Have a look there is userid = 0. Looks strange.

Maybe AUP can't handle 9200 users? on the other hand, then it would break during the process and there could be already a couple of hundred synced users if we think about memory limits...
Last edit: 2 years 10 months ago by sulpher.

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

More
2 years 10 months ago #45633 by nordmograph
Ok, il se peut aussi qu'une extension de sécurité du type admin tools casse cette fonctionnalité. Verifiez.

- Need help? Post the URL of the related page (eventualy as confidential info), it will help solve your issue faster.
- An error, notice or warning? report the exact message including the line number
- If you get a white page , enable error reporting and / or check your server error logs.

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

Time to create page: 0.338 seconds
Powered by Kunena Forum
Disclaimer: Nordmograph is not affiliated with or endorsed by The Joomla! Project™. Any products and services provided through this site are not supported or warrantied by The Joomla! Project or Open Source Matters, Inc. Use of the Joomla!® name, symbol, logo and related trademarks is permitted under a limited license granted by Open Source Matters, Inc.