Jump to content



Photo
- - - - -

osCommerce Online Merchant v2.3.3.4


  • Please log in to reply
29 replies to this topic

#1   Harald Ponce de Leon

Harald Ponce de Leon

    Healthy Giraffe

  • Core Team
  • 5,346 posts
  • Real Name:Harald Ponce de Leon
  • Gender:Male
  • Location:Solingen, Germany

Posted 25 September 2013 - 22:38

osCommerce Online Merchant v2.3.3.4 is a general maintenance release focusing on improving core features and the Database Tables "Convert to UTF-8" action introduced in the previous release.

This release is in preparation of and building up to v2.3.4.

Changelog

  • MySQL Error Functions (Harald)
    Don't pass a null parameter to the MySQL error functions otherwise PHP will display a warning message.
  • UTF-8 Conversion (Harald)
    Also manually convert existing data records to UTF-8 and detect encodings to prevent double encodings. Allow a dry-run to show which queries would be performed.
  • LC_NUMERIC Locale (Harald)
    As LC_ALL is now being used to set the locale, some languages other than English were using commas in float/decimal values which conflicted with MySQL. LC_NUMERIC is now set and forced to the system locale after the main language file has loaded.

Release and Upgrade Guide

A detailed release and upgrade guide is available online at:

http://library.oscom..._notes&v2_3_3_4

Download

Full and Update Packages of osCommerce Online Merchant v2.3.3.4 can be downloaded at:

http://www.oscommerce.com/Products

Thank You!

We'd like to thank the community for their feedback on our releases. In addition, we thank the following people who participated in the development of this release.

Bug Reporters


Testers


Reference

A full list of source code changes can be seen at:

https://github.com/o...3...upgrade2334

:heart: , osCommerce


#2   Harald Ponce de Leon

Harald Ponce de Leon

    Healthy Giraffe

  • Core Team
  • 5,346 posts
  • Real Name:Harald Ponce de Leon
  • Gender:Male
  • Location:Solingen, Germany

Posted 25 September 2013 - 23:18

Hi All..

Just some insider news .. this release was meant to be pushed out sooner this week due to the MySQL convert-to-UTF-8 query introduced in the previous release not doing a sufficient job at converting tables to UTF-8. We did a lot of research on the matter and discovered that we also had to take each record in every table into consideration - and detect and prevent double encodings from occurring.

We found a solution and it worked amazingly good on MyISAM tables however the same query failed on InnoDB tables which had varchar primary keys. In the core, the "sessions" table has a varchar primary key (the session ID) and we also discovered some Add-Ons also having varchar primary keys. We had to fix this even though the core is not optimized for InnoDB tables.

An entire day alone was spent on finding a solution for InnoDB tables and the end result was replacing a @ variable in the query with a duplicate value. It worked, it passed our tests, it also worked for others who we asked to test it out, and finally the InnoDB Table Pom Pom Girls were cheering again.

Gergely also found a nugget in the MySQL documentation that stated that @ variables should not be used in normal queries and is recommended only for SET queries.

Now we know, and now we have an awesome UTF-8 conversion tool in the core :thumbsup:

:heart: , osCommerce


#3   burt

burt

    I drink and I know things

  • Community Team
  • 12,449 posts
  • Real Name:G Burton
  • Gender:Male
  • Location:UK/DEV/on

Posted 26 September 2013 - 10:07

I can confirm that the UTF 8 conversion tool works well. Went through a large database (circa 60,000 orders) in less than 10 seconds.

Prior to coversion was getting problems with the GBP £ (pound sterling) sign. After conversion - all perfect.

This is a signature that appears on all my posts.  It is not specifically aimed at you.

 

IF YOU MAKE A POST REQUESTING HELP...please state the exact version of osCommerce that you are using. THANKS
 
If you are still on the old style osCommerce, it is time to move to Responsive.

 


#4   Gergely

Gergely

    Json Juggler

  • Community Team
  • 2,113 posts
  • Real Name:Gergely Tóth
  • Gender:Male
  • Location:Budapest

Posted 26 September 2013 - 11:44

I plan an extra feautre to convert module. There would be use char modules where you can define conversion rules. So the HTML descriptons could be convert to XHTML tags, convert special characters or do other problems.

Next PHP changes will kill the current codes on the following years. We should do programing for the future and never stick in the present.

My addons: Conversion Tools::Hungarian Translation::Email Templates::URL redirection
 
Development Works: Setup Languages::Email Templates::Languages from ini files::Parcel Shops::Facebook App
 
What core codes have been complained?

In orders table payment_methods value would be better if payment class name used than payment's language name.
In the orders class we found order status does not contains $order->info['orders_status'] but instead there is $order->info['orders_status_name'], and that property is language dependant.
We can not identify in order the customer language.


