I am getting 'There was an error while processing a database query '
I have encountered a serious error on my CMG and i really need to this ASAP.
I have run the MySQL Repair tool and this is what it has come up with ?
error : 28 when fixing table
error : Can't copy datafile-header to tempfile, error 9
status : Operation failed
I will give $20.00 via paypal who can fix this for me.
Thankyou.
This isn't a Coppermine error, it's a MySQL problem. A Google search for Can't copy datafile-header to tempfile, error 9 turned up these links:
http://www.threadsdev.com/forum/showflat.php?Cat=&Number=114356
http://www.webhostingtalk.com/archive/thread/166422-1.html
Your database is corrupted, but you haven't told us what happened that made you do a repair table action. Error 28 means you have no space left on the device.
Thank kegobeer, i found another thread on the forum , you said to drop the SQL table and re import the data i tried that but the pictures and albums were no updated. I had to drop the whole thing and reinstall CPG ,
Thanks for the links , I have plenty of SQL Space left on the server so , i have create backups now, of the new gallery incase of another complication like this.
regards