SQL tables install

New Member Joined: Nov 11, 2006 Posts: 8

I want first thank the entire group for getting 2.10 released with all the fixes!

I'm going through the installSQL page and I have a few questions/problems?

Step 4: HTML Newsletter tables - I have 34 installed but the HowTo shows 40 tables should be there? Is this correct or just a mis-print?

I tried Step 6 (Full NukeSentinel IP2Country data) but it failed with the famous 'max_questions' error.
I had the webhost clear the 'max_questions' error but when I went onto step 6a (part 1/6), I'm getting Duplicate entry error '982745088-982753279' for key 1

Doesn't the new installer automatically drop and delete previous data and try again? Or, I should ask which tables/row/data do I need to alter to get the IP2Country data installed?

Sorry, but phpMyAdmin and me always seem to argue. Sad

Can someone give a link or instructions how to fix this?

Posted: Mon Mar 12, 2007 3:36 pm

Where are you getting 34 tables in the newsletter? Oh, I see. The "number of instructions" indicated in the how to document refers to instructions, not tables. For instance each field loaded counts as one instruction I believe.

If you are hitting max questions then you will probably need to install the IPcountry tables individually (6 steps) rather than in one swell foop. Just go into PHPmyadmin and drop the IPcountry table and start that step over. If you are using Ipowerweb, you can reset the max questions for your user manually by going into host manager, database setup and edit the user. Select update for that user and it will reset. Don't tell Ipowerweb I told you. There is also a hack posted in these forums to create additional users in config.php and distribute the workload over them ... you will of course need to create the users in host manager first and config.php basically selects the users randomly every time it runs so that individual users don't get maxxed out as easily.

Posted: Mon Mar 12, 2007 3:43 pm

Thank You fkelly, and yes I'm on Ipowerweb just like you. Laughing

I'll try dropping IPcountry table and give it a shot again.

Thanks again!

Involved Joined: Apr 05, 2006 Posts: 263

sorry to interject,

i had same problem for those who else do, i had to upload , then unzip and import indevidualy to that Database (all 12) through my weba dmin page ,file manager link.
worked a treat.
my way round for those who else need to solve it.