I'M AN IDIOT PLEASE HELP

[mrpcpro]

Try it and see. If it breaks then try changing 'location as user_location' to ' '' AS user_location'

I'll try it now Sir.  Thanks

CG

[mrpcpro]

I think I see the problem. The data requested by the sql statement is not only in the members table but the member_extra table. wouldn't these two tables have the be joined based on UserID so the SQL statement is able to retrieve the databa?

CG

[Hein Traag]

This board isnt slowchat. Try posting more text per post instead of posting 1 sentence per post every few minutes.

Is this your professional guess at what's the problem?

It's my opinion on your way of posting. See it as advice to shorten the threads you open and getting a quicker answer from those who are kind enough to help out.

[mrpcpro]

This board isnt slowchat. Try posting more text per post instead of posting 1 sentence per post every few minutes.

Is this your professional guess at what's the problem?

It's my opinion on your way of posting. See it as advice to shorten the threads you open and getting a quicker answer from those who are kind enough to help out.

I understand, but your smart ass "this isn't slow chat" comment was necessary. I'm trying to do the best I can, I'm sorry that doesn't please you.

CG

[mrpcpro]

I think I know what I'm going to try. Since I know joined isn't a field I'll replace it with another field I know exists. I'll let you know when I blow up my computer

[mrpcpro]

well that did the trick! I replaced the fields that I know don't exist in the members table with fields I know do exist. Obviously what would be better would be to join members and members extra table to get the original query to work.

Any ideas on how to do that? Hein, you've been brilliant so far. Maybe you have some ideas?

[Hein Traag]

Come on man, help us out.  It's so much easier to read when you compose a complete message instead of posing several one line messages.

That's another way of saying it. Seeing how well you take advice on how to post i wish you the best of luck with coppermine and this board. You might want to read the HowTo on posting on this board while your at it.

[mrpcpro]

Come on man, help us out.  It's so much easier to read when you compose a complete message instead of posing several one line messages.

That's another way of saying it. Seeing how well you take advice on how to post i wish you the best of luck with coppermine and this board. You might want to read the HowTo on posting on this board while your at it.

Well I did do that. After he explained why it was better I immediately posted everything in one shot.

I think you are the one with the problem. Not everyone can take jokes very well. Your first post was to make fun of me rather then help. If this is your contribution to my question then why bother? I'm not being nasty or anything to you. I simply said I needed help and you just make fun of me. That's not fair.

Anyway, I really don't understand why those fields are requested in the SQL statement because they are not used in the e-card system. Pretty silly if you ask me

[mrpcpro]

I hope my solution helps somebody. It's not the greatest solution, but it's certainly better then "IT'S UP TO YOU TO FIX IT" answers I've seen.

I guess the biggest problem with Invision board support is that you have to buy Invision Board in order to understand what someone is experiencing. So it must be hard for the open source people to integrate with this board without having to spend lots of $$$

I really think it sucks that Invision board is paid now, but it's a pretty amazing board with tons of options.I hope SMF becomes better and stays free so I can switch over to this board. It's pretty nice.

Finally, I still don't know why that SQL statement asks for location, website, and other stuff because it doesn't use it. Maybe it's somewhere else and I can't find it.

I'll report back to see if I can find it

[mrpcpro]

simple enough, it's under Profile. When you pull up a user's profile you get the results of the fields I substituted. For "Location in user_location" is used "posts in user_location" so when you pull up a profile rather then "location" you will get "posts". So to fix the error you would have to join members and members_extra table and then run the original query.

The above is just my guess.

CG

[Hein Traag]

Just for the sake of argument. My first post was not ment to make fun of you but merely to point out you were kinda flooding the thread with one-liners, as kegobeer points out as wel. EOF

[mrpcpro]

Just for the sake of argument. My first post was not ment to make fun of you but merely to point out you were kinda flooding the thread with one-liners, as kegobeer points out as wel. EOF

OK. Thanks Hein. I guess it was my mistake. Sorry

CG