For the last month, other than a small rotate issue, CP1.3.0 has been working great.
The the debugging info says:
While executing query "SELECT DISTINCT a.aid as aid, a.title as title, c.name as cname FROM cpg130_albums as a, cpg130_categories as c WHERE a.category = c.cid AND a.category < '10000' ORDER BY cname,title" on 0
mySQL error: Got error 28 from table handler
I don't see any errors in the mysql error log, and it stops and restarts just fine, so I don't think the DB was corrupted.
Any ideas how to fix this?
Let me add...
OS: Red Hat 9.
Apache: 2.0.40
MySQL: 3.23.58
Browsers: Firefox (Linux and Windows), Safari, IE
I just started seeing the same issue. It just happened over the last week, and I haven't made any changes to my system. Any ideas? My error is a little different. Here it is:
While executing query "SELECT aid, CONCAT('(', user_name, ') ', title) AS title FROM cpg11d_albums AS a INNER JOIN cpg11d_users AS u ON category = (10000 + user_id) ORDER BY title" on 0
mySQL error: Got error 28 from table handler
TIA!
A google search yielded these links for error 28:
http://forums.devshed.com/t49604/s.html
http://www.pmachine.com/forum/threads.php?id=15122_0_16_0_C
http://fudforum.org/forum/index.php?t=msg&th=1983&start=0&
http://www.experts-exchange.com/Databases/Mysql/Q_20810900.html
http://dev.mysql.com/doc/mysql/en/Cannot_create.html
Try the mysql.com link first. Pay particular attention to the temp directory stuff.
You can lookup mysql error codes on your own PC using perror (http://dev.mysql.com/doc/mysql/en/perror.html).
Error code 28: No space left on device