Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

satinwoods

Pioneers
  • Posts

    51
  • Joined

  • Last visited

Posts posted by satinwoods

  1. Hello,

     

    I'm looking for a popup to request people add themselves to our mailing list.  I want it popping up once for them and I want to be able to customize it.

     

    I haven't found one that works with oscommerce.  

     

    I use mail chimp for my newsletter though its pop up does not allow me to customize what I want and it also does not work.

     

    Can anyone recommend an addon that will do this for me?

     

    Thank you!

  2. I've tracked down the sort to this line

     

    $products_attributes_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "'");
    

     

    I just need to get this to sort properly.

     

    I fixed it. For anyone else who wants to have they're attributes organized open up;

     

    includes/classes/pad_base.php

     

    Find:

    }

    if (isset($cart->contents[$this->products_id]['attributes'][$products_options_name['products_options_id']]))

    Add Above:

    asort($products_options_array);

     

    That will fix it.

     

     

    Anyone else have a problem with pay pal? Its really inconsistent.

  3. I've tracked down the sort to this line

     

    $products_attributes_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "'");
    

     

    I just need to get this to sort properly.

  4. Hi there.

     

    I just updated to the latest file and the stock.php was suppose to sort the attributes alphabetically, but it hasn't worked.

     

    //$q=tep_db_query("select * from " . TABLE_PRODUCTS_STOCK . " where products_id=" . $VARS['product_id'] . " order by products_stock_attributes");
    //sorting below goes by name rather than products_stock_attributes. Much easier to have it all sorted alphabetically
     $q=tep_db_query("select ps. products_stock_id, ps.products_id, ps.products_stock_attributes, ps.products_stock_quantity, pov.products_options_values_id, pov.language_id, pov.products_options_values_name from " . TABLE_PRODUCTS_STOCK . " ps, products_options_values pov where ps.products_id=" . $VARS['product_id'] . " and pov.products_options_values_id = substring_index(ps.products_stock_attributes, '-', -1) order by pov.products_options_values_name asc");
    

     

    It's not working and I'm lost as to what to do. Suggestions?

     

     

     

    The other problem I'm having is when people buy something from PayPal, sometimes the stock is taken out and sometimes it doesn't. I haven't been able to find anything connecting the problem. Anyone have a similar problem?

  5. @@Jack_mcs

     

    Tried it and I got this mess;

     

    [b]Strict Standards[/b][color=#000000][font='Trebuchet MS', Arial][size=3]: Non-static method amDB::query() should not be called statically, assuming $this from incompatible context in [/size][/font][/color][b]/home/.../public_html/strutfashion.ca/admin/attributeManager/classes/attributeManagerConfig.class.php[/b][color=#000000][font='Trebuchet MS', Arial][size=3] on line [/size][/font][/color][b]143[/b]
    
    [b]Strict Standards[/b][color=#000000][font='Trebuchet MS', Arial][size=3]: Non-static method amDB::query() should not be called statically, assuming $this from incompatible context in [/size][/font][/color][b]/home/.../public_html/strutfashion.ca/admin/attributeManager/classes/attributeManagerConfig.class.php[/b][color=#000000][font='Trebuchet MS', Arial][size=3] on line [/size][/font][/color][b]148[/b]
    
    [b]Strict Standards[/b][color=#000000][font='Trebuchet MS', Arial][size=3]: Non-static method amDB::query() should not be called statically, assuming $this from incompatible context in [/size][/font][/color][b]/home/.../public_html/strutfashion.ca/admin/attributeManager/classes/attributeManagerConfig.class.php[/b][color=#000000][font='Trebuchet MS', Arial][size=3] on line [/size][/font][/color][b]167[/b]
    

     

    For about 100 lines of just errors after errors

     

    And yes I did go in and do this like it said to "Yo use QTpro with this contrib, you must edit attributeManager - attributeManager - classes attributeManagerConfig.class.php and edit line 65 "AM_USE_QT_PRO" to "true""

     

    Did I miss something else? I read through the instructions again and I think I got everything.

     

    I used v2.8.10. Was I suppose to use v2.8.7?

  6. @@toyicebear

     

    Nice, that fixed it! Thanks!

     

    Now it won't load all the areas, here's what the sql looks like

     

    Full texts
    geo_zone_id
    geo_zone_name
    geo_zone_description
    last_modified
    date_added
    Edit Edit
    Copy Copy
    Delete Delete
    3
    15% Rate
    NULL
    2013-08-21 13:09:15
    Edit Edit
    Copy Copy
    Delete Delete
    4
    14% Rate
    NULL
    2013-08-21 13:09:24
    Edit Edit
    Copy Copy
    Delete Delete
    5
    13% Rate
    NULL
    2013-08-21 13:09:33
    Edit Edit
    Copy Copy
    Delete Delete
    6
    5% Rate
    NULL
    2013-08-21 13:09:43
    Edit Edit
    Copy Copy
    Delete Delete
    7
    No Tax
    Out Side Canada
    2013-10-07 08:37:21
    2013-10-07 08:32:20
    Edit Edit
    Copy Copy
    Delete Delete
    8
    Shp: United States: 48
    United States:  Continental 48 states
    NULL
    2013-11-20 13:11:01
    Edit Edit
    Copy Copy
    Delete Delete
    9
    Shp: United States: 48
    United States:  Continental 48 states
    NULL
    2013-11-21 14:00:17
    

     

    It shows the double States in the drop down and the "rest of the world". No idea why the rest isn't working.

  7. I just installed multigeozone and I'm getting this error when I try to edit it in the admin section

     

    Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, resource given in /home/satinn5/public_html/strutfashion.ca/includes/modules/shipping/mzmt.php on line 196
    Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, resource given in /home/satinn5/public_html/strutfashion.ca/includes/modules/shipping/mzmt.php on line 196
    Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, resource given in /home/satinn5/public_html/strutfashion.ca/includes/modules/shipping/mzmt.php on line 196
    

     

    line 196 is

     

    while ($zone_class = mysqli_fetch_assoc($zone_class_query)) {
    

     

    Thoughts?

  8. In qtpro_stock_table.php

     

    Here is the original

    $products_attributes_query = tep_db_query("SELECT pa.options_id, pa.options_values_id, pa.options_values_price, pa.price_prefix
    	   FROM " . TABLE_PRODUCTS_ATTRIBUTES . " pa
    	   WHERE pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'");
    

     

    What I would like it to do is

    $products_attributes_query = tep_db_query("SELECT pa.options_id, pa.options_values_id, pa.options_values_price, pa.price_prefix, pa.products_options_values_name
    	   FROM " . TABLE_PRODUCTS_ATTRIBUTES . " pa
    	   WHERE pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'.
    	   ORDER BY pa.products_options_values_name");
    

     

    I'm not getting any errors, but its also not doing anything.

     

    Help?

  9. I'm trying to get this mod working

     

    http://addons.oscommerce.com/info/6414

     

    But when I go to confirm my order I get this message.

     

    Internal Server Error

    The server encountered an internal error or misconfiguration and was unable to complete your request.

    Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.

    More information about this error may be available in the server error log.

    Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

     

    I spoke with my host and they narrowed the problem down to this.

     

    Premature end of script headers: checkout_process.php, referer: https://strutfashion.ca/checkout_confirmation.php

     

    I just spoke with Internet Secure and they say that that mod should be working fine.

     

    Any thoughts on how to fix this?

  10. Hi there,

     

    I think I'm missing something with this mod.

     

    I've tripled checked my installation and everything seems to be fine. I can add the module, add a discount code, it knows when I've entered a wrong code, but when it gets to checkout_confirmation.php it doesn't show at all. I echoed array_sum($order->coupon->applied_discount) and its 0.

     

    I've been going through all the forums I can find to see if anyone else has had this problem.

     

    The only thing that I can find is that in include/calsses/order.php I found this code

     

    $shown_price = $currencies->calculate_price($this->products[$index]['final_price'], $this->products[$index]['tax'], $this->products[$index]['qty']);
    $this->info['subtotal'] += $shown_price;
    

     

    Instead of this code in the instructions

     

        $shown_price = tep_add_tax($this->products[$index]['final_price'], $this->products[$index]['tax']) * $this->products[$index]['qty'];
        $this->info['subtotal'] += $shown_price;
    

     

    I also didn't run any SQL because it said

    The installation should now be complete. The module will automatically create the database tables needed, there is no SQL script you need to run, unless the script encountered an error creating the tables (this can happen if the user osCommerce connects with does not have CREATE TABLE permissions). See the common problems section if you need to manually run the create table statements.

    And since I can go into the admin and see my coupon code I assume everything is working well.

     

    Please help, I'm really lost with this.

  11. Hello,

     

    I've been trying to install this great contri, think I'm almost done,

    however when I want to add the module in the admin sector - total order

    (so points can be seen in the checkout_confirmation page)

     

    I get this error :

     

    Warning: reset() [function.reset]: Passed variable is not an array or object in /home/lilijewel/domains/pretty-juwelen.com/public_html/prettyadmin/modules.php on line 240

     

    Warning: Variable passed to each() is not an array or object in /home/lilijewel/domains/pretty-juwelen.com/public_html/prettyadmin/modules.php on line 241

     

     

    There are many topics about this but I can't find a solution to fix this.

     

    this is what's in admin/modules.php around lines 240/241

     

    switch ($action) {
    case 'edit':
     $keys = '';
     reset($mInfo->keys);
     while (list($key, $value) = each($mInfo->keys)) {
     $keys .= '<strong>' . $value['title'] . '</strong><br />' . $value['description'] . '<br />';[/b]
    [b]	 if ($value['set_function']) {
    	 eval('$keys .= ' . $value['set_function'] . "'" . $value['value'] . "', '" . $key . "');");
     } else {
    	 $keys .= tep_draw_input_field('configuration[' . $key . ']', $value['value']);
     }
     $keys .= '<br /><br />';
     }
     $keys = substr($keys, 0, strrpos($keys, '<br /><br />'));[/b]
    [b]	 $heading[] = array('text' => '<strong>' . $mInfo->title . '</strong>');[/b]
    [b]	 $contents = array('form' => tep_draw_form('modules', FILENAME_MODULES, 'set=' . $set . '&module=' . $HTTP_GET_VARS['module'] . '&action=save'));
     $contents[] = array('text' => $keys);
     $contents[] = array('align' => 'center', 'text' => '<br />' . tep_draw_button(IMAGE_SAVE, 'disk', null, 'primary') . tep_draw_button(IMAGE_CANCEL, 'close', tep_href_link(FILENAME_MODULES, 'set=' . $set . '&module=' . $HTTP_GET_VARS['module'])));
     break;
    

     

    can anyone help me out here?

    Thanks in advance

    Lili

     

    I'm having the same problem. Anyone know the solution to this problem?

  12. Hello everyone,

     

    Just installed OScommerce fresh and added on how did you hear about us addon. I then added on qtpro and it all works and I get no errors however when the order is processed the order itself is blank although the product attribute has been decremented and the price is still there properly.

     

    Products Model Tax Price (ex) Price (inc) Total (ex) Total (inc) 0 x 0% $0.00 $0.00 $0.00 $0.00 Sub-Total: $65.00 Flat Rate (Best Way): $5.00 HST: $8.45 Total: $78.45

     

     

    I have no errors to report so I'm kinda lost at this point.

     

    Help?

    :(

×
×
  • Create New...