1
Rowejob
Block Administrator Query Error: Can't create/write to file '/tmp/#sql_6f99_0.MYD'
  • 2006/9/6 5:28

  • Rowejob

  • Just popping in

  • Posts: 14

  • Since: 2006/3/31


When i was configuring my XOOPS I all of a sudden blocks come up blank. I get this error in the Debug.

SELECT b.* FROM xoops_newblocks b, xoops_block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND m.module_id IN (0,-1) AND b.bid IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,34) ORDER BY b.side,b.weight,b.bid
Error number: 1
Error message: Can't create/write to file '/tmp/#sql_6f99_0.MYD' (Errcode: 17)

Do you know why this would happen?

2
McNaz
Re: Block Administrator Query Error: Can't create/write to file '/tmp/#sql_6f99_0.MYD'
  • 2006/9/6 7:50

  • McNaz

  • Just can't stay away

  • Posts: 574

  • Since: 2003/4/21


Looks like a mySQL error. From what I gather from the message you might have insufficient disk space left in your server's drive or insufficient previledges for the tmp folder.

Google mySQL (Errcode: 17) for more pointers.

Cheers.

3
Rowejob
Re: Block Administrator Query Error: Can't create/write to file '/tmp/#sql_6f99_0.MYD'
  • 2006/9/6 21:18

  • Rowejob

  • Just popping in

  • Posts: 14

  • Since: 2006/3/31


I guess my sql server never had a tmp directory set so I edited the the tmpdir so that it pointed somewhere.

Thanks for the help.

Login

Who's Online

252 user(s) are online (146 user(s) are browsing Support Forums)


Members: 0


Guests: 252


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits