category in product page

go to the back end at categories you click on the "root" top left and it shows you " product category, tax category, order status, brand, συγγραφεις"
the last one "συγγραφεις"=writers click it and there are 98714 categories

Hi,

I have activate temporally the "Development error reporting" in the Joomla configuration and I've got this message.

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 26 bytes) in /home/ubook/ubook.igrouphost.com/libraries/joomla/database/database/mysql.php on line 712

Your blank page was a 500 error page.
I think that, there is too much data to load in some categories so, the mysql crashes.
When you made a query with Joomla, Joomla would load all data in memory.
I don't have the same Joomla version as you so I don't know what contains the line 712 but I think this is the direction for the investigation.

Regards,

can you please give me some more info:

In the category table in mysql joomla db, there are the following tree fields:

category_left
category_right

what is the logic of those fields? which category (id I guess) is the left and right?

also, there is a category_namekey (as far as I can remember) field. I tried to decode the data, ok, it starts from the category kind, then after the first underscore it is the integer date of the date created, but after the second underscore what is this integer? where does it come from?

Thank you so much in advanced.

Hi,

category_left and category_right are use for the tree model
en.wikipedia.org/wiki/Nested_set_model
Joomla use the same logical for this menus.
With it, you can find easily all sub elements of an element.

The namekey should be auto generated.

Regards,

hello
we insert the data from another database with a custom script so we must insert the right the left and the main key so there is no auto insert
so this has to do with the right and left object ? or just give me an example on how to insert them "manually" if possible
and what about the name key integer ? since i insert everything manually .. what could i do with that also ????
thanks

Hi,

There is no "manually". The left and right data must follow the rule of hierarchy model.
Like explain here : www.sitepoint.com/hierarchical-data-database-2/

Regards,

Thanks for your reply, I will check out the link you provided.

and what about the namekey second integer?

Hi,

The first number is the timestamp, the second number is a random number.
There is specific rule for the namekey but important thing is having a unique key.

Regards,

Hello
another thing i need your help with is this:

i want to add a general discount of 10% to all products
so i created a discount set it to 10% and tried 0 categories or assigned the general product category including the subcategories
i enabled Show discounted price and Price display method
but i can see no discount on the product

there is a link of a product for example to see what happens
ubook.igrouphost.com/index.php?option=co...ow&cid=83&Itemid=289

it shows 0€/χχχ€
the zero should be the original price (in the link above 4.15) and the xxx should be the discounted price (in our case 4.15-10%.735)

thanks

Hi gili,

Can you show with some screenshots of how did you configured your discount ? and of this product page setting ?

Thanks.

ok instead of taking screenshots
i want to do this
www.prosperus.gr/books/product_info.php?...47m8vr6h5ramfebidap1
its in greek but you can understand the red is the discounted price and the grey is the original price and the last is the discount amount

give me instructions on how to do this

thanks

Hi,

You broke up HikaShop.
You have created a custom field named "discount". This custom field broke the "discount" system. So HikaShop try to display the price using the "product discount" object which is no more an object but... your custom field.

Regards,

hello
ok so if i delete that field then it will work ?????

Yes it should work.