Advertisement:

Author Topic: MySQL 5.0.12 Compatibility patch  (Read 155469 times)

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: MySQL 5.0.12 Compatibility patch
« Reply #80 on: November 30, 2005, 04:25:24 PM »
@ ss4vegito

It seems like you didn't overwrite all the files when you downloaded the upgrade package.  Also you did not run upgrade.php.  You will need to download 1.1 RC1 again the upgrade package, not install nor update.  Then using your FTP client overwrite all the files, run upgrade.php.  Then apply this patch.

NOTICE: Doing this will remove any mods that you have installed.
Follow me on Twitter

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

Offline TedNigma

  • Semi-Newbie
  • *
  • Posts: 99
Re: MySQL 5.0.12 Compatibility patch
« Reply #81 on: December 03, 2005, 02:01:12 AM »
I used the 'over write your files' method.  unzip/FTP works like a champ...

Now, if I can get that damned email thang worked out....

Offline ss4vegito7

  • Semi-Newbie
  • *
  • Posts: 43
Re: MySQL 5.0.12 Compatibility patch
« Reply #82 on: December 03, 2005, 02:05:45 PM »
Thanks Jay, everything works now.  :D

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: MySQL 5.0.12 Compatibility patch
« Reply #83 on: December 03, 2005, 03:48:18 PM »
You're welcome ss4vegito7
Follow me on Twitter

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

Offline puggsley1980

  • Newbie
  • *
  • Posts: 6
Re: MySQL 5.0.12 Compatibility patch
« Reply #84 on: December 08, 2005, 09:52:23 AM »
Hi,

I have been getting errors with my new SMF install.  I am using PHP 5.1.1 and MySQL 5.0.

When i try to go into my boards i get: Database error Please try again. If you come back to this error screen, report the error to an administrator.

When i try and 'find and repair' errors i get the following:

Unknown column 't.ID_TOPIC' in 'on clause'
File: c:\Inetpub\wwwroot\Sources\RepairBoards.php
Line: 1390

Could this be along the same lines as some of the issues posted here?  Must admit much of it went over my head.

Any help you can give would be great, thanks.

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: MySQL 5.0.12 Compatibility patch
« Reply #85 on: December 08, 2005, 11:33:06 AM »
Just apply the patch found in the first post.  MySQL 5.0.12 Compatibility patch
Follow me on Twitter

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

Offline puggsley1980

  • Newbie
  • *
  • Posts: 6
Re: MySQL 5.0.12 Compatibility patch
« Reply #86 on: December 08, 2005, 11:35:00 AM »
Yeah, got it and it worked a treat.

Thanks!

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: MySQL 5.0.12 Compatibility patch
« Reply #87 on: December 08, 2005, 11:36:50 AM »
You're welcome.
Follow me on Twitter

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

Bonk

  • Guest
Re: MySQL 5.0.12 Compatibility patch
« Reply #88 on: December 12, 2005, 01:34:17 PM »
On sorting PMs by "from" I get the following error:

Quote
Unknown column 'pm.ID_MEMBER_FROM' in 'on clause'
File: ***\forum\Sources\InstantMessage.php
Line: 175

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. It is recommended that you execute the latest version of upgrade.php.

Wouldn't upgrade.php have run when I updated to 1.0.5 and won't running it again undo any MySQL 5 corrections made to the db?

I suspect this error is another MySQL 5 incompatibilty in the SMF code.

