This SQL statement works even better
SELECT * FROM customers
WHERE customers_lastname LIKE CONCAT(customers_firstname, '__');

TY @heatherbell

I would need to find the SQL statement that deletes the data that @raiwa mentions

TY @heatherbell

TY @raiwa
Address book table entries and customer data should be also deleted

What would be the SQL statement to delete these fields using the SQL statement that heatherbell provided and works correctly?

BR

Valqui

Hello everyone. I have several fake customers in the database. Is there an easy addon to delete customers? Another question, can you find an SQL statement to delete them? My fake clients are all of the type: First Name: XXXXXXX Last Name: XXXXXXXYY The length of XXXXXXX can vary. Example: First Name...

Hi philpla,

The eubanktransfer Payment Module it was part of an old version of OSC Frozen that I'm still using (I know ... I have to update it as soon as possible to phoenix but different personal problems I didn't have time).

Best regards
Valqui

Hi ecartz,

Thank you very much for the fix.

Yes, I changed the hosting plan and therefore I change the PHP version. I can downgrade the PHP version back to 7.0, but I'd rather try to fix these messages in the meantime.

Keep in touch and best regards

Valqui

Hello everyone! My error_log file started to fill with the following warning: Warning: Use of undefined constant MODULE_PAYMENT_EU_BANKTRANSFER_ID - assumed 'MODULE_PAYMENT_EU_BANKTRANSFER_ID' (this will throw an Error in a future version of PHP) in /home/mysite/public_html/catalog/includes/modules/...