uninstalling shop

[Vi31]

OK, i don;t know what i did wrong but now when i click on a topic i get this error:

Database Error
Unknown column 'shop_nameStyle' in 'field list'
File: /home/msvi007/public_html/timeout/Sources/Load.php
Line: 1007 

I would like to UNINSTALL this completely and start over, seems I have been having nothing but problems  with this mod since i upgraded to RC3.  Is there a step by step for dummies type guide on how to remove this completely.  It must be very specific because when i tried to just remove stuff that was shop related i made my board inoperable.

PLEASE HELP!

[matkins70]

Don't you just uninstall the package from your admin area?

[Vi31]

I tried but it says there is no uninstaller and to contact mods author.

[Daniel15]

That error is because you had the 'Display Name CSS' item installed. To completely uninstall that item:
Open Load.php, and find:

Code: [Select]

    //SMFShop Name Style item
    global $db_prefix;

    $result = db_query("SELECT shop_nameStyle
                        FROM {$db_prefix}members
                        WHERE ID_MEMBER = {$user}", __FILE__, __LINE__);
   
    $row = mysql_fetch_array($result, MYSQL_ASSOC);
    if (!isset($row['shop_nameStyle']) || $row['shop_nameStyle'] == "") {
        $nameStyle = "";
    } else {
        $nameStyle = "style='".$row['shop_nameStyle']."' ";
    }
    //End SMFShop Name Style Item
Delete it.

Also, in the same file, find:

Code: [Select]

//'link' => '<a href="' . $scripturl . '?action=profile;u=' . $profile['ID_MEMBER'] . '" title="' . $txt[92] . ' ' . $profile['realName'] . '">' . $profile['realName'] . '</a>',
'link' => '<a ' . $nameStyle . 'href="' . $scripturl . '?action=profile;u=' . $profile['ID_MEMBER'] . '" title="' . $txt[92] . ' ' . $profile['realName'] . '">' . $profile['realName'] . '</a>',
Replace with:

Code: [Select]

<search position="replace"><![CDATA[
'link' => '<a href="' . $scripturl . '?action=profile;u=' . $profile['ID_MEMBER'] . '" title="' . $txt[92] . ' ' . $profile['realName'] . '">' . $profile['realName'] . '</a>',


[Vi31]

is the display name css item a bad item?

[Daniel15]

No, it's not a bad item, it's just that when you uninstall SMFShop, it doesn't uninstall that item. Either uninstall the item through the SMF admin panel, or uninstall it manually.