Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1054 - Unknown column - character missing on URL


tonyh

Recommended Posts

Good People.

 

I need your help I have messed up my code. All of a sudden I now have a product not found or 1054 - Unknown column error when I click on product to view detials.

 

On a closer analysis the error is caused by the script not assigning an "&" as below (after category ID - 28)

 

catalog/product_info.php?cPath=28products_id=2&osCsid=5a9xxxxxxxxx

 

If I add manually add "&" to read

 

catalog/product_info.php?cPath=28&products_id=2&osCsid=5a9xxxxxxx the page loads correctly.

 

How do I get around this problem?

Link to comment
Share on other sites

Good People.

 

I need your help .............

 

How do I get around this problem?

 

 

Got it!. Because I have been using word and note pad to edit code, these introduced spurious control characters into the php code that messed up the scripts. Backing up and a software to compare code are surely a must.

 

thanks for your time.

Link to comment
Share on other sites

Because I have been using word and note pad to edit code, these introduced spurious control characters into the php code that messed up the scripts.
Do yourself (and us) a favor and download a real editor. Something like JEdit (OSS) is a real help: color codes text, will show you matching braces ( { } ) if you put your cursor next to one and much more.
Link to comment
Share on other sites

Do yourself (and us) a favor and download a real editor. Something like JEdit (OSS) is a real help: color codes text, will show you matching braces ( { } ) if you put your cursor next to one and much more.

 

 

Your are a blessing JanZ. Thanks lots for the code URL.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...