Search
Other DB Replacer questions
Forum

db replacer dont found occurence on live site

folamour's Avatar folamour
hi folks, i'm sorry all worked fine on our Xampp lab, but on live site db replacer dont found some occurence

in table content / intro text / full text

we search :

font-size: 14px;

and replace to

font-size: 15px;

that worked for some article, but we still have article that have this occurence and is not found (all is ok on lab !) its the live site who cause issue

example :

www.crashdebug.fr/tous-surveilles-7-milliards-de-suspects-arte

<h2><em><span style="font-size: 14px;">Merci à David de la <a href=" www.laquadrature.net/ " title="">Quadrature du net</a>...</span></em></h2>
<p>
<iframe src="//ok.ru/videoembed/1870419135150" allowfullscreen="allowfullscreen" allow="autoplay" width="650" height="355" frameborder="0"></iframe>
</p>
<section class="program-section margin-bottom-s">
<div class="rich-text program-summary">
<p><span style="font-size: 14px;"><span style="font-family: tahoma,geneva,sans-serif;"><strong>Des caméras de Nice à la répression chinoise des Ouïghours, cette enquête dresse le panorama mondial de l'obsession sécuritaire, avec un constat glaçant : le totalitarisme numérique est pour demain.&nbsp;</strong></span></span></p>
</div>
</section>
Peter van Westen's Avatar Peter van Westen ADMIN
Then I guess there is a difference in the syntax.
Try:
font-size:14px;
So without the space.

As a test you could just search for '14px' to see what the syntax is around it.

Also: I recommend you do not use inline styling at all, and rely on class names.
This way you can change the font size (and any other styling) in one go for your entire site.
Please post a rating at the Joomla! Extensions Directory
folamour's Avatar folamour
hi peter, i have already checked both with space or not, but even 14px; is not found at all,

all the best,
Peter van Westen's Avatar Peter van Westen ADMIN
That pretty much means that what you are looking for is not inside the table (and columns) you are searching in. It can be that that content (HTML) is coming from somewhere else.
Please post a rating at the Joomla! Extensions Directory
folamour's Avatar folamour
Hi peter i'm well seeking in content and introtext / fulltext

(remember that worked for all occurence on the xampp lab copy, same php release etc)

correct me if i'm wrong, but i guess that our 15k articles is in these tables

so DB replacer should found theses occurence

font-size:14px;

and

font-size: 14px;

you saw the html code of the sample article

www.crashdebug.fr/tous-surveilles-7-milliards-de-suspects-arte

i provided before,


that the problem.... i dont understand why,

all the best,

f.
Peter van Westen's Avatar Peter van Westen ADMIN
Can you give me (super) admin access so I can take a look?
You can use the 'Confidential information' button in the forum editor to hide sensitive information.
Please post a rating at the Joomla! Extensions Directory
folamour's Avatar folamour
hi peter i'll prefer sending you the credential by email,
Peter van Westen's Avatar Peter van Westen ADMIN
Well, there you go. It said the credentials were not correct, and now my IP is suspended.

You say you have a PHP error. Do you also have that on the xampp version?
PHP errors can also make ajax calls fail, so it could be the reason things don't work.
Please post a rating at the Joomla! Extensions Directory
folamour's Avatar folamour
hi peter i'll confirm you that the credential i'll sendend you are correct but there is a caps (i sended you the pass), reboot your gateway and try again

yes we also have the same error on the xampp lab, but as i told you that dont impact the site, its template related or something like that, i have to dig the issue.
Peter van Westen's Avatar Peter van Westen ADMIN
reboot your gateway and try again
No, remove my IP from your blocked list. Or disable the IP/admin blocking temporarily.
Please post a rating at the Joomla! Extensions Directory
folamour's Avatar folamour
done i'll think but we have tons of intruder banned every hours,

keep me updated....
Peter van Westen's Avatar Peter van Westen ADMIN
So it indeed looks like there are PHP errors preventing the search call to return what it should.

Can you also give me (s)ftp access so I can take a deeper look?
You can use the 'Confidential information' button in the forum editor to hide sensitive information.
Please post a rating at the Joomla! Extensions Directory
folamour's Avatar folamour
hi peter info send by email,

all the best

f.
Peter van Westen's Avatar Peter van Westen ADMIN
The website is running into memory limit errors, which causes stuff to fail.

So either increase your server's PHP memory settings.
Or set the max search results lower in the DB Replacer settings.
Please post a rating at the Joomla! Extensions Directory
folamour's Avatar folamour
ok, i'll set this this nigth and get a try
folamour's Avatar folamour
its ok peter i've done the job make memory goes to 4096 but still issue, so lowering to 200 and finished the job

thanks you so much,

you can close the case.

f.
Peter van Westen's Avatar Peter van Westen ADMIN
Ok, happy you got it working.
Please post a rating at the Joomla! Extensions Directory
You can only post on the extension support forum if you have an active subscription and you log in

Buy a Pro subscription