Extension talk:CIForms

About this board

Thank you to the creators.

3
Makertrainer (talkcontribs)

This is a great extension, and it seems like not many people had problems with it. Thank you very much for creating it.

Thomas-topway-it (talkcontribs)

hello @Makertrainer, thank you, I suggest you to upgrade to the latest version ! (1.2.1)

Makertrainer (talkcontribs)

Hi Thomas,

I updated to the newest version, and it doesn't seem to work for some reason. I ran update.php, but I still get this error:


Error 1146: Table 'makertra_mw19564.mwrh_CIForms_submissions' doesn't exist (localhost)


If you have any suggestions, I'd be glad to hear them. For now I switched back to the older version, which works fine.

Reply to "Thank you to the creators."

Translating / where to edit

3
212.23.139.2 (talkcontribs)

Hey, thank you for this great extension, by testing right now, I was wondering if it would be possible to change the text in the "Form Submission Page" and the "Submissions Spezial Page" ?

Thomas-topway-it (talkcontribs)

You can edit the messages in the file i18n/en.json

I suggest you to upgrade to the latest version ! (1.2.1)

Brunodapei (talkcontribs)

and how can i edit the message "submit" (the text of the button), please?

Reply to "Translating / where to edit"
Brunodapei (talkcontribs)

When i try to read Submissions special page it founds an error because it looks for the table "CIForms_submissions" without the prefix name (in my case: mw_)

Reply to "Problem with table name"
Idris, the wise (talkcontribs)

I have mediawiki 1.35.5 installed and I installed the latest 1.2.1 version of the extension.

When I enter the codes, I have the forms and they are working correctly, but their design is as simple as possible and not at all like the pictures.

What is my problem? I had this extension on 1 MW 1.37.1 on a localhost and the graphic design was ok


thnx

Thomas-topway-it (talkcontribs)

@Idris, the wise it could be related to the css, which is not loading. Do you have a screenshot or a link or can you check that the css load correctly ? (for instance hard-refreshing the browser)

Idris, the wise (talkcontribs)

[SOLVED]

Update:

I copied the contents of Style.css (found in /extensions/CIForms/resources/style.css) inside the /index.php/MediaWiki:Common.css.

It is working now


@Thomas-topway-it thanks for the tip to the css load problem

Thomas-topway-it (talkcontribs)

hello @Idris, the wise, I think it's related to the skin chameleon, the resources (css and javascript) are not loading, you can add them manually or I will check it as soon as possible

Idris, the wise (talkcontribs)

@Thomas-topway-it

but I found that this problem reoccurred with other skins too.

However my issue is solved now

I edited my previous comment.

Thomas-topway-it (talkcontribs)

@Idris, the wise but still the Javascript is not loading, so you need to load it in some way

Idris, the wise (talkcontribs)
Thomas-topway-it (talkcontribs)

yes but the validation will not work well

Idris, the wise (talkcontribs)
Thomas-topway-it (talkcontribs)

perhaps yes, but the Javascript select (for long lists of options) will not work

Idris, the wise (talkcontribs)
Reply to "Design Problem"

Compatibility with Postgres?

5
YahboobayYahboobay (talkcontribs)

Im getting this error when trying to submit a CIForm:

Error 42P01: relation "CIForms_submissions" does not exist

I've successfully followed all the installation steps (I did skip step 2: "Run composer update inside the folder extensions/CIForms" because i dont need the email functionality).

We are using Postgres and it looks like CIForms.php is only making the the DB changes if mysql is being used?

Is it correct that only mysql is supported? if so, what would it take to get this working with Postgres?

Thanks in advance!

YahboobayYahboobay (talkcontribs)

Update: I've been able to get Forms to submit successfully by

1. translating the two files in "CIForms/sql/" from mysql to postgres

2. making some minor changes to "CIForms/includes/specials/CIFormsSubmit.php" & "CIForms/includes/specials/CIFormsManage.php" (changing any references to the "CIForms..." tables to lower case i.e. "ciforms...")

But now i get a new database error when trying to view the results at Special:CIFormsManage:

Error 42803: ERROR: column "ciforms_submissions.id" must appear in the GROUP BY clause or be used in an aggregate function

LINE 1: SELECT /* CIFormsManage::reallyDoQuery */ ciforms_submissio...


Function: CIFormsManage::reallyDoQuery

Query: SELECT ciforms_submissions.*,

COUNT(*) as submissions,

(SELECT MAX(created_at)

FROM ciforms_submissions as b

WHERE b.title = ciforms_submissions.title


) as last_submission_date,

SUM(CASE WHEN shown IS NULL THEN 1 ELSE 0 END) as new

FROM ciforms_submissions


GROUP BY ciforms_submissions.page_id, ciforms_submissions.title

ORDER BY last_submission_date DESC LIMIT 51 OFFSET 0


It seems to originate from the database query that results from line 413 in "CIForms/includes/specials/CIFormsManage.php"

Im afraid i've reached the limits of my troubleshooting capabilities. Do you have any ideas to help me view the results in given our Postgres database?

Thanks again!

YahboobayYahboobay (talkcontribs)

Update #2:

