[Plugin: dbview] Table does not appear in the post

The view has been marked as public.

Hmm, presumably the table appears correctly in the dashboard? Have you tried inspecting the element in the browser to check that the table isn’t hidden e.g. by style sheet. Is the table present but has zero rows? Have you tried a simple query which returns just 1 row and 1 column?

Yes, in dashboard, the table appears correctly.
I inspect the element and I don’t see anything strange. The table isnt present, and I tryed a simple query which returns just 1 row and 1 column.

I made a new wordpress install with the same theme and the same plugins, and your plugin works fine… I dont understand what’s wrong…

OK, that’s helpful. I haven’t seen this before. Sorry you are having this problem. Could you look at the two apache transfer logs. There should be (an ajax) request for the data and the response. They should be identical for both old and new installs. Thanks.

Thank you by your suport ??

‘ll have to apologize for my lack of knowledge … but where can I find these log’s?

Default location is /var/log/apache2/access.log on a linux server running apache2. It shows each URL request and the size of each response. Sorry I don’t know where the logs are on your box. This might help you find them. https://php.net/manual/en/function.phpinfo.php

Ok, I think I find the Apache log

WordPress install were dbview not show the table:
((ip)) domain.com – [10/Oct/2012:02:12:44 +0200] “GET /formacao/wp-admin/admin-ajax.php?action=dbview&verb=autoLoad&name=nova&pageSize=10 HTTP/1.1” 200 2783 “https://formacao.domain.com/empresas/” “Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.4 (KHTML, like Gecko) Chrome/22.0.1229.92 Safari/537.4”

WordPress install were dbview show the table:
((ip)) domain.com – [10/Oct/2012:03:08:57 +0200] “GET /teste/wp-admin/admin-ajax.php?action=dbview&verb=autoLoad&name=lista&pageSize=10 HTTP/1.1” 200 1975 “https://domain.com/teste/lista-de-posts/” “Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.4 (KHTML, like Gecko) Chrome/22.0.1229.92 Safari/537.4”

That’s it and quite interesting. From my reading of the log, 2783 bytes are being returned to the browser. It doesn’t ring any bells. I don’t know what to suggest next. But I’d be tempted to put a breakpoint in the browser (i could give you line number) and dump the data into a file. It could be a stack dump but they are normally displayed. Long shot, if you can make your webserver port public temporarily, I could do it.

Have you checked your browser error log? Errors are quite often hidden.

Its online

https://formacao.ficriativa.com/empresas/ (not show the table)

https://ficriativa.com/teste/lista-de-posts/ (show the table)

OK on Chrome i get this on the error console:

XMLHttpRequest cannot load https://ficriativa.com/formacao/wp-admin/admin-ajax.php?action=dbview&verb=autoLoad&name=teste_novo&pageSize=10. Origin https://formacao.ficriativa.com is not allowed by Access-Control-Allow-Origin.

I haven’t looked this up but will tomorrow.

When I inspect the page (chrome > inspect), in console show the following error:

XMLHttpRequest cannot load https://ficriativa.com/formacao/wp-admin/admin-ajax.php?action=dbview&verb=autoLoad&name=teste_novo&pageSize=10. Origin https://formacao.ficriativa.com is not allowed by Access-Control-Allow-Origin.

OK
thanks again

Is the ‘WordPress Address (URL)’ set to https://formacao.ficriativa.com. The underlying problem relates to the subdomain.

The wordpress address is set to https://formacao.ficriativa.com and the site address is set to https://ficriativa.com/formacao

I changed the wordpress address (and the .htaccess file) on my test site and the same problem occurred.