mysql help

[awelsh]

I get this in IPB, im trying to install quick responses


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 'CREATE TABLE `ibf_responses` ( `rid` INT NOT NULL AUTO_INCREMENT PRIMARY KEY, `m' at line 3

Here is the query im trying to run:


ALTER TABLE `ipbgroups` ADD `g_can_response` TINYINT(1) NOT NULL DEFAULT '0',

CREATE TABLE `ibf_responses` ( `rid` INT NOT NULL AUTO_INCREMENT PRIMARY KEY, `mid` INT NOT NULL, `response` TEXT )

I do have the table called ipbgroups, Ive checked it myself.

Any help

Edited by Lµke (Forum Moderator): Thread Moved From Website Designing. Please post in the correct section next time, Thanks :).

[awelsh]

this is looking to be the problem:


function quick_response($data, $fid, $tid, $key="") {
global $ibforums;
return <<<EOF
<div align='left' style='float:left;width:auto'>
<form method='POST' style='display:inline' name='quickresponse' action='{$ibforums->base_url}'>
<input type='hidden' name='act' value='Post' />
<input type='hidden' name='CODE' value='03' />
<input type='hidden' name='f' value='$fid' />
<input type='hidden' name='t' value='$tid' />
<input type='hidden' name='st' value='{$ibforums->input['st']}' />
<input type='hidden' name='auth_key' value='$key' />
<select name='Post' class='forminput'>
<option value='-1' style='color:black'>Quick Response</option>
$data
</select>&nbsp;<input type='submit' value='Post' class='forminput' /></form>
</div>

EOF;
}

at

http://www.ironcat.co.uk/tester/index.php?showtopic=1

if you look at the bottom left there may be a quick response button.

When I press it instead of it opening the box up it posts -1


The myqsl is fixed now :) but this isnt