I'm on the 6.9.4 and get a weird error on the search.php page. Im going to try updating to the 7.0.0 to see if that helps, but any insight would be great.

pNumSales would be a new column that should be in your database. Last time you updated, perhaps you did not run the updatestore.php script in your browser and that would explain why that column does not exist.

that field is in there. I added a couple of custom rows as well via phpmyadmin. Not sure if the order of the rows matters. I wouldnt think that it would, but pNumSales is definitely there

I would either run through the 6.9.4 updater again, or run the new 7.0.0 and see what you get.

I'm up to 7.0.0 and still the same.

The end of my products table looks like this:

pMetaDesc varchar(255) utf8_general_ci Yes Browse distinct values Change Drop Primary Unique Index Fulltext
pMinQuant int(11) Yes 0 Browse distinct values Change Drop Primary Unique Index Fulltext
pCustom4 tinyint(4) Yes NULL Browse distinct values Change Drop Primary Unique Index Fulltext
pCustom5 tinyint(4) Yes NULL Browse distinct values Change Drop Primary Unique Index Fulltext
pCustom6 tinyint(1) Yes NULL Browse distinct values Change Drop Primary Unique Index Fulltext
pCustom7 tinyint(4) Yes NULL Browse distinct values Change Drop Primary Unique Index Fulltext
pPopularity int(11) No 0 Browse distinct values Change Drop Primary Unique Index Fulltext
pNumSales int(11) No 0 Browse distinct values Change Drop Primary Unique Index Fulltext

I added a few custom rows before a previous update that added the pPopularity and pNumSales. It seems like that should matter, but that is the only thing that I can possibly think that is different...

Also, it only does that error when it would return a search result. If I put something that would not return a result, it operates normally (by having the message that there are no results...).

If you ran the update store in your browser successfully with no errors, I expect the extra columns in the database are not really a problem.

Is this an unmodded install?
I would check the dates on the files on the server to be sure all files were updated.
If you use a custom admin, be sure you not only updated that one, but the vsadmin (transfer files) as well.

As near as I can tell, and with no other reports of search problems on 7.0, and knowing that I have a test site on 7.0, I think the error points to the database and files on the server not matching.

Of course, this is only my thoughts and I expect Andy or someone else will be along shortly with additional assistance.

no, mods on it. Based on the error, is there anything else I should be looking at?

Try adding this to the includes first and see if it cures the issue
$nosearchbyfilters=TRUE;

If it doesn't, take a backup of the products table, remove the custom fields you have added and re-import the table, then test it.



* Database Migrations and Conversions*
* ASP to PHP Cart Conversions*
*Contact Us*
*Buy The PHP Capture Card Plugin*
*Rate Our Services/View Our Feedback*

Stil doesnt seem to work. Does anyone know what this means:

Unknown column 'pNumSales' in 'order clause'

Possibly the answer lies there? The column is definitely there. In fact I dropped the column and then re-created it using the updatestore.php and still nothing. It only generates that message when there is a hit in the results. Otherwise if it did not return a result it shows the appropriate message.

function ect_free_result($ectres){
@$GLOBALS['ectdatabase']?$ectres->free_result():mysql_free_result($ectres);
}

This is the code on line 1747 that is generating the fatal error. Does this offer any clue as to what the solution might be?

Hi Chris

quote:

---

Unknown column 'pNumSales' in 'order clause'
Sorry, no products matched your search.

---

I'm sorry about the problems here but it does seem to be a bug and I've fixed this now. Can you get a new copy of the incsearch.php script from the updater and copy that to your site and it should sort it out.

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater