Not all categories are imported

-- HikaShop version -- : 2.1.2
-- Joomla version -- : 2.5.9
-- PHP version -- : 5.4
-- Browser(s) name and version -- : Chrome 46.0
-- Error-message(debug-mod must be tuned on) -- : JDatabaseMySQL::query: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND category_type='product' LIMIT 1' at line 1 SQL=SELECT category_id FROM adng5_hikashop_category WHERE category_parent_id= AND category_type='product' LIMIT 1

I have no errors, but when importing products, only some of the categories are importes and some products are incorrectly assigned to the only imported categories.

Hi Nicolas,

Ok, purchased the license, I had to get approval from my client. Updated, everything OK.

OK Table "hikashop_address" checked
OK Table "hikashop_badge" checked
OK Table "hikashop_banner" checked
OK Table "hikashop_cart" checked
OK Table "hikashop_cart_product" checked
OK Table "hikashop_category" checked
OK Table "hikashop_characteristic" checked
OK Table "hikashop_click" checked
OK Table "hikashop_config" checked
OK Table "hikashop_currency" checked
OK Table "hikashop_discount" checked
OK Table "hikashop_download" checked
OK Table "hikashop_email_log" checked
OK Table "hikashop_entry" checked
OK Table "hikashop_field" checked
OK Table "hikashop_file" checked
OK Table "hikashop_filter" checked
OK Table "hikashop_geolocation" checked
OK Table "hikashop_history" checked
OK Table "hikashop_limit" checked
OK Table "hikashop_massaction" checked
OK Table "hikashop_order" checked
OK Table "hikashop_order_product" checked
OK Table "hikashop_payment" checked
OK Table "hikashop_price" checked
OK Table "hikashop_product" checked
OK Table "hikashop_product_category" checked
OK Table "hikashop_product_related" checked
OK Table "hikashop_plugin" checked
OK Table "hikashop_shipping" checked
OK Table "hikashop_shipping_price" checked
OK Table "hikashop_tax" checked
OK Table "hikashop_taxation" checked
OK Table "hikashop_user" checked
OK Table "hikashop_variant" checked
OK Table "hikashop_vote" checked
OK Table "hikashop_vote_user" checked
OK Table "hikashop_waitlist" checked
OK Table "hikashop_widget" checked
OK Table "hikashop_zone" checked
OK Table "hikashop_zone_link" checked
OK Table "hikashop_warehouse" checked
OK Product categories checked
OK Variants orphan links cleaned

It seems the Herramientas category is being taken as the root category.

Herramientas should be a 1st level category, as well as Charms, but charms is being considered a child of Herramientas.

screencast.com/t/avm4q6LVOB

It should be:

/Herrmaientas
/Acero Inoxidable
/Bases de Resina

All those are main to be parent categories.

Also, why do I see a Root/Brand "ghost category? " screencast.com/t/7ur5gfye6qs

DB Table: screencast.com/t/hbSIm74Y0

I also retried by deleting all product categories and re-importing, and I only get the first category of teh fileimported as root: Acero Inoxidable, the other root categories are missing,

screencast.com/t/svuJq3bCo4

I just checked the FE, the catalog is now missing the categories in the module and showing no products/categories.

ekreaeltaller.com/catalogo

screencast.com/t/omdE7dA54xB

I have created a super admin user in case you need it.

I did as you requested and go the same results. I little bit more organized but again, it didn't import all of the categories.

screencast.com/t/M8SssLkNPDWq

Can you please take a deeper look?

When you look at the CVS, you have several level 1 categories, in the screenshot only one main category is being set and a lot are missing. Please look at the CSV.

I deleted the category and product_category tables again, re-installed HS and now I get this error:

Warning: Failed to move file!
Could not upload the file to /home/ekrea/public_html/media/com_hikashop/upload/0-500.csv
FAIL_OPEN

Q: how do I define that the Root category for all categories should be ROOT, and not the very first category that is detected?

Update:

ekreaeltaller.com/administrator/index.ph...roduct&filter_id=447

That Address shows an internal server error: that is also the category called Charms that gets imported inside of another category.

I did the following:

1- Delete Categories and Product Categories
2- Check and Rebuild the DB.
3- Import 1 category at the time. 3 Categories imported fine, the 4th, called charms, was imported inside of category 1 incorrectly.
4- When trying to navigate to it, I get the Internal Server error above.

---

Did everything again up to step 2. This time I removed all the "," I found on the images column of the separate CHARMS CSV and it imported fine ( no internal 500 error ). When I imported the Aluminium Category, it was imported inside of the CHARMS category, when it should have been child of root.

Did the same again. And started creating the category tree BY HAND.

Something is going on with this code/version. the categories went crazy again when I was creating them by hand.

Can you please check? this is really urgent and 1 answer at day is not making it and I feel this is becoming a snowball, not only I have spent many hrs on this but we paid for support and the update, and the update has generated even more work.

nicolas wrote: Hi,

I would recommend to delete all the entries in the hikashop_category table and the hikashop_product_category table.
.

- You also said that by updating, the categories were re-created.
- The error was: internal server error. Nothing more.
- No mass actions configured.
- The CSV was reduced already. The 500 error is present when I navigate to the already supposedly imported category of Charms. and it is not consistent, sometimes it happens, sometimes it doesn't.

I tried resintalling and I get out of memory errors when doing so.

PS. What I get are out of memory errors.

Fatal error: Out of memory (allocated 21495808) (tried to allocate 1697168 bytes) in /home/ekrea/public_html/plugins/system/debug/debug.php on line 183

For some reason I was getting the out of memory error a lot, I asked for support on the server side, they insisted on having a look at the admin dashboard and they weren't getting any errors.

I cleared cookies and cache and I didn't get the error again.

I did a reinstall, sorry, I confused the install with the update to essential.