Search code examples
joomlajoomla3.0joomla-extensions

Joomla Content builder short codes appearing on webpage

My website has recently been attached by malware and i am trying to reinstate the website by doing a fresh install. I have set up a localhost to ensure the installation is working well before migrating to my host server. I have done all the necessary installations i can think of and currently running PHP v 5.6, mysql, and Joomla 3.5, sppagebuilder free v 1.3., shaper_qubic - Default as my template. My set up displays my webpages alright but also with the sp bulder codes in the front end pages. This is not so cool and i have reinstalled and updated every plug in but the problem just doesnt go away. Here is a screen shot of what I am facing. enter image description here

I have no idea what else to do and have exhausted all search materials for a solution.

My problem above led me to the SP Page builder section of joomla found another ugly look. enter image description here

Seems a query to SP_page builder hits a snag but i cant think far as to what could be the root cause and how to fix it. I thought my database could be the culprit so i checked the database section for joomla and it seems pretty okay as per the screen shot below.

enter image description here

I kindly look up to you awesome, helpful, big heart, gurus here to help me figure this out.

Thanks very much for all your inputs.

My sincere thanks to Amit and everyone extending a hand. I have followed your answer and here is some updates. Good thing, the error message on SP_pagebuilder page is gone. yay!... Not so good thing, i get a COM_SPPAGEBUILDER_ERROR_PAGE_NOT_FOUND when i open the website. :( I guess its important i mention that shaper_qubic - Default as my template. How can i fix this please? enter image description here

enter image description here

enter image description here

I did a littile snooping around and digging and found out that some addons that were installed on my webhost do not exist on my localhost. these addons were used to create content on the webhost and as a result, their absence is causing the same contents on the localhost not to show up well. How can I get the addons from my webhost to match that on my localhost without having to purchase nor reinstall them? Here are some of the addons that I nicked: Contact Form, Animated NUmber, Audio, Block Number, Blockquote, Button Group, Call to Action, Clients, Drop Cap, Google Map, Image Content, Modal Popup, Person, Pie Progress, Pricing table, Progress bar, Raw HTML, Soundcloud.

Attached below is a screnshot of comparing addons on the localhost and webhost respectively. enter image description here

Solution

  • After going throught the extension I have found out some mistakes donein the extension. First when you uninstall a component it should uninstall completely but the uninstall file is empty. So even if you uninstall the old database will be there. So it wont update when you reinstall. If you look at the 1.0.7-2015-10-12.sql file in the admin/sql/updates you will find a line 

    ALTER TABLE `#__sppagebuilder` ADD `catid` int(10) NOT NULL AFTER `published`;

    which means it was added later in version 1.0.7. You probably had an earlier version not having catid.

    SOLUTION:

    1. First DELETE the SP Pagebuilder tables You have to delete the 2 tables manually from phpmyadmin. The tables are #__sppagebuilder and #__spmedia (replace #_ with your table prefix. You can see other tables prefix in that database).

    2. After deleting the two tables you have to install the tables again using this code. Run through SQL.

        CREATE TABLE IF NOT EXISTS `#__sppagebuilder` (
      `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
      `title` varchar(255) NOT NULL,
      `alias` varchar(255) NOT NULL DEFAULT '',
      `text` mediumtext NOT NULL,
      `published` tinyint(3) NOT NULL DEFAULT '1',
      `catid` int(10) NOT NULL DEFAULT '0',
      `access` int(10) NOT NULL DEFAULT '0',
      `ordering` int(11) NOT NULL DEFAULT '0',
      `created_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
      `created_user_id` bigint(20) NOT NULL DEFAULT '0',
      `modified_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
      `modified_user_id` bigint(20) NOT NULL DEFAULT '0',
      `og_title` varchar(255) NOT NULL,
      `og_image` varchar(255) NOT NULL,
      `og_description` varchar(255) NOT NULL,
      `page_layout` varchar(55) DEFAULT NULL,
      `language` char(7) NOT NULL,
      `hits` bigint(20) NOT NULL DEFAULT '0',
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    
    CREATE TABLE IF NOT EXISTS `#__spmedia` (
      `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
      `title` varchar(255) NOT NULL,
      `path` varchar(255) NOT NULL,
      `thumb` varchar(255) NOT NULL,
      `alt` varchar(255) NOT NULL,
      `caption` varchar(2048) NOT NULL,
      `description` mediumtext NOT NULL,
      `type` varchar(100) NOT NULL DEFAULT 'image',
      `extension` varchar(100) NOT NULL,
      `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
      `created_by` bigint(20) NOT NULL DEFAULT '0',
      `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
      `modified_by` bigint(20) NOT NULL DEFAULT '0',
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

    Replace #_ with your table prefix. enter image description here