Put this in the configuration of the slave:


replicate_wild_ignore_table=mysql.%


• Pagination Gallery: Examples And Good Practices published in Smashing Magazine.


delete from product_categories where category IN (select distinct category from product_categories PC LEFT JOIN categories C on PC.category = C.code WHERE code is NULL);


MySQL example:

delete PC from product_categories PC left join products P on PC.sku = P.sku where P.sku is NULL;
delete C from categories C left join product_categories PC on C.code = PC.category where C.parent > 0 and PC.category is NULL;


MySQL example for multiple table update:

Today, Stefan Hornburg aka Racke held an presentation about Interchange at the KaMUX booth on the CeBIT in Hannover.

The slides are available here.


insert into form_elements(code,name,label,component,widget) select nextval('form_elements_code_seq'),name,label,'register',widget from form_elements where component = 'shippingaddress';


RT plugins (extensions) are listed on:

http://wiki.bestpractical.com/view/Extensions

The Interchange Development Group is pleased to announce the release of Interchange 5.4.3 and 5.6.1, maintenance releases to the current and previous stable versions of Interchange.

There were several changes, including bugfixes to prevent cross-site scripting prevention and to fix regressions in the previous releases.

Keep your mail server from blacklists.

Spamhaus is used by a lot of email providers, e.g. GMX and Yahoo, to refuse incoming emails from
IPs listed there.

You can check the Spamhaus blacklists (SBL,PBL, XBL) at http://www.spamhaus.org/query/bl?ip=IP.

Instructions for avoiding the CBL are here.
The answer to the HELO should be fully qualified domain name (e.g. "mail.linuxia.de"), with correct reverse DNS lookup.

Request tracker (RT) on rt.icdevgroup.org has been updated on last Saturday to 3.8.1. The 3.8 series introduces lots of new features and fixes hundreds of bugs.

• dashboards
• ticket bookmarks
• richtext email
• email signatures and encryption
• relationship charts

Last month, the YAPC::Europe conference for 2008 took place in Copenhagen
(http://www.yapceurope2008.org/ye2008/). ICDEVGROUP member Stefan Hornburg
was one of the speakers. His talk was "Interchange - The Open Source Online
Shop Platform" (http://www.yapceurope2008.org/ye2008/talk/1339).

The next upcoming event is the Twincity Perl Workshop on 7th and 8th
November 2008, held in Vienna and Bratislava
(http://conferences.yapceurope.org/tcpw2008). ICDEVGROUP members Jure
Kodzoman and Stefan Hornburg will visit this event in both cities.