prroger

I want to pass on my thanks to gofe as well. I’ve been puzzling over this problem for 3 days and gofe solved it in 3 minutes. As others did I tried the usual plugin related fixes until I realized it was a database issue and soon found this thread with the answer. My new client loves me. Thanks much!

Tobias:

Problem solved! Here is what was done so you can pass this on to others with the same cPanel problem resulting in [table “0” not found /] instead of the table they were expecting:

An attempt was made to use the cPanel compile script to downgrade to 5.3.3. It failed compiling mysqli extensions. Next was trying to go back to php 5.3.2. Missing from the cPanel build options.

Then recompiled and re-installed pcre on the theory that its’ libraries are dynamically loaded, which seems reasonable.

So, the solution was:

PHP version 5.3.4

Download and compile pcre-8.12.tar.bz2 https://www.pcre.org/

./configure –enable-utf8 –enable-unicode-properties –prefix=/opt/pcre

On a cPanel server the installation directory is /opt/pcre

Anyone having shortcode problems should ask their host to give this a try.

Paul

Tobias:

Apparently cPanel was updated a day or so ago and cPanel has introduced a bug by using an a version of pcre (perl compatible regular expressions) which is apparently not compatible with php 5.3.4. They claim to be working on it.

When I went to update a table today, I noticed WP and WPTableReloaded both had upgrade available so I did. Then I made my table update and checking found the error and assumed there was an incompatibility. I reverted to WP 3.0.1 and TR 1.7 but still had the error. So it was only coincidence that I made the upgrades just before checking my table revisions. With the coincidence, I didn’t think to check the error logs – until you referred to the same problem from a year ago – and found thousands of errors back to shortcodes.php.

So, I find none of the plugins using shortcodes are working on any of my sites.

Thank you cPanel for another headache.

Thank you Tobias for your very prompt response. I recommend WP_Table-Reloaded all the time and can’t imagine how many people, in the same cPanel boat, are pulling out their hair trying to figure this out right now.

Thanks,

Paul

Also, clicking “Preview” under the table name brings up the table (without the custom CSS).