Forums / Installing on a Mac Server / 1139 Got error 'empty (sub)expression' from regexp -- Error in product listing

1139 Got error 'empty (sub)expression' from regexp -- Error in product listing

Locked

Results 1 to 2 of 2

This thread is locked. New replies are disabled.

25 May 2009, 2:54 PM

xalexas

New Zenner

Join Date:: May 2009
Posts:: 1
Plugin Contributions:: 0

1139 Got error 'empty (sub)expression' from regexp -- Error in product listing

Hi I have succefully installed ZC on MAMP but on bottom of the product listing there is always error:

1139 Got error 'empty (sub)expression' from regexp
in:
[select configuration_key, configuration_value from configuration where configuration_key RLIKE 'SHOW_PRODUCT_INFO_MISSING' and configuration_value > 0 order by configuration_value]

What is it?

22 Jun 2009, 10:34 PM

data_digger

Zen Follower

Join Date:: Jan 2009
Posts:: 222
Plugin Contributions:: 2

Re: 1139 Got error 'empty (sub)expression' from regexp -- Error in product listing

Can You write what version of MySQL You're using? Can You also paste here result of following query?

SHOW CREATE TABLE configuration

data_digger,
**Query Cache v1.7-beta for ZC 1.3.9h** Reduce query count by 80% | **Randomized Tests**
www.data-diggers.com