The ignore & un-ignore

[KULPDOGG]

the server switchover didnt seem to like the IGNORE MODULE
The bypass to view a particular post does not work and removing a user does not work.

Could not delete user from ignore table

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 'AND user_id = 225' at line 4

DELETE FROM nhforums_phpbb_ignore WHERE user_ignore = AND user_id = 225

Line : 88
File : /home/katia/www/forum.nessaholics.com/htdocs/ignore.php

there is no user with the id 225.
i checked.. unless they're not on the member list

[Vultch]

there is no user with the id 225.
i checked.. unless they're not on the member list

Look again, I'm 225. So that's not the problem, its the db link between 225 and my ignore list thats getting lost somewhere in SQhelL

[KULPDOGG]

:?

well, i noticed that the ids go in order on the memberlist...
but some numbers are missing(i assume from deleted members?)
but other than that they are in order..
and on the list
it goes from
http://forum.nessaholics.com/profile.php?mode=viewprofile&u=224
to
http://forum.nessaholics.com/profile.php?mode=viewprofile&u=226
no 225 in the middle
 :?
unless im wrong in thinking that the ids go in order..
i think you're not listed on the member list :?:

edit: oh shoot, my bad.. they're not in order :?
nevermind  :oops:  :oops:

[Trolan]

Something about the SQL statement.  It's not a problem with the userid, it's the bit after user_ignore.  WHERE user_ignore = (WHAT?!?).  I'll take a look at it, and if I can't find it, I'll just stick you on my ignore.  :twisted:

the server switchover didnt seem to like the IGNORE MODULE
The bypass to view a particular post does not work and removing a user does not work.

Could not delete user from ignore table

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 'AND user_id = 225' at line 4

DELETE FROM nhforums_phpbb_ignore WHERE user_ignore = AND user_id = 225

Line : 88
File : /home/katia/www/forum.nessaholics.com/htdocs/ignore.php

[Trolan]

Should be fixed now.

The authors of the ignore module appear to have forgotten a little detail in how PHP accesses variables from URL/form data, and how it changed the default from PHP 4.1 and 4.2.  As the previous server was installed with 4.1 originally, the defaults in the config file from that period remained in effect, even up to the current version on that server.  This one started at 4.3.4, and therefore is using those defaults, as I tend to agree with them, and it's been almost two years since that change was made.  Portable PHP code shouldn't make the assumption they did.

[LifelessPie]

i accidently pressed ignore instead of quote , as well....ut how d oyou get someone off your ignore lists??

[Si]

i accidently pressed ignore instead of quote , as well....ut how d oyou get someone off your ignore lists??

Go here
and then click on the little cross on the right of the name of the person you ignored

[Vultch]

Should be fixed now.

You're a pimp! Thanks Kelly!

[Jameson]

This is going to sound retarded but insted of clicking "quote" i clicked ignore....How do i reverse this? :?:

[kev222]

This is going to sound retarded but insted of clicking "quote" i clicked ignore....How do i reverse this? :?:

I'm sure Vulture answered this once, but his reply is gone. So...

http://forum.nessaholics.com/ignore.php

It's not so retarted. It's worse when you're a mod and you click [Edit] instead of

then save all over somebody's post lol

-Kev

[Vultch]

That's not so retarted. It's worse when you're a mod and you click [Edit] instead of (quote) then save all over somebody's post lol

lmfao! its funny cause it's true!

[kev222]

That's not so retarted. It's worse when you're a mod and you click [Edit] instead of (quote) then save all over somebody's post lol

lmfao! its funny cause it's true!

Heh. And only the back button can save you (if you're lucky).

-Kev

[kaysha]

I have never done that...  wth?

[TSE]

Some mods do that for fun :wink:

"What?!  I didn't say that!"

[Vultch]

I've never saved over but I have hit the wrong button and caught myself.

And I've seen mods quote when they meant to edit. hehe Thats not so bad cause it just makes a double post type of thing.