DB grows endless

-- url of the page with the problem -- : www.b-em.de
-- HikaShop version -- : 2.3.4
-- Joomla version -- : 3.3.6
-- PHP version -- : 5.4.34
-- Browser(s) name and version -- : firefox 34.0 safari 8.0
-- Error-message(debug-mod must be tuned on) -- : DB is now 2.6 GB big and not 5.06 MB as before

After the last error last week "Cannot read property 'openBox' of undefined" I want to create something new in the shop this means only " I want to create somthing which you can buy in our shop" I got the next problem. I know it´s my problem and not yours. But I hope you can and will help me. Before I have changed the hikashop.js I have created the parts in the shop with number round 5000. the database was round 5.06 MB. Then I have done the mistake with minimise the java file. Now I want to create some parts new in my shop and now the number is "87654321" the database backup is now 2.6 GB. Now the question can I do a backup from the old version with only "hikashop" sql files and restore the old sql backup files in the new database ? While I have done more than one changes in the meantime. And otherwise I have lost round 1 month of working with the homepage. Or what can I do to switch back to a slower database.
kind regards and happy christmas and a wonderfull new year.
Hansjörg Lauble

Hi
The only way to not loose the one month of work is test by yourself locally.
HKS team ll know refer to table name issue not name in the post. )
test locally a copy of remote ( path version ACL knowledge ) .

I don't really understand the problem, where come from the 2 Gb ?
In a specific table name ? not all ! I hope ,duplicate row in one table ?

you can also do all locally after recreate the problem locally and create a sql backup ( best way) .
under a new wamp server ( rdbms store data in *.myi my......) .

regard's

Hello Nicholas

I have fixed the problem. I have done a delete from tables hikas...... and have imported the tables from the old homepage
to the new homepage. And at the moment it runs.

A very quite christmas and a happy new year
Hansjörg Lauble

-- HikaShop version -- : 2.3.5
-- Joomla version -- : 3.3.6
-- PHP version -- : 5.4.34
-- Browser(s) name and version -- : firefox 35 safari 8.0.3
-- Error-message(debug-mod must be tuned on) -- : accelerated growth of DB in one month

Hello Nicolas
i will come back to you and my problem with the database. the database is accelerated grow in really one month.
at the moment the table "jomkas_hikashop_product" was growing in round one month from 863 kb to now 1,9 GB. The only thing i have done in this month was changing somthing in the database this means i have changed today the value of weight, from the products. and this week i have changed the prices in this table. nothing else done in the database.
the value from the file hikashop.js is the same as before after the latest crash from database. i have nothing changed on the file, this was the error in past. How can I handle this problem ? can I delete the table "jomkas_hikashop_product" on the productiv system and import it from the last system which is running in my home ? Or do you want access to the server and which access do you need. only to the system ? to the ftp server ? or to the database server ?
please give me answer what can I do.
I hope it is enough to change 1 table from home to my productiv side.
kind regards
Hansjörg Lauble

good morning nicholas
i have worked since this morning round 4.00 o´clock with this problem. i found the following solution to my problem.
i will work with more backups than before. I will check the database table hikashop_product before and after i have somtehing changed.
It´s really 1 product in the database which have the error. when you do some changes in this product the table grows up from 9.8 mb to more than 500 mb, if you do the next change with this product you have 1 GB and so on. yesterday evening i have deleted the table and have imported it from my homesystem. But there was no way to have a running hikashop. Then I have installed the whole hikashop new in my system. Also no way for hikashop running. So i have written a new menu and have said the users the shop is not available. then I was going to bed and sleep for round 5 hours. Than I have started my work this morning and now the system is running fine and smoothly.
I will do checks over weekend with creating this product new in the hikashop.
Thanks for your help and kind reagards
Hansjörg Lauble

in backend for debug
1-enable plugin ->sytem debug
2- enable debug configurtion : Site -> global configuration -> system-> debug setting -> debug system to yes should to show the SQL
I use xdebug / SQL proxy and i could follow the creation of variant with hikashop and understand the logic behing variant ! I think hikashop php skill should detect the code that trigger this many INSERT easely .The default joomla debug tool let you see for one change in hikashop product that 49 SQL are compute !! ( result of concat SQL string in php files ) .

here some clue to test
1- Does this occur when change any fields of this product ?
2- Does the problem occur because of the content of one of the fields attach to this product ?
3- have you test the export of this product and import in another joomla HKS system ?
4-does the number of items create is refer to variable define by HKS or related to memory limit ?
regard's