Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

edoscript

Members
  • Content count

    70
  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    Ed
  • Gender
    Male

Recent Profile Visitors

3,761 profile views
  1. edoscript

    How to report installation and operation issues

    I did a new installation from scratch and got same issues. I got the same Error. Can't update database. error. Then I followed pandrei's recommendation (thanks) and added if (empty(trim($sql))) continue; moved to the next SETTINGS page and got the same Error. Can't update database settings. error. So I am wondering if this is happening only to me or if there is an issue with the install package. Thanks in advance. P.S. I have my original v2.3.4 version with all my added mods and customizations including wholesale ordering and much more (my "Frankenstein" version). However, I want to move forward with the new v4.
  2. edoscript

    How to report installation and operation issues

    P.S. The other option would be, I can reinstall everything from scratch to make sure nothing went wrong during the initial install.
  3. edoscript

    How to report installation and operation issues

    On the next page, after I submitted the Settings (General, Contact Information, Address) it appears that the platforms table is missing. I got the following error: Error. Can't update database settings: Table 'ul_store.platforms' doesn't exist I could manually add the table, however I don't know the table details, and maybe this is something that would be better if a solution is found rather than manually overwriting it. Thanks.
  4. edoscript

    How to report installation and operation issues

    Good. Thanks. I passed that error. I will continue and then we'll see if it creates any issues. Hopefully not. Thanks again.
  5. edoscript

    How to report installation and operation issues

    I see /sql/trueloaded.sql is empty. Could it have to do anything with it? I checked the DB name, user and password are all good in the script.
  6. edoscript

    How to report installation and operation issues

    I agree it is strange. Actually, I tried the $sql line yesterday and it returned blank. I tried it again now with your line and got the same result: Error. Can't update database: sql:
  7. edoscript

    How to report installation and operation issues

    Thanks pandrei, I tried it, however it didn't return any error message. Apparently, $link->error returns empty. Thanks for the idea though.
  8. edoscript

    How to report installation and operation issues

    Hello everyone, I am using osCommerce since 2002-ish. I just downloaded the new 4.04 version and when I try to install, right after providing the MySQL details I get an error message: Error. Can't update database. Both lib/frontend/runtime/ and lib/backend/runtime/ folders are empty. I checked the server log files and here is what I found: == [06-Sep-2022 04:11:54 UTC] PHP Warning: mysqli_query(): Empty query in /home/ultragen/public_html/install/install_steps/db_access.class.php on line 224 == And here is the code causing the issue: $sqls = $this->parse_sql_file($restore_from); foreach($sqls as $sql) { $result = mysqli_query($link, $sql); if (!$result) { $this->log('install_error', 'Can\'t update database.'); return false; } As far as server details, here it is: Server OS: Linux 3.10.0-1160.59.1.el7.x86_64 Database: MySQL 5.7.39 HTTP Server: Apache/2.4.54 (cPanel) OpenSSL/1.1.1q mod_bwlimited/1.4 mod_fcgid/2.3.9 Phusion_Passenger/6.0.12 PHP Version: 7.4.30 (Zend: 3.4.0) I would appreciate any feedback. Thank you in advance. - Ed
  9. edoscript

    [Addon] Facebook Pixel

    @BrockleyJohn Thank you for the app. I noticed that the "InitiateCheckout" is not included so I added to my site and here are the additions if you or someone can benefit from it. in includes/modules/header_tags/ht_facebook_pixel.php near line 48 I replaced function execute() { global $PHP_SELF, $oscTemplate, $customer_id, $currencies, $order, $product_check, $currency; with function execute() { global $PHP_SELF, $oscTemplate, $customer_id, $currencies, $order, $product_check, $currency, $cart_total; near line 159 replaced } elseif ( basename($PHP_SELF) == 'advanced_search_result.php' && MODULE_HEADER_TAGS_FB_SEARCH_EVENTS == 'True' && isset($_GET['keywords']) ) { $footer .= '<!-- Facebook Event Tracking --> <script> fbq(\'track\', \'Search\', { search_string: \'' . $_GET['keywords'] . '\', }); </script> <!-- End Facebook Event Tracking --> '; $oscTemplate->addBlock($footer, 'footer_scripts'); } with } elseif ( basename($PHP_SELF) == 'advanced_search_result.php' && MODULE_HEADER_TAGS_FB_SEARCH_EVENTS == 'True' && isset($_GET['keywords']) ) { $footer .= '<!-- Facebook Event Tracking --> <script> fbq(\'track\', \'Search\', { search_string: \'' . $_GET['keywords'] . '\', }); </script> <!-- End Facebook Event Tracking --> '; $oscTemplate->addBlock($footer, 'footer_scripts'); } elseif ( basename($PHP_SELF) == 'checkout_shipping.php' && MODULE_HEADER_TAGS_FB_INITIATE_CHECKOUT_EVENT == 'True' && $cart_total > 0 ) { $footer .= '<!-- Facebook Event Tracking --> <script> fbq(\'track\', \'InitiateCheckout\'); </script> <!-- End Facebook Event Tracking --> '; $oscTemplate->addBlock($footer, 'footer_scripts'); } Replaced 'MODULE_HEADER_TAGS_FB_PRODUCT_VIEWS' => array('title' => 'Product Views', 'desc' => 'Do you want to track product views?', 'value' => 'True', 'set_func' => 'tep_cfg_select_option(array(\'True\', \'False\'), '), with 'MODULE_HEADER_TAGS_FB_PRODUCT_VIEWS' => array('title' => 'Product Views', 'desc' => 'Do you want to track product views?', 'value' => 'True', 'set_func' => 'tep_cfg_select_option(array(\'True\', \'False\'), '), 'MODULE_HEADER_TAGS_FB_INITIATE_CHECKOUT_EVENT' => array('title' => 'Initiate Checkout', 'desc' => 'Do you want to track checkout initiations?', 'value' => 'True', 'set_func' => 'tep_cfg_select_option(array(\'True\', \'False\'), '), Meanwhile, in template_bottom.php before echo $oscTemplate->getBlocks('footer_scripts'); I added $cart_total = $cart->show_total(); if (!tep_session_is_registered('cart_total')) tep_session_register('cart_total');
  10. edoscript

    Optional Related Products, Version 4.0

    I installed the Version Phoenix 7.1, which I now see says for osCommerce CE Phoenix 1.0.2.x. Which version is for 2.3.4? Well I guess I can look within the versions and find the right version. Right? Or maybe I should upgrade to the latest version of osC.
  11. edoscript

    Optional Related Products, Version 4.0

    I have installed this module and activated both for products_info page and the shopping_cart page, however on the installation instructions steps I didn't see any reference to adding a code within product_info.php or shopping_cart.php pages to show the related products and it doesn't show nowhere within product info or the shopping cart pages. My osC version is v.2.3.4. Am I missing something? Thanks in advance.
  12. edoscript

    Automatically send data feed to Froogle

    You are absolutely right, it say for testing only. However, since I needed it I worked on it and tested. The data is successfully uploaded to GMC. So I thought someone else may benefit from it too. Otherwise, thanks for the module. It works fine for me.
  13. edoscript

    Automatically send data feed to Froogle

    Couple of changes that may be useful if you plan to use the .csv file for the Google Merchant Center (GMC). GMC is using date format Y-m-d, so I changed the line define('OPTIONS_DATE_FORMAT', 'm-d-Y'); //change how the date is formatted to define('OPTIONS_DATE_FORMAT', 'Y-m-d'); //change how the date is formatted Since GMC requires the price field to have the curency specified (i.e. '19.99 USD'), near line 465 I replaced $row->price . "\t" . with $row->price . ' ' . OPTIONS_CURRENCY . "\t" . Near line 627 $csvStr = str_replace("\t", '", "', '"' . $output); $csvStr = str_replace("\n", "\"\n\"", $csvStr); $csvStr = substr($csvStr,0,-1); $csvStr = str_replace("\t", '", "', '"' . $output . '"'); I escaped the last line #$csvStr = str_replace("\t", '", "', '"' . $output . '"'); And finally I replaced the below three lines $fp = fopen( $csvFileLocn , "a" ); $fout = fwrite( $fp , $csvStr ); fclose( $fp ); with file_put_contents($csvFileLocn, $csvStr); I think that was it. Hope this will help someone.
  14. edoscript

    Automatically send data feed to Froogle

    was not being tested. So I changed it to if ( $row->prodStatus == 'a' ) { All is good now. I just found it came back to post it here and saw your reply. I just finished reading your comment and noticed that you actually guessed it right too. "Do you have at least one active product?" Thanks a lot.
  15. edoscript

    Automatically send data feed to Froogle

    @Jack_mcs Hello Jack, I have installed this nice module and it looks very promising. Thanks. My question is, I am getting a blank file with only the titles in it. (i.e. link title description price image_link id availability age_group brand condition expiration_date google product category gtin identifier exists adwords_labels mpn product_type upc I'm using osC v2.3.4. I tried debugging but can't find the problem comes from. I saw a post where you recommended replacing the line $myfetch_mysql = ($use_mysqli ? mysqli_fetch_object : mysql_fetch_object); with $myfetch_mysql = mysqli_fetch_object; or $myfetch_mysql = mysql_fetch_object; In my case the original line works same as mysqli_fetch_object, returning blank file with this output: Feed contains 0 products. File Completed: your-outfile.txt Use the following for easier viewing from this page. It is still in development and not meant for anything other than viewing. File Completed: your-outfile.csv Script timer: 0.003809 seconds. I am still looking through the pages on this topic to see if I can find the solution. Meanwhile, I would much appreciate your feedback on this. Thank you in advance. Here are my settings: define('SEO_ENABLED','true'); //Change to 'false' to disable if Ultimate SEO URLs is not installed define('FEEDNAME', 'your-outfile.txt'); //from your googlebase account define('DOMAIN_NAME', 'mysite.com'); //your correct domain name (don't include www unless it is used but do include the shops directory) define('FTP_USERNAME', 'username'); //created from within your googlebase account define('FTP_PASSWORD', 'password'); //created from within your googlebase account define('CONVERT_CURRENCY', '0'); //set to 0 to disable - only needed if a feed in a difference currecny is required define('CURRENCY_TYPE', 'USD'); //(eg. USD, EUR, GBP) define('DEFAULT_LANGUAGE_ID', $languages_id); //Change this to the id of your language if different than what is set as the default language in admin define('QUOTES_CATEGORY_NAME',''); //if the Quotes contribution is installed, enter the name of the quotes category here define('SKIP_CATEGORY_ID', ''); //don't list any categories (or their products) listed here - separate each id by a comma define('SKIP_PRODUCT_ID', ''); //don't list any products listed here - separate each id by a comma /*************** OPTIONS - IF ENABLED, ALSO SET THE SIMILAR OPTION FURTHER DOWN ******************/ define('OPTIONS_ENABLED', 1); define('OPTIONS_ENABLED_AGE_GROUP', 1); define('OPTIONS_ENABLED_ATTRIBUTES', 0); define('OPTIONS_ENABLED_BRAND', 1); //if set, see options for this setting below define('OPTIONS_ENABLED_CONDITION', 1); define('OPTIONS_ENABLED_CURRENCY', 0); define('OPTIONS_ENABLED_EXPIRATION', 1); define('OPTIONS_ENABLED_FEED_LANGUAGE', 0); define('OPTIONS_ENABLED_GTIN', 1); //if set, a database field named products_gtin must exist define('OPTIONS_ENABLED_GOOGLE_PRODUCT_CATEGORY', 1); //http://www.google.com/support/merchants/bin/answer.py?answer=160081 define('OPTIONS_ENABLED_GOOGLE_UTM', 0); // see 'OPTIONS_GOOGLE_UTM' below near line 72 define('OPTIONS_ENABLED_IDENTIFIER_EXISTS', 1); //set to 0 if required - https://support.google.com/merchants/answer/188494?hl=en define('OPTIONS_ENABLED_ISBN', 0); //if set, a database field named products_isbn must exist define('OPTIONS_ENABLED_LABEL', 1); define('OPTIONS_ENABLED_MADE_IN', 0); define('OPTIONS_ENABLED_MPN', 1); //if set, see options for this setting below define('OPTIONS_ENABLED_PRODUCT_MODEL', 0); //displays the product model define('OPTIONS_ENABLED_PRODUCT_TYPE', 1); define('OPTIONS_ENABLED_SHIPPING', 0); define('OPTIONS_ENABLED_INCLUDE_TAX', 0); //0 = no tax, 1 = uses google method, 2 = UK Vat define('OPTIONS_ENABLED_UPC', 1); //if set, a database field named products_upc must exist define('OPTIONS_ENABLED_WEIGHT', 0); //some of the following only work if the matching option is enabled above. define('OPTIONS_AGE_GROUP', 'Kids'); // Adult or Kids define('OPTIONS_AVAILABILITY', 'quantity'); //"in stock" - Include this value if you are certain that it will ship (or be in-transit to the customer) in 3 business days or less. //"available for order" - Include this value if it will take 4 or more business days to ship it to the customer. //"out of stock" - You’re currently not accepting orders for this product. //preorder - You are taking orders for this product, but it’s not yet been released. //if empty (no entry), the data will be loaded from the database. A field in the products description table named products_availability is required //if "quantity," the field will be populated via the quantity: 0 or less = out of stock, greater than 0 = in stock //if "status," the field will be populated via the status field. in or out of stock define('OPTIONS_BRAND', 'name'); //leave blank to load from the database field named products_brand, set to "name" to substitute the products name, manu to substitute the manufactueres name or model to substitute the products model define('OPTIONS_CONDITION', 'New'); //possible entries are New, Refurbished, Used or blank, which loads from the database field named products_condition define('OPTIONS_CURRENCY', 'USD'); define('OPTIONS_CURRENCY_THOUSANDS_POINT', ','); //this is the thousands point as in $1,000. define('OPTIONS_DATE_FORMAT', 'm-d-Y'); //change how the date is formatted define('OPTIONS_FEED_LANGUAGE', 'en'); define('OPTIONS_GOOGLE_UTM', '?utm_source=GoogleBase1&utm_medium=BaseFeed1&utm_campaign=products'); //see http://www.google.com/support/googleanalytics/bin/answer.py?hl=en&answer=55578 define('OPTIONS_GOOGLE_PRODUCT_CATEGORY', 'db'); //enter db to load from a database field named google_product_category enter or enter a specific google category - see taxomy - http://www.google.com/support/merchants/bin/answer.py?answer=160081 define('OPTIONS_GOOGLE_PRODUCT_CATEGORY_DEFAULT', '1253'); //enter the google category to be used if the database entry is empty define('OPTIONS_GTIN', ''); define('OPTIONS_ISBN', ''); define('OPTIONS_LABEL', ''); define('OPTIONS_MADE_IN', ''); // country code i.e. US - DEFAULT value was : define('OPTIONS_MADE_IN', 'US'); define('OPTIONS_MPN', 'model'); //leave blank to load from the database field named products_mpn, set to "name" to substitute the products name, manu to substitute the manufactueres name or model to substitute the products model define('OPTIONS_PRODUCT_TYPE', ''); //full means the full category path (i.e., hardware,printers), anything else, or blank, means just the products category (i.e., printers) //the following is for the shipping override option - enter multiple values separated by a comma //Format entries follow. A colon must be present for each field, whether it is entered or not. // COUNTRY - OPTIONAL - If country isn't included, we'll assume the shipping price applies to the target country of the item. If region isn't included, the shipping price will apply across the entire country. // REGION - OPTIONAL - blank for entire country, otherwise, us two-letter State (CA), full zip code (90210) or wildcard zip code (902*) // SERVICE - OPTIONAL - The service class or delivery speed, i.e. ground // PRICE - REQUIRED - Fixed shipping price (assumes the same currency as the price attribute) #define('OPTIONS_SHIPPING_STRING', 'US:FL:Ground:7.00'); //says charge shipping to US for residents of Florida at 5% and don't apply tax to shipping define('OPTIONS_SHIPPING_STRING', ''); # the above line was the DEFAULT value define('OPTIONS_TAX_RATE' , '10.25'); //default = 0 (e.g. for 20.0% tax use "$taxRate = 20.0;") //only used in the next line define('OPTIONS_TAX_CALC', (OPTIONS_ENABLED_INCLUDE_TAX == 2 ? (OPTIONS_TAX_RATE/100) + 1 : '1')); //UK. US tax rate - US is ignored since it is 1 //the following is for the tax override option - enter multiple values separated by a comma //Format entries follow. A colon must be present for each field, whether it is entered or not. // COUNTRY - OPTIONAL - country the tax applies to - only US for now // REGION - OPTIONAL - blank for entire country, otherwise, us two-letter State (CA), full zip code (90210) or wildcard zip code (902*) // TAX - REQUIRED - default = 0 (e.g. for 5.76% tax use 5.76) // SHIPPING - OPTIONAL - do you charge tax on shipping - choices are y or n define('OPTIONS_TAX_STRING', 'US:FL:10.25:n'); //says charge tax to US for residents of California at 10.25% and don't apply tax to shipping define('OPTIONS_UPC', ''); define('OPTIONS_USE_IMAGE_TABLE', '1'); //set to 1 to use the products_images table, which is only available in 2.3 shops define('OPTIONS_WEIGHT_ACCEPTED_METHODS', 'lb'); //Valid units include lb, pound, oz, ounce, g, gram, kg, kilogram. //the following allow skipping certain items define('OPTIONS_IGNORE_PRODUCT_PRICE', 1); //0 = include products with price of 0 in output, 1 = ignore products with price of 0 define('OPTIONS_IGNORE_PRODUCT_ZERO', 1); //0 = include products with qty of 0 in output, 1 = ignore products with qty of 0 /*************** END MASTER SETTINGS ******************/
×