Universal CSV Export - 504 Gateway Time-out

StartZurück 1 2 3 WeiterEnde
14.10.2024 15:17
#1
forty
Joomshopping forum user no avatar
Name: forty
10.07.2008
Posts: 61
Quote
Universal CSV Export - 504 Gateway Time-out

Hi, we have update joomshopping and plugins to latest version and now export is problematic and gives 504 Gateway Time-out from server but also on Universal CSV Export admin "export" button

We use Joomla! 5.1.4 Stable and PHP 8.1.30

It is server related problem?


Joomla: Joomla! 5.1.4
JoomShopping: 5.5.1
PHP: 8.1.30
MySQL: 10.6.18-MariaDB-cll-lve
Website Url: https://www.abc-mobile.gr/
 
15.10.2024 08:04
#2
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 28151
Quote
Aw: Universal CSV Export - 504 Gateway Time-out

Export by parts (lines): ?

 
15.10.2024 11:29
#3
forty
Joomshopping forum user no avatar
Name: forty
10.07.2008
Posts: 61
Quote
Aw: Universal CSV Export - 504 Gateway Time-out

The same error after 250 lines (Set 50 on admin)

 
15.10.2024 11:51
#4
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 28151
Quote
Aw: Universal CSV Export - 504 Gateway Time-out

for 50 - works?

 
15.10.2024 13:01
#5
forty
Joomshopping forum user no avatar
Name: forty
10.07.2008
Posts: 61
Quote
Aw: Universal CSV Export - 504 Gateway Time-out

Works only for 250 lines total (5x50 lines) after displays 504 Gateway Time-out. Operation not completed!


Letzte Änderung: 15.10.2024 13:02
 
15.10.2024 13:09
#6
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 28151
Quote
Aw: Universal CSV Export - 504 Gateway Time-out

Try
Export by parts (lines): 10

--------------------------------------------
Problem in your server.


Letzte Änderung: 15.10.2024 13:11
 
15.10.2024 13:23
#7
forty
Joomshopping forum user no avatar
Name: forty
10.07.2008
Posts: 61
Quote
Aw: Universal CSV Export - 504 Gateway Time-out

I try 10 and after 330 rows (Export started, 330 rows saved) stucks and after some time again 504 Gateway Time-out

How this can be solved?? Because we use it for external website to import products from Joomshopping.
Plesk (nginx) - Scheduled Tasks

Also we did not have any problem before Joomshopping and Joomla latest updates.


Letzte Änderung: 15.10.2024 13:24
 
15.10.2024 14:04
#8
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 28151
Quote
Aw: Universal CSV Export - 504 Gateway Time-out

url?
admin login?
(privat msg.)

 
16.10.2024 08:58
#9
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 28151
Quote
Aw: Universal CSV Export - 504 Gateway Time-out

Problem in category

Xiaomi/Covers - Keypads - Buzzers - Earpiece/Xiaomi/Covers - Keypads - Buzzers - Earpiece/Xiaomi/Covers - Keypads - Buzzers - Earpiece/Xiaomi/Covers - Keypads - Buzzers - Earpiece/Xiaomi/Covers - Keypads - Buzzers - Earpiece/Sony (Ericsson)

You created a category where the subcategory is set incorrectly.

Use phpMyAdmin - search problem

table: jshopping_categories

see fields
category_id
category_parent_id

-----------------------------------------
Fixed export in
Universal CSV Export 4.2.2


Letzte Änderung: 16.10.2024 08:59
 
17.10.2024 10:54
#10
forty
Joomshopping forum user no avatar
Name: forty
10.07.2008
Posts: 61
Quote
Aw: Universal CSV Export - 504 Gateway Time-out

Hi i did not create any category! The owner did :) I am helping them and the category structure confuses me.
So what is the problem with sub category to inform him not do it again.
You fixed problem or i must do something?

Thanks

 
17.10.2024 12:10
#11
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 28151
Quote
Aw: Universal CSV Export - 504 Gateway Time-out

1. Fixed export in
Universal CSV Export 4.2.2

