How to replace text in sql query via?

UPDATE subscribers SET email_format = replace(email_format,”TEXT”,”HTML”)

How to Add New Page in Zencart?

Hi this is take some more steps. You follow  very carefully.

1.  C:your_folderincludestemplatesyour_templatetemplatesyour_file.php
2.  C:your_folderincludesfilenames.php –>(Here mention your file name)
3.  C:your_folderincludesmodulespagesyour_page_folder –>(This Your Page Folder, You create here you header and script file also)
4.  C:your_folderincludeslanguagesenglishbusiness_edit.php

This is for the stapes in your page creation. If i found more information i can inform you.

How to Solve Error in Magento – The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later?

“The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later”

You find above error. You Have two Problem.

1. First you check server Side. And ask him.

2. Next you check your root folder any “maintenance.flag” file is there. If you find that file. Kindly remove or rename. Your server will work good. This is when set your server maintenance mode. This file automatically create in root folder. Then this redirect all files in 503 error page in side.

How to view Page Expert only in WP?

Hi People this is used for wp page excerpt only view.
<?php
$page_name = array(134,4754,4750); // 123 should be replaced with a specific Page’s id from your site, which you can find by mousing over the link to edit that Page on the Manage Pages admin page. The id will be embedded in the query string of the URL, e.g. page.php?action=edit&post=123.

$content_data1 = get_page( $page_name[0] );
$content_data2 = get_page( $page_name[1] );
$content_data3 = get_page( $page_name[2] ); // You must pass in a variable to the get_page function. If you pass in a value (e.g. get_page ( 123 ); ), WordPress will generate an error.

//Content Expert only view
echo $content_data1->post_excerpt;
?>

It is worked for me. Try your side.

<?php
$page_name = array(134,4754,4750); // 123 should be replaced with a specific Page’s id from your site, which you can find by mousing over the link to edit that Page on the Manage Pages admin page. The id will be embedded in the query string of the URL, e.g. page.php?action=edit&post=123.

$privateCoaching_data = get_page( $page_name[0] );
$facebook_data = get_page( $page_name[1] );
$newsletter_data = get_page( $page_name[2] ); // You must pass in a variable to the get_page function. If you pass in a value (e.g. get_page ( 123 ); ), WordPress will generate an error.
?>

How to View Magneto SKU Number in Cart & Page View?

1. You Want cart page to view the SKU number :
You can use below code in your : app/design/frontend/youtheme/yourtheme/template/checkout/cart.phtml
<?php echo $this->__(‘SKU Number’) ?>

And add item section this : app/design/frontend/youtheme/yourtheme/template/checkout/cart/item/default.phtml
<?php echo $_item->getSku() ?>

2. You want to view the Page View :

app/design/frontend/youtheme/yourtheme/template/catalog/product/view.phtml
<!– Write SKU –>
<?php echo $this->__(‘SKU Number :’); ?> <?php
$sku = Mage::getModel(‘catalog/product’)->load($_product->getId())->getSku();
echo $sku; ?>
<!– Sku End –>

its is working for my side.

How to View Order Status Comments History View?

Hi, this is one of very critical issue for me. I found one forum this solution.

That fourm url is below :
http://www.magentocommerce.com/boards/viewthread/20813/P75/

And I mentioned that code also. If they deleted that thread this is useful.

1. You this path : /app/code/core/Mage/Adminhtml/Block/Sales/Order/View/History.php

// For All Status View Purpose Below
public function getAllStatuses()
{
$statuses = $this->getOrder()->getConfig()->getStatuses();
return $statuses;
}
// For All Status View Purpose Above

I added this code after “public function getStatuses()” this function inside.

2. Next you go Here : /app/design/adminhtml/default/default/template/sales/order/view/history.phtml”

Find below Code :
<?php foreach ($this->getStatuses() as $_code=>$_label): ?>
<option value=”<?php echo $_code ?>”<?php if($_code==$this->getOrder()->getStatus()): ?> selected=”selected”<?php endif; ?> <?php echo $_label ?></option>
<?php endforeach; ?>

You feel Backup Above code take or Comment line.

And change Below Code :

<!– Write Below for Order Status –>
<?php foreach ($this->getAllStatuses() as $_code=>$_label): ?>
<option value=”<?php echo $_code ?>”<?php if($_code==$this->getOrder()->getStatus()): ?> selected=”selected”<?php endif; ?>><?php echo $_label ?></option>
<?php endforeach; ?>
<!– Write Above for Order Status –>

This is working for me. And check your side. And thanks this option giving that forum “thekanyon” also.

One Page Checkout not working in Magento?

For Some Solution is available in magento.

You need check your magento extension. Some magento module is conflict for One Page Checkout Javascript Error.

You can remove the extensions. This is will work.

Go to Admin –>Magento Connect –> Check your extension. You remove unwanted extension then its working fine.

How to View SKU Number in Cart Page from Magento?

You just put Below code in your template file.

<td><?php echo $_item->getSku() ?> </td>

1. Go APP Directory –> template –> checkout –> cart –> item –> default.phtml

Here you place above code.

2. Go APP Directory –> template –> checkout –> cart.phtml

Inside your Heading Title.

that’s all.

How to find Magento skin image URL in .phtml page inside

Just put this code where you want:
$this->getSkinUrl(“images/sample.jpg”)

– This skin url code: $this->getSkinUrl

Example:

echo ‘.main { background:url(‘.$this->getSkinUrl(“images/sample.jpg”).’) 0 0 repeat-y !important}’;

<img src=”$this->getSkinUrl(“images/sample.jpg”)”>

After installing Fontis reCaptcha showing 404 error page in magento

Once Clear cookies and session then logout and re open the admin panel.

© 2020 Spirituality