Fatal error when trying to add a product :(

-- url of the page with the problem -- :http://temp.yaeliq.com/fruits/product/24590-acai-berry-2.html
-- HikaShop version -- : 2.3.0
-- Joomla version -- : 2.5
-- PHP version -- : 5.4.24
-- Browser(s) name and version -- : chrome last one
-- Error-message(debug-mod must be tuned on) -- : Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 512 bytes) in /home/yaeliq1965roz/public_html/temp/libraries/joomla/database/database/mysqli.php on line 498

Fatal error: Access to undeclared static property: JLoader::$classes in /home/yaeliq1965roz/public_html/temp/libraries/loader.php on line 195

Very new in Hika business. Trying to upload products and this is the error I got. Please help me! Thanks

I increased my PHP memory limit and there is still an error. I spoke with my server (godaddy) and they told me that there is a bug with my component. There is a page using 128 mb memory in loop all the time.
I tried to delete this product but got an error too and can'not delete it.
this is the page:
temp.yaeliq.com/fruits.html

and try to go into "anise"

Please help me with this.
thanks/

Hey,

I just added 2 products and problems start. I do not modify anything in code or even in CSS. Nothing.

If you want i can provide you enter to admin so you can check.

Hi,
The problem is probably coming from the fact that you have too much characteristics.
For example, if you have 3 characteristics with 10 values each, that's 10*10*10=1000 possibilities. That's already too much.
You should indeed transform some characteristics into custom fields ( www.hikashop.com/en/support/documentatio...p-field-listing.html ) or options ( www.hikashop.com/en/support/documentatio...ct-form.html#options ) so that it becomes more manageable for your server.

Characteristics should only be used when you want to change some of the information on the products (the stock, the price, the image, etc). For choices which do not affect any of that custom fields of the table "item" are the way to go.

Yes you are right! I already got it. I replace the characteristics with options and the problem solved.
Thank you!

I have EXACTLY this same problem, except I already have options and no characteristics for the products themselves. (the options have)

I added my second product and suddenly POOF. Error 500.

[Tue Apr 01 01:04:26 2014] [warn] [client 84.80.63.27] mod_fcgid: stderr: PHP Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 71 bytes) in ..libraries/joomla/language/latin_transliterate.php on line 156, referer: www.dampsmaken.nl/administrator/index.ph...roduct&task=edit&cid []=81
[Tue Apr 01 01:08:56 2014] [warn] [client 84.80.63.27] mod_fcgid: stderr: PHP Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 71 bytes) in ..libraries/joomla/language/latin_transliterate.php on line 156, referer: www.dampsmaken.nl/administrator/index.ph...=product&filter_id=2

I can't delete the item, i can add other items and delete them, just not this one item. I have deleted its options, images, settings, and tekst but i cant save my changes anymore. im stuck with just this product not working and causing FATAL ERRORS.

I have 6 options, those options all have characteristics so they are grouped. My products themselves just have the options, no characteristics for themselves. Is this still a problem ? If so, i might need a refund ;(

Is there a way i can sanitise the database or something else i can do ? I think my db is messed up.

What does this latin_transliterate.php file do to cause such memory usage?

Bummed out.. stuck.. hoping for a helpful answer so i can continue building the site tomorrow..

~Trail.

Thanks for your reply.

I enabled unicode alias, and when i try to delete that faulty product i still get the 500 error but this message shows in error log;

[Tue Apr 01 20:39:09 2014] [warn] [client 84.80.63.27] mod_fcgid: stderr: PHP Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 88 bytes) ..libraries/joomla/database/database/mysql.php on line 712, referer: www.dampsmaken.nl/administrator/index.ph...ikashop&ctrl=product

Editing the php.ini to 128M results in:
[Tue Apr 01 21:11:00 2014] [warn] [client 84.80.63.27] mod_fcgid: stderr: PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 83 bytes) in ../libraries/joomla/database/database/mysql.php on line 712, referer: www.dampsmaken.nl/administrator/index.ph...=product&filter_id=2

Editing the php.ini to 256M results in:
[Tue Apr 01 21:13:52 2014] [warn] [client 84.80.63.27] mod_fcgid: stderr: PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 6 bytes) in ../libraries/joomla/database/database/mysql.php on line 712, referer: www.dampsmaken.nl/administrator/index.ph...=product&filter_id=2

When saving this product it sais this:
[Tue Apr 01 21:21:02 2014] [warn] [client 84.80.63.27] mod_fcgid: stderr: PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 70 bytes) in ../libraries/joomla/database/database.php on line 1411, referer: www.dampsmaken.nl/administrator/index.ph...roduct&task=edit&cid []=81

Always ERROR 500.

Let's not go beond 256M..

Personally i think that product (-the database entries) for this item are corrupt, because i can recreate the product, and save/delete it without problem and i can also delete other very similar products with the same options in the same category without these problems.

I must have done something to mess this particular product up..

Is there another way to delete this product and everything associated with it? I've got phpmyadmin installed but my mysql is rusty and i have no knowledge of the structure of the hikashop db

~Trail.

The product has 6 options, each with their variants.

The product itself has no variants.

Its the same kind of product as the other products, with the same 6 options.

I can RE-create the same product and everthing works.

I have created this product about 10 times on fresh installations on this same server without problems.

The product is some flavor of electronic sigarette, just like the other flavors I carry, people can have options for nicotine level, more or less, flavor, more or less sweetener, etc etc.. 6 options...

I want to create separate products for all flavors so I can add pics of the flavors.

So I have many of the same kind of product and they all work, except this one...

~Trail.

This sounds promising :0

The mass action found 36K results! And deleted them

I was sure this would have fixed it.. so I went and took a look but my item is still there..

Hmm how do I find the correct product id? When I hover my mouse over the item in backend it shows cid=81 isn't that the product id?

I can now probably delete the product by its product_code, but I don't want to miss out on deleting anything related to this product by doing that ?

So is product_id = cid?

Thanks,
Trail.

Nothing is actually deleted, or the content is automaticly recreated somehow as soon as i reload the page.

First it shows my selecting covers 36333 rows, then i delete them. then i reselect my selection and it says 36333 rows affected again. It isn't actually deleting them.

Thanks for your input,
Trail.

It displays the amount of affected rows but doesn't actually delete when i process.
Also tried setting a trigger on before create, and tried to make a new product but still no deleting.

I was actually processing the action.. without a trigger..

i think there's no other way but let you guys have a peek.. Where do i send login details to ?

The only item left is the faulty item. 'bananen noten brood'.

I know i could easily start over but i like to know what caused this and how to fix it myself in case it ever happens again further down the road..

Thanks,
Trail.