2. Bug in category (not only for export)
category not displayed in shop

 
17.10.2024 13:44
#12
forty
Joomshopping forum user no avatar
Name: forty
10.07.2008
Posts: 61
Quote
Aw: Universal CSV Export - 504 Gateway Time-out

What is the bug i don't understand? I must inform them to not make this again

 
17.10.2024 13:46
#13
forty
Joomshopping forum user no avatar
Name: forty
10.07.2008
Posts: 61
Quote
Aw: Universal CSV Export - 504 Gateway Time-out

Category not displayed because what? The name is incorrect?

Thank you for your help!

 
17.10.2024 14:35
#14
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 28151
Quote
Aw: Universal CSV Export - 504 Gateway Time-out

Need set correct parent category.

 
17.10.2024 15:31
#15
forty
Joomshopping forum user no avatar
Name: forty
10.07.2008
Posts: 61
Quote
Aw: Universal CSV Export - 504 Gateway Time-out

Ok, Thanks

 
24.04.2025 12:15
#16
forty
Joomshopping forum user no avatar
Name: forty
10.07.2008
Posts: 61
Quote
Aw: Universal CSV Export - 504 Gateway Time-out

Hi!
we have 2 url
https://www.abc-mobile.gr/index.php?option=com_jshopping&controller=importexport&task=start&setting_id=3&id=5&key=
https://www.abc-mobile.gr/index.php?option=com_jshopping&controller=importexport&task=start&setting_id=1&id=5&key=

i am not sure if it is working.
External website cannot recieve data from the urls above
Both are set on Schedule Tasks (PLESK) and if i RUN them result is

Task "https://www.abc-mobile.gr/index.php?option=com_jshopping&controller=importexport&task=start&setting_id=1&id=5&key=" successfully completed in 49 seconds, output:

Url 'https://www.abc-mobile.gr/index.php?option=com_jshopping&controller=importexport&task=start&setting_id=1&id=5&key=' fetched
Status: 200

What is the problem?

Thanks


Joomla: 5.3
JoomShopping: 5.6.1
PHP: 8.1.32
MySQL: 10.6.21
Website Url: https://www.abc-mobile.gr

Letzte Änderung: 24.04.2025 14:24
 
24.04.2025 13:26
#17
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 28151
Quote
Aw: Universal CSV Export - 504 Gateway Time-out

https://www.abc-mobile.gr/index.php?option=com_jshopping&controller=importexport&task=start&setting_id=1&id=5&key=- works

I don't see any problems.
Check if your file (xxx.csv) has been generated.

Status: 200 = > status ok


Letzte Änderung: 24.04.2025 14:24
 
24.04.2025 13:55
#18
forty
Joomshopping forum user no avatar
Name: forty
10.07.2008
Posts: 61
Quote
Aw: Universal CSV Export - 504 Gateway Time-out

Yes i am sorry

They need a live url and they ask this below

Do you have the option to create a clone of the following url, where the file will not be exported?


Letzte Änderung: 24.04.2025 16:03
 
24.04.2025 14:23
#19
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 28151
Quote
Aw: Universal CSV Export - 504 Gateway Time-out

Yes.
------------------------
Do not share secret information on the forum - it is available to everyone.

 
24.04.2025 16:04
#20
forty
Joomshopping forum user no avatar
Name: forty
10.07.2008
Posts: 61
Quote
Aw: Universal CSV Export - 504 Gateway Time-out

Yes i am sorry
Ok this is working for one website but in this case we are talking about they need a live url and they ask this below

We operate a custom system (not cms etc) in which we have to build this mechanism that you mention ourselves
Do you have the option to create a clone of the following url, where the file will not be exported?
https://www.axxxxx.gr/components/com_jshopping/files/importexport/unicsvexport/xxxxx.xlsx



Letzte Änderung: 24.04.2025 17:03
 
StartZurück 1 2 3 WeiterEnde


Copyrights MAXXmarketing GmbH. Alle Rechte vorbehalten
Durch die Nutzung dieser Website stimme ich zu, dass Cookies zur optimalen Gestaltung der Website sowie zur Analyse der Nutzung der Website verwendet werden. Weiterführende Informationen finden Sie hier. OK, einverstanden.