Where are the HTML snippets stored in Pockets

ErickL

Apparently, I made a mistake in pasting an HTML snipped in the Plugin. Note sure if I missed either "<" or ">" in the code, but now, I cannot see the settings in my dashboard and vanilla itself is pretty messed up too.

Since I cannot see anything in the dashboard, I cannot disable it. The only way to fix this is to delete the Pockets folder under Plugins. When I re-add pockets to the plugins folder the issue still exists.

I am trying to delete the HTML code somewhere in the vanilla files but I do not know where to find it?

Kasper

The HTML is stored in your database so you'll need to use a tool like Sequel Pro or PhpMyAdmin to remove the entries directly in the DB.

ErickL

Whoah. I never thought about that. Thanks Kasper

hgtonight

Welcome to the community!

Plugins are determined to be enabled/disabled based on the /conf/config.php file. Look for the configuration line $Configuration['EnabledPlugins']['PluginNameHere'] = TRUE; and either remove it or change TRUE to FALSE to manually disable the plugin.

ErickL

@hgtonight said:
Welcome to the community!

Plugins are determined to be enabled/disabled based on the /conf/config.php file. Look for the configuration line $Configuration['EnabledPlugins']['PluginNameHere'] = TRUE; and either remove it or change TRUE to FALSE to manually disable the plugin.

Thanks, doing it now... What is the right action when speaking about HTML in phpMyAdmin? do I just delete the database entry?

hgtonight

Disabling plugins manually will not execute any cleanup code the plugin may have.

I think it is safe to remove the offending rows in the pocket table from the db.

If you don't mind sharing, I would like to see a dump of the row that is causing the error.

ErickL

Here.
Apparently, I forgot to add the closing ">" in the img tag. Maybe adding it directly in phpmyadmin will fix the issue?

-- phpMyAdmin SQL Dump
-- version 3.5.2.2

-- http://www.phpmyadmin.net

-- Host: localhost
-- Generation Time: Jan 06, 2014 at 09:19 PM
-- Server version: 5.1.69
-- PHP Version: 5.2.17

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

/!40101 SET @CHARACTER_SET_CLIENT */;
/!40101 SET @CHARACTER_SET_RESULTS /;
/!40101 SET @COLLATION_CONNECTION /;
/!40101 SET NAMES utf8 */;

--

-- Database: u615138275090688ga_t81032948ga

---

--

-- Table structure for table GDN_Pocket

CREATE TABLE IF NOT EXISTS GDN_Pocket (
PocketID int(11) NOT NULL AUTO_INCREMENT,
Name varchar(255) COLLATE utf8_unicode_ci NOT NULL,
Page varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
Location varchar(50) COLLATE utf8_unicode_ci NOT NULL,
Sort smallint(6) NOT NULL,
Repeat varchar(25) COLLATE utf8_unicode_ci NOT NULL,
Body text COLLATE utf8_unicode_ci NOT NULL,
Format varchar(20) COLLATE utf8_unicode_ci NOT NULL,
Condition varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
Disabled smallint(6) NOT NULL DEFAULT '0',
Attributes text COLLATE utf8_unicode_ci,
PRIMARY KEY (PocketID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;

--

-- Dumping data for table GDN_Pocket

INSERT INTO GDN_Pocket (PocketID, Name, Page, Location, Sort, Repeat, Body, Format, Condition, Disabled, Attributes) VALUES
(4, 'http://www.cdjapan.co.jp/apparel/arconomi.html', '', 'Panel', 0, 'after', '

\n\n<img src="http://www.cdjapan.co.jp/aff/banners/15_Apparel/arCONOMi_200x100.gif\n\n\n

', 'Raw', '', 2, NULL);

/!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS /;
/!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

vrijvlinder

You can disable the plugin from the config.php by adding

$Configuration['EnabledPlugins']['Pockets'] = FALSE;

After disabling, delete the folder of the plugin and reinstall. But do not delete from the dashboard. Then drop the table for pocket from DB

ErickL

ok.. doing right now... I'll post later thanks guys.

ErickL

uwa... done done thanks to all cheers... I'm getting used to it now.