Forum

Thread tagged as: Error, Blog

Error message after successfully deleting a repeatable region in Blog.

Invalid query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'xxx.perch2_resource_log' doesn't exist

(where xxx is my db name).

It does actually remove it, but as I had error checking on I saw this in red below in list of actions. Can email you full debug read out.

Stuart Farrell

Stuart Farrell 0 points

  • 6 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

Can you try manually running an update?

/perch/core/update/?force=update

OK, did that, threw a bunch of warnings about duplications etc. but that seems to have fixed that error being thrown when deleting a repeatable region.

Thanks, Stuart.

Drew McLellan

Drew McLellan 2638 points
Perch Support

Can you clarify what you mean by "repeatable region" in this context?

This was a repeatable region inside the blog post template for an image gallery with titles/links etc.

<perch:repeater id="gallery" label="Gallery">
                    <li class="slide">
                        <perch:if exists="image-slider">
                        <div class="slide-image">
                            <img src="<perch:blog id="image-slider" type="image" width="1920" height="1063" crop="true" label="Large Gallery Image" help="Image used in popover gallery. (1920 x 1063)"/>" alt="<perch:blog id="client" type="text" label="Client" order="3" size="l" required="true"/>" width="1920" height="1063" class="background-image" />
                        </div><!-- /.slide-image -->
                        </perch:if>
                        <perch:if exists="video-slider">
                        <div class="slide-video video-container">
                            <video id="video">
                                <source src="<perch:blog id="video-slider" type="text" label="Video URL" size="l" help="Alternate content if Photo is not used, add video URL."/>">
                            </video>

                            <a href="#" class="video-play"></a>
                        </div><!-- /.slide-video -->
                        </perch:if>

                        <div class="slide-content">
                            <i class="ico-logo"></i>

                            <p><perch:blog id="title" type="text" label="Title" required="true" size="xl autowidth" order="1" title="true"/></p>

                            <h1><perch:blog id="client" type="text" label="Client" order="3" size="l" required="true"/></h1>
                        </div><!-- /.slide-content -->
                    </li><!-- /.slide -->
                    </perch:repeater>
Drew McLellan

Drew McLellan 2638 points
Perch Support

Ah, a repeater - got it, thanks.