Forums

I'm looking to have a user form on my website which will directly submit printable items to my website. Ideally it would be hidden and then I can review the info and choose to publish it. So I googled it and found this link.
Now I am not a programmer but I can edit and tinker, and so I tried this.

I did the k2 templating which seemed alright. I put the display code in a flexi code module and got a fatal error on line 1.

Fatal error: Call to undefined function process() in /home/accoolrn/public_html/tmp/htmlCdZp3b on line 1

I tried putting the php script directly in a k2 item and it showed nothing and seems to just delete the script then i toggle the editor

I believe i have templated and placed the scripts accurately, I see the article mentions older versions of joomla. I am operating on the most current joomla and k2...

Anyone have any insight or help? really looking for an easy way to get user data to be presentable or close to and i'm open to other options.

The tutorial link is not working so I couldn't check it!

I don't have any experience with k2 but you can use Chronoforms to save data to database then you can use ChronoConnetcivity to list this data.

Regards,
Max

Hi accordwithnature,

I fixed the link.

I don't' know anything about K2 - where exactly are you putting this code - it needs to be inside <?php ?> tags and presumably somewhere that the process() function is defined?

Bob

Hi there,

I looked at the tutorial and it is written for and older version of Joomla and K2. "This tutorial is tested with Joomla 2.5 and K2 2.6.8". So you can not expect it to work with your setup.

I think the solution suggested by Max would work for you. Else I have a suggestion but it does not involve Chronoforms.

Thanks
Dilshan

Yea i seen that it was for an older version of joomla (also thatthe link went down for a while) sometimes these things translate to future versions tho so i gave it a shot.

I put the code with php tags into a flexi custom code module. I had php turned on and all i got was the error message.

Interesting anout chronoconnectivity i will definitely look into that.

Whats the other suggestion oryou want me to try the chrono solution first?

Thanks for the help guys very much appreciated

Chron connectivity does appear to do what i am asking. Ill give it a shot tonight

Hi there,

There are three portions of code right? You have put the first two in item.php. The last bit of code also need to go into item.php.
Item.php is a K2 template file. It decides how your k2 item gets rendered on the web page.

Try to locate on item.php where the code is trying to print out the k2 item title.(try to find itemTitle, title or item_title something like that) That k2 item title is probably getting displayed in a h2 tag.

Paste the last portion of code just after the code which renders the item title. It will work.

I was under the impression the first box on that site is a line already in item.php

the second box goes into the item.php file after the first line

and the third box was for the backend on joomla to print what i wanted.

So i tried having all three in the item.php and im getting this so far

I tried using the third box in several places around the k2 item title and h2

it seems to be giving me an error on the "process('load');" line

"Call to undefined function process()"

if you have any other ideas id try them but im moving on to try chrono connectivity

I have just checked the tutorial link, that code is for Chronoforms v4 and will not work with v5.

What you may also try is to simply use a Chronoforms v5 plugin code {chronoforms5}form_name{/chronoforms5} and configure k2 to process plugins.

Or use Connectivity!

Regards,
Max

I started connectivity but i was having learning curve issues yesterday. Ive done some reading and should get it fairly soon.


My confusion is will i be able to create a page on form submission, and will that page function normally (be able to add and subtract modules etc). Also how i could make the created submission pending review....

So much for a newb to find out lol

My whole goal was to make the submission as internet ready as possible so im not constantly cutting and pasting content

We have some tutorials on the FAQs section under CCv5

Yes, the displayed output will be in the page main content area, just like any other Joomla extension including the core articles.

The pending review will require a field in your table to have a default "0", which can then be toggled in the admin area by setting it to a "Binary field, there was a topic about this here recently but I think under the Connectivity forums.

Regards,
Max

I've been at this for a while and there still seems to be some things that I'm just not getting.

