| mariovaldez.net http://www.mariovaldez.net/webapps/forums/ |
|
| Unknown column - products.products_id in 'on clause' http://www.mariovaldez.net/webapps/forums/viewtopic.php?f=12&t=270 |
Page 1 of 1 |
| Author: | mehulno1 [ 02 Jan 2006, 10:52 ] |
| Post subject: | Unknown column - products.products_id in 'on clause' |
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 |
|
| Author: | bobbus [ 19 Jan 2006, 06:34 ] |
| Post subject: | PHP5 & MySQL5 compatibility |
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 |
|
| Author: | mvaldez [ 23 Jan 2006, 12:02 ] |
| Post subject: | MySQL 5 compatibility. |
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. |
|
| Author: | Gadd [ 27 Jan 2006, 14:27 ] |
| Post subject: | RE:Unknown column - 'products.products_id' in 'on clause' |
Yes, version 250 works fine and solve the problem. Thanks |
|
| Author: | Xinirnix [ 20 Mar 2006, 16:02 ] |
| Post subject: | Re: Unknown column - products.products_id in 'on clause' |
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 |
|
| Author: | Guest [ 13 Apr 2006, 15:01 ] |
| Post subject: | Re: MySQL 5 compatibility. |
> 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 |
|
| Author: | Guest [ 14 Apr 2006, 02:42 ] |
| Post subject: | |
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 |
|
| Author: | Guest [ 06 Jul 2006, 07:14 ] |
| Post subject: | Re: MySQL 5 compatibility. |
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 |
|
| Page 1 of 1 | All times are UTC - 7 hours |
| Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |
|