Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

dets03ab

Members
  • Content count

    120
  • Joined

  • Last visited

  1. dets03ab

    All Customers Report

    any has a solution to this?
  2. dets03ab

    All Customers Report

    Ok now i see i reached the same problem as others in this thread i have the following error: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /mnt/w0509/d36/s07/b02be82e/ MY CATALOG/catalog/admin/includes/functions/database.php on line 107 AND Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /mnt/w0509/d36/s07/b02be82e/www/MYCATALOG/catalog/admin/includes/functions/database.php on line 99 Did any find a solution to this???? I have tried the sql update also - didnt work! What is the solution to this? any know a contribution that can do the same job as this (have spent so many hours on this one now is enough!)???
  3. dets03ab

    All Customers Report

    now i get this error inside the admin under all customers: 1054 - Unknown column 'a.entry_zone_id' in 'on clause' SELECT c.customers_id , c.customers_default_address_id, c.customers_email_address, c.customers_fax, c.customers_telephone, a.entry_company, a.address_book_id, a.customers_id, a.entry_firstname, a.entry_lastname, a.entry_street_address, a.entry_suburb, a.entry_city, a.entry_state, a.entry_postcode, a.entry_country_id, a.entry_zone_id, z.zone_code, co.countries_name FROM customers c LEFT JOIN zones z ON a.entry_zone_id = z.zone_id JOIN countries co ON a.entry_country_id = co.countries_id LEFT JOIN address_book a ON c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id ORDER BY a.entry_lastname What should i do here? As I udnerstand the all_customers file already has some of these as default so why it makes this error? Also the link look like this: BOX_REPORTS_ALL_CUSTOMERS what am i doing wrong guys?
  4. dets03ab

    All Customers Report

    Guys i have tried to download and install this addon on my 2.2 osc shop but it still doesent work!! I get a syntax error in admin under customers. Can you please specify the step 3 of installation which is very cery unclear what code to put and where to put it?? I am about to rip out my hair due to step 3 i have tried so many things and it still make me syntax errors! Here is the code i use currently in the reports file!: <?php /* $Id: reports.php,v 1.5 2003/07/09 01:18:53 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2002 osCommerce Released under the GNU General Public License */ ?> <!-- reports //--> <tr> <td> <?php $heading = array(); $contents = array(); $heading[] = array('text' => BOX_HEADING_REPORTS, 'link' => tep_href_link(FILENAME_STATS_PRODUCTS_VIEWED, 'selected_box=reports')); if ($selected_box == 'reports') { $contents[] = array('text' => '<a href="' . tep_href_link(FILENAME_STATS_PRODUCTS_VIEWED, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_PRODUCTS_VIEWED . '</a><br>' . '<a href="' . tep_href_link(FILENAME_STATS_PRODUCTS_PURCHASED, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_PRODUCTS_PURCHASED . '</a><br>' . '<a href="' . tep_href_link(FILENAME_STATS_CUSTOMERS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_ORDERS_TOTAL . '</a>'); '<a href="' . tep_href_link(FILENAME_ALL_CUSTOMERS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_ALL_CUSTOMERS . '</a><br>' . } $box = new box; echo $box->menuBox($heading, $contents); ?> </td> </tr> <!-- reports_eof //--> This is what step 3 says: STEP 3 (Add link in Admin) =========================== Edit /admin/includes/boxes/reports.php. It's a small file. Find the section with lines that look like the following one, and add the following line (this reads easier with word wrap off): '<a href="' . tep_href_link(FILENAME_ALL_CUSTOMERS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_ALL_CUSTOMERS . '</a><br>' . You can add the lines in any order you want, but make sure to follow the correct syntax. The finished section could look like this: if ($selected_box == 'reports') { $contents[] = array('text' => '<a href="' . tep_href_link(FILENAME_STATS_PRODUCTS_VIEWED, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_PRODUCTS_VIEWED . '</a><br>' . '<a href="' . tep_href_link(FILENAME_STATS_PRODUCTS_PURCHASED, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_PRODUCTS_PURCHASED . '</a><br>' . '<a href="' . tep_href_link(FILENAME_ALL_CUSTOMERS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_ALL_CUSTOMERS . '</a><br>' . '<a href="' . tep_href_link(FILENAME_STATS_CUSTOMERS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_ORDERS_TOTAL . '</a>'); } What should I put and WHERE SHOULD I PUT IT??? Any feedback is very very mucg appreciated :)
  5. can i only install this on a clean oscomemce installtion? if so should i start all over with my website to install this or?
  6. guys can I only install seo url's on a clean osc installation :o? if that is the case then i should start all over with my website in order to install this or?
  7. Hi all I am trying to install the Greek language module to my webshop from the Osc contribution but my shop went down before to some strange error. Any know which iso code i have to put for the Greek language in the admin module? Until now I found 2 different: GR and EL.....which one is it? Any know if i should change some scripts or something for the greek module? I have english as my main language and will continue with that Hope any can help
  8. Hi all I use Volusion live chat on my website with the contribution for OSC. It has worked perfect up untilo yesterday where suddenly the icon on my site does not change my online/offline status. The status stays as Offline.......I have not changed a single thing on the page recently so why is it doing this all of a sudden? it was working great before please advise as this is very impåortant to my shop to have. Kind regards Dets
  9. Nimz thanks a lot m8 you are a god ! When I paste the last code in either the left or the right column this text also show on my page: /* $Id: online_help.php,v 1.0 2007/DEC/06 Add-On Developed by Nima SG (nimz) http://www.webgurustudio.info for osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 osCommerce Released under the GNU General Public License */ What should I do to remove that?
  10. dets03ab

    Product Description 1.3

    I have just followed the long list of changes and now get following error: Fatal error: Cannot redeclare tep_set_banner_status() (previously declared in /mnt/w1006/d36/s07/b02be82e/www/products/catalog/includes/functions/general.php:701) in /mnt/w1006/d36/s07/b02be82e/www/products/catalog/includes/functions/banner.php on line 15 I have not been doing anything with the banner.php file - what should i do???
  11. dets03ab

    PayPal WPP Direct Payments & Express Checkout Support

    Do I need to install PayPal IPN? Any help is highly appreciated as I am totally lost atm since I can not use the Pay Pal Pro......
  12. dets03ab

    PayPal WPP Direct Payments & Express Checkout Support

    Hi guys. I desperately need some help to finnish my catalog. Since I just learned that PayPal Pro only is for UK and US citizens I now need some help to implement the socalled Buy buttons. I have these questions: 1) Can the customer log in fill up his cart on my site and when they go to the "Delivery Information site" I insert a Paypal button which summarizes the cart content and they pay on pay pal? 2) If yes to 1) How do I implement this buttons in the OsCommerce, which files should I modify and what should I modify? 3) If no to 1) should I then implement a PayPal "Buy now" button for each of my products and which files do I modyfy and how? Do I then have to get rid of the log in process of the OsCommerce or what do I do? Looking very mch forward for your answer Kind regards Dets
  13. dets03ab

    PayPal WPP Direct Payments & Express Checkout Support

    Hi I am experiencing a strange error after having installed the PayPal Pro module all of a sudden which I did not have after installment (havent changed anything though) at the PayPal button: TEXT_PAYPALWPP_EC_BUTTON_TEXT and TEXT_PAYPALWPP_EC_HEADER Any know what I should modify and which file I should do it in? On another note I want to ask in generel about peoples experience with Paypal as I myself am waiting their socalled Expanded Use Enrollment for 5 days now mail answer still pending after 4 days....phone is impossible to get through. I guess I will need my Expanded Use Enrollment to get hold of an API Certificate number to implement in OsCommerce PayPal Pro module? Cheers all Dets
  14. dets03ab

    PayPal

    Does the paypal buttons only allow to buy one item at a time :huh: ? If the customers have e.g. 5 items in their cart paypal can not work with this :o?
×