[Marco van Herwaarden]

Originally Posted by kylek

I have it installed on vb3.0.6 and the only problem I have is the new thread. Go to start a new thread, submit, this sql error pops up,

Database error in vBulletin 3.0.6:

Invalid SQL: SELECT threadid FROM post WHERE postid=4249
mysql error: Table 'vbulletin.post' doesn't exist

mysql error number: 1146

Date: Thursday 14th of April 2005 08:54:33 PM
Script: xxxxxxxxxxxxxxx/forum/newthread.php
Referer: xxxxxx
Username: xIP Address: xxxxxxxxxx

After hitting back button it shows the new thread post but no reponse from Bot. However any posts added after the initial one works fine and the bot responds to all.
I use a vb3_ prefix for my database so vbulletin.post should be vb3_ post which does exist.
Where do I look to change this, seems it is only in new thread.php
Anyone have any suggestions?

In your _talkerbot.php file, find:

PHP Code:

        $tinfo = $DB_site->query_first("SELECT threadid FROM post WHERE postid=$newpost[postid]");
        $threadinfo[threadid] = $tinfo[threadid];
    }
    $pinfo = $DB_site->query_first("SELECT max(postid) as pid FROM post WHERE threadid={$threadinfo[threadid]}"); 


And replace by:

PHP Code:

        $tinfo = $DB_site->query_first("SELECT threadid FROM " . TABLE_PREFIX . "post WHERE postid=$newpost[postid]");
        $threadinfo[threadid] = $tinfo[threadid];
    }
    $pinfo = $DB_site->query_first("SELECT max(postid) as pid FROM " . TABLE_PREFIX . "post WHERE threadid={$threadinfo[threadid]}"); 


You will find this 2 times in that file, it has to be replaced 2 times.

PS I don't have this mod installed, so it is untested!