The code of InstantMessage.php at and before line 175:
Code: [Select]
// Load the messages up...
$request = db_query("
SELECT pm.ID_PM, pm.ID_MEMBER_FROM
FROM {$db_prefix}instant_messages AS pm" . ($context['folder'] == 'outbox' ? ($context['sort_by'] == 'name' ? "
LEFT JOIN {$db_prefix}im_recipients AS pmr ON (pmr.ID_PM = pm.ID_PM)" : '') : ", {$db_prefix}im_recipients AS pmr") . ($context['sort_by'] == 'name' ? ("
LEFT JOIN {$db_prefix}members AS mem ON (mem.ID_MEMBER = " . ($context['folder'] == 'outbox' ? 'pmr.ID_MEMBER' : 'pm.ID_MEMBER_FROM') . ")") : '') . "
WHERE " . ($context['folder'] == 'outbox' ? "pm.ID_MEMBER_FROM = $ID_MEMBER
AND pm.deletedBySender = 0" : "pm.ID_PM = pmr.ID_PM
AND pmr.ID_MEMBER = $ID_MEMBER
AND pmr.deleted = 0") . "
ORDER BY " . ($_GET['sort'] == 'pm.ID_PM' && $context['folder'] != 'outbox' ? 'pmr.ID_PM' : $_GET['sort']) . ($descending ? ' DESC' : ' ASC') . "
LIMIT $_GET[start], $modSettings[defaultMaxMessages]", __FILE__, __LINE__);

Sorting by "subject" or "date" works fine only sorting by "from" gives this error...

NOTE: still running 1.0.5 here.

Offline Thantos

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 16,163
  • Gender: Male
Re: MySQL 5.0.12 Compatibility patch
« Reply #89 on: December 12, 2005, 01:59:22 PM »
I get the same results Bonk and have notified the developers.

Offline Grudge

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 10,742
  • Gender: Male
  • Unofficial nuisance
Re: MySQL 5.0.12 Compatibility patch
« Reply #90 on: December 12, 2005, 02:31:21 PM »
Stupid MySQL. Replace with:

Code: [Select]
// Load the messages up...
$request = db_query("
SELECT pm.ID_PM, pm.ID_MEMBER_FROM
FROM ({$db_prefix}instant_messages AS pm" . ($context['folder'] == 'outbox' ? ($context['sort_by'] == 'name' ? ")
LEFT JOIN {$db_prefix}im_recipients AS pmr ON (pmr.ID_PM = pm.ID_PM)" : ')') : ", {$db_prefix}im_recipients AS pmr)") . ($context['sort_by'] == 'name' ? ("
LEFT JOIN {$db_prefix}members AS mem ON (mem.ID_MEMBER = " . ($context['folder'] == 'outbox' ? 'pmr.ID_MEMBER' : 'pm.ID_MEMBER_FROM') . ")") : '') . "
WHERE " . ($context['folder'] == 'outbox' ? "pm.ID_MEMBER_FROM = $ID_MEMBER
AND pm.deletedBySender = 0" : "pm.ID_PM = pmr.ID_PM
AND pmr.ID_MEMBER = $ID_MEMBER
AND pmr.deleted = 0") . "
ORDER BY " . ($_GET['sort'] == 'pm.ID_PM' && $context['folder'] != 'outbox' ? 'pmr.ID_PM' : $_GET['sort']) . ($descending ? ' DESC' : ' ASC') . "
LIMIT $_GET[start], $modSettings[defaultMaxMessages]", __FILE__, __LINE__);
I'm only a half geek really...

Offline Grudge

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 10,742
  • Gender: Male
  • Unofficial nuisance
Re: MySQL 5.0.12 Compatibility patch
« Reply #91 on: December 12, 2005, 02:51:36 PM »
Note the first post has also been updated. You can simply run the modification called smf_mysql_5.0.12_patch2 if you prefer.
I'm only a half geek really...

Bonk

  • Guest
Re: MySQL 5.0.12 Compatibility patch
« Reply #92 on: December 12, 2005, 03:21:06 PM »
I get the same results Bonk and have notified the developers.

Thanks. I supect those joins are the issue as that was changed in MySQL 5, I just forget how right now...

Bonk

  • Guest
Re: MySQL 5.0.12 Compatibility patch
« Reply #93 on: December 12, 2005, 03:28:48 PM »
Stupid MySQL. Replace with:

Code: [Select]
// Load the messages up...
$request = db_query("
SELECT pm.ID_PM, pm.ID_MEMBER_FROM
FROM ({$db_prefix}instant_messages AS pm" . ($context['folder'] == 'outbox' ? ($context['sort_by'] == 'name' ? ")
LEFT JOIN {$db_prefix}im_recipients AS pmr ON (pmr.ID_PM = pm.ID_PM)" : ')') : ", {$db_prefix}im_recipients AS pmr)") . ($context['sort_by'] == 'name' ? ("
LEFT JOIN {$db_prefix}members AS mem ON (mem.ID_MEMBER = " . ($context['folder'] == 'outbox' ? 'pmr.ID_MEMBER' : 'pm.ID_MEMBER_FROM') . ")") : '') . "
WHERE " . ($context['folder'] == 'outbox' ? "pm.ID_MEMBER_FROM = $ID_MEMBER
AND pm.deletedBySender = 0" : "pm.ID_PM = pmr.ID_PM
AND pmr.ID_MEMBER = $ID_MEMBER
AND pmr.deleted = 0") . "
ORDER BY " . ($_GET['sort'] == 'pm.ID_PM' && $context['folder'] != 'outbox' ? 'pmr.ID_PM' : $_GET['sort']) . ($descending ? ' DESC' : ' ASC') . "
LIMIT $_GET[start], $modSettings[defaultMaxMessages]", __FILE__, __LINE__);

Coolness! Thanks bunches. That fixed my copy of 1.0.5 just fine. I can sort my PMs by sender again!  :D

Offline California Dreamin

  • Semi-Newbie
  • *
  • Posts: 28
Re: MySQL 5.0.12 Compatibility patch
« Reply #94 on: December 22, 2005, 02:13:44 AM »
I get this error when I click on a forum message:  HELP!


Database Error
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 '' at line 1
File: /home/rrhs/www/forum/Sources/Display.php
Line: 546

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. 

Offline wizard13335

  • Jr. Member
  • **
  • Posts: 169
  • Gender: Male
  • Engage!
    • Kitten Kare
Re: MySQL 5.0.12 Compatibility patch
« Reply #95 on: December 22, 2005, 04:29:05 PM »
Quote
It is recommended that you execute the latest version of upgrade.php.
Wizard-A world of spells and enchantments awaits you.
Have a cat? Share your pet with the world at Kitten Kare.

Offline California Dreamin

  • Semi-Newbie
  • *
  • Posts: 28
Re: MySQL 5.0.12 Compatibility patch
« Reply #96 on: December 22, 2005, 11:42:06 PM »
Quote
It is recommended that you execute the latest version of upgrade.php.

I have tried to upload with the package manager.....the  patches (smf_1-0-5_update.zip and smf_1-1-rc1_upgradeand I keep getting this error  :

An Error Has Occurred!
The package you tried to upload either is not a valid package or has become corrupted. 



HELP!
« Last Edit: December 22, 2005, 11:46:37 PM by fresnolady »

Offline johnwayne

  • Newbie
  • *
  • Posts: 8
Re: MySQL 5.0.12 Compatibility patch
« Reply #97 on: December 24, 2005, 01:24:51 AM »
I just went with the MySQL manual file upload option for 1.1. RC1.

Is there any way to tell that this update is "Good to go".  Like at the bottom it says the version of SMF.

Anything like that regarding the MySQL update?  Like "Currently running MySQL compatibility update 5.0.12" or some feedback from the site.

Also, in trying to get the package manager to work, I think my problem may have been the 'local path to SMF'.  How do I find this out for the future when there are other package updates?


Thanks

Offline CrayZ

  • Jr. Member
  • **
  • Posts: 115
  • Gender: Male
    • Takime Network
Re: MySQL 5.0.12 Compatibility patch
« Reply #98 on: December 24, 2005, 10:59:43 AM »
Hi all...

I need a little bit of help here and I hope I have one.

So I'll make as mach as possible simple. Since I changed my server because they shut me down first time ( don't know reason ) I changed to a VPS server. I'm happy with it but the only problem is that i receive some strange characters when someone Quote someone else and some old post from the previous server, just some of them was totally a mes. This problem was when I had characters like ë and Ç used before and instead of them now I can see Squares and and some other characters that I don't know how they comming.

One example:

This is problematic:
Quote
Termi ?gnostik딠i referohej nj렧rupi heterogjen i ardhur nga rryma filozofiko-fetare antike, - t렣il봠pat뮠nj렰벨apje렴렭adhe n렳hekujt II-III-t묠pas Krishtit, - n렰벧jith볩 t렶endosur n렺onat m렫ulturore t력pokes, - sic ishin Roma dhe Aleksandria. Disa prej k봹re sekteve gnostike, kan렮j련istori t렭ir뤯kumentuar, nd벳a t렴jerat t렬뮡 n련ije, - n렫uptimin q렮uk njihen as themeluesit e tyre.

After I change the View/Encoding/Western European ( Windows ) is OK

Quote
Termi “gnostikë” i referohej një grupi heterogjen i ardhur nga rryma filozofiko-fetare antike, - të cilët patën një përhapjeë të madhe në shekujt II-III-të, pas Krishtit, - në përgjithësi të vendosur në zonat më kulturore të epokes, - sic ishin Roma dhe Aleksandria. Disa prej këtyre sekteve gnostike, kanë një histori të mirëdokumentuar, ndërsa të tjerat të lëna në hije, - në kuptimin që nuk njihen as themeluesit e tyre.

So as you can see I saw to many this kind of mistakes and I'm tyrerd fixing them one by one and the problem is that they steel hapening if somone quoted someone else but not so many just a few small problems.

I really don't know what's the problem and I need help.

I saw that those problems now are stored to the database. Hope is not serious.  :(

Any halp ???

Offline Prasad007

  • SMF Hero
  • ******
  • Posts: 1,557
  • Gender: Male
  • JOOMLA AND SMF FAN!!
Re: MySQL 5.0.12 Compatibility patch
« Reply #99 on: December 27, 2005, 01:14:35 AM »
how and in what way is this patch important?