Pharkie Posted November 21, 2003 Share Posted November 21, 2003 OK I've investigated that language fix a bit. It's hardcoded that it looks on 'language_id = 1'. So if your database doesn't have your main language as language 1, it's going to cause you problems! I'd say find out from your database what the language_id of your main language is, then change the appropriate bit of the Language Fix SQL. It's near the end: AND b.language_id = 1 Change the number and you'll be away. I think this is likely the problem you two have been having. So if you've not already, don't copy over the bit of code I included in the post above - try fixing the language_id first and tell me here if it works? Thanks. :ph34r: Quote Link to comment Share on other sites More sharing options...
k0mplik8ed Posted November 21, 2003 Share Posted November 21, 2003 My default language id is 1, and I don't use any other languages. I did try to copy over the new code but it still didnt work. Could it be that I have to many products? we have 8000+ products. The appication top says I am running --> define('PROJECT_VERSION', 'osCommerce 2.2-MS2-CVS'); maybe the fault is mine for thinking it is compatable. Thanks, Judy Quote Link to comment Share on other sites More sharing options...
Pharkie Posted November 21, 2003 Share Posted November 21, 2003 It could that you're on a CVS version rather than a full release.. but let's try and fix it anyway :) Can you run each query above from phpmyadmin or the mySQL console? That should report back to you on what's wrong. Paste what mySQL says back here and we might get some clues? Quote Link to comment Share on other sites More sharing options...
Pharkie Posted November 21, 2003 Share Posted November 21, 2003 heh - thinking about it, 8000 products is very likely to be the problem. Genius, how many items do you stock? The interface to x-sell lists every item in your store on one long page. In my latest revision I made it display the thumbnail image for each one too. A reasonable server is unlikley to finish that before your PHP script timeout, and even if it did, the resulting page would take forever to download to your browser! It's a flaw with the way the interface for this script works. I only have 130 products, so it doesn't affect me. If both SQL bits execute no problem, then its definitely this causing the problem. The only solution is to get someone to change the interface to something that can work with unlimited products, or naturally, change it yourself! As I noted in the install files, this mod has a long way to go before it's right! Quote Link to comment Share on other sites More sharing options...
k0mplik8ed Posted November 21, 2003 Share Posted November 21, 2003 You have an error in your SQL syntax near '"select a.products_id, b.products_name, b.products_description, ". "a.products_q' at line 1 that is the error I got when I put in your code, so I straightened the code out to "SELECT b.language_id,a.products_id, b.products_name, b.products_description,a.products_quantity, a.products_model, a.products_image,b.products_url, a.products_price FROM products a,products_description b WHERE b.products_id = a.products_id AND b.language_id = 1 ORDER BY a.products_id; myphpadmin gave me resuts none of the selects gave me any errors.. I also just read your post about the amount of products I have. Maybe I can put select row $first_row through $last_row or something and have it only show 50 or less per page... I will let you know Thanks, Judy Quote Link to comment Share on other sites More sharing options...
k0mplik8ed Posted November 21, 2003 Share Posted November 21, 2003 Couldn't I use the split page results class? Thanks, Judy Quote Link to comment Share on other sites More sharing options...
Pharkie Posted November 21, 2003 Share Posted November 21, 2003 So the 'query' bits basically work, when you remove the PHP-only stuff? That's good (and what I expected) To limit the results i think you add LIMIT 50 to the end of the SQL. Either that or SELECT TOP 10, but I'm pretty sure that's TSQL not mySQL's SQL. You can do LIMIT 50, 150 to get e.g. products 150->200. Let me know how you get on? Quote Link to comment Share on other sites More sharing options...
Pharkie Posted November 21, 2003 Share Posted November 21, 2003 Split page results class sounds great! Me not aware of that. Remember to resubmit the Contribution when you're done :) It's still not perfect, since there must be a better way to select the product to add a cross-sell to - but if it works and its easy to implement, that's good for me. Quote Link to comment Share on other sites More sharing options...
k0mplik8ed Posted November 21, 2003 Share Posted November 21, 2003 Ok I put LIMIT 50,150 at the end of the first select and got the 150-200 rows!! so all I have to do is figure out how to make it automatically figure out what the last 50 I veiwed were :-) But I am for now just going to do it manually, so to anyone out there who has too many products and it won't list them all, here is a manual fix! THANKS ADAM!!!!!! Quote Link to comment Share on other sites More sharing options...
k0mplik8ed Posted November 21, 2003 Share Posted November 21, 2003 It's still not perfect, since there must be a better way to select the product to add a cross-sell to - but if it works and its easy to implement, that's good for me. I wonder if in the products area of admin there could be a link, cross sell this product, now this would only be benificial to people who don't cross sell alot. For instance we sell knives so I only wanna cross sell the knives and sheaths that go together and there isn't that many, but back on subject, and when they click the link it says select "All these things" where products_id=var_id, as you can tell I dont know my php good enuff to right exactly what it should say. but I can cut some code up to figure out what I want lol Judy Quote Link to comment Share on other sites More sharing options...
k0mplik8ed Posted November 21, 2003 Share Posted November 21, 2003 that wouldnt help me either, unless there was a text input box where u typed the model # of the item you wanted to cross sell it to... This is something I will work on, and let you know as I get it updated... If anyone who knows php better than I wants to take a shot at it, we all would apreciate it. Judy Quote Link to comment Share on other sites More sharing options...
Genius Posted November 27, 2003 Share Posted November 27, 2003 HI Judy / Adam, My problem is having many products i do have approx 5000 products.. . judy please could you assist me with the admin section. Many thanks Quote Link to comment Share on other sites More sharing options...
k0mplik8ed Posted December 1, 2003 Share Posted December 1, 2003 I do not know if this will help you or not:unsure:, but there is a small problem with the way I did it, All I did was put Limit 1000 at the end of each select statement that called all the products. and say I needed to get the 1559 product, I would put Limit 1000, 1000 at the end, that means give me 1000, start at the 1000th product---now where this is a problem, say you wanted product id 599 to x-sell to product id 1698 well then youd have to go in and make the correct limits at each statement, now this wasnt a problem for me because most the products that needed to b x-selled are close together, and maybe yours are too, the main benifit to this x-sell admin is you can see what you are x-selling but if you have 5000 products you probably know without seeing whats needs x-sold so you can always do it how I really did it, once I put the limit statement in and x-selled a few things I seen how the table worked, like what went in what column etc, and I did a search on my spreadsheet for the model # copied the id directly into the table through phpmyadmin, and basically just entered the information into the table without using the admin... hopes this helps Judy PS Sorry it took so long I was away for Thanksgiving Quote Link to comment Share on other sites More sharing options...
Genius Posted December 1, 2003 Share Posted December 1, 2003 Thanks Judy, Putting a limit is probably the only best solution we may have at this stage but thinking of adding new products so the list would grow in time and for someone not too fimilar with all the products may find a bit of a problem trying to cross sell the products. Thanks for you assistance... I will try and see if can get some code to show a limited number of products.. Quote Link to comment Share on other sites More sharing options...
Pharkie Posted December 1, 2003 Share Posted December 1, 2003 Another short-term answer for those with many many products is to just do all your x-sell admin direct in phpmyadmin - it might be less work than messing about in the OSC admin :) Just a thought. Quote Link to comment Share on other sites More sharing options...
Genius Posted December 1, 2003 Share Posted December 1, 2003 That may be any easy solution at the moment, but say if one wants to do a special bundle sale and sell a few mixed products.. it would be a bit difficult for one if they are not well versed with the phpmyadmin.. Just a thought I have been looking at the code in the Stats_products_viewed.php and trying to add the split codes in like Judy was doing earlier. I am not succeeding but i am sure someone there could assist.. hmm Quote Link to comment Share on other sites More sharing options...
Guest Posted December 18, 2003 Share Posted December 18, 2003 Everything LOOKS good, alas, when I select products to x-sell from the populated list and submit, the page simply reloads. Is this correct? <form action="" method="post"> There is nothing in the form action above. I also have the same problem with the Article mod's x-sell capbilites. same empty form action. Look at the product in admin and no x-sell products attached to it. And, obviously not in the actual catalog either. :P Quote Link to comment Share on other sites More sharing options...
Guest Posted December 18, 2003 Share Posted December 18, 2003 Well I dont have permission to edit my posts so this one replaces the one above with more details.... Everything LOOKS good, alas, when I select products to x-sell from the populated list and submit, the page simply reloads. I did a view source and have... <form action="" method="post"> There is nothing in the form action above. Is this correct???? In the in the ../admin/xsell_products.php file I have... <form action="<?php tep_href_link(FILENAME_XSELL_PRODUCTS, '', 'NONSSL'); ?>" method="post"> I also have the same problem with the Article mod's x-sell capbilites. same empty form action. Look at the product in admin and no x-sell products attached to it. And, obviously not in the actual catalog either. :P Quote Link to comment Share on other sites More sharing options...
Pharkie Posted December 18, 2003 Share Posted December 18, 2003 Here's my thinking.. If the action in your form is empty, then the thing that's supposed to be there isn't there.. So I expect FILENAME_XSELL_PRODUCTS isn't defined, as it should be. Check the install instructions for the mod. Somewhere it'll say e.g. Add define(FILENAME_XSELL_PRODUCTS, 'blahblah.php') to somefile.php You're probably missing that bit. The action on the form shouldn't be empty. Quote Link to comment Share on other sites More sharing options...
Guest Posted December 18, 2003 Share Posted December 18, 2003 (edited) Here's my thinking.. If the action in your form is empty, then the thing that's supposed to be there isn't there.. So I expect FILENAME_XSELL_PRODUCTS isn't defined, as it should be. Check the install instructions for the mod. Somewhere it'll say e.g. Add define(FILENAME_XSELL_PRODUCTS, 'blahblah.php') to somefile.php You're probably missing that bit. The action on the form shouldn't be empty. :o Hmmmm... well trying to cover all bases here... Well, I have it defined in admin/includes/filenames.php // X-Sell define('FILENAME_XSELL_PRODUCTS', 'xsell_products.php'); I tried moving this around within the filenames.php file to no avail. No difference. xsell_products.php is in my catalog/admin sub-directory. I went to my MSQL database and do not see a table for this. Not saying it should be just stating that it isn't. I do have a table products_xsell though which was made running the products_xsell.sql file included with the mod. Which is --- DROP TABLE IF EXISTS products_xsell; CREATE TABLE products_xsell ( ?ID int(10) NOT NULL auto_increment, ?products_id int(10) unsigned NOT NULL default '1', ?xsell_id int(10) unsigned NOT NULL default '1', ?sort_order int(10) unsigned NOT NULL default '1', ?PRIMARY KEY ?(ID) ) TYPE=MyISAM; I also have a table, artciles_xsell for the Article mod. As stated, both forms turn up empty. Inside xsell_products.php I have a call for xsell_products ... <form action="<?php tep_href_link(FILENAME_XSELL_PRODUCTS, '', 'NONSSL'); ?>" method="post"> <b class=\'main\'>Cross-sells updated <a href="' . tep_href_link(FILENAME_XSELL_PRODUCTS, '', 'NONSSL') . '">Back to cross-sell admin</a> <form method="post" action="<?php tep_href_link(FILENAME_XSELL_PRODUCTS, 'sort=1&add_related_product_ID=' . $add_related_product_ID, 'NONSSL'); ?>"> echo "<tr onMouseOver=\"cOn(this); this.style.cursor='pointer'; this.style.cursor='hand';\" onMouseOut=\"cOut(this);\" bgcolor='#DFE4F4' onClick=document.location.href='" . tep_href_link(FILENAME_XSELL_PRODUCTS, 'add_related_product_ID=' . $PRODUCTS_id[$i], 'NONSSL') . "'>"; <a href="' . tep_href_link(FILENAME_XSELL_PRODUCTS, 'add_related_product_ID=' . $PRODUCTS_id[$i], 'NONSSL') . '">Edit</a> <a href="' . tep_href_link(FILENAME_XSELL_PRODUCTS, 'sort=1&add_related_product_ID=' . $PRODUCTS_id[$i], 'NONSSL') . '">Prioritise</a> <a href="' . tep_href_link(FILENAME_XSELL_PRODUCTS, '', 'NONSSL') . '">Click Here to add a new cross sale</a> <a href="' . tep_href_link(FILENAME_XSELL_PRODUCTS, 'sort=1&add_related_product_ID=' . $_POST[add_related_product_ID], 'NONSSL') . '">Click here to sort (top to bottom) the added cross sale</a> When I access the admin area, select CATALOG then Cross Sell Products I get a nicely formated list of products within the store, viewing sources each products is set up as below and you can see there is a call to xsell_products.php file with products ID, when I click that product it is shown in the address bar <tr onMouseOver="cOn(this); this.style.cursor='pointer'; this.style.cursor='hand';" onMouseOut="cOut(this);" bgcolor='#DFE4F4' onClick=document.location.href=/catalog/admin/xsell_products.php?add_related_product_ID=411'><td class="dataTableContent" valign="top"> 411 </td> <td class="dataTableContent" valign="top">gc100 </td> <td class="dataTableContent" valign="top"> Gift Certificate $50.00 </td> <td class="dataTableContent">--</td> <td class="dataTableContent" valign="top"> <a href="/catalog/admin/xsell_products.php?add_related_product_ID=411">Edit</a> </td><td class="dataTableContent" valign=top align=center>--</td></tr> /catalog/admin/xsell_products.php?add_related_product_ID=411 which brings me to another page, with product 411 placed at the top of the table of all my products. and the resulting html page viewed in source has (Note empty form call near beginning.) <!-- body_text //--> ? ? ?<td width="100%" valign="top"> ? ? ? ? ?<!-- Start of cross sale //--> ? ? ? ? ?<table width="100%" border="0" cellpadding="0" cellspacing="0"> ? ? ? ? ? ?<tr> ? ? ? ? ? ? ?<td align=center> ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?<table border="0" cellpadding="2" cellspacing="1" bgcolor="#999999"> ? ? ? ? ? ? ? ? ?<form action="" method="post"> ? ? ? ? ? ? ? ? ? ?<tr class="dataTableHeadingRow"> ? ? ? ? ? ? ? ? ? ? ?<span class="pageHeading">Setting cross-sells for: gc100 (Product ID: 411) <br><br><img src="/~bvhosting/catalog/images/giftcertificates7.jpg" border="0" alt="Gift Certificate $50.00" title=" Gift Certificate $50.00 " width="150" height="150"></span><br><br> ? ? ? ? ? ? ? ? ? ? ?<td class="dataTableHeadingContent">Product ID</td> ? ? ? ? ? ? ? ? ? ? ?<td class="dataTableHeadingContent">Quickfind code</td> ? ? ? <td class="dataTableHeadingContent">Product image</td> ? ? ? ? ? ? ? ? ? ? ?<td class="dataTableHeadingContent">Cross-sell this?</td> ? ? ? ? ? ? ? ? ? ? ?<td class="dataTableHeadingContent">Item Name</td> ? ? ? ? ? ? ? ? ? ? ?<td class="dataTableHeadingContent">Price</td> ? ? ? ? ? ? ? ? ? ?</tr> which in the unprocessed xsell_products.php page looks like this... ? ? ?<!-- body_text //--> ? ? ?<td width="100%" valign="top"> ? ? ? ? ?<!-- Start of cross sale //--> ? ? ? ? ?<table width="100%" border="0" cellpadding="0" cellspacing="0"> ? ? ? ? ? ?<tr> ? ? ? ? ? ? ?<td align=center> ? ? ? ? ? ? ? ?<?php /* general_db_conct($query) Function */ /* To call use: list ($test_a, $test_b) = general_db_conct($query); */ function general_db_conct($query_1) { $result_1 = tep_db_query($query_1); $num_of_rows = mysql_num_rows($result_1); for ($i=0; $i < $num_of_rows; $i++) { $fields = mysql_fetch_row($result_1); $a_to_pass[$i] = $fields[$y=0]; $b_to_pass[$i] = $fields[++$y]; $c_to_pass[$i] = $fields[++$y]; $d_to_pass[$i] = $fields[++$y]; $e_to_pass[$i] = $fields[++$y]; $f_to_pass[$i] = $fields[++$y]; $g_to_pass[$i] = $fields[++$y]; $h_to_pass[$i] = $fields[++$y]; $i_to_pass[$i] = $fields[++$y]; $j_to_pass[$i] = $fields[++$y]; $k_to_pass[$i] = $fields[++$y]; $l_to_pass[$i] = $fields[++$y]; $m_to_pass[$i] = $fields[++$y]; $n_to_pass[$i] = $fields[++$y]; $o_to_pass[$i] = $fields[++$y]; } return array($a_to_pass,$b_to_pass,$c_to_pass,$d_to_pass,$e_to_pass,$f_to_pass,$g_to_pass,$h_to_pass,$i_to_pass,$j_to_pass,$k_to_pass,$l_to_pass,$m_to_pass,$n_to_pass,$o_to_pass); } // End of function general_db_conct() //////////////////////////////////////////////////////////////////////////////////////////////// // This bit does the first page. Lists all products and their X-sells if (!$add_related_product_ID ) { /* Multiple Language fix --- mail@michaelding.net <mailto:mail@michaelding.net> */ $query = "select b.language_id,a.products_id, b.products_name, b.products_description,a.products_quantity, a.products_model, a.products_image,b.products_url, a.products_price FROM products a,products_description b WHERE b.products_id = a.products_id AND b.language_id = 1 ORDER BY a.products_id;"; list ($LANGUAGE_id,$PRODUCTS_id, $PRODUCTS_name, $PRODUCTS_description , $PRODUCTS_quantity , $PRODUCTS_model , $PRODUCTS_image , $PRODUCTS_url , $PRODUCTS_price ) = general_db_conct($query); ?> ? ? ? ? ? ? ? ?<table border="0" cellspacing="1" cellpadding="2" bgcolor="#999999"> ? ? ? ? ? ? ? ? ?<tr class="dataTableHeadingRow"> ? ? ? ? ? ? ? ? ? ?<td class="dataTableHeadingContent" width="75">Product ID</td> ? ? ? ? ? ? ? ? ? ?<td class="dataTableHeadingContent">Quickfind code</td> ? ? ? ? ? ? ? ? ? ?<td class="dataTableHeadingContent">Product Name</td> ? ? ? ? ? ? ? ? ? ?<td class="dataTableHeadingContent" nowrap>Current Cross-Sells</td> ? ? ? ? ? ? ? ? ? ?<td class="dataTableHeadingContent" colspan=2 nowrap align=center>Update ? ? ? ? ? ? ? ? ? ? ?cross-sells</td> ? ? ? ? ? ? ? ? ?</tr> <?php $num_of_products = sizeof($PRODUCTS_id); for ($i=0; $i < $num_of_products; $i++) { /* now we will query the DB for existing related items */ $query = "select b.products_name, a.xsell_id, c.products_model from " . TABLE_PRODUCTS_XSELL . " a, products_description b, products c WHERE b.products_id = a.xsell_id and a.products_id ='" . $PRODUCTS_id[$i] . "' and b.products_id = c.products_id ORDER BY sort_order"; ? ? list ($related_items, $xsell_ids, $product_models) = general_db_conct($query); ? ? echo "<tr onMouseOver=\"cOn(this); this.style.cursor='pointer'; this.style.cursor='hand';\" onMouseOut=\"cOut(this);\" bgcolor='#DFE4F4' onClick=document.location.href='" . tep_href_link(FILENAME_XSELL_PRODUCTS, 'add_related_product_ID=' . $PRODUCTS_id[$i], 'NONSSL') . "'>"; echo "<td class=\"dataTableContent\" valign=\"top\"> ".$PRODUCTS_id[$i]." </td>\n"; ? ? echo "<td class=\"dataTableContent\" valign=\"top\">" . $PRODUCTS_model[$i]." </td>\n"; echo "<td class=\"dataTableContent\" valign=\"top\"> ".$PRODUCTS_name[$i]." </td>\n"; ? ? if ($related_items) { echo "<td class=\"dataTableContent\"><ol>"; ? ? ?for ($j = 0; $j < count($related_items); $j++) { ? ? ? echo '<li><strong>' . $product_models[$j] . '</strong> ' . $related_items[$j] . ?'</li>'; ? ? ?} echo"</ol></td>\n"; } else echo "<td class=\"dataTableContent\">--</td>\n"; echo '<td class="dataTableContent" valign="top"> <a href="' . tep_href_link(FILENAME_XSELL_PRODUCTS, 'add_related_product_ID=' . $PRODUCTS_id[$i], 'NONSSL') . '">Edit</a> </td>'; ? ? if (count($related_items)>1) { echo '<td class="dataTableContent" valign="top"> <a href="' . tep_href_link(FILENAME_XSELL_PRODUCTS, 'sort=1&add_related_product_ID=' . $PRODUCTS_id[$i], 'NONSSL') . '">Prioritise</a> </td>'; } else { echo "<td class=\"dataTableContent\" valign=top align=center>--</td>"; } echo "</tr>\n"; ? ? unset($related_items); } ?> ? ? ? ? ? ? ? ?</table> ? ? ? ? ? ? ? ?<? } // the end of -> if (!$add_related_product_ID) ////////////////////////////////////////////////////////////////////////////////// // This bit does the 'EDIT' page (previously Add/Remove) if ($_POST && !$sort) { if ($_POST[run_update]==true) { $query ="DELETE FROM " . TABLE_PRODUCTS_XSELL . " WHERE products_id = '".$_POST[add_related_product_ID]."'"; if (!tep_db_query($query)) exit('could not delete'); } if ($_POST[xsell_id]) foreach ($_POST[xsell_id] as $temp) { $query = "INSERT INTO " . TABLE_PRODUCTS_XSELL . " VALUES ('',$_POST[add_related_product_ID],$temp,1)"; if (!tep_db_query($query)) exit('could not insert to DB'); } echo '<a href="' . tep_href_link(FILENAME_XSELL_PRODUCTS, '', 'NONSSL') . '">Click Here to add a new cross sale</a><br>' . "\n"; if ($_POST[xsell_id]) echo '<a href="' . tep_href_link(FILENAME_XSELL_PRODUCTS, 'sort=1&add_related_product_ID=' . $_POST[add_related_product_ID], 'NONSSL') . '">Click here to sort (top to bottom) the added cross sale</a>' . "\n"; } if ($add_related_product_ID && ! $_POST && !$sort) { ?> ? ? ? ? ? ? ? ?<table border="0" cellpadding="2" cellspacing="1" bgcolor="#999999"> ? ? ? ? ? ? ? ? ?<form action="<?php tep_href_link(FILENAME_XSELL_PRODUCTS, '', 'NONSSL'); ?>" method="post"> And this last bit above in the code no longer maintains the actual href action in the online form. It is <form action=""> Why isnt this being parsed across from page to page? also when viewing mysql table for procucts_xsell Field Type Attributes Null Default Extra Action ID int(10) No auto_increment Change Drop Primary Index Unique Fulltext products_id int(11) UNSIGNED No 1 Change Drop Primary Index Unique Fulltext xsell_id int(10) UNSIGNED No 1 Change Drop Primary Index Unique Fulltext sort_order int(10) UNSIGNED No 1 Change Drop Primary Index Unique Fulltext and for articles_xsell Field Type Attributes Null Default Extra Action ID int(10) No auto_increment Change Drop Primary Index Unique Fulltext articles_id int(10) UNSIGNED No 1 Change Drop Primary Index Unique Fulltext xsell_id int(10) UNSIGNED No 1 Change Drop Primary Index Unique Fulltext sort_order int(10) UNSIGNED No 1 Change Drop Primary Index Unique Fulltext The BOTH contain the line ID int(10) No auto_increment Change Drop Primary Index Unique Fulltext Is this correct? NONE of my other tables have this line. Edited December 18, 2003 by MsGIF Quote Link to comment Share on other sites More sharing options...
Scotty Posted December 20, 2003 Share Posted December 20, 2003 (edited) I installed the Module and it worked fine, however, after I deleted a product from my shop which wasn't even linked to X-Sell, I started getting this error: 1146 - Table 'xxxxxx_osc1.TABLE_PRODUCTS_XSELL' doesn't exist select b.products_name, a.xsell_id, c.products_model from TABLE_PRODUCTS_XSELL a, products_description b, products c WHERE b.products_id = a.xsell_id and a.products_id ='48' and b.products_id = c.products_id ORDER BY sort_order [TEP STOP] The XSell teble is in the database and everything seem to be as it was when the module was behaving well. Any ideas. TIA, Scotty Edited December 20, 2003 by Scotty Quote Link to comment Share on other sites More sharing options...
Pharkie Posted December 20, 2003 Share Posted December 20, 2003 Any ideas.TIA, I have an idea :) 1146 - Table 'xxxxxx_osc1.TABLE_PRODUCTS_XSELL' doesn't exist The query shouldn't be on TABLE_PRODUCTS_XSELL, it should be on what that needs to be replaced with i.e. products_xsell You're missing the define for TABLE_PRODUCTS_XSELL somehow. Maybe it's related to the problem MsGIF is having? Let me know how you get on? Quote Link to comment Share on other sites More sharing options...
Pharkie Posted December 20, 2003 Share Posted December 20, 2003 heh .. ok I've just read msGIF's big post.. I think I'm onto something. If I'm right, I'm a dumb git. I'm 90% sure I'm right and it'll fix both your two problems. Checking now. Adam Quote Link to comment Share on other sites More sharing options...
Pharkie Posted December 20, 2003 Share Posted December 20, 2003 OK here's the deal. form='' is incorrect: that's not how it should be. But that is what everyone who's downloaded my X-sell admin gets. It works for most people since a browser given a blank action should submit the data back to the same page, as a default thing to do. Point is that relies on your browser to do the right thing to work. Out of interest, what browser are you using MsGIF? Anyway, in xsell_products.php, replace in your action= this: <?php tep_href_link(FILENAME_XSELL_PRODUCTS, '', 'NONSSL'); ?> with <?php echo(tep_href_link(FILENAME_XSELL_PRODUCTS, '', 'NONSSL')); ?> There's only one place in xsell_products.php you need to do this. Scotty it's possible your problem is caused by the same mistake. Check for a <?php TABLE_PRODUCTS_XSELL ?> that needs to be replaced with <?php echo(TABLE_PRODUCTS_XSELL) ?> ! If you find one please message me back so I can correct this and update the contribution so others don't get this problem. MsGIF please let me know if this fixes your problem? Thanks. Adam Quote Link to comment Share on other sites More sharing options...
Pharkie Posted December 20, 2003 Share Posted December 20, 2003 Scotty can you tell me which page you get that error on? Is it the Xsell admin or one of the user-side Product pages? Ta. Adam Quote Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.