News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

MySQL 5.0.12 Compatibility patch

Started by Compuart, November 06, 2005, 09:19:38 PM

Previous topic - Next topic

JayBachatero

Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

RoarinRow


SMF 2.0
TP 1.0 RC1.1
Wordpress 3.1.3

xenovanis

Errcode 13: Can't create/write to file ...

You should contact your host about this. Possibly a permission problem during the upgrade of mySQL.
"Insanity: doing the same thing over and over again and expecting different results."


xenovanis

Gijs, that is not a solution for your problem. You need to enter your ftp username and password in the packagemanager, or chmod your files to make them writable.
"Insanity: doing the same thing over and over again and expecting different results."

gijs

eh, I tried both:

- I entered the FTP username/passw, but then got the message "You cannot download or install new packages because the Packages directory or one of the files in it are not writable"

- then I chmodded the packages directory&files 777

guessed that the first item (entering the FTP username/passw) should have done it already?

hmm

VxJasonxV

I didn't get any attachments in my e-mail.
(That's fine though, probably got around spam nukers for that very reason :P)

xenovanis

Quote from: gijs on November 07, 2005, 03:47:14 PM
eh, I tried both:

- I entered the FTP username/passw, but then got the message "You cannot download or install new packages because the Packages directory or one of the files in it are not writable"

- then I chmodded the packages directory&files 777

guessed that the first item (entering the FTP username/passw) should have done it already?

hmm

Yeah, it should.. Are you sure your path is correct?
"Insanity: doing the same thing over and over again and expecting different results."

JayBachatero

Try creating a dir called temp in the attachments dir and chmod it to 777
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

gijs

that worked! (never would have guessed this solution  :D)

thanx alot!

JayBachatero

Quote from: gijs on November 07, 2005, 04:43:21 PM
that worked! (never would have guessed this solution  :D)

thanx alot!

You welcome.  Im guessing it was having problems creating the temp dir itself.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

RoarinRow

Quote from: RoarinRow on November 07, 2005, 03:00:53 PM
Now I get this error:

File './smf/smf_log_online.MYD' not found (Errcode: 13)
File: /forum/Sources/Subs.php
Line: 1347

Note: It appears that your database may require an upgrade. Your forum files are currently at version SMF 1.0.5, whereas your database is at version SMF 1.0.2. It is recommended that you execute the latest version of upgrade.php.

Can anyone help here?  I backup up my database before this sql upgrade patch, but when I store I still get the similar message regarding the same file. subs.php

I can not get to the Admin section or any section of the forum.  I tried to use the upgrade.php, but that didn't work.  I did repairsettings.php and that didn't work either.

Any other suggestions?

SMF 2.0
TP 1.0 RC1.1
Wordpress 3.1.3

RoarinRow

I get this message after restoring:

Got error 127 from storage engine
File: /forum/Sources/Subs.php
Line: 1347

SMF 2.0
TP 1.0 RC1.1
Wordpress 3.1.3

xenovanis

Quote from: RoarinRow on November 07, 2005, 05:00:02 PM
Quote from: RoarinRow on November 07, 2005, 03:00:53 PM
Now I get this error:

File './smf/smf_log_online.MYD' not found (Errcode: 13)
File: /forum/Sources/Subs.php
Line: 1347

Note: It appears that your database may require an upgrade. Your forum files are currently at version SMF 1.0.5, whereas your database is at version SMF 1.0.2. It is recommended that you execute the latest version of upgrade.php.

Can anyone help here?  I backup up my database before this sql upgrade patch, but when I store I still get the similar message regarding the same file. subs.php

I can not get to the Admin section or any section of the forum.  I tried to use the upgrade.php, but that didn't work.  I did repairsettings.php and that didn't work either.

Any other suggestions?

I answered your post on the previous page. You should contact your host. There is a problem with your database, not with SMF.
"Insanity: doing the same thing over and over again and expecting different results."

RoarinRow

As well as this one:

Incorrect key file for table 'smf_log_online'; try to repair it
File: /forum/Sources/Subs.php
Line: 1347

Note: It appears that your database may require an upgrade. Your forum files are currently at version SMF 1.0.5, whereas your database is at version SMF 1.0.2. It is recommended that you execute the latest version of upgrade.php.

SMF 2.0
TP 1.0 RC1.1
Wordpress 3.1.3

newbiepp

Hi,
i'm curious to know exactly what you modified because i've already done by myself some modifications from few days ago, but on many more files and occurences on (v 1.1.RC1) in /sources Directory +SSI.php

by the way i replaced
for all the "SELECT"
with "LEFT JOIN"
either there is "FROM XXX AS Y" or "FROM XXX, YYY AS Y"

by a "FROM (XXX AS Y)" or  "FROM (XXX, YYY AS Y)"

I saw that you juste replace "XXX, YYY AS Y" cases
is that the only change??
seems that
as i checked with winmerge

Compuart

The problem is the order of joins:

FROM A, B
   LEFT JOIN C


was before MySQL 5.0.12 interpreted as:
FROM ((A, B)
   LEFT JOIN C)


but after MySQL 5.0.12 interpreted as:
FROM (A, (B
   LEFT JOIN C))


If there's only one table after the FROM it can only be interpreted in one way, so the parentheses are unnecessary.
Hendrik Jan Visser
Former Lead Developer & Co-founder www.simplemachines.org
Personal Signature:
Realitynet.nl -> ExpeditieRobinson.net / PekingExpress.org / WieIsDeMol.Com

eclectics

How can I use the compatabilty patch, I have no access to my BBoard. hxxp:www.windward-island.net/forum. [nonactive]
What's wrong. Can someone help me!
WKR
eclectic

Ricardo.SEP

Palmeiras
Brazil

Compuart

Quote from: eclectics on November 07, 2005, 08:27:00 PM
How can I use the compatabilty patch, I have no access to my BBoard. www.windward-island.net/forum.
What's wrong. Can someone help me!
WKR
eclectic
Try the PHP 4.4.0 compatibility first.
Hendrik Jan Visser
Former Lead Developer & Co-founder www.simplemachines.org
Personal Signature:
Realitynet.nl -> ExpeditieRobinson.net / PekingExpress.org / WieIsDeMol.Com

Advertisement: