Database Problem?????

**Steve Machol** · Thu 20 Apr '06, 2:15pm

We need to see the real error message. Right-click on the error page and go to View/Source. Then copy-n-paste the error message here.

**Sunshine98** · Fri 21 Apr '06, 3:24am

well right now it has stopped

if it happens again..I'll post it ..

**Sunshine98** · Fri 12 May '06, 3:04pm

well it finally has happened again...here is a copy of it..why is it doing this?

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>fourm name forum data base error
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<style type="text/css">

</style>
</head>
<body>
<blockquote>
<blockquote>
<p><strong>There seems to have been a problem with the Fourm name Forum database.</strong><br />
Please try again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</p>
<p>An E-Mail has been dispatched to our <a href="<A href="mailto:fourmname @yahoo.com">Technical">mailto:fourmname @yahoo.com">Technical Staff</a>, whom you can also contact if the problem persists.</p>
<p>We apologise for any inconvenience.</p>



</blockquote>
</blockquote>
</body>
</html>

I only changed what is in red...which was the fourm name and contact email...otherwise its what is showing up.

How can I fix it?

Thank you.

ps weird thing is it is allowing me to log in...and this shows up when I try to go in my pm box.

**Steve Machol** · Fri 12 May '06, 3:23pm

MySQL Error : Can't create/write to file '/var/tmp/#sql_5e3d_0.MYI' (Errcode: 2)

System error: 2 = No such file or directory

Your server's /var/tmp directory either doesn't exist or is not world-readable and writable. You need to contact your host and have them fix this.

**Sunshine98** · Fri 12 May '06, 3:27pm

Originally posted by Steve Machol

MySQL Error : Can't create/write to file '/var/tmp/#sql_5e3d_0.MYI' (Errcode: 2)

System error: 2 = No such file or directory

Your server's /var/tmp directory either doesn't exist or is not world-readable and writable. You need to contact your host and have them fix this.

does this mean the server that hosts the site?

Also...now when I log into the fourms...it allows me to click on the thread...but when I go in to see the posts...None are there

**Steve Machol** · Fri 12 May '06, 3:28pm

1. Yes, the server that hosts your site.

2. What's the URL? Have you installed any hacks or plugins?

**Sunshine98** · Fri 12 May '06, 3:38pm

Originally posted by Steve Machol

1. Yes, the server that hosts your site.

ok, sedning them a email...with the info your provided..

2. What's the URL?

before guests could read anything...now they cant, I cant..

3. Have you installed any hacks or plugins?

only thing new I added/changed:

1.putting the banner in the center
2. Adding the countdown above the banner
3. Allowing signatures only 1 time per page

**Steve Machol** · Fri 12 May '06, 3:41pm

Check the overall Usergroup permissions:

Admin CP -> Usergroups -> Usergroup Manager -> Edit Usergroup (Unregistered)

And the Forum permissions for each forum and Usergroup:

Admin CP -> Forums & Moderators -> Forum Permissions

If it's not one of these, then the problem is from one of your modifications. To troubleshoot this, remove any hacks and disable your plugins, then see if you still have this problem.

If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

Next, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it. Do you have the same problem?

**Sunshine98** · Fri 12 May '06, 3:42pm

Originally posted by Steve Machol

Check the overall Usergroup permissions:

Admin CP -> Usergroups -> Usergroup Manager -> Edit Usergroup (Unregistered)

And the Forum permissions for each forum and Usergroup:

Admin CP -> Forums & Moderators -> Forum Permissions

If it's not one of these, then the problem is from one of your modifications. To troubleshoot this, remove any hacks and disable your plugins, then see if you still have this problem.

If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

Next, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it. Do you have the same problem?

give me some time to do this....I'll try to get back to you ASAP!

**Sunshine98** · Fri 12 May '06, 4:02pm

Originally posted by Steve Machol

Check the overall Usergroup permissions:

Admin CP -> Usergroups -> Usergroup Manager -> Edit Usergroup (Unregistered)

so far on this...the option to view the forum is being allowed...so guests and members can view the forums

And the Forum permissions for each forum and Usergroup:

Admin CP -> Forums & Moderators -> Forum Permissions

all that is in white:
Standard: Using default usergroup permissions

If it's not one of these, then the problem is from one of your modifications.

To troubleshoot this, remove any hacks

well now when I am trying to remove the hacks:

VB Options...I get this:

Database error in vBulletin 3.5.4:
Invalid SQL:
SELECT setting.*, settinggroup.grouptitle
FROM settinggroup AS settinggroup
LEFT JOIN setting AS setting USING(grouptitle)
WHERE settinggroup.displayorder <> 0
ORDER BY settinggroup.displayorder, setting.displayorder;
MySQL Error : Can't create/write to file '/var/tmp/#sql_68b9_0.MYI' (Errcode: 2)
Error Number : 1
Date : Friday, May 12th 2006 @ 11:52:46 PM
Script : Forum name
IP Address : IP Address
Username : User Name
Classname : vb_database

and disable your plugins, then see if you still have this problem.

forgive me..what is a plug in?

If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

if I up load this again...will I loose what has already been posted?

and forgive me again...I dont know what ASCII format is? How do I do that?

Next, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it. Do you have the same problem?

will have more questions how to do this...but I think I have to get there first..with the above questions

Bare with me...Im not a computer expert...Im sorry..

ps now when I do log in..I can see threads..but when I go into the thread, Im unable to see the posts...

**Sunshine98** · Sat 13 May '06, 4:09am

.....

**Steve Machol** · Sat 13 May '06, 8:25am

I;'m sorry but I'm having trouble deciphering your last two posts.

As for this error:

MySQL Error : Can't create/write to file '/var/tmp/#sql_68b9_0.MYI' (Errcode: 2)

This means:

System error: 2 = No such file or directory

To fix this your host needs to create a /var/tmp directory on this server and chmod it to 777.

And:

1. To disable the plugin system, edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

2. ASCII=text. Uploading the original files does not affect any data. Otherwise we would not ask you to do this.

3. Admin CP -> Styles & Templates -> Style Manager -> Add New Style

**Sunshine98** · Sat 13 May '06, 9:07am

Originally posted by Steve Machol

I;'m sorry but I'm having trouble deciphering your last two posts.

As for this error:

MySQL Error : Can't create/write to file '/var/tmp/#sql_68b9_0.MYI' (Errcode: 2)

This means:

System error: 2 = No such file or directory

To fix this your host needs to create a /var/tmp directory on this server and chmod it to 777.

Im sorry I dont mean to sound confusing...

its the termanology that confuses me

when you say host: is that me (who owns the site) or Yahoo where the server is?

and if it is me? how do I do it?

sorry...its just frustrating

**Scott MacVicar** · Sat 13 May '06, 9:10am

The person who manages the server for you, so in this case Yahoo would be who you speak to.

Database Problem?????

Database Problem?????

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment