Weird Error with cPath

[Guest]

Hi

 

I cant bottom out this issue PLEASE HELP

 

I am just setting up a site, i installed the site and have the usual demo products... all worked well UNTIL

 

I installed a new template and now i get an error "1054 - Unknown column 'p.products_id' in 'on clause'"

 

BUT before everyone tells me to search the knowledge base i can see this error is a bit weirder than that

 

If i go to my menu where as when i first installed the site 'hardware' was index.php?cPath=1 and a sub menu item would be index.php?cPath=1_2 for example

NOW

All my sub items have 21 at the begining!!! for example 'hardware' is still index.php?cPath=1 a sub item is index.php?cPath=21_1_2

 

Where the hell is the 21 coming from???????

 

(on another note i seem to have lost some links but they i have fixed by hardcoding the php)

 

Any help greatfully appreciated

[MrPhil]

Fix the 1054 problem first, and maybe the "21" problem will go away. No guarantees, but you might as well fix the 1054 problem, as it's not hard to figure out what's going on, and with luck that will also fix the other problem. Has your system recently changed to MySQL version 5? If so, osC requires fixes: http://www.oscommerce.com/forums/topic/335136-osc-and-mysql-5-1054-errors . Even if you've been at MySQL 5 for a while (having made the fixes earlier?), the template code may be written for MySQL 4 and earlier. Can you show the complete query that's failing? Are JOINs involved, with a list of tables on the left side?

[Guest]

Fix the 1054 problem first, and maybe the "21" problem will go away. No guarantees, but you might as well fix the 1054 problem, as it's not hard to figure out what's going on, and with luck that will also fix the other problem. Has your system recently changed to MySQL version 5? If so, osC requires fixes: http://www.oscommerce.com/forums/topic/335136-osc-and-mysql-5-1054-errors . Even if you've been at MySQL 5 for a while (having made the fixes earlier?), the template code may be written for MySQL 4 and earlier. Can you show the complete query that's failing? Are JOINs involved, with a list of tables on the left side?

 

Hi

 

I have done all that and still get the error, i only get it when selecting something out of the menu... if i select from for example "new products" i can see the product fine

 

Also not sure how to show the query, i just look what its doing when i hover over the menu

 

Anything else worth trying?

[Guest]

Hi

 

I have done all that and still get the error, i only get it when selecting something out of the menu... if i select from for example "new products" i can see the product fine

 

Also not sure how to show the query, i just look what its doing when i hover over the menu

 

Anything else worth trying?

 

FIXED IT! The menu still appears freaky when i hover over it with this phantom number at the begining but it works, i fixed it by following a link in the post you sent me a link to, it contained some additional changes i needed to make

 

One weird site effect is some of my links are now dead, for example shopping cart is "http://thediamondrevolution.com/%27.tep_href_link(FILENAME_SHOPPING_CART) so thats now my next challenge

 

Thanks for the support