Jump to content

Search the Community

Showing results for tags 'database'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • News and Announcements
    • News and Announcements
  • osCommerce Online Merchant v2.x
    • General Support
    • osCommerce Online Merchant Community Bootstrap Edition
    • Add-Ons
  • Development
  • General
    • General Discussions
    • Live Shop Reviews
    • Security
    • Developer Feedback
  • PayPal's Announcements
  • Sage Pay's Announcements
  • Solomono - new level osCommerce templates's Announcements
  • German Community's OSCOM v2.x
  • German Community's Allgemein

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start



Real Name




Found 9 results

  1. milkman45

    2.3.4 to

    Hi All, Okay, where to begin. My name is Renato and I have been using OSC since 2007 with the said addons, both PC based and installed listed below. Shop POS by POSFORWEBSHOPS (PC). Still, an integral part for everyday operations and sale in the retail store but not compatible with PHP7+ and the product is no longer supported, or updates offered. OSCPM (OS COMMERCE PRODUCT MANAGER) (PC). PC based and integral to all stock updates without the need to log into a web interface for stock updates. Clean and efficient. OSC 2.3.4 with MINI TEMPLATE SYSTEM Installed and still the base for my web store. Installs in the store code are apps to allow CSV upload, image manipulation and some others. I have been looking at jumping to for some time but have not been able to see or verify or even get consistent information on the compatibility and processes of such a move. Such as database migration, which will allow all categories, customers, products and so forth. In the meantime, I have been able to find all the above requirements being offered by other cart suppliers and more. It will be a shame that I have to jump CART options to be able to get what I have already in place for so long. Hence the post. Is there any parties in a position to be able to offer a solution in the way of integration for a POS system, desktop GUI with connector for the database to be ready and manipulated. Happy to read all comments, suggestions and offers of recoding to suit the transition. Kind regards, Ren.
  2. 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?
  3. Hello, I have a store installation (CE FROZEN, PHP 7.2) with very slow loading admin/categories.php, maybe 20-30 sec. Characteristics for products/chategories: products aprox. 1800 products_to categories aprox. 20000 (products are linked to several categories) categories aprox. 6000 The big number of categories and product links may explain the slow loading. Database tables have been analysed and optimized, they are all using MyISAM and the index settings in the tables are all correct (core). But I observe the following difference between server and local develop installation under XAMPP: Server: always the same loading time XAMPP: slow loading on first time page load rel. fast loading on second and following page loads (2-3 sec.) So my conclusion is that it should be related to a database cache setting. I checked the sqli settings in php.ini of the XAMPP installation and tried to lower mysqli.cache_size=2000 to a very low setting (10) in order to simulate the server problem but no difference. Questions: With the amount of products/categories/links does it sound reasonable this slow loading? Which setting on the server/database can produce this different behaviour Thank you in advance Rainer
  4. I've been building some new interfaces on my shop, and have realized that I would like to use mysqli_fetch_all, so I added it into my database.php. It might be a useful function to have in osC. Just a proposal. function tep_db_fetch_all($db_query) { return mysqli_fetch_all($db_query, MYSQLI_ASSOC); }
  5. 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
  6. 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?
  7. 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 ????
  8. 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
  9. 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