Import List Tab Not Working

  • Hello Sir/ Mam
    Thank you to Make a Great Plugin .
    When I Click on Import List Tab in Side my Website admin Panel ( WordPress ) . it Shows Following Error

    This page isn’t working
    londonbeauty.shop is currently unable to handle this request.
    HTTP ERROR 500

    Thank you in Advance
    https://londonbeauty.shop

    The page I need help with: [log in to see the link]

Viewing 15 replies - 1 through 15 (of 17 total)

  • Hi,
    I think you set “Number of items per page” for Import list too high. Please try decreasing it.
    Best regards

    Thread Starter oolalaji

    (@oolalaji)

    Hello kimvt1991
    Where I Found This “Number of items per page”
    Please Help

    Hi,

    Please go to the Screen Options at the top right corner of the Import list page, change number items per page there, you can see this image: https://prnt.sc/u235np

    Best regards.

    • This reply was modified 4 years, 7 months ago by mivtt.

    Because that page is not working so you have to use mysql or php to change the number of items per page.
    Please query meta key vi_wad_per_page from your usermeta table and change its value to 1.

    Thread Starter oolalaji

    (@oolalaji)

    Nice Thank you . Its Work For Value 1…How we can Adjust it More or We Use 1 Only

    It depends. Please increase that value to test it yourself.

    Thread Starter oolalaji

    (@oolalaji)

    Same Issue Again Comes… Now Not Working on Value 1

    Please enable WP_DEBUG and take a look at your errors log and tell me which error it shows.

    Thread Starter oolalaji

    (@oolalaji)

    After enable WP_DEBUG …..This is Error :
    WordPress database error: [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 ‘ASC’ at line 5]
    SELECT post_title, ID FROM wp_posts WHERE post_type = ‘product’ AND post_title != ‘Auto Draft’ GROUP BY ID ASC

    Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 102400 bytes) in /var/www/html/wp-includes/functions.php on line 4669

    Please show me a screenshot of your System Status page of this plugin.

    Thread Starter oolalaji

    (@oolalaji)

    PHP Max Execution Time 600 Should be greater than 100
    PHP Max Input Vars 1000 Should be greater than 10000
    Memory Limit 256M Should be greater than 128MB

    Please Check attached Image
    https://londonbeauty.shop/wp-content/uploads/2020/08/sp-1024×953.jpg

    They seems all good.
    Please try increasing memory limit to 512M to see if it can help.

    Some new about this problem? I have the same issue on a online shop where I work, I could not find the meta key ‘vi_wad_per_page’ on usermeta table.

    Hello @marteagam,
    If there’s no meta key vi_wad_per_page, the default value will be used which is 5 items per page.
    You can insert new row with user_id = your user ID, meta_key =’vi_wad_per_page’ and meta_value =1

    Review the plugin code I found the real problem in the line 1373 on import_list.php, previously to call the query for return the import list exist a logic for count all ‘vi_wad_draft_product’ post type, in my case I have around 5000, would be good find other way to count this posts type.

    Correction… something strange is happening before to line 1391. I did work the import list adding on the url ‘&vi_wad_search=’ and some word to search.

    Is for that ‘vi_wad_per_page’ value is not a solution.

    • This reply was modified 4 years, 7 months ago by marteagam.
    • This reply was modified 4 years, 7 months ago by marteagam.
Viewing 15 replies - 1 through 15 (of 17 total)
  • The topic ‘Import List Tab Not Working’ is closed to new replies.