txtSQL

If no disk space remains on the server and txtSQL attempts to update or add a record to a table, then the whole table gets lost.

This happened to me on a university shared server where some other idiot managed to fill the hard disk with log files. I lost all the forum data (I have now learnt to keep backups!) I realise on a properly managed server this wouldn't happen, but unfortunately the IT staff here are hopeless.

Errors I got were firstly a generic php error due to being unable to write session files:
Warning: session_start(): open(/****/sessions/, O_RDWR) failed: No space left on device (28) in /***/auth_check.inc.php on line 4
Followed by the txtSQL error:
txtSQL Warning: Table "ForumTopics" doesn't exist in /****/forum/index.php on line 51
after it had lost the table.

I'm using txtSQL 2.2 Final on php 4. I've temporarily prevented the same thing happening again by disabling the forums when it detects a new file can't be written. Not sure that this is really a 'bug' as such, but its certainly a nuisance if it happens. Has anyone else had this problem?

Thanks for the great script!

Dave

PS Just thought of a possible solution - on update, could txtSQL write the table to a new temporary file e.g. table_tmp and then delete the original and rename if successful?

Hmm. I've never ran into this problem; it was always assumed that disk space was abundant.

But if there is no more disk space, then I suppose before writing to the table, a check should be done to see whether any disk space remains or not.

http://www.fashion-products.com [url=http://www.fashion-products.com ]is a sell air force one,
air jordan,bape,kicks,nike,Jerseys,Shoes,Clothing,Bag,Glasses,Caps&Hats,sneakers,sunglasses,
watches,Jewelry,Electronics,NBA,NFL,NHL,MLB[/url]
shoes
clothing
Handbags Wallets
Hat
Sunglasses
Belts
Watches
Jewelry