getting the following sql error when running product import about magmi-git

[dweeves]

You seem to try to associate an invalid category id to an item. Check your category_ids in your data or use category creator/importer plugin and use named category paths

[Zxurian]

I'm using the category creator/importer plugin.
My categories column looks like this
Categories::1::1::1;;Categories/History::1::1::1;;Categories/History/World::1::1::1;;Categories/Nature::1::1::1;;Categories/Nature/Ecology::1::1::1;;Categories/Science::1::1::1;;Categories/Science/General::1::1::1;;Categories/Science/Earth Sciences::1::1::1;;Categories/Science/Earth Sciences/General::1::1::1;;Bestsellers::1::1::1

[light4ever]

Zxurian, I also got the error you described.
Try running the reindexall from the command line (php -f indexer.php reindexall) I noticed that the Category Products index had an exception while trying to re-index.

I believe I caused this corruption by running the "Clear Catalog, Categories and Reviews v1.0.1" Magmi Utilities. on a magento 1.8.1 install.

I did not find a workaround. I ended up deleting the magento webpage and database and starting over.

[keshav0001]

I did the same, ran Clear catalog, eav etc modules on my database. And after that I was having these same Invalid parameter errors.

Solution was:
We need to rebuild the index from magento. But that too was giving error for me. So

1. The attributes of dropdown, sometimes can have longer than acceptable values, so I deleted and recreated the ones having long values (got there in first place due to a malformed csv)
2. Somehow the default root category was unset in all the stores. So, go into manage stores, and open, all stores and set a root category. (must have been deleted as a result of clear categories plugin).