Latest News: (loading..)

Oggster

Members
  • Content count

    101
  • Joined

  • Last visited

1 Follower

About Oggster

Profile Information

  • Real Name
    Jay
  • Gender
    Male
  1. 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. 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. Am I correct in saying that I can only use -1- text field option per product ???
  4. 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. 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. 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. 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. 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. 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. 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. 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. That did it.. Thanks Jack..
  14. 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. 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..