Hi, I think Cook is amazing, so thank you so much for an amazing tool.
Search:
I have a problem where when I test in the sandbox the search facility works absolutely fine but when I upload the component to my site (I'm using Joomla 1.5) the search finds no entries at all.

Can anyone please give me some guidance as I really need this to work?
Can anyone point me in the right direction to getting this solved.

many thanks,
Terry.

To troubleshoot in the first instance I've installed a fresh joomla 1.5 on my local server and installed my component ... and the search works fine.

So could anyone suggest where I should look on my live site to work out what is causing the search not to work.

1) Could it be our hosting company?
2) Could it be another component?
3) Could it be a module?
4) Could it be a plugin?

I'm not asking anyone to work it out for me guys just a heads-up in the right direction would be much appreciated.

kind regards,
Terry.

Can anyone help point me in the right direction to get the 'search and reset' working on my production site?

As I mentioned in the above post I have tested in a fresh joomla 1.5 and it works so I guess there must be something interfering with my component on the production site.

I've disabled everything I don't need and am struggling to find what it could be.
Thank you in advance, Terry.

It is strange.

I think the best way is to dump the query and to test it in phpmyadmin.

On wich type of data do you make the search ?

Hi, thanks for replying.
My project component is called EssentialReading, there is x3 tables but the table I'm searching is called 'books' and I'm just trying searching for words in the 'title' (datatype - string) and the 'description' (datatype - text).
thanks, Terry.

I've done a search in phpmyadmin, I did the search on the iSBN field for the book.... and it worked, it found the record in question. Does that help narrow the problem down?

Hi Admin, I still can't get the search and reset to work correctly.
The hosting company for the production server is HostPapa and I have another copy of the site on a dedicated server with another company and it doesn't work on either of them.

BUT it works fine in your sandbox and also on my local mac, using MAMP but not on the above two external servers.

What can the answer be?
Any help would be much appreciated as I'm sure I will need to use the search and reset on other components I build.
kind regards, Terry.

Hi Terry,

It might be worth a little trouble shooting to 'spot the difference' at this stage. I would start by the quick little php program:

<?php
phpinfo();
?>

Run that on

A) your MAMP setup (which is done for you I believe from MAMP 'WebStart' page) then

upload or create the same code snippet on your Dedicated and Shared hosting server accounts.

Except that leaves out the obvious... checking same on J-Cook Pro server which only Jocelyn (Admin) can possibly provide. I'm certain that if you ask him nicely he might be able to do something for you..

Then compare the output from each looking for missing/differences in Libraries or other includes.

Hope that helps a little,

Regards,

Edward.

Thanks Edward, appreciate your reply, yes I'll do that.

It is a strange problem as I thought it was perhaps Hostpapa, so when I uploaded it to our dedicated server housed elsewhere I was surprised to see it not working on that as well.

Can I ask if anyone else has had problems with search/reset in their components?
And if so did they find any answers?

Will keep you posted on the comparisons.

kind regards,
Terry.

I cannot solve your problem from here.

If your query answer a good result, maybe it come from a the pagination.

Can you dump the list of items and see the result from PHP ?

Try step by step to find what is the SQL problem. It should be a SQL problem.
Do you use another database driver than MySQL ?

Hi, the database driver is MySQLi on the production servers, perhaps that is the problem?
If so could you advise on how to amend the component to work with this?

kind regards,
Terry.

Do you think it could the mysqli driver Admin?
I'm still trying to find out the problem with the search and reset not working.
Has anyone else had problems with this?

I need to try.

Is somebody else using MYSQLi ?

Never tried yet.