MyBB Community Forums
Discuss: MyBB 1.03 Released - Security Update - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: Community Archive (https://community.mybb.com/forum-106.html)
+--- Forum: Archived Forums (https://community.mybb.com/forum-143.html)
+---- Forum: Miscellaneous Archive (https://community.mybb.com/forum-140.html)
+----- Forum: Old Announcements (https://community.mybb.com/forum-2.html)
+------ Forum: Announcements Discussion (https://community.mybb.com/forum-31.html)
+------ Thread: Discuss: MyBB 1.03 Released - Security Update (/thread-6419.html)

Pages: 1 2 3 4 5


RE: Discuss: MyBB 1.03 Released - Security Update - Michael S. - 2006-01-31

Hi Chris,

thanks for the update. But there's one problem: The search function does not work:
Quote: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 '%test%'OR AND p.subject LIKE '%test%') AND t.fid NOT IN ('1' at line 1
Query: SELECT p.tid FROM posts p, threads t WHERE (1=0 OR AND p.message LIKE '%test%'OR AND p.subject LIKE '%test%') AND t.fid NOT IN ('14','15','16','33')



RE: Discuss: MyBB 1.03 Released - Security Update - skeletor - 2006-01-31

yea, i get this error when trying to search as well.. everything else seems to be working fine, but after submitting a search it sends out that error on a plain white page. and my forums search worked just before i updated.


/edit- just tried to search on this forum and it did the same thing Toungue


RE: Discuss: MyBB 1.03 Released - Security Update - Aaron - 2006-01-31

same here!

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 '%tech%'OR AND p.subject LIKE '%tech%')' at line 1
Query: SELECT p.tid FROM mybb_posts p, mybb_threads t WHERE (1=0 OR AND p.message LIKE '%tech%'OR AND p.subject LIKE '%tech%')


RE: Discuss: MyBB 1.03 Released - Security Update - Chris W. B. - 2006-01-31

Quote: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 '%tech%'OR AND p.subject LIKE '%tech%')' at line 1
Query: SELECT p.tid FROM mybb_posts p, mybb_threads t WHERE (1=0 OR AND p.message LIKE '%tech%'OR AND p.subject LIKE '%tech%')

there's a fix here: http://community.mybboard.net/showthread.php?tid=6423&action=lastpost

----
Thanks for the update. applyed Smile.


RE: Discuss: MyBB 1.03 Released - Security Update - skeletor - 2006-01-31

awesome!
thanx very much.
keep up the good work!


RE: Discuss: MyBB 1.03 Released - Security Update - zaher1988 - 2006-01-31

Regarding the fix
however it was a part of the fix, but it seems u will have to do it Smile


regards



RE: Discuss: MyBB 1.03 Released - Security Update - decswxaqz - 2006-01-31

I'm having trouble with logging in since the upgrade. Yes I've cleared my cookies but I still have to keep logging in it seems my session have timed out.
Not sure why but even clearing my cookies requires me to login a few times before it remembers me.


RE: Discuss: MyBB 1.03 Released - Security Update - Ryan Gordon - 2006-01-31

going to install patch when I get out of school Smile


RE: Discuss: MyBB 1.03 Released - Security Update - Ryan Gordon - 2006-01-31

Installed, and applied the search fix. Thanks guys Smile


RE: Discuss: MyBB 1.03 Released - Security Update - Will78 - 2006-02-01

http://community.mybboard.net/showthread.php?tid=6423&pid=38921#pid38921

this I can not find in the search.php at all