advance search broken

Next
 From:  phonx (DDRAGON)
470.1 

Hi;

Just to let you know the advance search is broken. Search user also broke.

  Reply Reply More Options
Post Options
Reply as PM Reply as PM
Print Print
Mark as unread Mark as unread
Relationship Relationship
IP Logged

Previous
Next
 From:  phonx (DDRAGON)
470.2 In reply to 470.1 
Error Message for server admins and developers:
Unknown error [1364]

Field 'KEYWORDS' doesn't have a default value

INSERT INTO SEARCH_RESULTS (UID, FORUM, FID, TID, PID, BY_UID, FROM_UID, TO_UID, CREATED) SELECT 296, 1, THREAD.FID, POST.TID, POST.PID, THREAD.BY_UID, POST.FROM_UID, POST.TO_UID, POST.CREATED FROM MOI_POST POST LEFT JOIN MOI_THREAD THREAD ON (THREAD.TID = POST.TID) LEFT JOIN MOI_USER_PEER USER_PEER ON (USER_PEER.PEER_UID = THREAD.BY_UID AND USER_PEER.UID = 296) WHERE THREAD.FID IN (1) AND POST.CREATED >= FROM_UNIXTIME(1157864400) AND POST.CREATED <= FROM_UNIXTIME(1157950799) AND (POST.FROM_UID = '296' OR POST.TO_UID = '296') AND ((USER_PEER.RELATIONSHIP & 8) = 0 OR USER_PEER.RELATIONSHIP IS NULL) AND ((USER_PEER.RELATIONSHIP & 2) = 0 OR USER_PEER.RELATIONSHIP IS NULL)


Unknown error in line 134 of file db_mysql.inc.php

Beehive Forum 0.6.3 on PHP/5.1.1 WINNT ISAPI MySQL/50022
  Reply Reply More Options
Post Options
Reply as PM Reply as PM
Print Print
Mark as unread Mark as unread
Relationship Relationship
IP Logged

Previous
 From:  Michael Gibson
470.3 In reply to 470.1 
Thanks for reporting this Phonx. It looks like this will happen if you don't fill in anything in the keywords section. I'd like to tune this up later on but I probably won't have a chance to work on it until the software for V1 is all ready.

- Michael
  Reply Reply More Options
Post Options
Reply as PM Reply as PM
Print Print
Mark as unread Mark as unread
Relationship Relationship
IP Logged
 

Reply to All Reply to All