2006-01-31, 09:30 PM
I am getting this error while trying to do a search:
mySQL error: 1064
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 'AND p.message LIKE '%keyword%'OR AND p.subject LIKE '%keyword%')
Query: SELECT p.tid FROM mybb_posts p, mybb_threads t WHERE (1=0 OR AND p.message LIKE '%keyword%'OR AND p.subject LIKE '%keyword%')
I have mysql 4.1.15 on my server with php 4.4.1.
mySQL error: 1064
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 'AND p.message LIKE '%keyword%'OR AND p.subject LIKE '%keyword%')
Query: SELECT p.tid FROM mybb_posts p, mybb_threads t WHERE (1=0 OR AND p.message LIKE '%keyword%'OR AND p.subject LIKE '%keyword%')
I have mysql 4.1.15 on my server with php 4.4.1.