john ackers

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

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.

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, 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.

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?

Don’t think I understand what has happened. What does your SQL look like? R U using any PHP snippets?

Sorry but won’t be able to investigate more until tomorrow PM.

That sounds like something I should add to the next version. Thanks for letting me know. I wasn’t aware of that.

Mike

You have to include a {sign} field in a petition (see valid fields in help). I have cut and pasted your form into into version 0.83 on my box and it works for me with that change.

The error message is useless and will fix. Been away, sorry for slow response.

John

Try replacing your {Name*} field with {name* label=Name}. It worked for me.

Field names are case sensitive. name and email are just an aliases for visitorName and visitorEmail and both are mandatory fields. (That’s not clear from the documentation, it’s fixed in next release but not yet committed).

Title and Organization are custom fields so case doesn’t matter.

No real need to have {captcha} {verificationCode} in the same form!

Hope this helps.

neworleansradio, it’s a bug and sorry for slow response. You should be able to resolve this problem by loading the ‘List views’ view and change the table name to noradionetwork.noradio_options and saving the view. Same goes for the other preinstalled views.

Or you can download the current version (0.4.5) which contains a fix for this problem. It works for me, hope it works for you.

Joe
Not sure what SQL you are using but the single and possibly double quotes look unbalanced. If the SQL I suggested works, I’d start from there.
John

Joe, I am out of town at the moment and don’t have much time to look at screens. Thanks for providing a link to your site, it’s very useful to see the HTML and fields.

In essence, you can install dbview plugin then through wp-admin menu, create a view using sql something like this
select visitorName as Name, info from wp_ecampaign_log where state='sign' order by id desc limit 10 ;
and save the view as say ‘signatures’.

Then add [dbview name='signatures'] to your wordpress page wherever you want the table to appear.

The actual sql query you need is more complicated because you need title and organisation. But the above should get you started. I can provide specific detail late next week and will update documentation because it’s weak in the area of custom fields; I thought only Mark would want that!

OK I understand now, thanks. First of all, there is a widget that displays the last n people that have signed. But it’s fairly limited and only displays first name and town or something like that. That’s what happens on lots of public petition sites.

However, if you want to display the recent/all signatures, you could use another plugin to display the fields you want to see (as discussed higher up in this thread). Using dbview, you’d set up and save a named view that contains the desired fields and it’s straightforward. You could insert that table below the ecampaign content.

There is a small problem, the table will not contain the most recently added signature until the whole page is refreshed. You could get around that by adding some javascript to refresh the table if the form submit is successful. I can probably be more specific next week.

Is that any help?

Joe, can you please elaborate on what you want to do. What do you mean by ‘a way to display the name of the signer’? Do want to change the order of the form elements? Or are you talking about listing the signatories.

Phew. Thanks Alex for the update.