2013-09-01, 03:37 PM
Hello,
I try to make newthread.php send information to ShoutBox about new topic being made. Every piece of data seems to be obtained correctly however I get this error:
My PHP code:
I try to make newthread.php send information to ShoutBox about new topic being made. Every piece of data seems to be obtained correctly however I get this error:
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.91.233)' at line 1
Query:
INSERT INTO mybb_dvz_shoutbox VALUES (NULL, 38, test, 1378049667, 109.196.91.233)
My PHP code:
// No errors were found, it is safe to insert the thread.
else
{
$thread_info = $posthandler->insert_thread();
$subject = $mybb->input['subject'];
$db->write_query("INSERT INTO ".TABLE_PREFIX."dvz_shoutbox VALUES (NULL, $uid, $subject, ".time().", ".get_ip().")");
$tid = $thread_info['tid'];
$visible = $thread_info['visible'];
// Mark thread as read