Jump to content

Nefandous

Members
  • Content count

    25
  • Joined

  • Last visited

  1. Yes, mysqli is installed. Centos 6.5 final. php 5.3.3 which actually with EVERY other version 5.3 and higher comes with the mysqlnd library, but not this one. :P As standard it's not included. So at the moment, my best course is to try to sort out the mysqlnd issues within the code. When I replaced the two files with the two you'd based your system on the create_order.php and create_order_process.php, the mysqli_fetch_all() query was a reason it didn't work right. As you discussed with Alsomean earlier. More than likely I will have to install a newer version of php in the end I'm sure. Or install all the little dependant programs and the library.
  2. lol Well this package uses plesk which is annoying a best. Really hate it and much prefer cpanel or whm, but this is what I have to work with. Everything about it is difficult. Thick it was bought for price rather than useability. If it was using conventional CPanel, then installation wouldn't be an issue. I just tried to install a couple of version of the Mysqlnd but need other dependancies installed to get either to work. So I've got a list of installs now to go through. You're right about my reluctance. The container, php/mysql and rest of modules are running correctly and website is working fast and well. If I change the php library, and it goes wrong it could be catastrophic. I may be picking pieces up for weeks :P Obviously I've made copies of both the site and the database... I've scanned through all 3 files that handle the order. ajax_handler.php orders_ajax.php order_handler.php Strangely it seems the mysqli_prepared_query "select" database queries work for the most part. Don't understand that, but as soon as they're changed to the oscommerce tep_db_query an error occurs with the query. So I tried only changing the "update" and "insert" queries only and it still doesn't work lol. Ironically I've installed this module on my own server and it works perfectly. So, I'll go back to the working settings and I'll take a look at the $order->totals which is the only part that doesn't work right now. Am assuming that there's a mysqli_prepared_query writing to the database that I'll need to alter so it actually does. Will give it another attempt now, and see if I can't get this library working.
  3. I think this is where my problems are. It is the library, I had looked at this yesterday night and changed one statement which worked perfectly after this (TAX statement.) I shall change all the mysqlnd functions around to the oscommerce ones for now and see if that works. Considering the difference just the one change made I think this is definite. Yes, unfortunately my Operating system on the server doesn't come with the Mysqlnd libraries as standard. Thanks for the link, I'll take a look. I think this is probably the way to go in the long run and when I install your update. I'll tell you what happens.
  4. @@alsomean & @@Dr. Rolex Let me say firstly, this is an awesome module! However, I had the same problem as alsomean with installing this module. I have my own server, it's all working 100% right at the moment apart from this one module, also I have CentOS 6 with Parallels Plesk Panel 11.5 (yeah, I didn't know till it was bought by my company and they bought a year up front.... :P) which doesn't have mysqlnd installed as standard. Instead of attempting to rewrite your code ;) i went to the previous version that you based yours on. I took the create_order.php and create_order_process.php (changed the very last line of create_order_process.php to use Dr. Rolex's order_handler.php also included the sql statement putting an extra line into orders) and this all works fine now. I do however have an issue with the order_handler.php, as far as TAX is concerned. If I make an order with the order creater then it doesn't look for or put tax into the equation. :P You'll probably say it's the OLD create_order.php page I'm now using. But this seems to be the only issue I have now. I have got something to work, putting a tax query in, and then copying it with a ($order->products[$i]['tax'] = round($tax_class['tax_rate'], 2)) statement and then putting it back into the database. Any ideas what this issue could be?
  5. Nefandous

    Custom Product Builder

    @ RS Designs Once again the problem is the age of the last update, you'll get some errors on the page like an accented a "á" and so on because of this>> ------------------- @ line 30 where there's a blank space before the <head> put @ line 33 you'll find you need to change this to something like this.... So changing these sorts out any character issues because utf-8 is now the standard set for OsCommerce then go to line 85 and find Replace with this ------------------------ then go to line 98 and find Replace with this For some reason str_replace, preg_replace, trim, rtrim and everything else doesn't seem to work in this statement to get rid of the white space at the front of each string in the array. substr did the job though. Now there should be no space between the currency symbol and the values, meaning the $currencies->format will work properly without an error. Of course you could go the non code way and just put - instead of the line. But obviously you wouldn't be able to use it for more than one currency at a time. Anyhow, hopefully this is understandable and this sorts the whole module out finally!!
  6. Nefandous

    Custom Product Builder

    :P Maybe I should update this on the download so all the errors are fixed? :P
  7. Nefandous

    Custom Product Builder

    On the off chance there were any more of the same error. I found one more in builder_products_info.php at line 18. Should read instead of That looks like the last instance of this error. I'll try it out later and see how it works...
  8. Nefandous

    Custom Product Builder

    Yes. Worked it out. Look in builder_product_list.php in your catalog line 22 should read I'll test it some more later just to make sure it's all working on every part.
  9. Nefandous

    Custom Product Builder

    @@RS Designs It's not displaying the builder because there's another error with the code. In builder_main.php in your catalog. It's on line 24. And should read rather than the line And the page displays correctly now. However, there may be another error in the code. When I put in the first component, it displays a database error. Will look into this when I have a little more time.
  10. Nefandous

    Custom Product Builder

    Just found another error in the bm_builder.php found in Catalog/includes/modules/boxes. And it's another MySQL change at line 38 should be rather than the line that's there.
  11. Nefandous

    Custom Product Builder

    The reason it didn't work is that preg_split has changed from split, with the syntax it uses to split each file. this particular function is splitting graphics file names so they'll show in a pull down menu. It would work, but you'll get errors thrown back at you. What used to be $whatever = split('\.', $file) to $whatever = preg_split('/\./', $file) So this worked till split was deprecated...
  12. Nefandous

    Custom Product Builder

    That's because I got the syntax wrong...here's the real working one...sorry for that :- And this works. I didn't have a chance to try it till now.
  13. Nefandous

    Custom Product Builder

    Ooops Sorry just realised, I put that on backwards...ignore that, it should be... Embarrassing :blush:
  14. Nefandous

    Custom Product Builder

    @@RS Designs On the newer version of PHP "split" is no longer used and split_preg is used instead. Haven't tried it, but should work if you change the above to Just another thing that needed to be updated. I'll take a look later to see if it's right. :)
  15. Nefandous

    Custom Product Builder

    Well it seems I can't edit the above to make more sense. Hopefully if you need to use it, you get it! ;) Should make this work with oscommerce 2.3.3.4 and higher after changing it.
×