Jump to content

Recommended Posts

where van I find a list of changes to the database from 2.3 to Phoenix?

Share this post


Link to post
Share on other sites

Hi Burt and other 'godfathers',

Thank you very very much for the great work you accomplished making Phoenix 1.0.

I am in the process of updating my existing web shop to Phoenix 1.0.1.0, which is hard, since I used a lot of mods.

I the meantime, I came across issues with some of the files of 1.0.1.0.

I hope this is the right place to report these issues?
Well, here goes..

Remarks on Phoenix\Responsive-osCommerce-1.0.0.0

Files that need updating:

\admin\orders.php
Replace (4x) " . TABLE_ORDERS_STATUS . " by orders_status
Replace (6x) " . TABLE_ORDERS . " by orders
Replace (2x) " . TABLE_ORDERS_STATUS_HISTORY. " by orders_status_history
Replace (3x) " . TABLE_ORDERS_TOTAL . " by orders_total
Remove unused script // v2.2rc2a compatibility
Uses classes for table lay out

\admin\invoice.php
Replace (1x) " . TABLE_ORDERS . " by orders

\admin\customers.php
Replace (3x) " . TABLE_ZONES . " by zones
Replace (4x) " . TABLE_CUSTOMERS . " by customers
Replace (3x) " . TABLE_CUSTOMERS_INFO . " by customers_info
Replace (3x) " . TABLE_ADDRESS_BOOK . " by address_book
Replace (1x) " . TABLE_CUSTOMERS_BASKET . " by customers_basket
Replace (1x) " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " by customers_basket_attributes
Replace (1x) " . TABLE_WHOS_ONLINE . " by whos-online
Replace (3x) " . TABLE_REVIEWS . " by reviews
Replace (1x) " . TABLE_REVIEWS_DESCRIPTION . " by reviews_description
Replace (1x) " . TABLE_COUNTRIES . " by countries

\admin\includes\application_top.php
Replace (1x) ' . TABLE_CONFIGURATION by configuration '

\index.php
Replace (3x) " . TABLE_CATEGORIES . " by categories
Replace (3x) " . TABLE_CATEGORIES_DESCRIPTION . " by categories_description

\admin\includes\functions\sessions.php
Replace (6x) " . TABLE_SESSIONS . " by sessions

\admin\includes\functions\general.php
Replace (19x) " . TABLE_CUSTOMERS . " by customers
Replace (10x) " . TABLE_CATEGORIES . " by categories
Replace ( 6x) " . TABLE_CATEGORIES_DESCRIPTION . " by categories_description
Replace (10x) " . TABLE_PRODUCTS . " by products
Replace ( 6x) " . TABLE_PRODUCTS_DESCRIPTION . " by products_description
Replace ( 1x) " . TABLE_PRODUCTS_OPTIONS . " by products_options
Replace ( 1x) " . TABLE_PRODUCTS_OPTIONS_VALUES . " by products_options_values
Replace ( 2x) " . TABLE_COUNTRIES . " by countries
Replace ( 4x) " . TABLE_ZONES . " by zones
Replace ( 3x) " . TABLE_TAX_CLASS . " by tax_class
Replace ( 5x) " . TABLE_GEO_ZONES . " by geo_zones
Replace ( 2x) " . TABLE_ADDRESS_FORMAT . " by address_format
Replace ( 1x) " . TABLE_LANGUAGES . " by languages
Replace ( 4x) " . TABLE_ORDERS_STATUS . " by orders_status
Replace ( 1x) " . TABLE_MANUFACTURERS_INFO . " by manufacturers_info
Replace ( 5x) " . TABLE_PRODUCTS_TO_CATEGORIES . " by products_to_categories
Replace ( 2x) " . TABLE_BANNERS . " by banners
Replace ( 4x) " . TABLE_REVIEWS . " by reviews
Replace ( 1x) " . TABLE_REVIEWS_DESCRIPTION . " by reviews_description
Replace ( 3x) " . TABLE_SPECIALS . " by specials
Replace ( 3x) " . TABLE_PRODUCTS_IMAGES . " by products_images
Replace ( 1x) " . TABLE_PRODUCTS_ATTRIBUTES . " by products_attributes
Replace ( 1x) " . TABLE_CUSTOMERS_BASKET . " by customers_basket
Replace ( 1x) " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " by customers_basket_attributes
Replace ( 2x) " . TABLE_ORDERS_PRODUCTS . " by orders_products
Replace ( 1x) " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " by orders_products_attributes
Replace ( 1x) " . TABLE_ORDERS_STATUS_HISTORY . " by orders_status_history
Replace ( 1x) " . TABLE_ORDERS_TOTAL . " by orders_total
Replace ( 1x) " . TABLE_TAX_RATES . " by tax_rates
Replace ( 1x) " . TABLE_ZONES_TO_GEO_ZONES . " by zones_to_geo_zones

