Jump to content
Latest News: (loading..)

Oggster

Members
  • Content count

    101
  • Joined

  • Last visited

Everything posted by Oggster

  1. Oggster

    Imprint Text Options

    Do you have model numbers for all products?? That was my problem when my site was doing the same thing... Added model numbers for all and fixed everything..
  2. Oggster

    Imprint Text Options

    When I ran a test order. I added a product with the text option to the shopping cart.. When I try to add a second different product with the text option.. The text field is filed out with the other products attribute.. So 2 products cannot be added to the cart with text options.. Unless both those products had there own assigned text attribute.. I hope this is making sense.. If this is the only issue I can work with it.. Just wanted to make sure its working right... Thanks..
  3. Oggster

    Imprint Text Options

    Am I correct in saying that I can only use -1- text field option per product ???
  4. Oggster

    Imprint Text Options

    Error Fixed by doing the following.. Open admin/invoice.php and find the following: // denuz text attr// $pid = @mysql_result(tep_db_query("select products_id from products_description where products_name='" . tep_db_input($order->products[$i]['name']) . "'"), 0, "products_id"); $pid_query = tep_db_query("select products_id from " . TABLE_PRODUCTS . " where products_model LIKE '" . tep_db_input($order->products[$i]['model']) . "'"); Replace with: // $pid = @mysql_result(tep_db_query("select products_id from products_description where products_name='" . tep_db_input($order->products[$i]['name']) . "'"), 0, "products_id"); $pid_query = tep_db_query("select products_id from " . TABLE_PRODUCTS_DESCRIPTION . " where products_name = '" . tep_db_input($order->products[$i]['name']) . "'"); Open admin/packingslip.php and find the following: // denuz text attr $pid_query = tep_db_query("select products_id from " . TABLE_PRODUCTS . " where products_model LIKE '" . tep_db_input($order->products[$i]['model']) . "'"); Replace with: // denuz text attr $pid_query = tep_db_query("select products_id from " . TABLE_PRODUCTS_DESCRIPTION . " where products_name = '" . tep_db_input($order->products[$i]['name']) . "'");
  5. Oggster

    Imprint Text Options

    Ok fixed the product model numbers.. You were right I didn't really use them... Well, they all have them now... Now I get this error on the orders.php page... 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 'and pta.products_text_attributes_id = ota.products_text_attributes_id' at line 1 select ota.*, pta.products_text_attributes_name from orders_text_attributes as ota, products_text_attributes as pta where ota.orders_id = 8551 and ota.products_id = and pta.products_text_attributes_id = ota.products_text_attributes_id [TEP STOP]
  6. Oggster

    Imprint Text Options

    I even uplaoded the orders.php file in the contribution to test.. and it would not work either.. I am runing MS2... Would love to get this working.. I know I'm 90% there.. THanks for your help..
  7. Oggster

    Imprint Text Options

    Hey Jack Having an issue with the text attributes not showing in Admin / Orders... Can you take a look and see what the heck I'm doing wrong.. Data is in the database.. Also not showing on the invoice.. Here is the section of my admin/orders.php <?php for ($i=0, $n=sizeof($order->products); $i<$n; $i++) { echo ' <tr class="dataTableRow">' . "\n" . ' <td class="dataTableContent" valign="top" align="right">' . $order->products[$i]['qty'] . ' x</td>' . "\n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['name']; if (isset($order->products[$i]['attributes']) && (sizeof($order->products[$i]['attributes']) > 0)) { for ($j = 0, $k = sizeof($order->products[$i]['attributes']); $j < $k; $j++) { echo '<br><nobr><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value']; if ($order->products[$i]['attributes'][$j]['price'] != '0') echo ' (' . $order->products[$i]['attributes'][$j]['prefix'] . $currencies->format($order->products[$i]['attributes'][$j]['price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . ')'; echo '</i></small></nobr>'; } } // denuz text attr // $pid = @mysql_result(tep_db_query("select products_id from products_description where products_name='" . tep_db_input($order->products[$i]['name']) . "'"), 0, "products_id"); $pid_query = tep_db_query("select products_id from " . TABLE_PRODUCTS . " where products_model LIKE '" . tep_db_input($order->products[$i]['model']) . "'"); $pid = tep_db_fetch_array($pid_query); $attr_q = tep_db_query("select ota.*, pta.products_text_attributes_name from orders_text_attributes as ota, products_text_attributes as pta where ota.orders_id = " . $HTTP_GET_VARS['oID'] . " and ota.products_id = " . $pid['products_id'] . " and pta.products_text_attributes_id = ota.products_text_attributes_id"); while ($attr = tep_db_fetch_array($attr_q)) { echo '<br><nobr><small> <i> - ' . $attr['products_text_attributes_name'] . ': ' . stripslashes($attr['products_text_attributes_text']); echo '</i></small></nobr>'; } // eof denuz text attr
  8. Oggster

    State Based Region Shipping Rates

    Those who may be using this contribution as Country based shipping.. You'll find when building your region tables you can only add 255 characters... Therefore if you wanted to add all the coutries you'd have to add about 36 shipping regions FIX,,, In SQL MyPhpAdmin.. Run this command.. ALTER TABLE configuration MODIFY configuration_value varchar(3000) This will allow you to add as many states or countries you want...
  9. Oggster

    State Based Region Shipping Rates

    I've installed this contribution.. I am using is as coutry based shipping.. United States and free shipping.. Works great Now for all other coutries.. I want to add a flat shipping rate.. Problem is I cannot add all the coutry's to the text field... I enter them all in and only about a dozen of them are added.. How can I increase this field capaicity... Thanks.. Shipping per item.. for US i have 100:0.00
  10. Is there a contribution that allows the customer when viewing a product and selection attributes they can also input in a text field some type of personalization that will be put thru the checkout and processed with the order.. ??? Thanks..
  11. Oggster

    ULTIMATE Seo Urls 5 - by FWR Media

    Nothing was changed on my end... For some reason they (host) did an apache upgrade and didn't include the mod_rewrite... They installed that module and everything works again.. Oh to be able to get a private server..
  12. Oggster

    ULTIMATE Seo Urls 5 - by FWR Media

    Hey Robert... Site has been working for past month.. Then all the sudden the url rewrite is not working.. Nothing has changed with my site files.. Meaning I have not made any changes.. Do you have any ideas what caused this suddenly to happen.. Thanks Settings are.... And have been working fine.. Seo Urls 5 Title Value Action Add category parent to beginning of URLs? false Add cPath to product URLs? false Enable SEO URLs? true Filter Short Words 1 Output W3C valid URLs? true Choose URL Rewrite Type rewrite Enter special character conversions Remove all non-alphanumeric characters? false Set the number of days to store the cache. 7 Reset SEO URLs Cache Turn degug reporting on/off. false Select caching system. FileSystem Funny thing is.. I also just checked my dev server and it is doing the same thing there...
  13. Oggster

    Automatically send data feed to Froogle

    That did it.. Thanks Jack..
  14. Oggster

    Automatically send data feed to Froogle

    Didn't work.. I get the following error... Warning: Attempt to assign property of non-object in /home/XXXXXXXXX/public_html/XXXXXXX/googlefeeder.php on line 293 This was added on the line before if(SEO_ENABLED=='true'){ $output .= tep_href_link($productURL,$productParam . $row->id) . "\t" . Here is what my SEO Enable looks like if(SEO_ENABLED=='true'){ $output .= tep_href_link($productURL,$productParam . $row['id'], 'NONSSL', false) . "\t" . preg_replace($_strip_search, $_strip_replace, strip_tags( strtr($row['name'], $_cleaner_array) ) ) . "\t" . preg_replace($_strip_search, $_strip_replace, strip_tags( strtr($row['description'], $_cleaner_array) ) ) . "\t" . $feed_exp_date . "\t" . $row['price'] . "\t" . $row['image_url'] . "\t" . $catIndex[$row['prodCatID']] . "\t" . $row['id'];
  15. Oggster

    Automatically send data feed to Froogle

    Not promotional text.. adding a descriptive word.. Promotional text is ie.. "Free shipping" "Discounts" or anything to upsell... Example.. "Title" + "Keyword" = "Turtle" + "Sticker" = Turtle Sticker Keyword being the same for all products..
  16. Oggster

    Automatically send data feed to Froogle

    Did anyone figure this out... I need to add text after the title.. I contacted my google rep and she stated as long as I don't add promotional text then all is fine.. So, I just need to know where to add it...
  17. Oggster

    ULTIMATE Seo Urls 5 - by FWR Media

    Ok.. I was just trying to avoid any down time.. I guess it cannot be avoided.. I did state in post #911 that dns was not pointed yet.. Thanks AGAIN for your help... I will point the dns and start from there.. Looks like its just a configure.php issue..
  18. Oggster

    ULTIMATE Seo Urls 5 - by FWR Media

    Eventhough the DNS has yet to be pointed to the new host.. ?? The site is up and running currently at the old host..
  19. Oggster

    ULTIMATE Seo Urls 5 - by FWR Media

    LOL... Sorry... Had everything working great.. Then having way to many issues with hosting company.. Had to move.. Also I don't have DNS pointing yet.. Wanting to get the site up and running beforehand.. define('HTTP_SERVER', 'http://gator1118.hostgator.com/~xxxxxxxxx'); // eg, http://localhost - should not be empty for productive servers define('HTTPS_SERVER', 'https://www.carstickersdecals.com'); // eg, https://localhost - should not be empty for productive servers define('ENABLE_SSL', false); // secure webserver for checkout procedure? define('HTTP_COOKIE_DOMAIN', 'http://gator1118.hostgator.com/~xxxxxxxxx'); define('HTTPS_COOKIE_DOMAIN', ''); define('HTTP_COOKIE_PATH', '/'); define('HTTPS_COOKIE_PATH', ''); define('DIR_WS_HTTP_CATALOG', '/'); define('DIR_WS_HTTPS_CATALOG', ''); define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/'); define('DIR_FS_CATALOG', '/home/xxxxxxxxx/public_html/'); define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/'); define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');
  20. Oggster

    ULTIMATE Seo Urls 5 - by FWR Media

    OK got that all worked out... Index.php is loading great.. All the images and everything is working.. When I click on a category I get page not found.. What a pain..
  21. Oggster

    ULTIMATE Seo Urls 5 - by FWR Media

    I got that path figured out.. Not just trying to figure out where the extra // is coming from when going into a category.. Using USU 5...
  22. Oggster

    ULTIMATE Seo Urls 5 - by FWR Media

    Hey Robert.. I moved host and got everything all setup.. When I load my index.php I get the following... Warning: file_put_contents(/public_html/includes/modules/ultimate_seo_urls5/cache/1_usucache.cache) [function.file-put-contents]: failed to open stream: No such file or directory in /home/XXXXXXX/public_html/includes/modules/ultimate_seo_urls5/classes/Usu_Cache_FileSystem.php on line 35 Any Ideas...
  23. Oggster

    ULTIMATE Seo Urls 5 - by FWR Media

    Robert.. Do you know of an sitemap generator that works with this contribution.. I have Jack_mcs Google sitemap XML.. It doesn't generate the product pages correctly with this contribution.. Didn't know if there was one out there that works correspondently. Thanks Jay
  24. Oggster

    ULTIMATE Seo Urls 5 - by FWR Media

    Disregard last post.. Figured it out.. Had an extra "/" in there...,
  25. Oggster

    ULTIMATE Seo Urls 5 - by FWR Media

    Hey Robert.. At the checkout_success page when a customer clicks on continue.. I get the FWR page not found.. Can you tell me what I did wrong.. I was thinking it was the configure.php but cant seem to see an error..
×