#5   altoid

altoid
  • Members
  • 1,406 posts
  • Real Name:Steve
  • Gender:Male
  • Location:Hollidaysburg, Pennsylvania

Posted 26 September 2013 - 11:54

Thanks to you three for moving things along.
I am not a professional webmaster or PHP coder by background or training but I will try to help as best I can.
I remember what it was like when I first started with osC. It can be overwhelming.
However, I strongly recommend considering hiring a professional for extensive site modifications, site cleaning, etc.
There are several good pros here on osCommerce. Look around, you'll figure out who they are.

#6   dculley

dculley
  • Members
  • 558 posts
  • Real Name:Dean
  • Gender:Male
  • Location:North Charleston, SC (USA)

Posted 29 September 2013 - 18:19

OK I have just applied 2.3.3.4. I still have the issue in tools/security check that I had with 2.3.3.3, and was adviced to wait for this update.
I have the following message:

MySQL UTF-8 mysql_utf8 Some databse tables need to be converted to UTF-8 (utf8_unicode_ci). Please review the tables under tools -> Database Tables

Do I need to put a check mark by ALL the latin1_swedish_ci and pick "convert to UTF8? About 85% of table is not UTF8 at the moment.

Just want to be sure on what to do. Thanks

#7   Gergely

Gergely

    Json Juggler

  • Community Team
  • 2,113 posts
  • Real Name:Gergely Tóth
  • Gender:Male
  • Location:Budapest

Posted 29 September 2013 - 18:35

I think you have a test page. Keep one database backup and do conversion.

Next PHP changes will kill the current codes on the following years. We should do programing for the future and never stick in the present.

My addons: Conversion Tools::Hungarian Translation::Email Templates::URL redirection
 
Development Works: Setup Languages::Email Templates::Languages from ini files::Parcel Shops::Facebook App
 
What core codes have been complained?

In orders table payment_methods value would be better if payment class name used than payment's language name.
In the orders class we found order status does not contains $order->info['orders_status'] but instead there is $order->info['orders_status_name'], and that property is language dependant.
We can not identify in order the customer language.


#8   dculley

dculley
  • Members
  • 558 posts
  • Real Name:Dean
  • Gender:Male
  • Location:North Charleston, SC (USA)

Posted 29 September 2013 - 19:28

I crossed my fingers and toes. The confersion seems to be working. You know there is a but. When I run Security Checks I it the same message. I have opened Database Tables and do not anything that says Latin1. All is saying utf8. I have refreashed the page and nothing changes.

#9   Gergely

Gergely

    Json Juggler

  • Community Team
  • 2,113 posts
  • Real Name:Gergely Tóth
  • Gender:Male
  • Location:Budapest

Posted 30 September 2013 - 06:52

The conversion suggests utf8_unicode_ci collation and your tables maybe utf8_general_ci. So convert all tables to utf8_unicode_ci collation. Select all oscommerce tables and at the bottom select Convert to UTF8 auto. If you have other system tables (wordpress, joomla, and so on) in your databse those tables could be referal bad collations but this is not intresting.

Need v2.3.3.4 database_tables.php for the conversion.

Next PHP changes will kill the current codes on the following years. We should do programing for the future and never stick in the present.

My addons: Conversion Tools::Hungarian Translation::Email Templates::URL redirection
 
Development Works: Setup Languages::Email Templates::Languages from ini files::Parcel Shops::Facebook App
 
What core codes have been complained?

In orders table payment_methods value would be better if payment class name used than payment's language name.
In the orders class we found order status does not contains $order->info['orders_status'] but instead there is $order->info['orders_status_name'], and that property is language dependant.
We can not identify in order the customer language.


#10   dculley

dculley
  • Members
  • 558 posts
  • Real Name:Dean
  • Gender:Male
  • Location:North Charleston, SC (USA)

Posted 30 September 2013 - 10:21

That did it. Thanks

#11   rudolfl

rudolfl
  • Members
  • 219 posts
  • Real Name:Rudolf Ladyzhenskii
  • Gender:Male
  • Location:Melbourne, Australia

Posted 16 November 2013 - 03:58

When can we see 2.3.4? I know you are doing osCommerce in your spare time and you are doing a great job!
The reason I ask is because I am moving two more stores to osCommerce and want to know if it is worth waiting for 2.3.4 or just stick with current version and buy responsive template.

Thanks,
Rudolf
P.S. How does one gets involved with development of osCommerce? I may be able to help.

#12   GLWalker

GLWalker

    ıllıllı < /> ıllıllı

  • Members
  • 864 posts
  • Real Name:G.L.Walker
  • Gender:Male
  • Location:Texas

Posted 16 November 2013 - 18:35

