Find all posts liked for. - User Profiles
Post Reply
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
07-07-2011, 11:38 AM
 
Find all posts liked for. - User Profiles
Seems to do nothing but lead to an error page if used to try and find likes someone has given you or likes others have given someone else. The other function, Find all threads liked for works perfectly and can be used to find the thread the single post resides in but its not as convenient.

Not a major issue, but I didn't see any mention of the problem prior to this thread.
Quote this message in a reply
[+] 1 user Likes Maskelyne's post
07-07-2011, 12:17 PM
RE: Find all posts liked for. - User Profiles
Strange. It works fine for me. I'll look into the settings for new members....

Just visiting.

-SR
Find all posts by this user
Like Post Quote this message in a reply
07-07-2011, 12:37 PM
RE: Find all posts liked for. - User Profiles
Doesn't work for me either, on any profile including my own.

I get this error:

Code:
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1054 - Unknown column 't.uid' in 'where clause'
Query:
SELECT pid FROM mybb_posts WHERE pid IN ( SELECT tyl.pid FROM mybb_g33k_thankyoulike_thankyoulike tyl WHERE tyl.puid = 284) AND fid NOT IN ('27')AND ((fid IN(27) AND t.uid='9782') OR t.fid NOT IN(27)) ORDER BY dateline DESC

   

The God excuse: the last refuge of a man with no answers and no argument. "God did it." Anything we can't describe must have come from God. - George Carlin

Whenever I'm asked "What if you're wrong?", I always show the asker this video: http://youtu.be/iClejS8vWjo Screw Pascal's wager.
Find all posts by this user
Like Post Quote this message in a reply
[+] 1 user Likes Efrx86's post
07-07-2011, 05:41 PM
RE: Find all posts liked for. - User Profiles
The function works for me.

I don't believe Jesus is the son of God until I see the long form birth certificate!
Find all posts by this user
Like Post Quote this message in a reply
07-07-2011, 09:18 PM
RE: Find all posts liked for. - User Profiles
Problems like this are slightly harder to track down than ones that fail consistently. Though that sql query shown above is clearly wrong. I'll have to track down why those queries are being generated like that.

I'll fix it sometime this weekend.

“Forget Jesus, the stars died so you could be born.” - Lawrence M. Krauss
Find all posts by this user
Like Post Quote this message in a reply
18-07-2011, 01:14 AM
RE: Find all posts liked for. - User Profiles
(07-07-2011 12:37 PM)Efrx86 Wrote:  Doesn't work for me either, on any profile including my own.

I get this error:

Code:
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1054 - Unknown column 't.uid' in 'where clause'
Query:
SELECT pid FROM mybb_posts WHERE pid IN ( SELECT tyl.pid FROM mybb_g33k_thankyoulike_thankyoulike tyl WHERE tyl.puid = 284) AND fid NOT IN ('27')AND ((fid IN(27) AND t.uid='9782') OR t.fid NOT IN(27)) ORDER BY dateline DESC

Same error for me.
   
Find all posts by this user
Like Post Quote this message in a reply
30-08-2011, 08:11 AM
RE: Find all posts liked for. - User Profiles
This issue should be resolved as of now. Took me a while but I finally got off my lazy ass and fixed it! Smile

“Forget Jesus, the stars died so you could be born.” - Lawrence M. Krauss
Find all posts by this user
Like Post Quote this message in a reply
30-08-2011, 08:15 AM
 
RE: Find all posts liked for. - User Profiles
(30-08-2011 08:11 AM)DeepThought Wrote:  This issue should be resolved as of now. Took me a while but I finally got off my lazy ass and fixed it! Smile

Sorry, it still doesn't work for me.

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 mybb_posts WHERE pid IN ( SELECT tyl.pid FROM mybb_g33k_thankyoulike_thankyoulike tyl WHERE tyl.puid = 11568) AND fid NOT IN ('27')AND ((fid IN(27) AND t.uid='11568') OR t.fid NOT IN(27)) ORDER BY dateline DESC
Quote this message in a reply
30-08-2011, 01:31 PM
RE: Find all posts liked for. - User Profiles
It's still not fixed, and now I can't see the "likes given" or "likes received" fields on user posts.

   

The God excuse: the last refuge of a man with no answers and no argument. "God did it." Anything we can't describe must have come from God. - George Carlin

Whenever I'm asked "What if you're wrong?", I always show the asker this video: http://youtu.be/iClejS8vWjo Screw Pascal's wager.
Find all posts by this user
Like Post Quote this message in a reply
30-08-2011, 06:18 PM
RE: Find all posts liked for. - User Profiles
I'll continue with it after work. This is really becoming a pain in the ass.

The search problem is intermittent. The new version of the likes system changed how it uses the templates so I need to do a couple changes.

“Forget Jesus, the stars died so you could be born.” - Lawrence M. Krauss
Find all posts by this user
Like Post Quote this message in a reply
Post Reply
Forum Jump: