Jump to content

ricarios

Members
  • Content count

    9
  • Joined

  • Last visited

Profile Information

  • Real Name
    ricarios
  1. The MySQL 3 and 4 -servers are going to be switched off. So I'm desperately trying to upgrade at least the used MySQL 3.23.58 to 5.6.19 in order to prolong its life till I have a complete new online shop. I could succesfully import the old 3-database into the new 5-database. But when clicking on categories or manufacturer this error appears: 1054 - Unknown column 'p.products_id' in 'on clause' select count(*) as total from products p, products_description pd, manufacturers m left join specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '56' I thought version 5 is compatible with 3 ?
  2. ricarios

    1&1 ipayment

    I just discovered this. Thank you very much for your kind help !
  3. ricarios

    1&1 ipayment

    1&1 ipayment said to me they just got from oscommerce directly the information that their is a module available. https://apps.oscommerce.com/q=ipayment This is 10 years ago and for 2.2.
  4. ricarios

    2.2 CVS Upgrade steps

    Thank you a lot! I found this too: Converting from OSC 2.2 to 2.3x, for dummies https://docs.google.com/document/d/1AI6RquhcmO-u9GLAofk3RX2w9SWv0ddejdiRemUhWLo/edit
  5. ricarios

    1&1 ipayment

    Is there a module available for 1&1 ipayment (https://www.ipayment.de/) which works with 2.3.4.1 ?
  6. ricarios

    2.2 CVS Upgrade steps

    I looked into the database and was very surprised: The old and the new are nearly identical. But I noticed there is also a new column called Collation. Shall I convert my old Database with notepad+ to utf8 and then just import it? Will that work? Intended working flow: 1. Export old DB (MYSQL3) to a temporary empty DB (MYSQL55) 2. Delete all obsolete tables like "login, permissions" etc. 3. Export DB and convert to UTF 8 4. Import into new DB Something missing?
  7. ricarios

    2.2 CVS Upgrade steps

    Yes, its still active and working fine. I have everything here: phpMyAdmin, PHP 5 & 7 and MySQL 3 - 5 I have a lot of headache because of my old database. You wrote " (adding tables and data, modifying existing tables, etc.). " Where can I find detailied instructions about the new schema? That will work, really?
  8. ricarios

    2.2 CVS Upgrade steps

    We're running a very very old 2.2 CVS which lies between 2.2 MS1 and MS2 Could someone help me which steps I have to do? To which version I should start first and then how to continue? Is it possible to upgrade the MySQL 3 database to MySQL 5?
×