If I cannot import the formatted CSV file to the database table [dtregister_codes] via PHPMYADMIN, is DTH Available to assist with this import as a paid consulting project?
We just ran a Living Social deal and have been running into some issues inputting discount codes into the system. At first I wanted to input all 1,000 potential codes to make the process seamless. I loaded them in as a CSV file through phpmyadmin. The codes showed up in the Discount Codes list in Joomla at that point, but it seemed like some data was missing from other tables, so I started opening them one-by-one and saving them from the back end and they seemed to populate properly throughout the system and work from the front end.
However, when I reached around 40 codes I started getting a mysql Fatal Error when loading my site. The error said that it could not allocate a certain number of bytes.. The entire site was down. I had to delete the data from three tables to get the site back up: "dtregister_events_codes", "dtregister_feeorder" (only the records with the type "discountcode") and "dtregister_codes".
From what I can see from phpmyadmin, it looks like the mysql data tables are growing to very large sizes because of the way these 3 tables are joined. My hosts tech support says the mysql fatal error was related to running out of space and that the best way to fix it would be to compress the data before running it through the php engine.
So, my question is: if there is no limit as you mentioned above, am I doing something wrong that is causing this error? As I mentioned, I was loading in the codes as CSV files through phpmyadmin but have since started over by inputting them manually. I am up to around 30 codes and am worried that I will encounter the same error once I add 10 or so more.
Nope --- there's definitely a bug here.. When I get up to about 40 codes I get the same error. I had to go back into the tables in myPHPadmin to erase quite a few records in order to get my site back online.