Item not listed in plugin backend

It’s strange. Can you click the “mine” filter for test?

• This reply was modified 1 year, 5 months ago by Avirtum.

It’s the same under both “mine” and “all”

@avirtum I have archived your reply and flagged your account. If you ask for login again you may lose access to this site and have your plugin removed.

You need to reply here that you understand and will not repeat that again. It’s important.

While I know you have the best of intentions, it’s forum policy that you not ask users for admin or server access. Users on the forums aren’t your customers, they’re your open source collaborators, and requesting that kind of access can put you and them at high risk.

If they are paying customers (such as people who bought a premium service/product from you) then by all means, direct them to your official customer support system. But in all other cases, you need to help them here on the forums.

Thankfully are other ways to get information you need:

• Ask the user to install the Health Check plugin and get the data that way.
• Ask for a link to the https://pastebin.com/ or https://gist.github.com log of the user’s web server error log.
• Ask the user to create and post a link to their phpinfo(); output.
• Walk the user through enabling WP_DEBUG and how to log that output to a file and how to share that file.
• Walk the user through basic troubleshooting steps such and disabling all other plugins, clear their cache and cookies and try again (the Health Check plugin can do this without impacting any site vistors).
• Ask the user for the step-by-step directions on how they can reproduce the problem.

You get the idea.

We know volunteer support is not easy, and this guideline can feel needlessly restrictive. It’s actually there to protect you as much as end users. Should their site be hacked or have any issues after you accessed it, you could be held legally liable for damages. In addition, it’s difficult for end users to know the difference between helpful developers and people with malicious intentions. Because of that, we rely on plugin developers and long-standing volunteers (like you) to help us and uphold this particular guideline.

When you help users here and in public, you also help the next person with the same problem. They’ll be able to read the debugging and solution and educate themselves. That’s how we get the next generation of developers.

Ok, I do

Try to disable other installed plugins. Maybe someone filters the list.

• This reply was modified 1 year, 5 months ago by Avirtum.

I have the same problem: Our card is currently active on the front-end of the site, but does not appear in the back-end so that we can modify it? Please see the screenshot – you’ll see that it says there’s 1 item, but it doesn’t appear in the list. Please help. I’ve deactivated and reactivated all the plugins without success.

• This reply was modified 1 year, 4 months ago by imagin49.

As I said above something filters the item list. Also I don’t see your screenshot

The screen shot

Well, I see the tag “All” in the header has 1 element, and “Mine” has 1 element, but the list is empty for some reason. It likes it’s a sql issue in my plugin, but I need to check the code. Will answer soon.

• This reply was modified 1 year, 4 months ago by Avirtum.
• This reply was modified 1 year, 4 months ago by Avirtum.

Thank you

The list showing is implemennted in this file “wp-content\plugins\vision\includes\list-table-items.php”. The main code is on line 579, 580 (see code below)

...		
} else {
$sql = $wpdb->prepare("SELECT * FROM {$table} WHERE NOT deleted AND title LIKE %s ORDER BY %s %s LIMIT %d, %d", $search, $orderby, $order, $currentPage, $itemsPerPage);
$sql_total_items = $wpdb->prepare("SELECT id FROM {$table} WHERE NOT deleted AND title LIKE %s", $search);
}

I think the problem is with WHERE condition, we can delete NOT deleted for example and test, then AND title LIKE %s with the $search parameter if the first action does not help.

• This reply was modified 1 year, 4 months ago by Avirtum.

Hello,
I tried removing the NOT after WHERE but nothing happened. So I switched to your second solution with this code:
} else {

                    $sql = $wpdb->prepare("SELECT * FROM {$table} WHERE deleted ORDER BY %s %s LIMIT %d, %d", $orderby, $order, $currentPage, $itemsPerPage);

                    $sql_total_items = $wpdb->prepare("SELECT id FROM {$table} WHERE deleted);

                }

But it gives me “a critical error has occurred on the site…”.

Is there a problem with my code?
Thank you,
Stéphanie

} else {
//$sql = $wpdb->prepare("SELECT * FROM {$table} WHERE NOT deleted AND title LIKE %s ORDER BY %s %s LIMIT %d, %d", $search, $orderby, $order, $currentPage, $itemsPerPage);
//$sql_total_items = $wpdb->prepare("SELECT id FROM {$table} WHERE NOT deleted AND title LIKE %s", $search);

$sql = $wpdb->prepare("SELECT * FROM {$table} ORDER BY %s %s LIMIT %d, %d", $orderby, $order, $currentPage, $itemsPerPage);
$sql_total_items = "SELECT id FROM {$table}";
}

Try this code, it work. I’ve deleted all “WHERE” conditions. The first two string are commented, it’ original code. Lines 579, 580.

• This reply was modified 1 year, 4 months ago by Avirtum.

Good evening,
I’ve copied and pasted the code but here’s what happens:
A critical error has occurred on this site. Please check your site administration email inbox for more information.

Very strange, because it’s really simple sql query. What about this code below. Also take a screenshot of your code after paste

$sql = $wpdb->prepare("SELECT * FROM {$table} WHERE NOT deleted ORDER BY %s %s LIMIT %d, %d", $orderby, $order, $currentPage, $itemsPerPage);
$sql_total_items = "SELECT id FROM {$table}";