Errors Solved in the CSV import/export of opencart

Dear Rupak

I have a similar error to ialiendre's when I click on the export button:

Error: Table 'opn_j262cjfa6g.product' doesn't exist
Error No: 1146
SELECT * FROM `product` p inner join product_description pd on pd.product_id=p.product_id

Are you able to help me? I'm running v1.4.9.4 .

Thanks & best regards

-=============================================


The tip is that i forget to place the database prefix.

Change the following code

At model/tool/csvproduct.php replace with the codes

$query = "SELECT * FROM `". DB_PREFIX ."" . $table . "` p inner join ". DB_PREFIX ."product_description pd on pd.product_id=p.product_id";

at line no 21 or something like the $query

$query15 = "SELECT * from ". DB_PREFIX ."product_to_category ptc inner join ". DB_PREFIX ."category_description cd on cd.category_id=ptc.category_id where ptc.product_id=". $row['product_id'];

at line number 85 or something like the $query

$sql_query = "INSERT INTO ". DB_PREFIX ."product(product_id,model,quantity,price,list_price,image,stock_status_id,status,weight_class_id, length_class_id) VALUES";
$sql_query1 = "INSERT INTO ". DB_PREFIX ."product_description(product_id,name,description,language_id) VALUES";
$sql_query2 = "INSERT INTO ". DB_PREFIX ."product_to_store (product_id,store_id)VALUES";

at line no 159 to 161 or something like the $query

Thanking You

Best Cycling trick ever done by Berni

funny cartoon of berni, rupak nepali berni

Want to play Golf with the Berni

Watch out how Berni Play golf, one of the most hilarious cartoon on the glof

Decrypt Your code

Want to decrypt the code then visit the site above.
How do i decrypt the php code?
How do i use the decryption of the code?

For all the above question the answer is
Visit the site below:
http://www.region59.net/unlockit/decoder.php

This service is designed to decrypt php-scripts that have been processed by the program SourceCop. Do not use this service to remove the protection to commercial products and for any similar actions which violate the copyright of third parties. Author services shall not be liable for the performance of the decoded scripts, as well as for any damage caused by their use.

Php errors: Deprecated: Call-time pass-by-reference has been deprecated and its solution

Got problems with the Notice in the code you can simply remove them by pasting the line below
error_reporting (E_ALL ^ E_NOTICE);

Notice: Use of undefined constant action - assumed 'action' in D:\web\xampp\htdocs\....\....\..\.....php(1) : eval()'d code on line 43



Deprecated: Call-time pass-by-reference has been deprecated

if we get this errors then we just have to change 
allow_call_time_pass_reference = off 
 to

allow_call_time_pass_reference = on


at php.ini file


After this don't forget to restart your xampp or wamp or means server.


Ways to find the php.ini file
Make one file and write <?php echo phpinfo(); ?>

and run it in the browser and search for the word "php.ini"

According to above mine php.ini file is included in the D:\web\xampp\php folders.

By this you will be able to get the php.ini file and change the setting as per your need.

Thanking You
Rupak Nepali

Rupak Nepali Admin Menu Management in Opencart

Rupak Nepali Admin Menu Management in Opencart
Click To Download Rupak Nepali Admin Menu Managment of Opencart 

Unzip the file and copy in the respective folder then it works


The file at the admin/view/template/common/header.tpl is overridden so better to keep the back up of the file if you dont like it you can use the previous one.

If you have performed any changes in the menu then it may not work.


Thanking You
Rupak Nepali

hiding menu when no permission is given, show only the menu which have permission, menu according to the permission given in opencart.

How to add Special Buttons in the main menu of opencart

I would like to ceate a new button next to the "Home button" on default template. Called "Specials" and then link it to specials offers page.

Any one have any ideas on how to create it as same as the defult colors etc and link it to specials offers page.

I am learning heaps about programming etc.

=========================
Answer:
Remove this from catalog/view/template/common/header.tpl
<div class="div4"><a href="<?php echo str_replace('&', '&amp;', $home); ?>" id="tab_home"><?php echo $text_home; ?></a>
      <?php if (!$logged) { ?>
      <a href="<?php echo str_replace('&', '&amp;', $login); ?>" id="tab_login"><?php echo $text_login; ?></a>
      <?php } else { ?>
      <a href="<?php echo str_replace('&', '&amp;', $logout); ?>" id="tab_logout"><?php echo $text_logout; ?></a>
      <?php } ?>
      <a href="<?php echo str_replace('&', '&amp;', $account); ?>" id="tab_account"><?php echo $text_account; ?></a><a href="<?php echo str_replace('&', '&amp;', $cart); ?>" id="tab_cart"><?php echo $text_cart; ?></a><a href="<?php echo str_replace('&', '&amp;', $checkout); ?>" id="tab_checkout"><?php echo $text_checkout; ?></a></div>

