Search the Community

I'm getting a timeout when trying to run oscb156. I've ran it before on this site but had to start over. The only difference I can think of between the two runs is that the site is now using CloudFlare. The live site is working fine. I've attached the log error below. Any thoughts about what it might be? 2023-03-08 18:36:20 [2603:9009:b10:7d00:300a:554a:27ed:e449][-][-][error][yii\base\ErrorException:2] yii\base\ErrorException: mysqli_connect(): (HY000/2002): Network is unreachable in /home/HIDDEN/public_html/jack/compat/database.php:18

I have an installation where I converted the database from a V2 shop when V4 was first released. At that time the additional images were not handled. The update for V4 say that has been fixed so I want to run the conversion script again to fix that. I uploaded the latest version of oscb. When I try to run it I get the following failure. The shop is working find and not having any database issues so it is just related to this script. Do I need to clear something to get it to work?

Here's a new one... Just moved to a new location that didn't have landline based internet. OK so I ordered Satellite internet "Exede Internet" Works great with the exception of about 700ms ping and latency. Nonetheless, I have developed a problem within ORDER EDITOR, that if you manage any input or create an order or change the status of an existing order, the order becomes blank and doesn't exist. When looking at the dbase entry using WebAdmin all data is missing on the order except for the order number. I thought I had been hacked but also realized it was the first time using it since Satellite internet. Took my laptop to landbased internet source and the admin order editor works perfect. Only through the Satellite do I have problems... What in the world? Any suggestions?

Hello, I've 3 big queries in my shop. Is there someone how can rewrite the contributions? This will be for all users here a great solution! I've installed a querie read tool so i can see on every page how many queries and wich queries are beeing loaded. 1. select specials_new_products_price from specials where products_id = '7230' and status This Is the standard special price querie from Oscommerce i believe. I got this on the products_new.php page. The querie loads for EACH product again. So i have 20 queries for loading on the special price. All products have normaling pricing. 2. I have installed this contribution: http://addons.oscommerce.com/info/2251 I've allready installed the querie reduce contri for the categories. But this contri for an advanced search box on every page also loads the categorie querie. select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '31' and c.categories_id = cd.categories_id and cd.language_id = '4' order by sort_order, cd.categories_name. In my case an extra 35 queries on every page!!! Can someone please look at this beautyfull contri and make it less querie needed please? Thanks! 3. The last contri i have installed how loads a lot of queries is http://addons.oscommerce.com/info/6674. This is also a very nice contri but also takes a lot of queries! I think this is also a simple mod to get the querie count less. I hope someone can help us to rewrite some code to minimize the querie counts. Thanks in advanced all of you! Best regards, Martin

I've been learning about NoSQL Databases that use object models instead of traditional table-based implementations and it seems like something that would be helpful on osCommerce installations with heavy traffic. I'm working on an online store with over 8k products, 20k orders, and 50k products sold. It seems like one of these databases like MongoDB would be able to combine a ton of tables, like one staring with Customers, Orders, etc, into customer based records. My question: Has anyone ever heard of any projects to get a NoSQL database to work with osC? //Additional questions My main purpose in looking toward a NoSQL database is to try to speed up my site. Or: Does anyone know of any tips/tricks to really increase the performance of an osCommerce 2.3.x site? Also: Is anyone familiar with any type of query profiler, perhaps similiar to the CodeIgniter one, that would let me see what all is being run to generate each page?

I realise what I am looking for probably doesn't exist, but I think if someone would take on the challenge it could make an interesting addon. Also it would take oscommerce to a whole new level !!! I am looking for an addon that allows for a subdomain that can be added to an oscommerce site which has the same database / log in details for customers, whilst being operated on the same css / template, and from the same admin page as the main site. This could allow the main page to be for sales of products and the subdomain to cater for hire / rental of products via means of a booking calendar or a blog to promote your site. Thus giving handy information to customers whilst also attracting extra traffic through added searchable content. This could be product releases, upcoming events or some other useful info. I realise there is a lot in this and will probably need two parts : 1) the addon for the oscommerce subdomain that shares template / css / database / admin with the main site and 2) a booking calendar addon for rental of products / hotel rooms / cars ..... but if anyone has any ideas I think it could make an interesting conversation piece or an epic pair of addons ????

I'm currently using the PayPal IPN payment module, although I'm not entirely sure if this issue is related to it or not. The problem seems to be centred around the checkout_confirmation page. If a customer reaches that page and then decides to go back and change their shipping address, billing address, or shipping method, the order that was written into the database does not reflect the changes they make, nor is a new order generated. What the customer sees on the screen changes, and the correct data is sent to Paypal when they pay (new order total, shipping method & rate, etc.), however the order I see in admin (and thus what they see in their order history and order confirmation email) shows the order as it was before they made any changes. In addition, even though payment is successfully completed, the order status displays as "Pending" "PayPal IPN Verified [payment status: Completed]" instead of "Completed" "PayPal IPN Verified [payment status: Completed]". Interestingly, when a customer makes any change to items in the shopping cart, a new order *is* generated in the database when they hit the checkout_confirmation page again. What can I do to allow these other changes to be "recorded" in oscommerce? (thanks in advance for any advice!) ~ Elaine

Native MySQL extension is slightly faster than the improved MySQLi extension, but the latest more stable and have more features. This addon simply replicate the default database function, so you don't have to worry that you need to edit many files. The installation process as easy as uploading a file (database_mysqli.php) and edit one line in application.top.php. As a bonus, this addon add new tep_db_multi_query function (see: mysqli.multi-query.php), so now you can make multi query in one call. Sample of using "tep_db_multi_query" can be found in the archive. Download it here: http://addons.oscommerce.com/info/8168 Best, @zaenal