cancel
Showing results for 
Search instead for 
Did you mean: 

MYSQL FAULT??

peterwestern
Newbie
Posts: 1
Registered: 06-08-2007

MYSQL FAULT??

I have set up a sql db for a gedcom file import which works on other servers (USA) Does anyone know what the error "The table 'SQL28e9c41_0' is full" actually means. It implies to me that there is a limit on the amount of data that can be in the sql db.(F9 say thats not so) If I import a 2nd gedcom file of 1000 records, under a different tree name, but into the same sql db set up,(eg same set of PHP files, same sql db name, path etc) it works fineHuh The problem one has 70000 records. All other user functions work.
The query being run is to list the surnames and is as folows: SELECT ucase(lastname) as lastname, ucase( lastname) as binlast, count(ucase(lastname ) ) as lncount FROM people GROUP BY binlast ORDER by lncount
DESC LIMIT 25

This works fine on smaller db entries even though its a sub section of the overall sql db?

No one at F9 has been able to assist me does anyone know why this PHP db works fine for 130 users worldwide, on different sql servers, but not for me it seems?
Any suggestions welcome
Thanks
Peter