MySQL 5.0.12 Compatibility patch

[linuxgeek]

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.

[shinji]

error fatal

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

line 30

if ($this->_result = $database->query()) {

[JayBachatero]

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

[Max22]

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

Code Select Expand

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.

[GJ-tje]

Does this mod need any modification in order to work with 1.1RC3?
If so, what needs to be changed?

[JayBachatero]

No RC3 is MySQL 5.0.12 compatible.

[GJ-tje]

No RC3 is MySQL 5.0.12 compatible.

That's even better news! Many thanks in advance!

[junglecat]

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.