System Hangs When adding or modifying serials

-- url of the page with the problem -- : dollarsaverprograms.com
-- HikaShop version -- : 2.6.2
-- HikaSerial version -- : 1.10.3
-- Joomla version -- : 3.5.1
-- PHP version -- : 5.4
-- Browser(s) name and version -- : Firefox 45.0.2
-- Error-message(debug-mod must be tuned on) -- : None

Hi,
When trying to add serials to the system in the admin area, the system hangs "Waiting on the server to respond" Server logs indicate an internal server error. I'm getting nothing else for errors or indication as to what could be wrong.

Seems I can add a pack, but when I go to enter a serial everything just stops responding. If I close the browser, wait a minute or so, then log back in, I can do other things but not work with HikaSerial. If I try it stops again.

Any assistance gratefully received.

Thanks for the response.
I was manually entering a test product, pack and serial. This site is not yet live, I've been importing thousands of serials from an existing site and they all seem to go in OK. Yesterday I added a payment method and was going to start testing the cart and serial generation.
So I entered a new item that could be deleted later, added a pack manually and then a serial of 001, 002 & 003 and thats when it started stalling.

There are currently 313,293 serials, 3072 packs and 3149 items. Am I over capacity?

More than happy to give you admin access if it would help.

Ok, step by step, what I'm doing:
1. login to the Administrator
2. Went to Components/HikaSerial/Packs
3. Clicked "New" and added a new pack.. Using "No Pack Data Provider" & an available Vendor. Left all other settings alone
4. Went to Components/HikaSerial/Serials
5. Clicked "New" and added/typed a serial number (004) in "Serial Data", Chose new Pack from drop down, then Save & Close
6. At this point the system hangs and the wheel just keeps spinning and status sits on "Waiting for (site)

Please see attached image

That did it. But the unfortunate thing is that I REALLY need to have the quantity of serials left show on the front end. Is there any other solution?

Before going to far into rewriting the algorithm, I'm sure that a lot of those records can be deleted, but I want to make sure that I do it in manner that won't adversely affect database integrity.

Steps to bulk remove unneeded serials and packs: Is it safe to mass remove all "used" serials using phpmyadmin, then all "empty" packs from within the administrator? Remember this site is not yet live and all this data was transferred/imported from an older antiquated system. I'm wondering if some of my problem is just the sheer size of those tables. Please advise.

Then if that doesn't work I guess the 1st question is your availability/desire to rewrite the algorithm plus time and cost.

I've also started experiencing another issue with the Attachserial plugin. Tried to open it this morning to make some changes and I get the following error. Don't know if it could be related to what we are doing or not:
An error has occurred.

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 ') ORDER BY pack_name' at line 1 SQL=SELECT pack_id, pack_name, pack_data, pack_generator FROM #__hikaserial_pack WHERE pack_id IN () ORDER BY pack_name

Thank you for all your help.

I wasnt sure, so I created a new record and was sure to include a pack. I get the same error on the new one if I try to go back into it to modify it.
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 ') ORDER BY pack_name' at line 1 SQL=SELECT pack_id, pack_name, pack_data, pack_generator FROM #__hikaserial_pack WHERE pack_id IN () ORDER BY pack_name

But with that question asked, is there a way that I can use the same attachment with ALL pack so as we don't have to enter them all in?

Perfect, removing that 's' did the trick for that issue.

What do you think about it being safe to mass remove "used" serials? I wouldn't be breaking some other relationship somewhere would I?

Since I had not imported any orders from the old system, I went ahead and deleted all of the used serials and empty packs. Unfortunately it had no affect on the original problem. The system is still hanging when I try to add serials either one at a time or if I try to import them.

Did you see my other question about the attachserial plugin? I want to use one attachment for all serials. Is there a way to NOT have to enter in every Pack in the Plugin Parameters? Maybe delete that filter completely?

Also when trying to go through the pages of packs in hikaserial I get this error:
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 ')' at line 1 SQL=SELECT serial_pack_id, count(*) as `cpt` FROM #__hikaserial_serial WHERE serial_pack_id IN ( );

Thanks!

Hi,
While I'm waiting for you to figure how to get accomplish this, is there a maximum number of packs that should be entered into that field before creating a new record? I've got about 1600 active packs.

Ok, thanks.
Actually the more I think about it, the more I believe I don't want one certificate to handle all serials. There are benefits to having at least a few different options for them. Though the list of packs would still potentially be large.
Thanks.