If  all while constructions should be replaced with for each constructions , there is a lot to do in this file
\admin\includes\functions\general.php.

More on Phoenix\Responsive-osCommerce-1.0.0.0:

The following files have the same type of problem: need to replace symbolic table names with real table names.
\admin\includes\boxes\configuration.php

\admin\includes\classes\currencies.php
\admin\includes\classes\language.php
\admin\includes\classes\order.php        Also: while constructions ?
\admin\includes\classes\payment_module_info.php
\admin\includes\classes\shopping_cart.php

\admin\includes\functions\html_graphs.php
\admin\includes\functions\html_output.php
\admin\includes\functions\languages.php

\admin\includes\graphs\banner_daily.php
\admin\includes\graphs\banner_infobox.php
\admin\includes\graphs\banner_monthly.php
\admin\includes\graphs\banner_yearly.php

\admin\includes\modules\dashboard\d_admin_logins.php
\admin\includes\modules\dashboard\d_customers.php
\admin\includes\modules\dashboard\d_latest_addons.php
\admin\includes\modules\dashboard\d_latest_news.php
\admin\includes\modules\dashboard\d_orders.php
\admin\includes\modules\dashboard\d_partner_news.php
\admin\includes\modules\dashboard\d_reviews.php
\admin\includes\modules\dashboard\d_security_checks.php
\admin\includes\modules\dashboard\d_total_customers.php
\admin\includes\modules\dashboard\d_total_revenue.php
\admin\includes\modules\dashboard\d_version_check.php

\admin\includes\modules\newsletters\newsletter.php
\admin\includes\modules\newsletters\product_notification.php

\admin\includes\modules\security_check\extended_last_run.php

\admin\action_recorder.php
\admin\administrators.php
\admin\backup.php
\admin\banner_manager.php
\admin\banner_statistics.php
\admin\categories.php
\admin\configuration.php
\admin\countries.php
\admin\currencies.php
\admin\geo_zones.php
\admin\languages.php
\admin\login.php
\admin\mail.php
\admin\manufacturers.php
\admin\modules.php
\admin\modules_content.php
\admin\newsletters.php
\admin\orders_status.php
\admin\packingslip.php
\admin\popup_image.php
\admin\products_attributes.php
\admin\sec_dir_permissions.php
\admin\specials.php
\admin\stats_customers.php
\admin\stats_products_purchased.php
\admin\stats_products_viewed.php
\admin\tax_classes.php
\admin\tax_rates.php
\admin\whos_online.php
\admin\zones.php


In the update to Responsive-osCommerce-1.0.1.0, symbolic names seem to have replaced the real names of many files and tables in many files:

Responsive-osCommerce-1.0.1.0\includes\modules\content\login\cm_paypal_login.php
  Symbolic file names?

Responsive-osCommerce-1.0.1.0\includes\apps\paypal\OSCOM_PayPal.php
  Symbolic file names and table names?

Responsive-osCommerce-1.0.1.0\includes\apps\paypal\hooks\admin\orders\tab.php 
  Symbolic file names and table names?

Responsive-osCommerce-1.0.1.0\ext\modules\payment\paypal\standard_ipn.php
  Symbolic file names?
Responsive-osCommerce-1.0.1.0\ext\modules\payment\paypal\hosted_checkout.php
  Symbolic file names?
Responsive-osCommerce-1.0.1.0\ext\modules\payment\paypal\express.php
  Symbolic file names and table names?

Responsive-osCommerce-1.0.1.0\admin\paypal.php
Responsive-osCommerce-1.0.1.0\admin\login.php
Responsive-osCommerce-1.0.1.0\admin\includes\functions\sessions.php
  Symbolic table names?