And Paste on the same place the line below
<div class="div4">
    <a href="<?php echo str_replace('&', '&amp;', $home); ?>" id="tab_home"><?php echo $text_home; ?></a>

     <a href="<?php echo str_replace('&', '&amp;', $special); ?>"><?php echo $text_special; ?></a>
      <?php if (!$logged) { ?>
      <a href="<?php echo str_replace('&', '&amp;', $login); ?>" id="tab_login"><?php echo $text_login; ?></a>
      <?php } else { ?>
      <a href="<?php echo str_replace('&', '&amp;', $logout); ?>" id="tab_logout"><?php echo $text_logout; ?></a>
      <?php } ?>
      <a href="<?php echo str_replace('&', '&amp;', $account); ?>" id="tab_account"><?php echo $text_account; ?></a><a href="<?php echo str_replace('&', '&amp;', $cart); ?>" id="tab_cart"><?php echo $text_cart; ?></a>

      </div>

Latest News module for the opencart

Click to download the Latest News Module of opencart
Unzip the files and

Copy and paste the files in their respective folders.
====================================================
FOR BACK END
====================================================
Paste the following

<li><a href="<?php echo  HTTPS_SERVER . 'index.php?route=catalog/news&token=' . $this->session->data['token']; ?>">Latest News</a></li>

in the admin\view\template\common\header.tpl

below these lines

       <li><a href="<?php echo $product; ?>"><?php echo $text_product; ?></a></li>
        <li><a href="<?php echo $manufacturer; ?>"><?php echo $text_manufacturer; ?></a></li>
        <li><a href="<?php echo $download; ?>"><?php echo $text_download; ?></a></li>
======================================================


Now open in the browser login in the admin

Give permission to the user (You can set the permission by admin only) for catalog/news

admin>> System>> Users>> User Groups>> Then select the user and click edit and check the catalog/news  on both the access permission and the modify permission


======================================================

After that click on the Catalog>> Latest News
======================================================
FOR FRONT END SETTINGS
======================================================
Place "Latest News" by linking with the link
        "index.php?route=information/news"
Now clicking on the link shows the latest news in the desc order
======================================================

Latest News Extension coming Soon wait until Sunday, April 24, 2011

Latest News Extension coming Soon wait until Sunday, April 24, 2011

I am now working on the Latest News Showing in the Opencart. I have almost completed it and i am checking it so please wait until Sunday, April 24, 2011 after that you will be able to get the latest news module for free in the opencart.

Thanking You all for having patience.

Rupak Nepali

Banner Advertisement management System in the opencart
What i have found is that the banner advertisement management system can be used with my existing slider banner management syste,.

Visit this link http://nepalrupak.blogspot.com/2011/04/sliding-banner-management-code-for.html and you will be able to get the banner management system for the opencart where administrator can easily manage the banner and links that exists.

The 'Banner ADS System' has been designed to allow the administrator to advertise two main types of banner ads, both types can be run side by side from the same admin so double the whammy...

1. LONG BANNER ADS (480X100*): these banners are rotators, the banner one takes up one banner space and rotates every 10 seconds, banners are linkable and have title information (edit via admin). These are set to be displayed at he top of the page (but can be moved manually anywhere).

2. MINI BANNER ADS (160X100*): these are mini ads that appear in a module on the left AND right columns (YES NOW BOTH), these are displayed as a vertical list.

See the workflow images for guidance.

Rupak Nepali Wish-list extension for the Opencart

Wish-list extension for the Opencart

Click To Download The Wishlist of Opencart 

Unzzip the file and place the file to the respective folders.
===================================

But in the product.tpl we have to kep the code by deleting the code below:

  <input type="text" name="quantity" size="3" value="<?php echo $minimum; ?>" />
                <a onclick="$('#product').submit();" id="add_to_cart" class="button"><span><?php echo $button_add_to_cart; ?></span></a>
                <?php if ($minimum > 1) { ?><br/><small><?php echo $text_minimum; ?></small><?php } ?>
              </div>
              <div>
                <input type="hidden" name="product_id" value="<?php echo $product_id; ?>" />
                <input type="hidden" name="redirect" value="<?php echo str_replace('&', '&amp;', $redirect); ?>" />               
              </div>

paste the following code:

        <input type="text" name="quantity" size="3" value="<?php echo $minimum; ?>" />    <br />    <br />
                <input name="" onClick="f1.action='index.php?route=checkout/cart'; return true;" type="image" src="catalog/view/theme/candid/image/add-tocart.png" />
                <?php if ($minimum > 1) { ?><br/><small><?php echo $text_minimum; ?></small><?php } ?>
             
          
                <input type="hidden" name="product_id" value="<?php echo $product_id; ?>" />
                <input type="hidden" name="redirect" value="<?php echo str_replace('&', '&amp;', $redirect); ?>" />               
               
               
        <input name="" onClick="f1.action='index.php?route=account/wish_list&product_id=<?php echo $product_id; ?>'; return true;" type="image" src="catalog/view/theme/candid/image/add-to-wishlist.png" />

========================================
The main theme is to give the form name="f1"

Find the below code:


<form action="<?php echo str_replace('&', '&amp;', $action); ?>" method="post" enctype="multipart/form-data" id="product">

Repalce with

 <form action="<?php echo str_replace('&', '&amp;', $action); ?>" method="post" enctype="multipart/form-data" id="product" name="f1">

=======================================

Hope that the above code workout if it doesnot comment on

http://nepalrupak.blogspot.com

Thanking You for your time to use it.

wishlist module for the opencart, wishlist component for the opencart, opencart wishlist, download wishlist for free opencart, opencart wishlist for free