Database error after domain expired

Gday,
Please see <https://scottyzee.com/blog&gt; to know what I am on about.

My domain expired yesterday and I did not renew until today. So my site was not online for less than a day. Now that I have renewed and the site is back up, there is a horrible error being shown and no posts are available. In site admin I can go to the recent posts on the dashboard but there are no posts in manage?

The error shown is:
WordPress database error: [Can’t create/write to file ‘C:\WINDOWS\TEMP\#sql_ba4_0.MYI’ (Errcode: 28)]
SELECT DISTINCT * FROM wp_posts LEFT JOIN wp_post2cat ON ( wp_posts.ID = wp_post2cat.post_id) WHERE 1=1 AND post_date_gmt <= ‘2006-12-17 10:30:59’ AND (post_status = “publish”) AND post_status != “attachment” GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 10

Can someone please give me a hand. The error says a database error and mentions ‘sql’ so I think it is a mysql database error? No idea!? The rest of the site is fine, just the posts.

Please help ASAP. A big thank in advance.

Scotty Zee