Forums / Setup & design / Change nospam@ez.no
cubby cub
Sunday 23 August 2009 11:29:10 pm
Hello,
How do I change all instances of nospam@ez.no?
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/
Sunday 23 August 2009 11:59:08 pm
hi,
thanks. unfortunately, i'm not that skilled..
i did a search for nospam@ez.no 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?
Heath
Monday 24 August 2009 12:35:24 am
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
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
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.
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?