Re: Vanishing dollar signs!

"Tanc" <[email protected]> wrote in message 
news:mailman.78.1162130670.17193.xaraya_user-gn8pmO+6nsymdvSpIQae8A@public.gmane.org
> Jason,
>
> I did a comparison as you suggested searching for longtext and blob  types 
> but the tables from the working and non-working databases match  fine up 
> so that doesn't seem to be the issue.
>
> I've stripped all modules other than articles, search and categories  (and 
> the core modules) from the non-working database site but the  problem 
> still occurs.
>
> I also tested another module, the sitecontact module, to see whether  the 
> vanishing dollar sign problem occurred and it did, so its not  specific to 
> the articles module. It seems to effect all textareas and  it even happens 
> in other input boxes.
>
> Is there any thing else I can check to do with the database? The  MySQL 
> version I'm using is 5.0.18 with a UTF-8 character set. PHP  versions I've 
> tested are 4.4.2 as mod_php on apache and versions  5.1.2 and 5.1.5 both 
> as fastcgi on apache. All have the same  problematic result.
>
> Tanc

Okay, running out of straws now.

How about something like this:

http://pear.php.net/bugs/bug.php?id=50

All input variables (GET and POST) go through a filter, albeit not PEAR, and 
there could be something happening in that area. Also there may be another 
clue here:

http://www.usebb.net/community/topic-744.html

When the data you input is stored in the database, is it stored differntly 
in the work and non-working databases? i.e. is this a problem with 
information being mangled on the way into the database, or on the way out?

Do you have any hooks turned on for the articles module? e.g. the html 
module hooks, or autolinks? Ultimately, I think we need to follow a piece of 
data from an input form into the database and back out again, to see where 
it gets munched. That should be fairly easy (with our help) using the 
divide-in-half method. The first step is looking in the database to see 
whether the $n is disappearing on its way to being stored, or on its way out 
of the database to be displayed.

-- JJ