When can we see 2.3.4?
How does one gets involved with development of osCommerce


https://github.com/o...mmerce2/tree/24

Follow the community build:

BS3 to osCommerce Responsive from the Get Go!

Check out the new construction:

Admin Gone to Total BS!


#13   tonylee5566

tonylee5566
  • Members
  • 10 posts
  • Real Name:Tonylee
  • Gender:Male

Posted 17 November 2013 - 14:19

cool .. thanks the information !

#14   Yseed

Yseed

    Yseed.net

  • Members
  • 9 posts
  • Real Name:Yseed
  • Gender:Male

Posted 22 November 2013 - 00:10

oh good!~
flower seeds Yseed.net

#15   quetevendo

quetevendo
  • Members
  • 72 posts
  • Real Name:Franco
  • Gender:Male
  • Location:Argentina

Posted 22 November 2013 - 13:23

@Harald Ponce de Leon what is the progress of this version? When will be free or stable? Why in ghitub files and folders have date 9 months ago? No new changes are making in this period?

Best Regard

#16   burt

burt

    I drink and I know things

  • Community Team
  • 12,449 posts
  • Real Name:G Burton
  • Gender:Male
  • Location:UK/DEV/on

Posted 22 November 2013 - 13:41

There is loads of ongoing developments, stable version at github easily. Dev versions also at github, but a bit harder to find (as they are dev versions, hence don't want "normal" shopwners downloading and using them [for live sites]).

Edited by burt, 22 November 2013 - 13:44.

This is a signature that appears on all my posts.  It is not specifically aimed at you.

 

IF YOU MAKE A POST REQUESTING HELP...please state the exact version of osCommerce that you are using. THANKS
 
If you are still on the old style osCommerce, it is time to move to Responsive.

 


#17   dr_lucas

dr_lucas
  • Members
  • 331 posts
  • Real Name:Michaela
  • Gender:Female

Posted 26 November 2013 - 09:13

@Harald Ponce de Leon I am not sure how to contact you directly, so I will post this here, although this is about the forums here and not the shopping-cart's development.
Have you considered adding to the forums "Thanks" button with thanks meter, like on xda-developers?
I am quite sure this can make the osC community much more active and helpful...
Also, a thread rating system like on xda may be a good idea...

#18   burt

burt

    I drink and I know things

  • Community Team
  • 12,449 posts
  • Real Name:G Burton
  • Gender:Male
  • Location:UK/DEV/on

Posted 26 November 2013 - 10:21

@dr_lucas - there is a "like this" button on each post. Hit "like this" when you see a post you like, likes are counted on each users profile.

A thread rating system also exists already. Upcoming is a "best answer" system where the best answer in a thread can be chosen.

This is a signature that appears on all my posts.  It is not specifically aimed at you.

 

IF YOU MAKE A POST REQUESTING HELP...please state the exact version of osCommerce that you are using. THANKS
 
If you are still on the old style osCommerce, it is time to move to Responsive.

 


#19   dr_lucas

dr_lucas
  • Members
  • 331 posts
  • Real Name:Michaela
  • Gender:Female

Posted 26 November 2013 - 16:41

"Thanks" button with a clearly visible "Thanks meter" under each user's avatar in the thread like on XDA is a much better implementation.
"Best Answer" is a great idea to be added too! :)

Edited by dr_lucas, 26 November 2013 - 16:42.


#20   jcsls6

jcsls6
  • Members
  • 2 posts
  • Real Name:Joys Simons

Posted 13 December 2013 - 03:38

:D Hi Mr. Ponce,
I appreciate so much your message. I am new to Oscommerce, but very interested in it. I want to set up a online store. But I am not sure how? Maybe you can help me clear my mind.

after I purchase the web hosting, I still need to install the OSCommerce software to my PC or not? Since PHP and MySQL have the web-based administration. can I just edit my online store in the web server and not need to install the PHP/My SQL in my PC at all?

I am a little confused about this: can it be another possible way? Oscommerce is just like shopping cart? If I want to add a home page or other features in the my website, and the Oscommerce is within my website, can or not? for example, if I use Dreamweaver :software set up my PHP/MySQL website and link to my purchased web hosting (which support the oscommerce), then I downloard the Oscommerce source code inside my web pages, can it work this way? I will have more control over my online store then.

I know you are the expert of oscommerce, would you please advice me about my above two questions? in a word: 1. can I just edit my online store in the web server no installation anything in my PC? 2. if I want to have more control over my online store, can I use the oscommerce source code add to my web site using Dreamweaver? I would like this if it is possible.

Any other advice and suggestions are very welcome. I want to work it out in the best way, if you have some examples of Oscommerce website link for me to look at (both examples of my two questions, that will be wonderful!) Many thanks in advance!!!

Sincerely,

Joys