Author Message

cubby cub

Sunday 23 August 2009 11:29:10 pm

Hello,

How do I change all instances of [email protected]?

I changed it in the DB but it's still showing on the front end whenever I edit an article.

Thank you

Aang: Just like the legend says, we let love lead the way.

kracker (the)

Sunday 23 August 2009 11:37:52 pm

I suggest dumping the sql database to a dump file and performing a search and replace on the contents of the file to quickly and globally remove this address from your database content.

perl -pi -e 's/originalStringA/replacmentStringB/g' ezpublish.dump.sql

<i>//kracker</i>

Member since: 2001.07.13 || http://ezpedia.se7enx.com/

cubby cub

Sunday 23 August 2009 11:59:08 pm

hi,

thanks. unfortunately, i'm not that skilled..

i did a search for [email protected] in phpmyadmin and replaced it there. so i'm guessing it's file-side? whenever i edit an article, this address shows as the default.

it should be a simple change right?

Aang: Just like the legend says, we let love lead the way.

Heath

Monday 24 August 2009 12:35:24 am

Hello,

Here a specific example command that should work. I tried it myself just before posting it.

perl -pi -e 's/nospam\@ez\.no/nospam\@example\.com/g' test.dump.sql;

This will require shell (command line) access to run this command to replace the offending text entries from the database dump.

Start by dumping your database to file and then use a search and replace program (like perl) to use this regular expression to replace the values.

phpmyadmin in this case prolly can help you dump the database to file. I don't know a sql query which would perform this action in sql (though I'm certain that's possible too).

These address are stored per article content object version within the (rather complicated database structure, i forget which table offhand).

Cheers,
Heath

Brookins Consulting | http://brookinsconsulting.com/
Certified | http://auth.ez.no/certification/verify/380350
Solutions | http://projects.ez.no/users/community/brookins_consulting
eZpedia community documentation project | http://ezpedia.org

cubby cub

Monday 24 August 2009 3:01:03 am

i dont know how to run shell commands.

i tried phpmyadmin again and did a search for "spam" instead of the full email address. that brought up the sessions table so hopefully, once i make the changes there, that'll take care of the discrepancy.

thanks

Aang: Just like the legend says, we let love lead the way.

James

Monday 24 August 2009 4:22:38 am

Unfortunately I am fairly certain from experience it won't. Those values are from the anonymous user session records in the database. In-fact those values come from the anonymous user (you should change the address within the user itself within the ezadmin).

Your best bet is to review the existing content in the <i>ezcontentobject_attribute</i> sql table.

Remember some of content in this table rows are stored in xml and some values may be serialized. So take care to make compatible changes (aka try not to mess up the internal storage format).

Cheers,
James

Monday 24 August 2009 4:27:52 am

And if you want to do it within the admin, anyone who wants to could, update this extension which helps users change the author of a content object to eZ Publish 4.1

<i>http://ez.no/developer/contribs/applications/change_owner_using_the_content_browser</i>

But your not going to be able to make use of that solution out of the box presently since it has not been updated for some time and your still learning eZ

Your best bet is to learn how to use shell or speak with someone who knows how to and can show you.

cubby cub

Monday 24 August 2009 4:58:33 am

SIGH!

See this is what I'm talking about. Anytime a script requires that you execute a shell command to change the default email address, it's not user friendly...by ANY stretch of the imagination.

From what I can tell, changing it in phpmyadmin worked. There were three tables that had the email address. I changed it for the anony user as well.

Now if this address is on the file-side, yes, it will constantly reproduce itself. But I assume that there are places in the admin panel where it can/should be updated to change it on the file-side. So is this location in the admin panel a secret? Beyond changing the admin user email, do I need to do something else?

Aang: Just like the legend says, we let love lead the way.

eZ debug

Timing: Feb 13 2025 04:13:03
Script start
Timing: Feb 13 2025 04:13:03
Module start 'content'
Timing: Feb 13 2025 04:13:03
Module end 'content'
Timing: Feb 13 2025 04:13:03
Script end

Main resources:

Total runtime0.1289 sec
Peak memory usage2,048.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0056 589.9375180.8359
Module start 'content' 0.00560.0084 770.7734105.9609
Module end 'content' 0.01400.1149 876.7344535.7188
Script end 0.1289  1,412.4531 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00413.2007200.0002
Check MTime0.00181.4205200.0001
Mysql Total
Database connection0.00070.550610.0007
Mysqli_queries0.081062.79951410.0006
Looping result0.00100.74111390.0000
Template Total0.114688.810.1146
Template load0.00090.684910.0009
Template processing0.113788.161210.1137
Override
Cache load0.00060.474610.0006
Sytem overhead
Fetch class attribute can translate value0.00110.833710.0011
XML
Image XML parsing0.00030.222610.0003
General
dbfile0.01088.3584200.0005
String conversion0.00000.003130.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs