WordPress database error: ['dentcorp_db.wp_wsm_monthWiseVisitors' is not VIEW]
CREATE OR REPLACE VIEW wp_wsm_monthWiseVisitors AS SELECT DATE_FORMAT(CONVERT_TZ(visitLastActionTime,'+00:00','+00:00'),'%Y-%m') as recordMonth, COUNT(*) as visitors FROM wp_wsm_logUniqueVisit GROUP BY DATE_FORMAT(CONVERT_TZ(visitLastActionTime,'+00:00','+00:00'),'%Y-%m')

WordPress database error: ['dentcorp_db.wp_wsm_monthWisePageViews' is not VIEW]
CREATE OR REPLACE VIEW wp_wsm_monthWisePageViews AS SELECT DATE_FORMAT(CONVERT_TZ(visitLastActionTime,'+00:00','+00:00'),'%Y-%m') as recordMonth, SUM(totalViews) as pageViews FROM wp_wsm_pageViews GROUP BY DATE_FORMAT(CONVERT_TZ(visitLastActionTime,'+00:00','+00:00'),'%Y-%m')

WordPress database error: ['dentcorp_db.wp_wsm_monthWiseFirstVisitors' is not VIEW]
CREATE OR REPLACE VIEW wp_wsm_monthWiseFirstVisitors AS SELECT DATE_FORMAT(CONVERT_TZ(firstVisitTime,'+00:00','+00:00'),'%Y-%m') as recordMonth, COUNT(visitorId) as visitors FROM wp_wsm_uniqueVisitors GROUP BY DATE_FORMAT(CONVERT_TZ(firstVisitTime,'+00:00','+00:00'),'%Y-%m')

WordPress database error: [Table 'dentcorp_db.wp_wsm_bounceVisits' doesn't exist]
CREATE OR REPLACE VIEW wp_wsm_monthWiseBounce AS SELECT DATE_FORMAT(CONVERT_TZ(visitLastActionTime,'+00:00','+00:00'),'%Y-%m') as recordMonth, COUNT(*) as bounce FROM wp_wsm_bounceVisits GROUP BY DATE_FORMAT(CONVERT_TZ(visitLastActionTime,'+00:00','+00:00'),'%Y-%m-')

WordPress database error: ['dentcorp_db.wp_wsm_monthWiseBounceRate' is not VIEW]
CREATE OR REPLACE VIEW wp_wsm_monthWiseBounceRate AS SELECT mwb.recordMonth, mwb.bounce, mwp.pageViews, mwv.visitors, ((mwb.bounce/mwp.pageViews)*100) AS bRatePageViews, ((mwb.bounce/mwv.visitors)*100) AS bRateVisitors FROM wp_wsm_monthWiseBounce mwb LEFT JOIN wp_wsm_monthWisePageViews mwp ON mwb.recordMonth=mwp.recordMonth LEFT JOIN wp_wsm_monthWiseVisitors mwv ON mwb.recordMonth=mwv.recordMonth

Contact – Dentcorp

CONTACT US

Our team at Dent Corp values each and every customer. We look forward to your feedback concerning suggestions,
enquiries or comments about our products and services. Please contact us using this form or by emailing us at info@dentcorp.com

Thank you,

David Albelda, 

Dent Corp Research & Development 656 Mamaroneck Ave. White Plains, NY 10605

info@dentcorp.com dentcorp@cloud9.net

Cell 914-837-7304, 914-682-6600

Fax 914-948-1711

Scroll to top