Buy Now
Sign in

No error message, but no data displaying

tmonsta , February 14 at 19:26
T
tmonsta
I'm setting up what is intended to just be a table of data, pulled from user profiles
I just want to show their avatar, first and last name, and a description (from their profile)​
​and I'm not getting any errors, but nothing is populating​
​​
​I'm pulling data from a table created by Membership Pro​
​​
​I have read and reread, and recreated the view, function and event, and I can't seem to figure out why this isn't working​
​​
​any help in resolving this would be appreaciated
GreyHead
Hi tmonsta ,
It's not possible to say much from the info here. What do you see if you enable the CC Debugger? Does the query shown there work correctly if you test it in PHPMyAdmin?
Bob
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
T
tmonsta
is there good documentation somewhere? i read through the FAQs the 3 tutorial documents, but they focus on pulling articles. ​
​​
​as for the debugging... i didn't know chrono connect had a debugger. where would i turn that on at.​
​​
​sorry for the newb questions. i'm very experienced with joomla, but the lack of documentation on this one is making getting started a bit difficult.
T
tmonsta
I have some of the fields populating. i'm having some issues with the custom fields from membership pro, and i think that has something to do with how it stores the data​
​​
​there's a table called osm-membershipfields and then it stores them by field id, which in this case is 23.​
​is there a way I need to set up that function
admin
Hi tmonsta,
Connectivity works well and easily with horizontal tables, when a table is connected to another using a foreign key, but some tables store the data virtually, like the Joomla profile fields table for example and this makes managing the data harder.
if this is how the data is stored in your case then you will need to post some screenshots of the tables here and I will try to let you know how you can manage the steup in Connectivity.
Best regards
Max
If your main question got answered then please mark the answer using the button!​
​Please let us know if you have any problems with the new forums text editor, we appreciate your feedback!
T
tmonsta
Here is an example​
​​
​thanks so much for your help​
db-fields1.png
Attachments
db-fields1.png
db-fields1.png
(256.81 KiB)
192 Downloads/Views
T
tmonsta
Hi Max
Hadn't heard back for how to display this data in combination with the profile fields. I tried a couple of things, but nothing so far has worked.​
​​
​the data I want to display is in the orange circled field.​
​​
​It's field_id 23. I haven't seen any documentation for chronoconnectivity 6 on how to filter results
Thanks
T
tmonsta
I know exactly what the SQL query should be, but cant figure out how to set it up in the plugin.​
​​
admin
Hi tmonsta,
You have a vertical table and reading the data will not be straight forward, you will need to retrieve each user's profile fields values using a an associated model and set the relation type to "Multiple records", and set the relation conditions to associate the tables using the "subscriber_id" field, this should retrieve the user profile fields values but in order to display them in the the table in the user's row you will need to modify the data structure before its used in the table using PHP, I can help you with that, but please set up the "Read data" first and add a debugger after the "Read data" then post the debugger output here to make sure the data is setup correctly.
Best regards
Max
If your main question got answered then please mark the answer using the button!​
​Please let us know if you have any problems with the new forums text editor, we appreciate your feedback!