add 3 rows element calc

[albertotactik]

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

 

[albertotactik]

hello Is it possible that we do some more test?
I'm losing hope ...
I'm sorry...

 

[troester]

it generates an error

Which?

 

[albertotactik]

Which?

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

 

[troester]

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.

 

[albertotactik]

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

 

[troester]

Ok. if it's the 1st param you must append
?fabrikdebug=1
i.e. ...impagat?fabrikdebug=1

 

[albertotactik]

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!

 

[troester]

As you can see your table doesn't exist in your database...

If you using multiple Fabrik connections you must know what you are doing and create the query on the correct connection.
http://fabrikar.com/forums/index.php?wiki/php-common-tasks/#use-alternate-fabrik-connection

 

[albertotactik]

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.