SMF Upgraded but MySQL did not.

[FX-FatCat]

Hi Folks

Please, first off let me say right at the start what I know about MySQL is nothing and what I know about SMF and modifying or coding it is dangerous.
Please answer me like you would a child, I shall not be offended at all.

I have SMF 1.1.7 installed just fine for a few months now.
This morning I have emails from users stating that thy are getting this error

Can't create/write to file '/var/tmp/#sql_6a8_0.MYI' (Errcode: 13)
File: /usr/home/ovenston/public_html/f3/Sources/Recent.php
Line: 102

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.7, while your database is at version 1.1.4. The above error might possibly go away if you execute the latest version of upgrade.php.

I have done a search and found many references to this problem so at least I know it is not unique to me.

The problem is that I have no idea how to fix it.
No one, in any of the threads I have read yet has explained, in very basic terms, how to get the database or whatever this MySQL is upgraded to the same version as SMF?

Next question.
Why the hell does SMF not upgrade the database when it upgrades itself or did I do something wrong when I upgraded with every version via Fantastico since 1.1.4?

Thank you in Advance
Wayne

[Dragooon]

There are no DB changes between 1.1.x series, so thats why it doesn't upgrade. You need to contact your host for that issue, it seems something got corrupted. You can attempt an DB repair though.

[FX-FatCat]

Thanks Dragoon, I have logged a support ticket with my Host and will await their response?

Cheers
Wayne

[FX-FatCat]

Hi Duncan

Firstly this is not a duplicate, with all due respect, have a careful look again.

This post/thread is about repairing the issue in this version 1.1.7.
The thread you locked, picture attached is about upgrading 1.1.7 to 2 in order to fix the problem.

Two totally separate issue as far as I am concerned and now you have closed that thread so no one will be able to answer me?
Why did you do that, or was it just that you got confused?

Why so serious. Seems I've seen that somewhere before?

Cheers
Wayne

[Kermit]

I've locked your topic,because you've asked the same question here too

as next question

Next question.
Why the hell does SMF not upgrade the database when it upgrades itself or did I do something wrong when I upgraded with every version via Fantastico since 1.1.4?

Btw. the error from other topic can not be caused due to upgrade to 2.x,because in the error message you can see,that your forum files have  still the version 1.1.7,so long story short,the issues are similar enough for me,that's why i've locked the other one and both of them can be solved in this topic


-Duncan85

[FX-FatCat]

OK. You the moderator.

I'll ask both questions here then, but I honestly think that a question about upgrading to Ver 2.0 should be in the 2.0 thread?
But I will do it as you ask, except if you do not mind I think I should open a new thread here then about the upgrade otherwise it may confuse people have two different subjects in one thread, let me know which way you'd prefer it?

Question 1.
Is posted in this thread in the first post.

Question 2.
If I upgrade to ver 2 from my current version 1.1.7, will the problem as discussed in post #1 of this thread be resolved?

Thanks
Wayne

[Dragooon]

No..Your MySQL has corruption, you won't even be able to upgrade if this error doesn't go away.

[FX-FatCat]

Thanks Dragoon

Damn I am getting the same error on all three instances of SMF?
I guess my Host must have done something?
I have logged a ticket as you suggested.

Thanks again for the help.
Wayne

[Dragooon]

Yup, then its most certainly host's issue here. you can however attempt a repair from phpMyAdmin.

[FX-FatCat]

If it's not that difficult and you don't mind giving me some direction, I'd be more than happy to try?

Thanks again
Wayne

[Dragooon]

Go to phpMyAdmin > Select all your tables and from the dropdown at most bottom, select Repair.

[FX-FatCat]

Hi Dragoon

I think I did it right, it was not that difficult, so I did all the SMF instances, but the problem remains.

Can't create/write to file '/var/tmp/#sql_6a8_0.MYI' (Errcode: 13)
File: /usr/home/ovenston/public_html/f3/Sources/Recent.php
Line: 102

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.7, while your database is at version 1.1.4. The above error might possibly go away if you execute the latest version of upgrade.php.

Do you have any other idea's that I may be able to try?

Thanks
Wayne

[Dragooon]

Then its all up for host.

[FX-FatCat]

Thanks Dragoon, appreciate all the help.
I'll wait for CookieHost to get back to me and see what they have to say?

Cheers
Wayne

[N3RVE]

I'll ask both questions here then, but I honestly think that a question about upgrading to Ver 2.0 should be in the 2.0 thread?

All queries related to Installations / Upgrades should be started in the Install and Upgrade board, that said, this topic and the other are in their right location.

But I will do it as you ask, except if you do not mind I think I should open a new thread here then about the upgrade otherwise it may confuse people have two different subjects in one thread, let me know which way you'd prefer it?

Question 1.
Is posted in this thread in the first post.

Question 2.
If I upgrade to ver 2 from my current version 1.1.7, will the problem as discussed in post #1 of this thread be resolved?

There are actually two different queries but it wouldn't hurt having both in one support topic seeing that they were both started to get rid of the same issue, thus, I'd leave your other topic locked and mark as solved so support regarding this issue can be continued here.

Can't create/write to file '/var/tmp/#sql_6a8_0.MYI' (Errcode: 13)
File: /usr/home/ovenston/public_html/f3/Sources/Recent.php
Line: 102

This happens when, for any reason, MySQL decides it's better to run a query by making a temporary index for it.  This can often be faster than otherwise, but can sometimes be slower; either way, this is done automatically and not something the script can directly control.
http://dev.mysql.com/doc/refman/5.0/en/file-permissions.html

I suggest you open phpMyAdmin (What is phpMyAdmin?), and run a repair on the entire database. Also ensure that /tmp is chmodded to 666 or 777 (preferably 777). (How do I chmod? / what is chmod?)

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.7, while your database is at version 1.1.4. The above error might possibly go away if you execute the latest version of upgrade.php.

There's nothing to worry about as they were no database changes between both versions, if you decide to fix that, you can use the solution at Manual Upgrade Instructions, scroll to the end and run that query to update the smfVersion variable to 1.1.7 in the {db_prefix}Settings table.

-[n3rve]

[FX-FatCat]

Hi n3rve
Thanks for that.

Just out of interest, I followed Dragoon's advice and got hold of my Host.
Turns out the problem was something on the host side and not with SMF.

Thank you Dragoon.

Cheers
Wayne

[Tyrsson]

Glad you got it sorted out Can you please mark the topic as solved by selecting it from the bottom of the thread by the link tree

Thanks

[FX-FatCat]

With Pleasure.

[N3RVE]

Good to see you got it resolved, perhaps, your host restored the correct permissions for the /tmp dir.

-[n3rve]