No results on hosted site?
g051798 - July 12, 2009 - 03:54
| Project: | Autocomplete Node Finder |
| Version: | 5.x-3.9 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
Description
Hello,
I was able to get this block working on my local dev box. However, after uploading to prod, it doesn't return any results in the autocomplete. It just spins for a while and returns nothing. Its an exact duplicate copy of my database and files on production as it is in dev. It does return the results if i hit the submit button. Does anyone have an idea of why the ajax dynamic results portion doesn't work? Thanks for any ideas.
John
#1
Hello,
These are the error messages i am getting from log:
Sun Jul 12 13:05:04 2009] [error] PHP Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= '') ORDER BY random_sort ASC LIMIT 0, 30' at line 1\nquery: SELECT node.nid, rand() AS random_sort FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid WHERE (term_node.tid = '72') AND (node.type IN ('clip')) AND (node.status = '1') AND (.word = '') ORDER BY random_sort ASC LIMIT 0, 30 in /home/g051798/public_html/includes/database.mysql.inc on line 174
[Sun Jul 12 13:05:04 2009] [error] PHP Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= '')' at line 1\nquery: SELECT count(node.nid) FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid WHERE (term_node.tid = '72') AND (node.type IN ('clip')) AND (node.status = '1') AND (.word = '') in /home/g051798/public_html/includes/database.mysql.inc on line 174
Thanks for any help,
John
#2
any idea what this part of the query might be trying to refer to ?
(.word = '')#3
Sorry, the previous sql errors were due to a different views problem. Unfortunately, I don't have any errors that are reported in the logs to determine what the problem is. So, it works great locally on my laptop. However, on my hosted site it just spins for a while and then stops with no autocomplete drop list. I can get the results on the remote site if i go to the url directly:
http://www.videobjj.com/?q=autocomplete_node_finder/autocomplete/0/test
Is there anything I can do to turn on debugging or try something?
Thanks for your help,
John
#4
You could have network connection problems ? No idea what you can do other than to manually debug whether the autocomplete function is getting hit and if so what is it doing, etc...
#5
You are right. I signed up for a free hosting service and it was causing me all kinds of headaches (quipis.com). I switched to a new host and it works great! Thanks