If this is not the right place or way to report this, I am sorry. I am not 'at home' with GitHub...

Best regards

Eveline

Share this post


Link to post
Share on other sites

Hi

Maybe this is useful to know about PHP version compatibility.

I updated my WAMP server, I now use PHP 7.3.7,

The front page of my shop  now shows these warnings:

( ! ) Warning: Use of undefined constant MODULE_CONTENT_NAVBAR_STYLE_BG - assumed 'MODULE_CONTENT_NAVBAR_STYLE_BG' (this will throw an Error in a future version of PHP) in C:\wamp64\www\htdoc2\winkel\includes\modules\content\navigation\cm_navbar.php on line 52
Call Stack
# Time Memory Function Location
1 0.0000 408376 {main}( ) ...\index.php:0
2 0.1248 757384 require( 'C:\wamp64\www\htdoc2\winkel\includes\template_top.php' ) ...\index.php:43
3 0.1716 880840 oscTemplate->getContent( ) ...\template_top.php:47
4 0.1716 882480 cm_navbar->execute( ) ...\osc_template.php:152

 

( ! ) Warning: Use of undefined constant MODULE_CONTENT_NAVBAR_STYLE_FG - assumed 'MODULE_CONTENT_NAVBAR_STYLE_FG' (this will throw an Error in a future version of PHP) in C:\wamp64\www\htdoc2\winkel\includes\modules\content\navigation\cm_navbar.php on line 53
Call Stack
# Time Memory Function Location
1 0.0000 408376 {main}( ) ...\index.php:0
2 0.1248 757384 require( 'C:\wamp64\www\htdoc2\winkel\includes\template_top.php' ) ...\index.php:43
3 0.1716 880840 oscTemplate->getContent( ) ...\template_top.php:47
4 0.1716 882480 cm_navbar->execute( ) ...\osc_template.php:152

 

( ! ) Warning: Use of undefined constant MODULE_CONTENT_NAVBAR_COLLAPSE - assumed 'MODULE_CONTENT_NAVBAR_COLLAPSE' (this will throw an Error in a future version of PHP) in C:\wamp64\www\htdoc2\winkel\includes\modules\content\navigation\cm_navbar.php on line 55
Call Stack
# Time Memory Function Location
1 0.0000 408376 {main}( ) ...\index.php:0
2 0.1248 757384 require( 'C:\wamp64\www\htdoc2\winkel\includes\template_top.php' ) ...\index.php:43
3 0.1716 880840 oscTemplate->getContent( ) ...\template_top.php:47
4 0.1716 882480 cm_navbar->execute( ) ...\osc_template.php:152
 
Of course I can switch warnings off, but...
Best regards
Eveline

Share this post


Link to post
Share on other sites
Posted (edited)

Hi,

I have a problem with this line 304 of Responsive-osCommerce-1.0.1.0\admin\modules_content.php

      $heading[] = array('text' => '<strong>' . $mInfo->title . '</strong>');

Because when I click on 'Content' in the 'Admin' menu I get this message:

( ! ) Parse error: syntax error, unexpected '$heading' (T_VARIABLE) in C:\wamp64\www\htdoc2\winkel\achter\modules_content.php on line 309
Edited by Denkster
added cause and message

Share this post


Link to post
Share on other sites

Hi,

When I click on 'Actions' in the admin  menu I get these messages:

( ! ) Warning: scandir(C:/wamp64/www/htdoc2/winkel/includes/actions/,C:/wamp64/www/htdoc2/winkel/includes/actions/): Het systeem kan het opgegeven bestand niet vinden. (code: 2) in C:\wamp64\www\htdoc2\winkel\achter\modules_actions.php on line 36
Call Stack
# Time Memory Function Location
1 0.0000 408232 {main}( ) ...\modules_actions.php:0
2 0.0200 693504 scandir ( ) ...\modules_actions.php:36

 

( ! ) Warning: scandir(C:/wamp64/www/htdoc2/winkel/includes/actions/): failed to open dir: No such file or directory in C:\wamp64\www\htdoc2\winkel\achter\modules_actions.php on line 36
Call Stack
# Time Memory Function Location
1 0.0000 408232 {main}( ) ...\modules_actions.php:0
2 0.0200 693504 scandir ( ) ...\modules_actions.php:36

 

