whos online Who's online didn't show items after changing to MySQL 5.6.19

[mausmaki]

Hello!

After change from MySQL 3 to MySQL 5 using Oscommerce contribution

Error Message - 1054 - Unknown column 'p

I have the following problem:

The (original milestone 2.2!) who's online tool works but shows no items. The sql database entries are all up to date, entries are written into database.

What to do?

 

[YePix]

look on jour sql_query

[mausmaki]

vor 7 Minuten schrieb Yepi:

look on jour sql_query 

I am not an expert. Please explain a bit further!

[puddlec]

you should consider upgrading to phoenix edition of osCommerce, available at

https://www.oscommerce.com/Products

as the version you are currently using is ancient,

some reasons to update to phoenix

easier install of addon's (no changes to core files)

mobile responsive

works on modern versions of PHP and MYSQL

etc

 

 

 

[YePix]

you should not always believe what you hear or read! There are serious differences in osCommerce! I just hope that you have a backup of your previous software

[mcmannehan]

May you should not use the outdated osC 2.2. it's the same you would still use Windows 98. Change your system to Phoenix.

 

[mausmaki]

Yes, I do that at moment and will switch to Phoenix, but Domainfactory closed MySQL3 and I was forced to change things.

I solved the above problem in changing the configure.php under  webseiten/catalog/admin/ to correct values. Now access to new database
 (MySQL5 format) in admin area is working.

But there exists (I didn't do this!) an admin area under /webseiten/admin/ and if I use the administration panel all clicks were directed to  /webseiten/admin/  instead of webseiten/catalog/admin/

Where is the place I change this?

 

[♥JcMagpie]

20 minutes ago, mausmaki said:

Where is the place I change this?

Check path setting in webseiten/catalog/admin//includes/configure.php

[mausmaki]

Yes, true, I found it and different parameters were set wrong there.
After I changed to a formerly working version with new database paths its working again.

 

[Mary Williams]

upgrading would work