Error 1054 - 2.0 RC4 2.0.4 and 2.0.25 fresh installs

[mad_dexter]

I have installed 2.0.25 as a new installation with a new webhost running php 5.3.2. My previous OscMax 2.0RC3 site had been hacked. I am now trying to recover from this with a clean install with the latest revision.

Installation went well, I copied my site template from a backup to the new template subdirectory, then entered 1 product to test the system. This displays fine when browsed by category from the left frame. But when searching on product code (E-40CRP) I get the following error:

Products meeting the search criteria

1054 - Unknown column 'p.products_id' in 'on clause'

select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id), products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%e-40crp%' or p.products_model like '%e-40crp%' or m.manufacturers_name like '%e-40crp%' or pd.products_description like '%e-40crp%') )

[TEP STOP]


I have since back tracked in revisions, using clean installs of 2.0.4 then 2.0 RC4. All give the same error.

I see this error occurs when multi shops, but I have not installed this. Does anyone have any suggestions how to resolve this issue. I am not a programmer, but can follow instructions!

The site can be accessed at 188.64.184.62/catalog

Cheers.

[ridexbuilder]

osCommerce: Error Message - 1054 - Unknown column 'p.products_id' in 'on clause'
Looks like PHP version is the problem.
Check if the SVN has been fixed and grab that instead.
oscmax2 - Project Hosting on Google Code

And after Googling for 10 seconds more...
http://forums.oscommerce.com/topic/3...-in-on-clause/

[mad_dexter]

Thanks for prompt reply.

I thought that php 5+ was a requirement for OscMax 2.0.4 and above? Not sure about 2.0 RC4.

What do you mean by SVN being fixed and what is SVN?

Cheers.

[ridexbuilder]

5.3 isn't 5.0-5.2.9
Click the links.

[pgmarshall]

SVN.

Basically - if you click the developers link in the header of all of the pages on this site you will find a google code site which shows the osCmax developers submitting code to the SVN.

There are two branches - 2.0.x and 2.1.

Have a browse and a bit of a google ... if you need a SVN client (used to download the code) try here.

Regards,

[michael_s]

This error is not present in a default 2.0.25 install. It is fully compatible with php 5.3 and mysql5. I just tested a fresh installation of osCmax 2.0.25 on a server running apache 2.2.14, php 5.3.1 and mysql 5.1.41 and the search function works fine.

I suspect your custom template that you copied over. It was made for an older version of osCmax (RC3 it looks like) so you will have to upgrade it manually. The upgrade process, by necessity, doesn't touch custom templates at all.

Switch back to the fallback template (you should never customize the fallback template, by the way). It should work fine. That will then point you to your custom template content files.

[mad_dexter]

Thanks Michael. I believe you are correct. I have 2.0 RC4 installed at the moment, changed the default template back to fallback and the search worked. I guess this means 2.0 RC4 is also compatible with php5.3.2.

I am going to reinstall 2.0.25 and rerun the test with a single product and fallback templates, then copy each of my template files into my template directory, one at a time, til it falls over.

Once I have identified the offending file(s) is there a relatively easy way for a non-programmer like me to identify and fix the problem code?

Cheers.

[michael_s]

Yes, it is easy to fix. All you have to do is use a file compare software to compare your custom content templates to the default oscmax fallback content templates.

The software will highlight the differences, and you can merge in the changes with the compare software. Makes it very easy.

The first step I suggest is to remove your custom content templates from your template folder. Keep them safe, but just rename the folder from content to custom_files or something. That will make them invisible to the osCmax template engine.

Then switch osCmax to use your custom template. It will use the customized template except it will skip your custom content.

By the way, if you are getting an error with your search, the problem template will be the advanced_search.tpl.php template.