phpBB Smith: SQL Error and PM problem

Author	Message
gonkowonko Member
Tue May 10, 2005 7:47 am Post subject: SQL Error and PM problem
Hi first of all what a fantastic mod!!!!! easy to install as well Ok just a couple of problems 1. It seems that when 3 or more buddies come online at the same time and i get the popup to say who has come online i get this message Code: Could not get online/offline usernames DEBUG MODE SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 SELECT user_id, username FROM phpbb_users WHERE user_id IN () Anyone have any ideas how to fix this? 2. Disallow Users, It hides all information regarding bits in profile and topic but i can still send PMs to peeps who have disallowed me? Any ideas at all? Cheers Gaz BTW keep up the good work!!!!!!

Julien_B Member
Wed Mar 29, 2006 4:09 am Post subject:
up I have the same 2 pb... thank you for this great mod ! I use it on my forum : 100 000 members

Thoul Administrator
Fri Mar 31, 2006 12:40 am Post subject: re: SQL Error and PM problem
I think the PM problem might be due to some changes in phpBB since the last version of the hack was released. I'll try to do some in-depth testing next week to see what I can find with that. I'm not sure what would cause this popup problem, but I'll look at it at the same time. I have a half finished new version of this hack lying around somewhere that might already have that fixed. 100, 000 members, huh? That's pretty cool.

Thoul Administrator
Sun Apr 09, 2006 1:16 pm Post subject: re: SQL Error and PM problem
Sorry, but I didn't get to this during the week. I was planning to do something with it during the latter part of the week, but it turned out to be a really bad week.

oliver2000 Member
Fri Jun 22, 2007 9:44 am Post subject: is this problem not solved yet?
Hi to all, I also have the very same problem. Also around 50.000 users and mostly like 500 online together... I get the very same SQL error message? Would be nice if there is some fix for this, I love the MOD but i switched for now the complete popup function of. thank you, great mod anyway Oliver

Tue May 10, 2005 7:47 am Post subject: SQL Error and PM problem

Hi first of all what a fantastic mod!!!!! easy to install as well

Ok just a couple of problems

1. It seems that when 3 or more buddies come online at the same time and i get the popup to say who has come online i get this message

Code:

Could not get online/offline usernames

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1

SELECT user_id, username FROM phpbb_users WHERE user_id IN ()

Anyone have any ideas how to fix this?

2. Disallow Users, It hides all information regarding bits in profile and topic but i can still send PMs to peeps who have disallowed me? Any ideas at all?

Cheers

Gaz

BTW keep up the good work!!!!!!

Wed Mar 29, 2006 4:09 am Post subject:

up

I have the same 2 pb...

thank you for this great mod !
I use it on my forum : 100 000 members Super Razz

Fri Mar 31, 2006 12:40 am Post subject: re: SQL Error and PM problem

I think the PM problem might be due to some changes in phpBB since the last version of the hack was released. I'll try to do some in-depth testing next week to see what I can find with that.

I'm not sure what would cause this popup problem, but I'll look at it at the same time. I have a half finished new version of this hack lying around somewhere that might already have that fixed.

100, 000 members, huh? That's pretty cool. Smile

Sun Apr 09, 2006 1:16 pm Post subject: re: SQL Error and PM problem

Sorry, but I didn't get to this during the week. I was planning to do something with it during the latter part of the week, but it turned out to be a really bad week.

Fri Jun 22, 2007 9:44 am Post subject: is this problem not solved yet?

Hi to all,

I also have the very same problem. Also around 50.000 users and mostly like 500 online together...

I get the very same SQL error message?

Would be nice if there is some fix for this, I love the MOD but i switched for now the complete popup function of.

thank you,
great mod anyway

Oliver