capone
Posts: 6
|
| Posted: 06/10/2008, 2:45 PM |
|
i keep getting this error when trying to run a query does anyone know what this means. probably has something to do with multiplle joins?
|
 |
 |
wkempees
Posts: 1679
|
| Posted: 06/10/2008, 3:15 PM |
|
It is a MySQL problem not (directly) related to CodeCharge Studio.
How many rows are there in your table(s), how many rows do you expect as a result from your query?
What storage engine MyISAM or InnoDB?
What MySQL version?
Found you this thread http://forums.mysql.com/read.php?88,27250,27250
With this advise as interesting:http://forums.mysql.com/read.php?88,27250,77624#msg-77624
Quote :It seems that there is some limitation about data file.
So improve the limitation will be helpful.
Execute the following sql:
ALTER TABLE cdb_posts MAX_ROWS=100000000 AVG_ROW_LENGTH=15000;
You can adjust the MAX_ROWS to a little smaller.
Because it costs much time to change a large data file.
Also this Bug report seems interesting http://bugs.mysql.com/bug.php?id=1711
Alas, gave you some pointers, suggest MySQL website for further assistance.
Would appreciate solution if you find one.
BTW, Google was the search engine used 
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
Oper
Posts: 1195
|
| Posted: 06/11/2008, 10:43 AM |
|
Dont use MyISAM use INNODB
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
|
