Re: Vanishing dollar signs!

"Tanc" <[email protected]> wrote in message 
news:mailman.77.1162124267.17193.xaraya_user-gn8pmO+6nsymdvSpIQae8A@public.gmane.org
> I've installed a fresh version of Xaraya on DreamHost and it doesn't  have 
> this problem at all. I installed TinyMCE and tested, but again,  no 
> problem.
>
> I then used the database from problematic site on the fresh install  and 
> the dollar sign problem showed up again. Its really weird.
>
>> are you suppressing errors, i.e. try to set errorlevel to the  maximum 
>> and see if you get stuff back.
>
> As far as I know the error level reporting is set to the default  E_ALL 
> but I don't have much control over PHP on DreamHost. As long as  the 
> setting in config.system.php overrides the php.ini settings it  should be 
> at E_ALL.
>
> Tanc

Tanc,

Could you compare the datatypes of the columns that the data gets inserted 
into, on the two databases (the working and the non-working one). Try 
exporting the two table definitions using phpMyAdmin or similar, and compare 
them. It could be that one database is using a long text datatype 
(LONGTEXT), and the other a binary object (BLOB). The two need very 
different escape sequences to insert the same data, but at the moment Xaraya 
only does not take this into account, using just one string escaping method.

I'm assuming you are using MySQL, and that the problem lies with the 
database (you mentioned the working PHP scripts, pointing at the non-working 
database, exhibits the same problem).

-- JJ