edoscript
Members-
Posts
70 -
Joined
-
Last visited
edoscript's Achievements
-
How to report installation and operation issues
edoscript replied to osCommerce-Official's topic in General Support
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. -
How to report installation and operation issues
edoscript replied to osCommerce-Official's topic in General Support
P.S. The other option would be, I can reinstall everything from scratch to make sure nothing went wrong during the initial install. -
How to report installation and operation issues
edoscript replied to osCommerce-Official's topic in General Support
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. -
How to report installation and operation issues
edoscript replied to osCommerce-Official's topic in General Support
Good. Thanks. I passed that error. I will continue and then we'll see if it creates any issues. Hopefully not. Thanks again. -
How to report installation and operation issues
edoscript replied to osCommerce-Official's topic in General Support
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. -
How to report installation and operation issues
edoscript replied to osCommerce-Official's topic in General Support
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: -
patrocine reacted to a post in a topic: How to report installation and operation issues
-
How to report installation and operation issues
edoscript replied to osCommerce-Official's topic in General Support
Thanks pandrei, I tried it, however it didn't return any error message. Apparently, $link->error returns empty. Thanks for the idea though. -
How to report installation and operation issues
edoscript replied to osCommerce-Official's topic in General Support
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 -
@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');
-
Optional Related Products, Version 4.0
edoscript replied to Skittles's topic in General Add-Ons Support
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. -
Optional Related Products, Version 4.0
edoscript replied to Skittles's topic in General Add-Ons Support
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. -
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.
-
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.
-
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.
-
@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 ******************/