galt
04-15-2002, 11:29 PM
As I proceed along with my work-along CMS, I now need to create new threads from outside of VB. So far I have learned that when I insert a thread row:
I need to set up an invisible forum to attach the threads to (threadid <> 0)
I must set open = 1 (talk about a lousy variable name !!)
I must set visible = 1
That gives me a postable thread.
By accident during testing, I discovered that this was not enough. When I tried to Administratively change the topic name of the thread, I got a fatal error with the VB programs:
*****
Database error in vBulletin 2.2.4:
Invalid SQL: DELETE FROM searchindex WHERE wordid IN (0) AND postid=
mysql error: You have an error in your SQL syntax near '' at line 1
mysql error number: 1064
Date: Sunday 14th of April 2002 08:48:49 PM
Script: http://www.bobcosta.com/bcportal/vbb/bcportal/vbb/postings.php
Referer: http://www.bobcosta.com/bcportal/vbb/postings.php?action=editthread&threadid=16
I am guessing that this is some sort of database inconsistency that was not expected by the VB program. Can someone verify this, or is it some other problem?
If I am correct, IMHO it is a lousy design that causes fatal crashes when the progarm encounters non-fatal dtabase inconsistencies. So I guess I have three questions:
1. What are my chances of getting this fixed by jelSoft in a reasonable time frame?
2. What do I have to do to my thread insert routine to populate the searchindex? I am not sure that I want these "add-on" threads searchable. Then again, maybe I do. I sure would like the option.
3. Are there any other "gotchas" I am headed for that anyone can warn me about?
I need to set up an invisible forum to attach the threads to (threadid <> 0)
I must set open = 1 (talk about a lousy variable name !!)
I must set visible = 1
That gives me a postable thread.
By accident during testing, I discovered that this was not enough. When I tried to Administratively change the topic name of the thread, I got a fatal error with the VB programs:
*****
Database error in vBulletin 2.2.4:
Invalid SQL: DELETE FROM searchindex WHERE wordid IN (0) AND postid=
mysql error: You have an error in your SQL syntax near '' at line 1
mysql error number: 1064
Date: Sunday 14th of April 2002 08:48:49 PM
Script: http://www.bobcosta.com/bcportal/vbb/bcportal/vbb/postings.php
Referer: http://www.bobcosta.com/bcportal/vbb/postings.php?action=editthread&threadid=16
I am guessing that this is some sort of database inconsistency that was not expected by the VB program. Can someone verify this, or is it some other problem?
If I am correct, IMHO it is a lousy design that causes fatal crashes when the progarm encounters non-fatal dtabase inconsistencies. So I guess I have three questions:
1. What are my chances of getting this fixed by jelSoft in a reasonable time frame?
2. What do I have to do to my thread insert routine to populate the searchindex? I am not sure that I want these "add-on" threads searchable. Then again, maybe I do. I sure would like the option.
3. Are there any other "gotchas" I am headed for that anyone can warn me about?