Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Preseren

Archived
  • Posts

    43
  • Joined

  • Last visited

Everything posted by Preseren

  1. Hey Ive just installed the 2.0 version, and have great problems with it. Well it all works in the admin, and when looking at a product, it shows great. But, whenever I do a search, or try to clikc on a category, I get: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select p.products_image, m.manufacturers_name, pd.products_name, p.products_mode' at line 1 select count(select p.products_image, m.manufacturers_name, pd.products_name, p.products_model, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = \'1\' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = \'4\' and p2c.categories_id = \'46\' order by pd.products_name) as total [TEP STOP] Im really no tgood with MYSQL, so anyone can PLEASE help? Ive imported all the lines into SQL through phpmyadmin, so it should work. Thanks P.
  2. No, meni stvar ne deluje. Ne glede na to, da bi stvar morala delati avtomatsko (koda je noter, sem prevero). Moneti očitno pošlje napačno številko, saj moneta vzame vrednost SIT kot vrednost EUR, torej uporabniki plačajo vrednost SIT v EUR (nekaj tisoč evrov :D) Kaka ideja, zakaj bi do tega prišlo? Lahko iz zgoraj citirane kode vržem ven if?
  3. Thats the logical way of thinking that even I get :D Its 1am, so, Ill get to it tomorow and report. Thanks and have fun P.
  4. Well, Its installed for 3 dayz now, so it should be allready working... Ive done all the things from oyur post before asking here. The only difference is, that I dont have the analytics code in every file. I just puted it into bottom file and it works for me. Could that be a problem? P.
  5. Done, Ive done that in the start P.
  6. Yeah, your right. I was so into giving you all the info, that I forgot the most important one. Well the problem is that google analytics is not showing any shopping info. All the "normal" visiting stats are still being desplayed as before, but the "new" e-commerce info is not being recorded. P.
  7. Guyz I need hep with this contribution. I had google analytics installed before I installed this contrib and it is working ok, The "normal" analytics. Then I uploaded the analytics.php file, added the javascript into the chekout_sucess.php, enabled the e-commerce in google and removed my ip filter. I have no ide, what Ive done wrong. Im posting my checkout_sucess.php if someone can look into it. Thanks <?php /* $Id: checkout_success.php,v 1.49 2003/06/09 23:03:53 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); // if the customer is not logged on, redirect them to the shopping cart page if (!tep_session_is_registered('customer_id')) { tep_redirect(tep_href_link(FILENAME_SHOPPING_CART)); } if (isset($HTTP_GET_VARS['action']) && ($HTTP_GET_VARS['action'] == 'update')) { $notify_string = 'action=notify&'; $notify = $HTTP_POST_VARS['notify']; if (!is_array($notify)) $notify = array($notify); for ($i=0, $n=sizeof($notify); $i<$n; $i++) { $notify_string .= 'notify[]=' . $notify[$i] . '&'; } if (strlen($notify_string) > 0) $notify_string = substr($notify_string, 0, -1); tep_redirect(tep_href_link(FILENAME_DEFAULT, $notify_string)); } require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CHECKOUT_SUCCESS); $breadcrumb->add(NAvb script:__utmSetTrans()"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="3" cellpadding="3"> <tr> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </table></td> <!-- body_text //--> <td width="100%" valign="top"><?php echo tep_draw_form('order', tep_href_link(FILENAME_CHECKOUT_SUCCESS, 'action=update', 'SSL')); ?><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td><table border="0" width="100%" cellspacing="4" cellpadding="2"> <tr> <td valign="top"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_man_on_board.gif', HEADING_TITLE); ?></td> <td valign="top" class="main"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?><div align="center" class="pageHeading"><?php echo HEADING_TITLE; ?></div><br><?php echo TEXT_SUCCESS; ?><br><br> <?php if ($global['global_product_notifications'] != '1') { echo TEXT_NOTIFY_PRODUCTS . '<br><p class="productsNotifications">'; $products_displayed = array(); for ($i=0, $n=sizeof($products_array); $i<$n; $i++) { if (!in_array($products_array[$i]['id'], $products_displayed)) { echo tep_draw_checkbox_field('notify[]', $products_array[$i]['id']) . ' ' . $products_array[$i]['text'] . '<br>'; $products_displayed[] = $products_array[$i]['id']; } } echo '</p>'; } else { echo TEXT_SEE_ORDERS . '<br><br>' . TEXT_CONTACT_STORE_OWNER; } ?> <h3><?php echo TEXT_THANKS_FOR_SHOPPING; ?></h3></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td align="right" class="main"><?php echo tep_image_submit('button_continue.gif', IMAGE_BUTTON_CONTINUE); ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td width="25%"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td width="50%" align="right"><?php echo tep_draw_separator('pixel_silver.gif', '1', '5'); ?></td> <td width="50%"><?php echo tep_draw_separator('pixel_silver.gif', '100%', '1'); ?></td> </tr> </table></td> <td width="25%"><?php echo tep_draw_separator('pixel_silver.gif', '100%', '1'); ?></td> <td width="25%"><?php echo tep_draw_separator('pixel_silver.gif', '100%', '1'); ?></td> <td width="25%"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td width="50%"><?php echo tep_draw_separator('pixel_silver.gif', '100%', '1'); ?></td> <td width="50%"><?php echo tep_image(DIR_WS_IMAGES . 'checkout_bullet.gif'); ?></td> </tr> </table></td> </tr> <tr> <td align="center" width="25%" class="checkoutBarFrom"><?php echo CHECKOUT_BAR_DELIVERY; ?></td> <td align="center" width="25%" class="checkoutBarFrom"><?php echo CHECKOUT_BAR_PAYMENT; ?></td> <td align="center" width="25%" class="checkoutBarFrom"><?php echo CHECKOUT_BAR_CONFIRMATION; ?></td> <td align="center" width="25%" class="checkoutBarCurrent"><?php echo CHECKOUT_BAR_FINISHED; ?></td> </tr> </table></td> </tr> <?php if (DOWNLOAD_ENABLED == 'true') include(DIR_WS_MODULES . 'downloads.php'); ?> </table></form></td> <!-- body_text_eof //--> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> <!-- right_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_right.php'); ?> <!-- right_navigation_eof //--> </table></td> </tr> </table> <!-- body_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> <br> <?php // osCoders.biz - Analystics - start include(DIR_WS_MODULES . 'analytics/analytics.php'); // osCoders.biz - Analistics - end ?> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
  8. Ok, to ?e ?pila zdaj, kaj pa je z novimi zahtevami Mobitela, o tem, da jim po?iljamo ?e vrsto valute? Ma kdo kaj pojma, kako to dodat v moneto? P.
  9. Ok, jaz sem zgodaj omenjen modul začel nastavljat in stvar ne deluje. Ima kdo kaj več uspeha? Meni mobitel Javlja Naročilo ni bilo najdeno. Zaprite sejo in poskusite ponovno z nakupom. Kak?ne ideje? P.
  10. Evo, tukaj je link, ki so mi ga poslali iz Mobitela in vodi na oscommerce Moneta modul. JAvite kaj, če ga bo kdo uporabil, sam ga bom namestil v roku enega tedna. http://www.4ezi.com/ezisoftware/projects/osmoneta/index.asp P.
  11. Ja itaq da gre ziher v komercialne namene, sej ves oscommerce gre ane? Redki so vejretno, ki uporabljajo Oscommerce za to da se doma igrajo. Kakorkoli, poanta mojega posta je, da so mi iz Mobitela sporočili, da stvar nekje zunaj kro?i. Morem malo bolj podrezat pri njih, da vidimo, kaj se dogaja. Če kaj zvem, javim P.
  12. Hej... No meni ga firme ponujajo za 15K SIT, pa vseeno verjamem v free code comunity... A bi se dalo to za kolege? ;) P.
  13. Hy! The Slovenian law about discouts sais, that I need to show the percentage, how much is an article discounted. Any idea, what mod. does this? Thanks P.
×
×
  • Create New...