( ! ) Warning: scandir(): (errno 2): No such file or directory in C:\wamp64\www\htdoc2\winkel\achter\modules_actions.php on line 36
Call Stack
# Time Memory Function Location
1 0.0000 408232 {main}( ) ...\modules_actions.php:0
2 0.0200 693504 scandir ( ) ...\modules_actions.php:36

 

( ! ) Warning: array_diff(): Expected parameter 1 to be an array, bool given in C:\wamp64\www\htdoc2\winkel\achter\modules_actions.php on line 36
Call Stack
# Time Memory Function Location
1 0.0000 408232 {main}( ) ...\modules_actions.php:0
2 0.0200 693504 array_diff ( ) ...\modules_actions.php:36

 

( ! ) Warning: Invalid argument supplied for foreach() in C:\wamp64\www\htdoc2\winkel\achter\modules_actions.php on line 38
Call Stack
# Time Memory Function Location
1 0.0000 408232 {main}( ) ...\modules_actions.php:0

Actions Directory: C:/wamp64/www/htdoc2/winkel/includes/actions/

Share this post


Link to post
Share on other sites

Sorry,

I found the answer to my last question:

I had missed the folder Responsive-osCommerce-1.0.1.0\includes\actions\

Please excuse my ignorance..

Best regards

Eveline

Share this post


Link to post
Share on other sites

Hi,

I found the solution for the warnings on the front page of my shop , those about undefined constants MODULE_CONTENT_NAVBAR_...  in C:\wamp64\www\htdoc2\winkel\includes\modules\content\navigation\cm_navbar.php

I needed to add those constants to the table configuration.

Sorry for bothering anyone...

Bye

Eveline

Share this post


Link to post
Share on other sites
Posted (edited)
10 hours ago, Denkster said:

Hi Burt and other 'godfathers',

Thank you very very much for the great work you accomplished making Phoenix 1.0.

I am in the process of updating my existing web shop to Phoenix 1.0.1.0, which is hard, since I used a lot of mods.

I the meantime, I came across issues with some of the files of 1.0.1.0.

The errors you report here are errors of your uncomplete update, they are not errors produced by the Phoenix 1.0.1.0 files. Please revise your update and try to replace complete files if possible.

In general terms it would be easier to start from scratch with a clean Phoenix 1.0.1.0 installation. Then redo your modifications and add the addons you need. Consider that Phoenix is much more modular than your old store. So the installation of addons and other modifications are doen different than in your old store. Avoid core file changes like they were necessary in your old store, as much as possible.

7 hours ago, Denkster said:

Hi,

I have a problem with this line 304 of Responsive-osCommerce-1.0.1.0\admin\modules_content.php


      $heading[] = array('text' => '<strong>' . $mInfo->title . '</strong>');

Because when I click on 'Content' in the 'Admin' menu I get this message:

( ! ) Parse error: syntax error, unexpected '$heading' (T_VARIABLE) in C:\wamp64\www\htdoc2\winkel\achter\modules_content.php on line 309

This error only existed in Phoenix 1.0.0.0. Please replace the complete file with the version supplied in 1.0.1.0 or higher. The wrong code is not visible in a normal text editor. You have to replace the whole file.

 

5 hours ago, Denkster said:

I found the solution for the warnings on the front page of my shop , those about undefined constants MODULE_CONTENT_NAVBAR_...  in C:\wamp64\www\htdoc2\winkel\includes\modules\content\navigation\cm_navbar.php

I needed to add those constants to the table configuration

Instead to add manually missing constants to the database, you'd better uninstall and reinstall the module. This is more safe.

Edited by raiwa

Share this post


Link to post
Share on other sites
Posted (edited)

Dear Raiwa,

Thanks you for your answer. Of course starting over with a new installation Will prevent lots of Trouble...

You wrote:

"This error only existed in Phoenix 1.0.0.0. Please replace the complete file with the version supplied in 1.0.1.0 or higher. The wrong code is not visible in a normal text editor. You have to replace the whole file."

How is that possible? 

I use Beyond Compair..

Best regards

Eveline

Edited by Denkster
Typo

Share this post


