[MikeHolohan]

Originally Posted by IR15H

I figured out the DB error. The problem occurred with reading the table, rather than creating it, so the problem wasn't in the product file. Once I realised that I stopped looking in the wrong place and had a quick look in helpcenter.php. I figured out the error, and managed to fix it myself . If anyone else has prefixes on their SQL tables then do the following in helpcenter.php

SEARCH FOR;

$departmenttitle = $vbulletin->db->query_read("SELECT department FROM helpcenter_department WHERE departmentid = '" . intval($_REQUEST['departmentid']) . "'");

REPLACE WITH;

$departmenttitle = $vbulletin->db->query_read("SELECT department FROM " . TABLE_PREFIX . "helpcenter_department WHERE departmentid = '" . intval($_REQUEST['departmentid']) . "'");

...or just wait for Paul to update the zip .

Well done, works well... Mike.