I have a form which functions on location on my website (https://accordwithnature.com/home/submissions) but when i test the form on chronoforms I get, "Form name cannot be empty".

When I try to check my connected table I get the following long string of error message.

"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.`INT` ASC LIMIT 30' at line 1 SQL=SELECT `ListData`.`id` AS `ListData.id`, `ListData`.`uniq_id` AS `ListData.uniq_id`, `ListData`.`user_id` AS `ListData.user_id`, `ListData`.`Approved` AS `ListData.Approved`, `ListData`.`hidden25` AS `ListData.hidden25`, `ListData`.`hidden26` AS `ListData.hidden26`, `ListData`.`Category` AS `ListData.Category`, `ListData`.`Topic` AS `ListData.Topic`, `ListData`.`Affiliation` AS `ListData.Affiliation`, `ListData`.`Affiliations` AS `ListData.Affiliations`, `ListData`.`Uses` AS `ListData.Uses`, `ListData`.`Hazards` AS `ListData.Hazards`, `ListData`.`Renewability` AS `ListData.Renewability`, `ListData`.`Durability` AS `ListData.Durability`, `ListData`.`Transitional` AS `ListData.Transitional`, `ListData`.`Additional` AS `ListData.Additional`, `ListData`.`Link` AS `ListData.Link`, `ListData`.`Link_2` AS `ListData.Link_2`, `ListData`.`Link_3` AS `ListData.Link_3`, `ListData`.`Picture_upload` AS `ListData.Picture_upload`, `ListData`.`QR` AS `ListData.QR` FROM `t98_chronoengine_chronoforms_datatable_Submissions` AS `ListData` ORDER BY `ListData`.`Submissions`.`id`.`INT` ASC LIMIT 30"


Next, on chronoconnectivity I get the following error message when I test front view connection "Connection's name not present!"

And then when I test admin view i get Access Denied.


Yet the form on my page will e-mail me the form data, and when I view the database in phpmyadmin it appears the database is recording the submissions.


Any direction would be helpful, I feel like im getting close but still pretty confused.

Hi accordwithnature,

The MySQL error is from here

ORDER BY `ListData`.`Submissions`.`id`.`INT` ASC LIMIT 30"

How are you setting the ORDER BY for the listing?

Bob

sorry if i'm being dense but i looked everywhere and didn't see the option "order by?"

Hi accordwithnature,

If this is CCv5 I think it is the Order box on the Models tab

Bob

I found it and listed the categories separated by comas to no avail

id, uniq_id, user_id, Approved, hidden25, hidden26, Category, Uses, Hazards, Renewability, Durability, Transitional, Additional, Link, Link_2, Link_3, Picture_upload, QR

I'll tinker a bit but im still lost, i can't understand why it shows up blank even tho it lists the submissions, and some views claim the name is incorrect.

I fixed the viewer from giving me blank fields on the chronoform database view by altering my dbviewer code to exclude the field name, and type, which I thought a tutorial had shown me to use.

I am still having trouble in the connectivity end...

the admin connectivity try yields access denied

along with the following debug statement

"Array
(
[0] => SELECT `Extension`.`id` AS `Extension.id`, `Extension`.`name` AS `Extension.name` FROM `t98_chronoengine_extensions` AS `Extension` WHERE `Extension`.`enabled` = '1' ORDER BY `Extension`.`ordering` ASC
[1] => SELECT `Connection`.`id` AS `Connection.id`, `Connection`.`title` AS `Connection.title`, `Connection`.`params` AS `Connection.params`, `Connection`.`extras` AS `Connection.extras`, `Connection`.`published` AS `Connection.published` FROM `t98_chronoengine_connections` AS `Connection` WHERE `Connection`.`title` = 'Submissions' AND `Connection`.`published` = '1'
)"


the front view in CC yields

connection name not present.


Now I don't know about either of these. I tried altering permissions to see if i could lose the "access denied" but to no avail

As for the connection name not present im at a loss, all the names i used are Submissions can't see how the name could be not present???

Hi,

In CC you need to config the follow settings only:

#1- the connection name
#2- The model name and table ONLY
#3- the front listing -> Columns list
#4- the front listing -> permissions -> index

Please try that and don't change anything else, nothing is mandatory but the settings explained in the tutorial, some settings may cause problems if you configure them incorrectly!

Regards,
Max

Still nothing.

Access Denied

"Array
(
[0] => SELECT `Extension`.`id` AS `Extension.id`, `Extension`.`name` AS `Extension.name` FROM `t98_chronoengine_extensions` AS `Extension` WHERE `Extension`.`enabled` = '1' ORDER BY `Extension`.`ordering` ASC
[1] => SELECT `Connection`.`id` AS `Connection.id`, `Connection`.`title` AS `Connection.title`, `Connection`.`params` AS `Connection.params`, `Connection`.`extras` AS `Connection.extras`, `Connection`.`published` AS `Connection.published` FROM `t98_chronoengine_connections` AS `Connection` WHERE `Connection`.`title` = 'Submissions' AND `Connection`.`published` = '1'
)"


and on the front view connections name not present

How did you configure the permissions ?

And I couldn't understand this:

and on the front view connections name not present

Admin I made blank as we discussed

and Front view I set the view permissions to various settings but it is currently allowed for every group. I also tried public and several other combinations.

I am unsure if i need owner ID colum

Under the permissions please set "public" to "allowed" and everything else to "inherited" then save, then open the front view and logout then login.

Does it work ?

sigh, nope. I'm pretty much at a loss. I know its gotta be something stupid im missing but i just have no idea... it couldnt be a hosting issue could it?

No, this is not a hosting issue, are you sure that you have followed the tutorial correctly ?

Some Joomla installations (those with demo data) have a permissions glitch, please try to go to the "Users manager" then open the "options", make sure that the guest group is set to "guest" then "SAVE", you must save at least once, then try again.

Regards,
Max

I don't think that is it, I tried but it was already on guest.

Could you clarify how my "Front list" "Columns list" should look? I have tried several things, but its the only part of the tutorial i am hazy on. Could incorrect inputs be the problem I am experiencing?

Currently it is just a list of my columns each on a new line. At another point I had the form name before it and a period, and I had a period and the "type" after it. I tried several combinations of this too.

I'm not sure, please send me a link to you site and login info so I can check this, you can send this using PM or using the "contact us" page, but please include a link to this topic!

Regards,
Max

The problem is with your SEF, you should either configure the SEF extension to skip CCv5 OR create a menu item for your connection and test using this menu item link only.

Regards,
Max