Text only | Text with Images

TinyPortal

Development => Support => Servers & hosts => Topic started by: vortex on January 01, 2008, 04:38:34 PM

Title: MySQL v.5 Errors
Post by: vortex on January 01, 2008, 04:38:34 PM
My host upgraded to MySQL 5 from 4.0.27 and when I load my site I am getting this dB error:

Code Select

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
Title: Re: MySQL v.5 Errors
Post by: Smoky on January 01, 2008, 04:42:04 PM
No tinyportal??  :o
Title: Re: MySQL v.5 Errors
Post by: vortex on January 01, 2008, 04:47:38 PM
I would have used Tiny a long, long time ago but at the time I had scripts that were not compatible with it. :(
Title: Re: MySQL v.5 Errors
Post by: G6Cad on January 01, 2008, 05:04:23 PM
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.
Title: Re: MySQL v.5 Errors
Post by: vortex on January 01, 2008, 05:08:10 PM
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).
Title: Re: MySQL v.5 Errors
Post by: G6Cad on January 01, 2008, 05:08:55 PM
It's definatly not a theme issue
Title: Re: MySQL v.5 Errors
Post by: IchBin on January 01, 2008, 05:14:39 PM
Not a theme or TP related issue. You should seek help at SMF.
Title: Re: MySQL v.5 Errors
Post by: vortex on January 01, 2008, 05:15:55 PM
Quote from: G6 on January 01, 2008, 05:08:55 PM
It's definatly not a theme issue

Are you 100% positive?
Title: Re: MySQL v.5 Errors
Post by: IchBin on January 01, 2008, 05:19:39 PM
99% of the time, themes don't even contain MySQL calls in them. So I would say I'm at least 99% sure.
Title: Re: MySQL v.5 Errors
Post by: vortex on January 01, 2008, 05:22:44 PM
OK, good enough for me. Thanks fellas  :)
Title: Re: MySQL v.5 Errors
Post by: vortex on January 01, 2008, 06:35:26 PM
Hey IchBin; may I PM you?
Title: Re: MySQL v.5 Errors
Post by: IchBin on January 02, 2008, 07:38:16 AM
I would prefer to keep in on the board, unless you have private info you don't want to share.
Text only | Text with Images