MySQL v.5 Errors

[vortex]

My host upgraded to MySQL 5 from 4.0.27 and when I load my site I am getting this dB error:

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 >= 0 AND b.ID_BOARD IN (50) 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


I am using MKPortal 1.1.1, Azure 1.1 RC3 and SMF 1.1.4 but have no idea where this/these error/s are being generated from. If they're theme generated, is there an updated version that works with both SMF 1.1.4 and MySQL 5?
Any help is appreciated.

Thanks,
vortex

[Smoky]

No tinyportal?? 

[vortex]

I would have used Tiny a long, long time ago but at the time I had scripts that were not compatible with it.

[G6Cad]

During the install of SMF and TP (when you first installed your site) the installed checked what DB the server had at the time. If your host upgrade the DB, you will have to upgrade the tables for both SMF and TP to.

Download the TP database only file from our downloads and upload it to your forum and execute the file from the browser. yoursite.com/manual_tp_install.php and let it update the DB settings.

[vortex]

I'm not using TP, I use MKPortal. I just wanted to make sure it's not an issue with the theme I purchased here (Azure).

[G6Cad]

It's definatly not a theme issue

[IchBin]

Not a theme or TP related issue. You should seek help at SMF.

[vortex]

It's definatly not a theme issue

Are you 100% positive?

[IchBin]

99% of the time, themes don't even contain MySQL calls in them. So I would say I'm at least 99% sure.

[vortex]

OK, good enough for me. Thanks fellas