Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

MHWD

Members
  • Content count

    9
  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    Mark

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. MHWD

    Database Optimizer

    I couldn't find a reference either, it's on xampp with PHP Version: 5.3.1 & MySQL 5.1.41. In addition - if I run the SHOW TABLE STATUS in the sql query it works with no problems. Thank you though
  2. MHWD

    Database Optimizer

    Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\catalog\admin\includes\modules\database_optimizer_common.php on line 59 Not sure why this is being thrown - only happening on optimize and analyze obviously. Any ideas what would cause this?
  3. Not sure if anyone else has had this problem but drove me up a wall. While attributes stock was deducted correctly the total product was not. If you make this change this should correct it. Tested it several ways and worked perfect (No double deductions or anything) but suggest you make sure it works for you as you expect. Find in checkout_process.php: // do not decrement quantities if products_attributes_filename exists if (!$download_selected) { $stock_left = $stock_values['products_quantity'] - $actual_stock_bought; tep_db_query("UPDATE " . TABLE_PRODUCTS . " SET products_quantity = products_quantity - '" . $actual_stock_bought . "' WHERE products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"); Change to: // do not decrement quantities if products_attributes_filename exists if (!$download_selected) { $actual_stock_bought = $order->products[$i]['qty']; $stock_left = $stock_values['products_quantity'] - $actual_stock_bought; tep_db_query("UPDATE " . TABLE_PRODUCTS . " SET products_quantity = products_quantity - '" . $actual_stock_bought . "' WHERE products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"); btw: this is for the 2.3.1 version no idea if works differently with prior versions as Ive moved on
  4. My guess is you didn't run the SQL update that adjusts the db for the new columns. Use your admin section in your db and import the file.
  5. MHWD

    SiteMonitor

    The problem is in your .htaccess file you added changes that ban anyone from accessing any file with _setup in it, basically preventing anyone trying to get in thinking there may be a setup file. Either need to remove that or just change sitemonitor file name that ends in _setup to something else and all referring links to it. Banned myself couple times before I looked at that. All you should have to do is change the filename and the definition under filenames.php to your new name. Or again remove that condition in your htaccess file Havent bothered because still playing w/2.3 newness and seeing how much I can break it
  6. Well now that would of been too simple! (Can I blame the mental lapse on the meds from surgery last week?) Thanks again Robert
  7. Hi Robert, first want to say thank you.. been using osCommerce for a year now and have found all your contributions beyond value and appreciate the attention to detail to the code for reading to clear installations. Now to something I noticed and I cant find anything in here about it but may have missed it. When I have looked at the validation of the page source it shows 3 errors with the meta tags and link showing an omited end tag as so. <meta name="description" content="Graphics Cards, Hardware, Matrox G400 32MB, Matrox G200 MMS."> <meta name="keywords" content="graphics,cards,hardware,matrox,g400,32mb,g200,mms"> So, went into kiss_meta_tags.php and changed lines 272 and 273 From: '<meta name="description" content="' . $this->description . '"' . $this->html_end . PHP_EOL . '<meta name="keywords" content="' . $this->keywords . '"' . $this->html_end . PHP_EOL; To: '<meta name="description" content="' . $this->description . '"/' . $this->html_end . PHP_EOL . '<meta name="keywords" content="' . $this->keywords . '"/' . $this->html_end . PHP_EOL; which has removed those 2 errors.. just gotta track the canonical down now to add the / to end of it as well. Ok canonical is line 250 to change From: echo '<link rel="canonical" href="' . $this->canonical . '"' . $this->html_end . PHP_EOL;; To: echo '<link rel="canonical" href="' . $this->canonical . '"/' . $this->html_end . PHP_EOL;; Im sure it's not highly important but rather have an error free site if I can. This is for 2.3.1 btw. Not thinking this should cause any problems but just odd to me no one else has noticed this before, but search thru the topic and reading every post I just never saw it mentioned.
×