1. Fabrik 3.9 has been released. If you have updated Joomla to 3.9, this is a required update.
    Dismiss Notice

add 3 rows element calc

Discussion in 'Community' started by albertotactik, Oct 17, 2019.

  1. albertotactik

    albertotactik Member

    Level: Community
    hello
    when making the query with phpmyadmin it gives me a value .... which is the sum of all the rows ...
    I note that since phpmyadmin and navicat, it does generate the query well.
    how strange ... instead, with the calc element of fabrik's code ... it generates an error ...
    thanks
     
  2. albertotactik

    albertotactik Member

    Level: Community
    hello Is it possible that we do some more test?
    I'm losing hope ...
    I'm sorry...
     
  3. troester

    troester Well-Known Member Staff Member

    Level: Community
    Which?
     
  4. albertotactik

    albertotactik Member

    Level: Community
    hello
    when clicking list on the web ...
    I get a 500 error
     

    Attached Files:

  5. troester

    troester Well-Known Member Staff Member

    Level: Community
    As I said some time before:
    set "Allow Fabrik debug" to Yes in Fabrik Options "Debugging" and add &fabrikdebug=1 to your URL to see the complete error message.
     
  6. albertotactik

    albertotactik Member

    Level: Community
    hello,
    attached screenshots ...
    Let's see if there is a minimum chance of solving my mistake.
    Thank you
     

    Attached Files:

  7. troester

    troester Well-Known Member Staff Member

    Level: Community
    Ok. if it's the 1st param you must append
    ?fabrikdebug=1
    i.e. ...impagat?fabrikdebug=1
     
  8. albertotactik

    albertotactik Member

    Level: Community
    good...
    now the error comes out ... I left the "?" in fabrikdebug=1
    sorry
    apparently it points to the joomla database.
    for fabrik's data ... I have its own database.
    it is possible ... that you are pointing to the joomla database ... to use ...
    $ mydb = JFactory :: getDbo ();
    $ query = $ mydb-> getQuery (true);

    I think we are close.
    Thank you! +Thank you!
     

    Attached Files:

  9. troester

    troester Well-Known Member Staff Member

    Level: Community
    lousyfool likes this.
  10. albertotactik

    albertotactik Member

    Level: Community
    good...
    I didn't know that joomla database.
    I have always worked with database specifically for fabrik.
    For separating concepts. It may not be the best.

    on the other hand ... I appreciate the help ... I must say, I have learned many concepts that I did not know.
    I'm so sorry for the time I've lost you ...
    but I am very satisfied with your help ...
    Now I can move on ... and I guess I will encounter some difficulty ... but I will continue to learn.
    From Barcelona, I send a greeting.:);):)
     

Share This Page