ok, i'm almost
- a google search confirmed that Got error 124 from storage engine
is indeed NOT a space issue. i'm looking at this
The problem seems to be myisam specific and is only triggered after a fresh import. A dump file which displays the problem is attached, OasUser.sql. The problem does not occur if you import the table as an InnoDB table.
How to repeat:
bash#mysql test < OasUser.sql
mysql>select firstname from test.OasUser order by firstname limit 1;
Interestingly, rebuilding the table fixes the problem:
mysql>alter table OasUser engine=myisam;
mysql>select firstname from OasUser order by firstname limit 1;
- lo and behold, i refreshed the photos table as InnoDB - the error no longer displayed, and all photos and thumbnails were there, in tact.
- i also rebuilt the table to myisam, and the photos and thumbnails remained in tact, with no error messages. BUT...
- all photo counts in all categories remain at 0. the correct number of photos is displayed in the stats, but that's it. i ran recalculate photos/posts numbers and check children
a couple times, which returned the following:
Processing may take a while... please be patient and wait the for FINISHED message... |
Preparing to update categories with photo and posts information...
Preparing to update personal albums with photo and posts information...
click here to return to admin
but the counts all still remain at 0.
EDIT: just ran the above for a 4th time, and the counts are back!! wow.. looks like we're all set (fingers crossed).. thanks again, chuck..