[Plugin: dbview] Table does not appear in the post
-
Hello,
I made a query and recorded a view, put the shortcode in a post and the table does not appear… When I see the page only appears the message “0 errors” where the table should appear.
Am I doing something wrong?
-
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. http://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 “http://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 “http://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
http://formacao.ficriativa.com/empresas/ (not show the table)
http://ficriativa.com/teste/lista-de-posts/ (show the table)
OK on Chrome i get this on the error console:
XMLHttpRequest cannot load http://ficriativa.com/formacao/wp-admin/admin-ajax.php?action=dbview&verb=autoLoad&name=teste_novo&pageSize=10. Origin http://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 http://ficriativa.com/formacao/wp-admin/admin-ajax.php?action=dbview&verb=autoLoad&name=teste_novo&pageSize=10. Origin http://formacao.ficriativa.com is not allowed by Access-Control-Allow-Origin.
OK
thanks againIs the ‘WordPress Address (URL)’ set to http://formacao.ficriativa.com. The underlying problem relates to the subdomain.
The wordpress address is set to http://formacao.ficriativa.com and the site address is set to http://ficriativa.com/formacao
I changed the wordpress address (and the .htaccess file) on my test site and the same problem occurred.
The topic ‘[Plugin: dbview] Table does not appear in the post’ is closed to new replies.