Jump to content
Latest News: (loading..)

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
    • Partner Announcements
    • Ambassadors
  • Commercial Support
    • Developer Feedback
  • osCommerce Online Merchant v2.x
    • General Support
    • Installation and Configuration
    • Upgrading from Earlier Versions (v2.x to v2.x)
    • Add-Ons
    • Tips and Tricks
    • Security
  • Development
    • osCommerce Online Merchant v2.4
    • osCommerce Online Merchant Community Bootstrap Edition
    • osCommerce Online Merchant v3.x
    • Development Proposals
  • General
    • Next Steps / Optimizations / Marketing
    • Live Shop Reviews
    • E-Commerce Laws
    • General Discussions
    • PHP / SQL / Web Design
  • oscBooks and oscTemplates's Announcements
  • PayPal's Announcements
  • Sage Pay's Announcements
  • Solomono - new level osCommerce templates's Announcements
  • German Community's OSCOM v2.x
  • German Community's Allgemein
  • German Community's OSCOM v3.x

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start



Real Name





Found 13 results

  1. letsbuygold

    New Installation

    I am currently using version 1.280 ! Yes I know it is old 2003 ! I have created a sub domain in my hosting and i have installed version I wouldn't say i am a developer but i am seeing how far i can get without calling one in ! Do i need to create a new database ? Its asking for Database server, username and password and database name. so could someone spoon feed me and just tell me if i need to create a new database or should i enter my current database that is attached to my main domain ? This is probably really simple so hope someone can help ! Thanks
  2. Mort-lemur

    Set Values in Database

    Hi, Im looking to run a simple sql command to set all values in a database column to 0. To be more specific Im looking to unsubscribe all registered customers from the newsletter so table would be "Customers" and column would be "customers_newsletter" - I have googled solutions but there seems to be a couple of methods - and as always, with running sql commands the scope for disaster is huge - so I would be grateful if someone could give some expert advice please :) I know there is a large thread running on GDPR so I dont want to cloud that thread. Many Thanks
  3. zefeena

    Website gone strange!

    The website is doing all sorts of strange things. Customers are being constantly logged out, and the site is freezing all the time.I am also finding that if I delete an item it doesn't delete, so suspect this is a database issue. I got in touch with the host and the advice was as below. I have no idea where to find the file they are talking about, I cannot see anything called that, and why all of a sudden is there a problem, it was fine last week and I haven't touched the coding in years! any help would be appreciated, thanks I would suggest to disable the cache.You need to add in the root directory of the website the following code in the .htaccess file to disable mod security:<IfModule mod_security.c>SecFilterEngine OffSecFilterScanPOST Off</IfModule>Please put in your .htaccess file this code to disable the cache:<IfModule LiteSpeed>CacheDisable public /CacheDisable private /</IfModule>
  4. reflex-ocasion

    Remove client database addresses

    A customer can have multiple addresses but when their account is deleted only the primary address is deleted. How can the other addresses be deleted if they exist? After 11 years working with osC I have the database a bit saturated and I'm doing cleaning. Spanish laws require to keep invoices for a minimum of 5 years, although they are recommended 6. From there, there is no obligation to keep obsolete old orders, they can be eliminated and that is what I am doing. The problem is that many have two addresses because they are gifts that are made to each other or that they want to receive it at home but that the invoice is made on behalf of the company or similar situations. When you delete those orders they only delete the main address, not the others, and that is filling the database little by little. I'm afraid that at any moment it will be corrupted. Provisionally I am doing it manually but I would like to know if there is a way to do it automatically. Doing so is slow and heavy, very heavy. There must be a simple form but right now I am also saturated checking one by one each data from the different tables in the database so as not to make an error. Thanks in advance for the help, it is something that we would all appreciate since it had never been raised because it has not been given due importance.
  5. Sorry I know this has been coverd before but thread is now closed and I am having problems. This is the original post, I used it without any problem back in 2016! however when I use it now I get this error shown at end. Not what has changed I am doing it exactly as before. Can anyone help Error There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem ERROR: Unknown Punctuation String @ 1 STR: <? SQL: <?php error_reporting(E_ALL); SQL query: <?php error_reporting(E_ALL); MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<?php error_reporting(E_ALL)' at line 1
  6. 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); }
  7. 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?
  8. On table zones, the zone_id field is defined as PRIMARY AUTOINCREMENT, therefore I think that the field zone_country_id is unnecessary on these functions on general.php (on both admin/ and root directories): function tep_get_zone_name($country_id, $zone_id, $default_zone) { $zone_query = tep_db_query("select zone_name from " . TABLE_ZONES . " where zone_country_id = '" . (int)$country_id . "' and zone_id = '" . (int)$zone_id . "'"); [...] } function tep_get_zone_code($country_id, $zone_id, $default_zone) { $zone_query = tep_db_query("select zone_code from " . TABLE_ZONES . " where zone_country_id = '" . (int)$country_id . "' and zone_id = '" . (int)$zone_id . "'"); [...] }
  9. 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
  10. 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?
  11. 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 ????
  12. 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
  13. 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