News:

SMF 2.0.19 has been released! Please update. Read more.

Main Menu

MySQL 5.0.12 Compatibility patch

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

Previous topic - Next topic

linuxgeek

Quote from: JayBachatero on April 29, 2006, 04:06:51 PM
No you do not need the MySQL Compatibility patch.

This just in..  ;)  I went back to MySQL 5.0.20 and so far things seem to be working.  I have not tried any maintenance functions, but have setup several forums, some with sub-boards, and that much seems fine now.  I could not even get SMF 1.1 RC2 (or any other version) to install and run on my local server until now.
Local Server: FreeBSD 6.0, Apache 2.2 with PHP 5.1.2, MySQL 5.0.20, and SMF 1.1 RC2

shinji

error fatal

QuoteFatal error: Using $this when not in object context in /home/shinji/public_html/modules/mod_smf_recent_topics.php on line 30

line 30
Quoteif ($this->_result = $database->query()) {
MODD Artesano y Profesional..
(Mr.Shinji/Christianeithor)
User bar


JayBachatero

This doesn't seem to be related to the MySQL Compatibility issue.  It seems to be an issue with the joomla/mambo bridge.
Follow me on Twitter

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

Max22

I've this error during activation of board news function (in this case smf 1.1 rc2) in mkportal :

ERROR: Database error.
Cannot execute the query: SELECT m.posterTime, m.subject, m.ID_TOPIC, m.ID_MEMBER, m.ID_MSG, m.ID_BOARD, IFNULL(mem.realName, m.posterName) AS posterName, t.ID_BOARD, t.numReplies, b.name AS bName, m.body, m.smileysEnabled, m.Icon, mem.avatar, av.filename FROM smf_topics AS t, smf_messages AS m, smf_boards AS b LEFT JOIN smf_members AS mem ON (mem.ID_MEMBER = m.ID_MEMBER) LEFT JOIN smf_attachments AS av ON (mem.ID_MEMBER = av.ID_MEMBER) WHERE m.ID_MSG = t.ID_FIRST_MSG AND m.ID_MSG >= 756 AND b.ID_BOARD IN (2) AND b.ID_BOARD = t.ID_BOARD ORDER BY m.ID_MSG DESC LIMIT 1
MySql Error returned: Unknown column 'm.ID_MEMBER' in 'on clause'
MySql Error code: 1054


Please help me, I've MySQL 5.0.23-standard.

JayBachatero

This this not related to the MySQL Compatibility.  It's an issue with MKPortal.
Follow me on Twitter

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

GJ-tje

#125
Does this mod need any modification in order to work with 1.1RC3?
If so, what needs to be changed?
"People cannot gain anything without sacrificing something of equal value.
To obtain, something of equal value must be lost.
That is alchemy's first law of Equivalent Exchange."

"People should not be afraid of their Goverments. Goverments should be afraid of their People."

JayBachatero

No RC3 is MySQL 5.0.12 compatible.
Follow me on Twitter

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

GJ-tje

Quote from: Jay The Code Monkey on August 31, 2006, 02:13:45 PM
No RC3 is MySQL 5.0.12 compatible.

That's even better news! Many thanks in advance!
"People cannot gain anything without sacrificing something of equal value.
To obtain, something of equal value must be lost.
That is alchemy's first law of Equivalent Exchange."

"People should not be afraid of their Goverments. Goverments should be afraid of their People."

junglecat

#128
Quote from: JayBachatero on August 31, 2006, 02:13:45 PM
No RC3 is MySQL 5.0.12 compatible.
I updated mysql on my server to 5.0 and my forum 1.1.1 is down with sql errors. Someone please help! I need a patch to fix it. :(


ETA: never mind! It came back up all by itself.
PM me for affordable hosting. I will install your SMF forum with your choice of a theme for FREE.
~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
Join us at Christian Discussions 
~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~

Advertisement: