Friday 5 September 2014

Drupal 7 Image resizing module causes image to not display on Internet Explorer IE8

Here are some other searches I made tryign to find the solution to this one.

drupal 7 syze.min.js issue with IE8

drupal 7 ignore js file from head for IE8

drupal 7 change head output

drupal 7 change get rid of js with hook_preprocess_html

Drupal 7 how to remove js file with hook_js_alter


script if not less that ie9


The file here was syze.min.js that was causing the issue to fix I've used hook_js_alter to remove the old link and have readded the link in hook_preprocess_html using the drupal_add_html_head function . 

  1. open /sites/all/themes/custom/YOURTHEME/template.php
  2. Added the function

    /*
    * implement hook_js_alter
    * then intention here is to delete the syze.min.js
    * and then I'll readd with the lt IE9 command
    * using drupal_add_js in hook_preprocess_html
    */
    function rcnjobs_js_alter(&$javascript) {
    // Swap out jQuery to use an updated version of the library.
    //krumo($javascript);
    if (isset($javascript['profiles/commons/themes/commons/commons_origins/scripts/syze.min.js'])) {
    unset($javascript['profiles/commons/themes/commons/commons_origins/scripts/syze.min.js']);
    }

    }
3. in function YOURTHEME_preprocess_html ADD
global $base_url;

$syzeJSPath = $base_url.'profiles/commons/themes/commons/commons_origins/scripts/syze.min.js';
$jsnotsafeforIE = array(
'#type' => 'markup',
'#markup' => '',
);
drupal_add_html_head($jsnotsafeforIE, 'syzeJS');

Wednesday 3 September 2014

Drupal 7 menu token errorNotice: Undefined index: localized_options in menu_navigation_links() (line 1861 of */includes/menu.inc

The fix here was to go to > Structure > Menu > Settings >   


and change both Source for main links & Secondary source to No links .   this gets rid of issue. 

Thursday 26 June 2014

drupal 7 where to make new image style

drupal 7 where to make new image style

Here’s how I got to it

Modules  >  search ‘image’


> add style

Monday 23 June 2014

Acquia Cloud database import error Base table or view not found

SQLSTATE[*]: Base table or view not found: * Table                [error]
‘*.blocked_ips' doesn't exist
Drush call failed. Stderr:SQLSTATE[*]: Base table or view not found: * Table                [error]

‘*dev.blocked_ips' doesn't exist


All I needed to do here was to go in to Acquia download a copy of the latest database and manually import using myPhpAdmin

Wednesday 18 June 2014

Follow on from Drupal 7 basic Module

this is the next step on from this blog [link: http://littleripplesproject.blogspot.co.uk/2014/06/drupal-7-cant-see-my-module.html] Drupal 7 Can’t see my Module.

Lets print hello world on a page.  Add this to helloworld.module

// calling hook_menu()



function helloworld_menu() {

    

     $menu[‘hello/world'] = array(

          'title' => ‘Hello World Simple Page',

          'page callback' => ‘helloworld_worldview’,  // this is the function underneath

    'access callback' => TRUE,

     );



          return $menu;

}





functionhelloworld_worldview() {





  return ‘Hello World !';

 

}

Monday 16 June 2014

Timestamp to 0000-00-00 00:00:00 format

here's a quick note on this code; as what worked for me is slightly different to what I've found online

$timestamp = '1410126126';

$datestring = gmdate("Y-m-d H:i:s", $timestamp);

echo $datestring;

Thursday 12 June 2014

Add a Log In / Log out button to Drupal 7 TB Mega Menu

I thought I may have to make two menus; one for registered users and one for unregistered. Or maybe even write a function that would hide the button. But no all you need to do is set the buttons up; using the URLs for your login and log out. user/login user/logout and the rest happens like magic

Monday 9 June 2014

drupal 7 entity id comma returned in link value

Seemingly this was an issue with Replacement patterns . But what you need to do is go into your id in Structure > views > [your view] > fields and make sure 'comma' isn't selected as the 'Thousands marker' - it should be -none-

Sunday 8 June 2014

Drupal 7 - can't see my module

If you can't see your Module in Drupal 7 here's the very basics that's needed.  Check these things are in place and you should be able to see your module.

Create a new folder in your installation

Sites/All/Modules/Custom/helloworld

Create 2 files

helloworld.info
helloworld.module


in helloworld.info

name = "Hello World"
description = "Hello Modules list !."
core = 7.x


files[] = helloworld.module


helloworld.module  can be blank.  And thats it.  Make sure you clear your cache in admin.  

the next step can be seen at http://littleripplesproject.blogspot.co.uk/2014/06/follow-on-from-drupal-7-basic-module.html

Drupal 7 : Recieving PDOExceptions and missing fields and table on Module installation

When uploading some modules I was having issues with PDOExecptions and more specifically that Database table weren't fully loading.   A quick simple fix ( without finding out the real issue :/ ) is to use the module update manager.  Which is on the module page on the upper left.

By the way if anyone else couldn't find that button thats becuase you need to activate the 'Update Manager' module first to be able to see it.


Wednesday 28 May 2014

drupal 7 modules install error File upload error. Could not move uploaded file.

For me its

in drupal admin

Configuration >  Media ( box ) > File System

and then I changed the temporary path to   '/tmp'

Thursday 22 May 2014

acquia cloud not a git repository ( or any of the parent directories ): git failed

acquia cloud not a git repository ( or any of the parent directories ): .git git failed



I was getting this issue when trying to delete my site from the Acquia Dev Desktop 2 console.  The problem was that rather that trying to delete the folder I needed to delete using the console.  By using the '-' sign in the bottom left hand corner.  Once you do this then you have the option to Pull from Cloud again. 

SOLVED 

Wednesday 21 May 2014

How to make changes in Drupals TB Mega Menu Module

Rather than hacking over CSS here's how to make changes in Drupals TB Mega Menu Module.

the files can be found at sites/all/modules/contrib/tb_megamenu/css/styles/black.css

make a new file here like grey.ss

then in   /sites/all/modules/contrib/tb_megamenu/tb_megamenu.functions.inc 


Add 

'grey' => t('Grey'), 

under 

'green' => t('Green'), 


And 

    drupal_get_path('module', 'tb_megamenu') . '/css/styles/grey.css',

under



drupal_get_path('module', 'tb_megamenu') . '/css/styles/green.css', 


in admin visit  structure -> tb mega menu  ->  ( your menu ) -> configure. 

you can now choose Grey  

Tuesday 20 May 2014

Drupal Simple HTML Dom not installing

simple_html_dom.php is missing. Please copy the latest version of simple_html_dom.php (PHP Simple HTML DOM Parser library) from http://sourceforge.net/projects/simplehtmldom/ to you libraries folder, for example sites/all/libraries/simplehtmldom/simple_html_dom.php (Currently using "PHP Simple HTML DOM Parser" library not installed)


Go to


and download the file simple_html_dom.php

and paste in sites/all/libraries/simplehtmldom/

Friday 9 May 2014

Drupal Migrate Module error on activating Migrate UI


PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table '*.migrate_group' doesn't exist: SELECT mg.name AS name, mg.title AS title, mg.arguments AS arguments FROM {migrate_group} mg; Array ( ) in migrate_ui_migrate_dashboard() (line 29of *sites/all/modules/contrib/migrate/migrate_ui/migrate_ui.pages.inc).



the fix here was to add the following table to mysql 


CREATE TABLE IF NOT EXISTS `migrate_group` (
  `name` varchar(255) NOT NULL COMMENT 'Unique machine name for a migration group',
  `title` varchar(255) NOT NULL COMMENT 'Display name for a migration group',
  `arguments` blob NOT NULL COMMENT 'A serialized array of arguments to the migration group',
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



Wednesday 7 May 2014

How to change the password for user in Drupal 7 using mysql and phpmyadmin

Here’s the hashed MD5 password for ‘password’

$S$CDbdwZvjHQ09IVRs88G0fnaxPr50/kb81YI9.8M/D9okW7J/s5U4

this will get you in but then you may need to Change the user permissions on Drupal 7 in Mysql using phpmyadmin

drupal 7 user roles users_roles rid for super administrator

drupal 7 rid roles

User role should be ‘4'

Tuesday 25 March 2014

Horizontal Menu in Wordpress using CSS

Here's my CSS to solve showing a Wordpress Submenu Horizontally .  You'll need to use whichever tags you have in your menu.

 
ul.sub-menu {
left: 0;
margin-left: -340px;
min-width: 800px;
position: absolute;
z-index: 9999;
margin-top: -3px !important;
}

ul.sub-menu li {
display: block;
float: left;
position: relative;
width: auto !important;
}

.sf-menu li li{
background: none repeat scroll 0 0 #ffffff !important;
border-bottom: 1px solid #333333 !important;
border-top: 1px solid #333333 !important;

}

Having issue with making your YouTube Videos responsive.

I found some answers on google to the issue 'make Youtube embed responsive' but none of the replies fitted my website.  The issue here was that in some way the height was being forced shorted; meaning the display ratio was wrong.  To fix I've used a couple of div heights, that are Mobile dependent.  

In the youtube iframe I have both the height and width set to 100%.   And then applied an 'auto' width in the CSS.  its a css trick that seems to work.   ( all except ie 8 )


Next you need to wrap the embed code in a DIV .  like


div class="videoContainer"


and here is the CSS 

.video-container {
position: relative;
padding-bottom: 56.25%;
padding-top: 30px; height: 0, overflow: hidden;
}   

.video-container ifram, .video-container object,  . video-

container embed {
position: absolute;
top: 0;
left: 0;
width: 100%;
height: 100%;
}




Friday 21 March 2014

ERROR: Could not find a valid gem 'sass' <>=0>, here is why: Unable to download data from https://rubygems.org/ - SSL_connect returned=1 errno=0 state=SSLv3 read server certificate B: certificate verify failed

I received this error message while trying to install Sass on Windows 7 laptop. 

ERROR: Could not find a valid gem 'sass' <>=0>, here is why: Unable to download data from https://rubygems.org/ - SSL_connect returned=1 errno=0 state=SSLv3 read server certificate B: certificate verify failed

The issue is actually with  the Ruby Installer .  I found this out by searching 'ruby 2.0 gem install sass by http'  .  Check  http://stackoverflow.com/questions/21681817/cant-install-gems-on-windows-7-64

The solution then was to install Ruby Installer and roll back to an earlier version ( 1.9)

how to uninstall ruby installer ?  - I used 'Programs - Uninstall a program' found in Windows 'Control Panel' .

And then installed version Ruby 1.9.3.p545 instead from http://rubyinstaller.org/downloads/

Now after RESTARTING drush .  I can now run the command line gem install sass without issue.

Wednesday 19 March 2014

Wordpress Contact Form 7 Plugin not attaching email address

Here was the issue.  

On testing the form was sending fine.  However once switched to the customer the address of sender was not being attached.

The issue.  In   admin > contact > Contact Form  there is a tick box labelled 'Use HTML content type'  .  This may need to be un ticked. Once done then all recipients could receive the emails.

Thursday 6 March 2014

Wordpress - how to not display something in the header if template is X

What I had is a template that is displaying an featured image in the header .  However if the page is from a certain category I want to exclude this image from being show.


What you need is the is_page_template feature
 

if( !is_page_template('prod-category.php')) {

// show image

}

Thursday 27 February 2014

Adding a Mobile Redirect to Wordpress

At present most of my changes to change the website display on mobile devices is through @media .

Which lead me to my first questions

can I use @media to force to new URL

how to put a url redirect in css


There is a well recommended plugin Equivalent Mobile Redirect

However I could get this to work on Wordpress 3.8.1

So I found this plugin which works fine Mobi Redirect


Thursday 20 February 2014

Excluding a certain category when using Wordpress's have_posts function

Using Wordpress's 'have_posts' function is pretty darn cool.  It fetches a list of your most recent post; the number of which is set in
Admin -> Settings -> Reading -> 'Blog pages show at most'

This array can then be iterated through thus


  while (have_posts()) {   // WP function that gets post
                    the_post( ); 


what I wanted to do is eliminate a certain category from being returned in the have_posts

and thought I could get away with something like

foreach(get_the_category() as $category) {
$cat_ID = $category->cat_ID;
}
if($cat_ID == '81' || $cat_ID == '82') {} else {


in the while statement to solve this.  However this would change the number of posts I was displaying.  Something I didn't want.    The solution was to use query_posts  which adds to the have posts function.  It's not ideal in all situations but fine for what I was doing.

query_posts( 'cat=83&cat=84' );
            if (have_posts()) {


Wordpress Development Cornwall

Changing the Product page image size onWordpress WP E-commerce

If you want to make the image bigger on product pages then here's the page you need to change. 

Please note that first of all you'll need to go into

Administrator > Store > Presentation ( last tab )

On the right handside you have a box named 'Advanced Theme Settings'   - Clicking on 'Move Template Files'  will move the files you need into your theme.

OPEN /wp-content/themes/yourtheme/wpsc-single_product.php

FIND

if ( wpsc_the_product_thumbnail()


Underneath you can effect the image here. 

For my hack all I needed to do was display the full sized image.

so replaced

 
         <?php echo wpsc_the_product_title(); ?>
        


for

<?php echo wpsc_the_product_title(); ?>
        

Tuesday 18 February 2014

Wordpress Development Price List

Here's a general guide to my prices to build a Wordpress website.  It's worthy of note that using Wordpress we can provide a very cost effective website; however the thing that can push the price up rapidly is customisations to both themes and plugins.

Worpress Installation : includes the neccesary Security, SEO and website speed plugins.  Wordpress Installation Checklist

> Configure Permalinks
> Security Checks on installation
> SEO - Yoast plugin
> Social Media bar
> Contact Form
> Google Maps Plugin
> Help Pages Plugin
> Super Cache
> Gzip compression

8hrs @ £35 = £280


Installing a Theme : Once a theme has been chosen it will be purchased and installed. 

The following list includes the changes that are normally requested as a minimum when a client installs a theme.  However we do not wish to inhibit you're creativity, and you are welcome to request further quotes on changes you'd like to make.  The price here includes the purchase of the theme.  The theme will be tested on the main devices as listed on the Web Design contract.

> Change of logo
> CSS changes including Color and Fonts.
> Change of Artwork
> Theme set up and Widget, Menu allocation.

6hrs @ £35 +theme estimated.  £270


Adding Content.
__________________

Often content is taken off an existing website, if the existing website is another CMS the chances are we can use a transfer plugin. 
The following guide is based on a fairly small sized website that wants the basic pages; with content and images provided. 

News
Prices
About Us
Contact Us
How to find Us

7hrs @ £35  = £245


Hosting
_________

Your hosts will need to meet these minimum requirements

http://www.rafaytutorials.com/2013/11/minimum-requirements-to-install.html 

If you host we us then the annual charges are here http://www.heartinternet.co.uk/web-hosting

The package I normally recommend is £90 annually.


Site transfer
______________

if the website needs to be made in a testing folder or test web address then the website will need to transferred when ready.  This is 2 hours work

2hrs @ £35 = £70


Website design Contract

When things don't go right on a web development project then you'll need one of these to fall back on.   Any way here at Littleripples.com  here's mine.


Contract for web design  - What both parties agree to do.

You: You have the authority to enter into this contract on behalf of yourself, your company or your organisation. You’ll give us with everything we need to complete the project as and when and in the format we need it. You’ll review our work, provide feedback and approval in a timely manner too. Deadlines work two ways, so you’ll also be bound by dates we set together. You also agree to stick to the payment schedule set out at the end of this contract.

Us: We have the experience and ability to do everything we’ve agreed with you and we’ll do it all in a professional and timely manner. We’ll endeavour to meet every deadline that’s set and on top of that we’ll maintain the confidentiality of everything you give us.
We create look-and-feel designs, and flexible layouts that adapt to the capabilities of many devices and screen sizes. We create designs iteratively and use predominantly PHP, HTML and CSS so we won’t waste time mocking up every template as a static visual. We may use static visuals to indicate a look-and-feel direction (colour, texture and typography.)
You’ll have two or more weekly opportunities to review our work and provide feedback. If, at any stage, you’re not happy with the direction our work is taking, you’ll pay us in full for everything we’ve produced until that point and cancel this contract.
We know from experience that fixed-price contracts are rarely beneficial to you, as they often limit you to your earliest ideas. I don’t want to limit your ability to change your mind. The price at the beginning of this contract is based on the length of time we estimate we’ll need to accomplish everything you’ve told us you want to achieve, but we’re happy to be flexible. If you want to change your mind or add anything new, that won’t be a problem as we’ll provide a list of standard charges for extra's or quote.  If a template has been agreed on and your request is additional to anything that appears on the template then it will be additional to the quote.

Languages and Platforms
We deliver websites developed in PHP 5 and HTML5 markup, CSS2.1 + 3 stylesheets for styling and unobtrusive Javascript for feature detection, poly-fills and behaviours. As this is the latest languages it is hoped this will work on the widest range of devices. 
Desktop Browser Testing
We test our work in current versions of major desktop browsers including those made by Apple (Safari), Google (Chrome), Microsoft (Internet Explorer), Mozilla Firefox and Opera. We’ll also test to ensure Microsoft Internet Explorer 8 for Windows users get an appropriate, possibly different, experience. We’ll implement a single column design for Internet Explorer 7 and below for Windows and we won’t test in other older browsers unless you specify otherwise. If you need an enhanced design for an older browser, we can provide a separate estimate for that.
Mobile Browser Testing
Testing popular small-screen devices is essential in ensuring that a person’s experience of a design is appropriate to the capabilities of the device they’re using. We test our work in:
  • iOS: Safari, Google Chrome and Opera Mini
  • Android 4.1: Google Chrome, Firefox and Opera Mini
  • Android 3.2: Browser, Firefox and Opera Mini
We currently don’t test Blackberry OS or Blackberry QNX, Opera Mobile, Symbian or other mobile browsers. If you need us to test using these, we can provide a separate estimate for that.
Ownership
First, you guarantee that all elements of text, images or other artwork you provide are either owned by your good selves, or that you’ve permission to use them.
Then, when your final payment has cleared, copyright will be automatically assigned to yourselves for any customizations made to the theme.

Any code developed is written for an Open Source environment.

We love to show off our work and share what we’ve learned with other people, so we reserve the right, with your permission, to display and link to your project as part of our portfolio and to write about it on websites, in magazine articles and in books.
Showcasing

We love to show off our work and share what we’ve learned with other people, so we reserve the right, with your permission, to display and link to your project as part of our portfolio and to write about it on websites, in magazine articles and in books.



Guarantee
We can’t guarantee that our work will be error-free and so we can’t be liable to you or any third-party for damages, including lost profits, lost savings or other incidental, consequential or special damages, even if you’ve advised us of them. Finally, if any provision of this contract shall be unlawful, void, or for any reason unenforceable, then that provision shall be deemed severable from this contract and shall not affect the validity and enforceability of any remaining provisions.
Just like a parking ticket, you can’t transfer this contract to anyone else without our permission. This contract stays in place and need not be renewed. If for some reason one part of this contract becomes invalid or unenforceable, the remaining parts of it remain in place.
Payment is requested:
50% on project start.
40% on completion.
10% to released after the website has been live for 28 days in case any bugs need to be ironed out.




Wednesday 12 February 2014

How to make a child theme in Joomla

One of the most usefull tools of Wordpress is using Child themes.  If you're looking for this feature in Joomla too, it is there just less publicized.
Child templates for Joomla .

Navigate to  Administrator-> Extensions->template Manager and selecting the template you wish to change.  Once you've checked the box next to the template, you can click the 'Duplicate' button to create a second copy of the template.  This will become the Override while the primary copy of the template remains the designated Master.

Cornwall Joomla development

Wednesday 5 February 2014

Finding the Joomla URL address for an article

If you're used to using Wordpress then you're probably wandering where you can view your article; as there's no easy to find preview button here.

Firstly find out what your article ID is

You can find this at the end of the URL when you are editing.  As pictured here.


Then all you need to do is add that number to the end of this URL ; changing the domain of course.

www.yourdomain.com/index.php?option=com_content&view=article&id=

If you're using SEF then you'll also need to make a Menu Item; and use the alias. Which is much better for being found by search engines.

Wordpress Menu item issue on Domain referenced website transfer.

After transferring to a testing area ( Domain Referenced site ie webXX.yourhost.com/yourdomain.co.uk )
I was getting this message

Forbidden  You don't have permission to access /index.php on this server.
The issue here is in that we are using a domain referenced site. . 

OPEN .htaccess

online 8 FIND

RewriteRule . index.php

AND REPLACE WITH

RewriteRule . yourdomain.co.uk/index.php

Friday 31 January 2014

Joomla Mijoshop Download Folders

With larger downloads you'll need to FTP them in; as doing them through Mijoshop crashes.  Here's the folder you need to upload them to.

components/com_mijoshop/opencart/download/

After this all you need to do is enter the filename in when 'inserting' your download into Mijoshop.

Tuesday 28 January 2014

Joomla 3.2 moving things from model, controller to View.

If you've used other frameworks then one thing that might be a little confusing is how things are passed though the MVC design in Joomla.

It may make things much easier to get your head around once you appreciate the page /view/view_html.php is basically a mini-controller page.  

I for example had been putting controller in the Components controller and then calling it up with something like.

 ProductMapperController::sendToFile($xmlOutput);

by putting it in the view_html.php  then I can call it up with

$this->sendToFile($xmlOutput);


There's a bit more on this at Joomla MVC differences



Joomla Component Template for Database Queries Component

It's just occurred to me that the stage I'm at with a current Joomla 3.2 component.  That will be dealing with Transfer content across table; is at this early stage a pretty good template for any future Joomla 3.2 component for dealing with database queries in any way. 

So if you've a similar project then here's what I have.  Joomla 3.2 Database Queries Template Component

fix strict standards issues in Joomla Component development

While developing a Joomla Component I was getting this issue. 

Strict Standards: Only variables should be assigned by reference in * on line * Strict Standards: Only variables should be assigned by reference in /* on line * Notice: Undefined variable: items in * on line *

In my case this was due to using old Joomla Component rules that now with Joomla 3.2 need updating.

Take a look at this basic principle of passing values through MVC in a Joomla Component.

The Model .  com_urcomp/models/preview.php
defined('_JEXEC') or die;

class Vm2mijoModelPreview extends JModelList
{
 
 /* lets go and get all the details from MySql and then we'll deal with the array in the view */ 

  public function getVirtuemartCategory(){
      $db = &JFactory::getDBO();
      $query  = "select ";
      $query .= "* ";
   // new xref table for product/categories is #__virtuemart_product_categories
      $query .= "from #__virtuemart_categories as jvc ";
     $query .= "LEFT JOIN #__virtuemart_categories_en_gb as jvcgb ON jvc.virtuemart_category_id=jvcgb.virtuemart_category_id ";
  $query .= "LEFT JOIN #__virtuemart_category_medias as jvcm ON jvc.virtuemart_category_id=jvcm.virtuemart_category_id ";
      $db->setQuery($query);
      $row = $db->loadObjectList();
      return $row;
    }
 
 public function getGreeting()
 {
 return 'Hello, World!';
 }

}  
The View.html.php views/preview/view.html.php

defined('_JEXEC') or die;

class Vm2mijoViewPreview extends JViewLegacy
{
   function display($tpl = null) 
        {
  $model = $this->getModel();
  
  
  $greeting = $model->getGreeting();
  $this->assignRef('greeting', $greeting);
  
                          // Display the view
                parent::display($tpl);
        }
}


views/preview/tmpl/default.php


 defined('_JEXEC') or die;

// No direct access to this file
defined('_JEXEC') or die('Restricted Access');
 

echo $this->greeting;  


The error I was having was being caused on the line

$model = $this->getModel();

which I had as


$model = &$this->getModel();

Wednesday 22 January 2014

Mijoshop downloads going to 'file not found http://*/index.php/*/account/download/download?order_download_id=*

Here's the Issue.  I have Joomla 3.2.0 installed with Mijoshop 2.2.1

When my customers order downloads after clicking on the download box I then get the following message



file not found http://*/index.php/*/account/download/download?order_download_id=*

After some testing it is apparent that when I set up a small download then this was fine.  The breaking point being at about 120MB before it stops working.

After some research I found this post http://forum.opencart.com/viewtopic.php?t=3310 . This is our PHP Info http://www.rubydance.com.au/rdtst/phpinfo.php  

which is for Open Cart. 

so I added these values to the php.ini

upload_max_filesize = 390M ;
post_max_size = 400M ;
memory_limit = 640M ;

max_input_time = 3600;

This didn't work but with some help from my hosts HeartInternet  they suggested adding this to .htaccess

RLimitMem max

The downloads now work on the installations.

Cornwall Joomla Development


Tuesday 21 January 2014

Joomla 2.5 export Mysql error - ERROR * at line * Duplicate entry '*' for key 'idx_link_old'

When transferring the MySql database for Joomla 2.5 I am getting this message.

ERROR * at line * Duplicate entry '*' for key 'idx_link_old' 

After a Google search I found this . Relating to doing this through Command Line Database Transfer

if you are using the command line   just ad -f or --force to your import


However if you're not using command line I found that replacing my 'INSERT' commands for 'INSERT IGNORE' commands in the .sql file does the same thing.

Joomla Development Cornwall

Monday 20 January 2014

Joomla Mijoshop - Swap customer email address for email links.

At first I was going to write my own Plugin for this but got into some problems with using event triggers of someone elses component ( Mijo shop ) .

Luckily I found the following Component; which after some thought on it's application I could manipulate into doing what I needed it to . 
The  component to install is ReReplacer

I did have a conundrum involving how I would only effect the Customer Email page that I wanted.  As just using a Regular Expression to replace the emails was causing me issue in the Admin area; where I had emails in input areas. 

The way I solved this was to amend the HTML output to add a 'span' wrapper with unique class. 

To do this OPEN components/com_mijoshop/opencart/admin/view/template/sale/customer_list.tpl

AND on line 119 add



 
Around the Customer Email call up.

THEN go to your Joomla Administration.

>  Admin > Components >  'NoNumber ReReplacer'

Then click on 'New'

Give the item a title like 'Email Swap'


ADD this in SEARCH
  (?<=\)(.*\n?)(?=\<\/span\>)


ADD this in REPLACE
\1
 
 
And make sure 'Regular Expressions', 'Case Sensitive' and 'Published' are set to YES

And  'Use 'newline' modifier' and 'Thorough' set to NO

>>then click on the 'Search Areas' tab at the top.

Enable in area = Body (not head)
Enable in feeds = No

Enable in Admin = Yes.

And that should do it.


joomla development




Friday 17 January 2014

Joomla Mijoshop Downloads not working - can't find the file at */index.php/*/account/download/download?order_download_id=*

Before I go on I should point out that I haven't got a resolution for the but reading this blog entry may help you with a similar issue.

The Issue:  We have a website that sells MP3 Download Mix Albums; these albums come in at 330M

Testing showed that small files could be downloaded, but when the download goes over 120Mb I get this message

can't find the file at */index.php/*/account/download/download?order_download_id=* 

I found this post http://forum.opencart.com/viewtopic.php?t=3310  on a similar issue regarding Opencart.  The hosts however would not allow php.ini changes.  So I put a fresh install of Joomla 3.2 and Mijoshop 2.2.4 on it.  And even with these php.ini changes I cannot make the downloads



  upload_max_filesize = 390M ;

post_max_size = 400M ;

memory_limit = 640M ;  


So for the meantime I have split the downloads into Parts; as Mijoshop does allow multi items in the download for each product.

If you know a full solution please let me know !!

Wordpress Fashionista Theme - change Featured image size

OPEN

wp-content/themes/fashionista/formats/single-standard.php

ON Line 11 change the first value after

$img_width = (of_get_option('sidebar_layout') != 'none') ?

to the width you want.

AND save in your child theme in ;)

wp-content/themes/YOUR-CHILD-THEME-NAME/formats/single-standard.php

Wednesday 15 January 2014

Joomla Ticketmaster RD Media - Where to change the Terms & Conditions

a Ticketmaster RD Media - Where to change the Terms & Conditions in Admin

Basically I don't know !  if you find out could you reply to this post and fill me in .  Due to time restrictions and budget I've hard coded the Terms and Conditions in .  Here's how in case it's helpful to you to. 

OPEN

components/com_ticketmaster/views/payment/tmpl/default_bootstrap.php



Around line 279 FIND

 

And paste in your Terms and Conditions inbetween the Paragraph tags.

Joomla Development Cornwall

Tuesday 14 January 2014

Wordpress 3.8 cannot drag and drop menu items Admin Menu Editor

After upgrading to Wordpress 3.8 I found that I could no longer drag and drop menu items.

You need to turn off your plugins to find out which one is causing the issue.  In my case it was 'Admin Menu Editor'  .

Joomla Ticketmaster - RD Media ticket design

I'm using the component > Joomla Ticketmaster by RD Media but am finding documentation on the automatic ticket design quite short. 

Anyway I've found hardcoding the changes in a god send to making the tickets how I want them .

To do this the page to edit is. 

administrator/components/com_ticketmaster/classes/override/createtickets.class.php
s


Thursday 9 January 2014

Joomla 3.2 editor not working

If you've upgraded to Joomla 3.2 and your Editor in Admin has stopped working then you may have had the same issue as me.

Where you using 'CodeMirror' as your editor, if so then read on .

I fixed this by returning to 'TinyMCE' for the moment.

OPEN configuration.php

ADD or EDIT the line

public $editor = 'tinymce';


In Joomla Administration > Extensions > Plugin Manager

Turn off the other editors


Thats it. !!





wordpress transfer You do not have sufficient permissions to access this page

So after transfer a Wordpress website I got the message 'You do not have sufficient permissions to access this page' .

Actually the error arose because of a change to the 'wp_' suffix I'd made while doing the transfer.  So if that it isn't something you had done as well then this fix is not for you.


wordpress  wp_ suffix change You do not have sufficient permissions to access this page

Run these statements in MyPHPadmin. 

UPDATE new_usermeta
SET meta_key = REPLACE(meta_key,'old_','new_');

UPDATE new_options
SET option_name = REPLACE(option_name,'old_','new_');

Wednesday 8 January 2014

Wordpress file exceeds the maximum upload size for this site. Maximum upload file size: 2MB.

This isn't going to be a great solution for everyone, but it was a real quick fix for me.

And that was to FTP the file somewhere and use 'insert for URL' on the top left.

Joomla Mijo shop - remove Terms and conditions

Mijoshop >  Dashboard > Settings >

Select your shop in the main screen and click on 'edit'

Find the 'Option tab

> scroll down to 'Account Terms'

and then select 'none' from the dropdown.

Tuesday 7 January 2014

How to show old IE versions on Windows 8.1 Internet Explorer 10

I think this has changed slightly; so here's how you get there to save any confusion.,

In IE 10

press F12

A new display now appears. On the scrolling menu on the left go to the image of the Screen and phone at the bottom.

Now in the main window what you need to change is 'Document mode'

Thats it.