Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Mysql Questions!!!


Recommended Posts

Ok here's a question:


Fact 1:

I'm running a clustering enviorment with two linux boxes. To different physical IP address so that I can have redudancy and high availabilty running OS Commerece.


Fact 2: OS Commerece functions on both boxes


Fact 3: OS commerece on box 1 works correctly when populating the manufacters category description with any informatoin and displays fine.


On box 2, when populating the database through the admin interface, the variables I'm afraid don't pass through the value's all the way through. I've taken the same code from both boxes and it works on one but not the other.


After it so called inserts the information through, it list a folder but not the TEXT description. ???? What's wrong here? Is the table getting corrupted somehow?



Fact 4: The common denominator is the php code is the identical, but the difference is the MYSQL database.


When I manualy insert the data in the mysql database, it will display fine but and so I deconstructed the code to see where might be the problem but im blind cuz i've spent 2 days on this.


I've enabled logging sessions so that I can view the log views to verify that the code on box 2 is actually passing info through and it is.


So my real question is , what should i be looking for in MYSQL to have it spit out errors or is the tables themselves getting corrupted somehow?




Help me Community!



Link to comment
Share on other sites

Please refrain from cross posting. This thread is now locked.

Mark Evans

osCommerce Monkey & Lead Guitarist for "Sparky + the Monkeys" (Album on sale in all good record shops)



Software is like sex: It's better when it's free. (Linus Torvalds)

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...