mariovaldez.net

MV.net forums
It is currently 14 Jul 2016, 00:33

All times are UTC - 7 hours




Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 8 posts ] 
Author Message
PostPosted: 02 Jan 2006, 10:52 
Hi,

I am getting connected to database but while I try to click on any product categories. ot gives the following error:

An error occured while processing dataase query
Unknown column - 'products.products_id' in 'on clause'

As a result, I am unable to view any products or for that matter, any features of this seems to be fabulous software.

Can you pls help?

Thanks & best regards,
Mehul


Report this post
Top
  
Reply with quote  
PostPosted: 19 Jan 2006, 06:34 
This error on clause issue is related to some OSCommerce incompatibility issues with MySQL5. To fix the same error (error products.products_id on clause) which you will get in OSC using the search box, please see:

http://www.oscommerce.com/community/contributions,3727

I'm trying to find out how this OSCPMWin talks to Mysql and to change similar queries, but I hope more experienced people are doing the same...

Greetz,
Bobbus


Report this post
Top
  
Reply with quote  
 Post subject: MySQL 5 compatibility.
PostPosted: 23 Jan 2006, 12:02 
User avatar

Joined: 06 Mar 2003, 03:21
Posts: 447
Location: Monterrey, NL, Mexico
Mehul,
Bob:

m> I am getting connected to database but while I try to
m> click on any product categories. ot gives the following error:
m> An error occured while processing dataase query
m> Unknown column - 'products.products_id' in 'on clause'
m> As a result, I am unable to view any products or for that
m> matter, any features of this seems to be fabulous software.

b> This error on clause issue is related to some
b> OSCommerce incompatibility issues with MySQL5.

I have made some modifications and I think the OSCPMWin application is ready for MySQL 5. May you please test it? Please download it from:

http://www.mariovaldez.net/software/oscpmwin/files/oscpmwin_0.1.2.450.zip

or from:

http://www.mariovaldez.net/software/oscpmwin/files/oscpmwin_0.1.2.450_setup.exe

Please let me know if it works Ok.


Regards,

Mario A. Valdez-Ramirez.


Report this post
Top
 Profile  
Reply with quote  
PostPosted: 27 Jan 2006, 14:27 
Yes, version 250 works fine and solve the problem.

Thanks


Report this post
Top
  
Reply with quote  
PostPosted: 20 Mar 2006, 16:02 
I have the same problem but with XAMPP
[PHP: 4.4.1-pl1]

Can someone help me out? I did install also the 0.1.2.450 build of OSCPMWIn version...

mehulno1 wrote:
Hi,

I am getting connected to database but while I try to click on any product categories. ot gives the following error:

An error occured while processing dataase query
Unknown column - 'products.products_id' in 'on clause'

As a result, I am unable to view any products or for that matter, any features of this seems to be fabulous software.

Can you pls help?

Thanks & best regards,
Mehul


Report this post
Top
  
Reply with quote  
PostPosted: 13 Apr 2006, 15:01 
> This error on clause issue is related to some
> OSCommerce incompatibility issues with MySQL5.
http://www.mariovaldez.net/software/osc ... _setup.exe
Please let me know if it works Ok.

Mario,

first I installed Product ManagerV 0.1.2.436, This gave an windows box error, and did not start.
Then I installed Product Manager 0.1.0.434. This version started but this
version gave a (Unknown column - 'products.products_id' in 'on clause') error.

I installed V. 0.1.2.450 recommend as Posted: Mon Jan 23, 2006 12:02 pm (Post subject: MySQL 5 compatibility.)
This version looks great and worked fine (local)

Then I tried to test the ...636 version for database acces without a direct
connection. But this didn't work for me because of my provider settings.

Then I installed V. 0.1.2.450 again, but this gave again an windows error
on startup. Now i can only install V 0.1.0.434, because all other versions
are giving startup errors.
Are there registry settings that are not removed while running uninstall?
I clean the registry manual after each try, but this doesn't help.

Which version can i install best?
greetings nico verlaan


Report this post
Top
  
Reply with quote  
 Post subject:
PostPosted: 14 Apr 2006, 02:42 
Because I could not install 0.1.2.450 on my computer anymore, without
getting a violation error on startup.

I installed 0.1.2.450 on a other "clean" computer.
Here the program started nicely, without error (violation) box
then I copied this oscpwin directory to my usual computer, and it worked
there also nicely again.

nico verlaan


Report this post
Top
  
Reply with quote  
PostPosted: 06 Jul 2006, 07:14 
Anonymous wrote:
> This error on clause issue is related to some
> OSCommerce incompatibility issues with MySQL5.
http://www.mariovaldez.net/software/osc ... _setup.exe
Please let me know if it works Ok.

Mario,

Mario, it works fine now. Thank you.
MfG
Uwe


Report this post
Top
  
Reply with quote  
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 8 posts ] 

All times are UTC - 7 hours


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group