In project Tour Management
I can not view layout Order Item in backend when running sandbox
It shows a message:
Fatal error: Cannot use object of type JForm as array in /home/cook/sites/www.j-cook.net/public_html/sandbox/cms30/administrator/components/com_demo9509/views/orderitem/view.html.php on line 92
Error : Cannot use object of type JForm as array


Please help me.

How can i fix it?
Thanks

I have checked you project.


This is because you have confusion in the table's names and aliases.
In TABLE ALIAS, the '_' (underscore) is not allowed.
I know, still there is a little issue, and sometimes you can do it.
Please remove all underscores there.

Table : order_item
Alias becomes : 'orderitem'
But this is already used by the 'order' table.
You have a big confusion there.

I suggest you :

Table ORDERS :
Alias table : orders
Alias item : order

Table ITEMS
Alias table : items
Alias item : item

Well, Using 'order(s)' and 'item(s)' is quite confusing also because are developper language, but you can because they are not reserved.

I already answered to you few days (or week) ago.

If you need help, I can do it

Hi,
We had designed database before applied to J-Cook.
1. And we had some tables have to have the '_' (underscore).
But like you said: "In TABLE ALIAS, the '_' (underscore) is not allowed."

That means: we can't not name table that has the underscore, can we?

2. We need to have Order_item table, but this alias have been used by Order table.
so, why J-cook don't use the name of views like Joomla?
Ex: Article: With the collection, it uses: articles
and with the item, it uses: article

As this way, in this project, Order table will have 2 views: orders and order
and Oder_item table have 2 views: orderitems and orderitem.

If, i want to fix that issue, i have to change the alias of table, that's mean i have to change the name of table order_item?

Thanks and
Regards