PDA

View Full Version : I've got a SQL problem


byreklam
02-27-2009, 06:23 PM
I have got a problem
this my web site Click Here (http://www.guncelle.com) ,please
I repaired Database but site off
forum database error

Warning: mysql_query() [function.mysql-query]: Unable to save result set in [path]/includes/class_core.php on line 408

what's a problem for my web sıte

TigerC10
02-27-2009, 06:30 PM
Your database is corrupted somewhere. You should repair all of the tables.

http://www.vbulletin.com/forum/showthread.php?t=296684

byreklam
02-27-2009, 10:23 PM
Your database is corrupted somewhere. You should repair all of the tables.

http://www.vbulletin.com/forum/showthread.php?t=296684

Thanks.
I try ,2-3 times before but it did not.
Do you have no other choice

TigerC10
02-28-2009, 05:34 AM
Can you access anything in the database at all? Through something like phpMyAdmin?

byreklam
02-28-2009, 06:37 AM
yes can be accessed

I have repaired all the tables with SSH but problem is ongoing

Dismounted
02-28-2009, 12:19 PM
Your site looks like it is fine to me.

byreklam
03-01-2009, 07:11 AM
Always gives this error

Invalid SQL:

SELECT MIN(postid) AS postid
FROM post
WHERE threadid = 685185
AND visible = 1
AND dateline > 1235831752

LIMIT 1;

MySQL Error : Got error 127 from storage engine
Error Number : 1030

TigerC10
03-01-2009, 03:45 PM
LOL The database is too small for the data you're putting into it.


The default limit of tables is 4GB until 5.0.5 and 65,536TB in later versions. To change the default, use the table options AVG_ROW_LENGTH and MAX_ROWS. You can change your table with ALTER TABLE logs AVG_ROW_LENGTH=number MAX_ROWS=number. This will take a moment as a new table is copied from the old one. See also http://dev.mysql.com/doc/refman/5.0/en/create-table.html

http://forums.mysql.com/read.php?21,78713,78950#msg-78950

as7apcool
03-01-2009, 03:59 PM
your site work good with me

you have alot of links in the footer .. this is not good for google