First off, I don't know if this should go in the SQL and Database thread or in the help thread.

Anyway, after a wierd down period on my forum yesterday where it said 'Page cannot be found', I manage to get on today and log into the forum, which is an SMF forum using the '1.5' version. I log in and come to this message:

'database error'
"Can't create/write to file '/tmp/#sql_ba0_0.MYI' (Errcode: 30)
File: /www/vndv.com/g/a/m/gamen/htdocs/Sources/Recent.php
Line: 102"

The message is only on the index page of the forum and not on any other. Luckily I have a backup database incase of anything going wrong but can anyone tell me what this error is about and how I can fix it?

EDIT:

The problem is more widespread as my 'Boards' manage tool in the admin area of SMF seems to be broken. All the boards are still present according to Forum Maintainance.

How do you upload a backed up database?

http://www.zymic.com/forum/index.php?showtopic=12090

Ahhh, well I feel abit more relaxed now I know that I won't have to replace my database.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'users = '-1'' at line 1 can anyone help me wid this error plz

can someone give solution for these .. I have tested on my test server .. everything was ok .. now I don't know whats happening ... I have even chmod everything to 777.


Warning: session_start() [function.session-start]: open(/var/lib/php/sess_72f62cff2fb19ce604e48f7f9fbf12f6, O_RDWR) failed: Read-only file system (30) in /www/vndv.com/v/a/t/vatindrealops/htdocs/RealOps/index.php on line 34

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /www/vndv.com/v/a/t/vatindrealops/htdocs/RealOps/Connections/realops.php:10) in /www/vndv.com/v/a/t/vatindrealops/htdocs/RealOps/index.php on line 34

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /www/vndv.com/v/a/t/vatindrealops/htdocs/RealOps/Connections/realops.php:10) in /www/vndv.com/v/a/t/vatindrealops/htdocs/RealOps/index.php on line 34


Warning: mysql_query() [function.mysql-query]: Access denied for user 'vhostswww'@'localhost' (using password: NO) in /www/vndv.com/v/a/t/vatindrealops/htdocs/RealOps/poll/poll.php on line 13

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /www/vndv.com/v/a/t/vatindrealops/htdocs/RealOps/poll/poll.php on line 13

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /www/vndv.com/v/a/t/vatindrealops/htdocs/RealOps/poll/poll.php on line 14


Warning: mysql_query() [function.mysql-query]: Access denied for user 'vhostswww'@'localhost' (using password: NO) in /www/vndv.com/v/a/t/vatindrealops/htdocs/RealOps/poll/poll.php on line 90

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /www/vndv.com/v/a/t/vatindrealops/htdocs/RealOps/poll/poll.php on line 90

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/vndv.com/v/a/t/vatindrealops/htdocs/RealOps/poll/poll.php on line 90



Warning: mysql_query() [function.mysql-query]: Access denied for user 'vhostswww'@'localhost' (using password: NO) in /www/vndv.com/v/a/t/vatindrealops/htdocs/RealOps/poll/poll.php on line 96

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /www/vndv.com/v/a/t/vatindrealops/htdocs/RealOps/poll/poll.php on line 96

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/vndv.com/v/a/t/vatindrealops/htdocs/RealOps/poll/poll.php on line 97