Link to post
Share on other sites
On 7/20/2019 at 7:24 AM, Denkster said:

where van I find a list of changes to the database from 2.3 to Phoenix?

Is the above mentioned script stille useable?

 

Share this post


Link to post
Share on other sites
1 hour ago, Denkster said:

How is that possible?

No idea, some copy paste corrupted the code. I could only see the bad characters in the code editor here in the forum.

See GitHub:

https://github.com/gburton/Responsive-osCommerce/commit/05b4d809ff2e87a9f46d76cd8699740c3d2c5389

Share this post


Link to post
Share on other sites
Posted (edited)

There is something I'd like to get straight about "Phoenix";

There is no way to get the database from 2.3.4 BS Gold into it except by hand and some modules, such as Canada Post shipping and PayPal may or may not work with it?

Edited by Druid6900

No Good Deed EVER Goes Unpunished

Share this post


Link to post
Share on other sites
45 minutes ago, Druid6900 said:

There is no way to get the database from 2.3.4 BS Gold

This has been a stumbling block from day one! For any new version to be taken seriously a data import function needs to be built into the core or offerd as a stock add-on.

Hopefully hpdl will have this in official Version 3 when it comes out.

It clearly can be done as others carts offer this function!.

 

image.png.8c8fe7c678e304f65a9e3ad7b671bcb8.png


 

Share this post


Link to post
Share on other sites

Yes, I'd have to agree.

The shipping and payment modules would PROBABLY work, but, I have thousands of items and we are looking at a lot of paid person-hours to put them all back in. It's not really worth the effort or expense.

I guess it's a fine program if you're just starting a store, but for an established one, it's a deal-breaker.

I recall going for MS2.2 to 2.3.1 using a series of scripts to convert the initial database and they worked perfectly.


No Good Deed EVER Goes Unpunished

Share this post


Link to post
Share on other sites
54 minutes ago, Druid6900 said:

Yes, I'd have to agree.

The shipping and payment modules would PROBABLY work, but, I have thousands of items and we are looking at a lot of paid person-hours to put them all back in. It's not really worth the effort or expense.

I guess it's a fine program if you're just starting a store, but for an established one, it's a deal-breaker.

I recall going for MS2.2 to 2.3.1 using a series of scripts to convert the initial database and they worked perfectly.

I dont understand why its a deal breaker. It would take someone that knew what they were doing a few hours work to transfer the relevant database tables to a new database. I had someone do it the last time i upgraded from ms2 to BS Edge and the cost was a lot less than I thought it would be. Not every table needs to be transferred. it is probable something that many could do themselves but I have no inclination to mess with my database, its been working for too long.

As to converting your addons, that may take a lot longer, but  most software needs updating at some point and if you rely on your store to earn money then what ever money is spent on your store is a business expense and should be factored in to your pricing. Think of a website upgrade and a repaint of a bricks and mortar store. Most payment modules will work as far as I know. The big problem will be updating them for the latest strong customer authentication updates next month. The admin side has been left and is still very much the same as all the BS versions and even as far back as 2.3 versions so admin mods will require no modifications hopefully.


REMEMBER BACKUP, BACKUP AND BACKUP

Get the latest Responsive osCommerce CE (community edition) here

It's very easy to over complicate what are simple things in life

Share this post


Link to post
Share on other sites

@Druid6900  I am not a coder or developer and have no expertise but just upgraded from Frozen to Phoenix and transferred database data with little problem and we have 1000's of products. PhpMyadmin (or similar) database is easy to use - compare tables (there are very few differences anyway), export data from one table and import data into the other. Sure there is help here on the forum for advice if you need it.

Share this post


Link to post
Share on other sites

I've upgraded from an old Osc 2.3.4 version through to BS Gold, BS CE and now phoenix, with no problems.  Just compare the DB schema and export/import.  Addons are updated to suit latest php version and code standards.


osC BS gold live - osC CE in development (awesome)

Share this post


Link to post
Share on other sites

It is something to consider should we ever get a space of time that is quiet.

I know my way around a database and know enough that one mistake and you have to reload the DB backup and start again.

Maybe some Sunday on a holiday weekend we will give it a shot since we back up the database and entire site on a daily basis.

There is an old adage about "if it's not broke...."


No Good Deed EVER Goes Unpunished

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×