I changed line 457 in "CIForms/includes/specials/CIFormsManage.php" to:

GROUP BY ciforms_submissions.id, ciforms_submissions.page_id, ciforms_submissions.title


and now i can view the results! So it seems to be working now.

Thomas-topway-it (talkcontribs)

@YahboobayYahboobay thanks for reporting, so the issue is related to camelcase table names, right ?

YahboobayYahboobay (talkcontribs)

@Thomas-topway-it, Sorry that my comments may have been hard to follow, I wasn't able to properly format the update comments. To summarize, in the end, there were four things to get it working with Postgres:

  1. The two .sql files had to be translated from Mysql to Postgres. (CIForms_submissions.sql and CIForms_submissions_groups.sql)
  2. Then there's the capitalization issue (postgres apparently defaults to lower case) which required changing all sql references to the database table "CIForms_..." to "ciforms_..." (in CIFormsManage.php and CIFormsSubmit.php)
  3. Finally one small change to line 457 in CIFormsManage.php made an "ERROR: column must appear in the GROUP BY clause or be used in an aggregate function" error go away. This was changing GROUP BY ciforms_submissions.page_id, ciforms_submissions.title to GROUP BY ciforms_submissions.id, ciforms_submissions.page_id, ciforms_submissions.title
  4. adjust the if statement on line 130 of CIForms.php which checks for mysql before proceeding


Hopefully that helps? Thank you for the great work on this extension!

Reply to "Compatibility with Postgres?"

Problem with install, recieving error.

4
JackKE4LWT (talkcontribs)

I'm receiving the following error: [Yhmlbwo4R_Yu6pqZqcYh0gAB1Ao] 2022-02-26 03:58:39: Fatal exception of type "Wikimedia\Rdbms\DBQueryError"

During install I was not able to get this command to execute "php maintenance/update.php" , but the extension is showing installed in the mediawiki install. I may not have "submission groups = STUFF HERE" and "$wgCIFormsSubmissionGroups" configured properly. I cannot find anything on the format of users, such as is the list comma delimited, etc.

For further information, I'm using the HostGator service for hosting.

Thomas-topway-it (talkcontribs)

@JackKE4LWT if you cannot run the command "php maintenance/update.php" you need to run directly the sql to create tables in your database, either from console or through phpmyadmin. (just copy/paste the content of the files in the sql folder in the sql tab of phpmyadmin and execute it)

73.152.111.40 (talkcontribs)

Thank you. I ran those two files (CIForms_submissions.sql and CIForms_submissions_groups.sql) and got a lot of green checks, which I'm assuming is good thing, but I'm still getting errors. The form loads and displays well, but still that flippin' error!

I have no idea if this is correct or not, but this is the section from the LocalSettings.php

wfLoadExtension( 'CIForms' );

$wgCIFormsSenderEmail= 'address@gmail.com';

$wgCIFormsSenderName= 'DEC_EC Reports';

$wgCIFormsSubmitEmail= 'address@gmail.com';

$wgCIFormsSubmissionGroups= 'user1 user2';


And this is the submit lines in the form:

{{#CI form: title = Monthly DEC/EC Report

| submission groups = user1

Thomas-topway-it (talkcontribs)

@JackKE4LWT submission groups is comma separated. I'm not sure this solves the issue, "Wikimedia\Rdbms\DBQueryError" seems a generic error, can you activate the debug and post further details ?

Reply to "Problem with install, recieving error."
Jhollinden (talkcontribs)

I'm testing this extension, using the first example that's just name, email, and a textarea. The email sends successfully, but what I receive does not contain the form data? I only get the following:


<div class="ci_form_table"><div class="ci_form_section"><table class="ci_form_section_table""></table></div></div>

Thomas-topway-it (talkcontribs)

@Jhollinded, I have updated the repository now, can you verify everything works well ? Thanks

Jhollinden (talkcontribs)

It does, thanks.

Thomas-topway-it (talkcontribs)

hello @Jhollinden, I suggest you to upgrade to the latest version ! (1.2.1)

Reply to "Emails have no content?"
Agajdosi (talkcontribs)

I am facing a problem when I try to submit CIForm, this is the error:

Warning: file_get_contents(http: // localhost:8080/extensions/CIForms/resources/style.css): failed to open stream: Connection refused in /var/www/html/extensions/CIForms/includes/specials/CIFormsSubmit.php on line 160


Do you have any ideas what could be wrong? My wiki can send stuff to users, SMTP is thus correctly configured (using SwiftMailer extension).

Thomas-topway-it (talkcontribs)

Hello @Agajdosi, we have just upgraded all the repository. Just download / install the latest version and the issue should disappear!

Reply to "Error during form submission"

Is there anyway to turn off the Google Validation?

4
Equalze (talkcontribs)

We have a wiki on an internal server so do not require this security step, can we remove it?

Thomas-topway-it (talkcontribs)
209.239.96.194 (talkcontribs)

Has anything progressed with options to disable google validation?

Thomas-topway-it (talkcontribs)

@Equalze, I have updated the repository now, the captcha verification can now be disabled

Reply to "Is there anyway to turn off the Google Validation?"
There are no older topics
Return to "CIForms" page.