Join the Ashes of Creation MMORPG
(Register or log in to remove advertisements - why ads?)

"Find liked posts" function broken


Started by Sparhawk
Post #650
Member

Likes Given: 17
Likes Received: 18
Faction & Race:
Daggerfall Covenant (Breton)
Just got this when I clicked the option on my profile:

MyBB SQL Error

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1054 - Unknown column 't.uid' in 'where clause'
Query:
SELECT pid FROM tes_posts WHERE pid IN ( SELECT tyl.pid FROM tes_g33k_thankyoulike_thankyoulike tyl WHERE tyl.puid = 21) AND fid NOT IN ('18','15','17')AND ((fid IN(16) AND t.uid='21') OR t.fid NOT IN(16)) ORDER BY dateline DESC
Like this post Reply
Post #652
Administrator

Likes Given: 1,007
Likes Received: 963
Faction & Race:
Daggerfall Covenant
Redguard
Can you try it again? It's working on my end.


Please use the Help & Feedback section if you need help. This will help others that may have the same questions and you will receive a faster response.
Like this post Reply
Post #656
Member

Likes Given: 17
Likes Received: 18
Faction & Race:
Daggerfall Covenant (Breton)
Interesting. I can get it to work if I'm not logged in, but the error above consistently comes up when I am. Tested on both Firefox and Chrome. Maybe it's just something on my profile.
Like this post Reply
Post #657
Administrator

Likes Given: 1,007
Likes Received: 963
Faction & Race:
Daggerfall Covenant
Redguard
Thanks. I'll see if I can find out what the issue is and fix it.


Please use the Help & Feedback section if you need help. This will help others that may have the same questions and you will receive a faster response.
Like this post Reply
Post #660
Member

Likes Given: 3
Likes Received: 47
Faction & Race:
Daggerfall Covenant (Redguard)
Having the same issue Tecca. I can only see the "likes" when I log out. It takes me to the same error page when logged in.
Like this post Reply
Post #3282
Contributor

Likes Given: 141
Likes Received: 252
Faction & Race:
Aldmeri Dominion (Khajiit)
No fix yet? Tough one?


The Elsweyr Confederacy

My motto: "Don't look for the next opportunity. The one you have in hand, is the opportunity."
Like this post Reply
Post #3283
Administrator

Likes Given: 1,007
Likes Received: 963
Faction & Race:
Daggerfall Covenant
Redguard
Yeah, I believe it's conflicting with another plugin that we have. I can't recreate this on my end - it works fine for me. I still have it on my to-do list, however.


Please use the Help & Feedback section if you need help. This will help others that may have the same questions and you will receive a faster response.
Like this post Reply
Post #3285
Contributor

Likes Given: 141
Likes Received: 252
Faction & Race:
Aldmeri Dominion (Khajiit)
(October 16th 2012, 12:55 AM)Tecca Wrote: Yeah, I believe it's conflicting with another plugin that we have. I can't recreate this on my end - it works fine for me. I still have it on my to-do list, however.

Allright :)


The Elsweyr Confederacy

My motto: "Don't look for the next opportunity. The one you have in hand, is the opportunity."
Like this post Reply
Post #3309
Contributor

Likes Given: 141
Likes Received: 252
Faction & Race:
Aldmeri Dominion (Khajiit)
(August 26th 2012, 03:03 PM)Sparhawk Wrote: Just got this when I clicked the option on my profile:

MyBB SQL Error

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1054 - Unknown column 't.uid' in 'where clause'
Query:
SELECT pid FROM tes_posts WHERE pid IN ( SELECT tyl.pid FROM tes_g33k_thankyoulike_thankyoulike tyl WHERE tyl.puid = 21) AND fid NOT IN ('18','15','17')AND ((fid IN(16) AND t.uid='21') OR t.fid NOT IN(16)) ORDER BY dateline DESC

I got my message, about same problem as Sparhawk, but Query is maybe not same, particular number. But i think it does only every member have own query as number.

Quote:MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1054 - Unknown column 't.uid' in 'where clause'
Query:
SELECT pid FROM tes_posts WHERE pid IN ( SELECT tyl.pid FROM tes_g33k_thankyoulike_thankyoulike tyl WHERE tyl.puid = 61) AND fid NOT IN ('15','17','19','21')AND ((fid IN(16) AND t.uid='61') OR t.fid NOT IN(16)) ORDER BY dateline DESC

Please contact the MyBB Group for support.


The Elsweyr Confederacy

My motto: "Don't look for the next opportunity. The one you have in hand, is the opportunity."
Like this post Reply




Users browsing this thread: 1 Guest(s)
(Register or log in to remove advertisements - why ads?)


This fan site is not affiliated with ZeniMax Media Inc. or any of its subsidiaries. Including, but not limited to, Bethesda Game Studios and ZeniMax Online Studios.
The Elder Scrolls® images © ZeniMax Media Inc. / Forum content © TESOF.com