Adding Module sql error - help

[alfaowner]

i get this, can anyone help, i really love this software

Invalid SQL:
### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO adv_modules
(adv_modulesid, title, modcol, displayorder, active, filename, parent, identifier, templatelist, cleanoutput, useshell, link, colspan, formcode, inctype, userperms)
VALUES
(NULL, 'latest topics', '0', '1', '1', 'latesttopics.php', '', '', '', '0', '1', '', '', '', 'php_file', '1,2,3,4,5,6,7')
mysql error: Unknown column 'adv_modulesid' in 'field list'

Script: http://www.alfaowner.com/Forum/admin...cmps_admin.php
Referer: http://www.alfaowner.com/Forum/admin...&type=php_file



This happens every time i try to add a module

http://www.alfaowner.com/cmps_index.php

mysql error number: 1054

Please anyone know what is wrong?

[alfaowner]

i just cant sus it, I am a novice really but am having trouble rectifiying this, anyone please could you take a look and help with advice.... Man thanks for your time in advance...

AO

[Brian]

Looks like you've modified your files, as there should be no way you would get that error on a default install. Try downloading the package from here again, delete the admincp/vba_cmps_admin.php file that is currently on your server, and then upload that file from the package you downloaded from here.

[alfaowner]

Hi Brian,

I replaced everything, still same error. do you think its something to do with the build store? If so where should it be placed?

function build_datastore($title = '', $data = '')
{
global $DB_site;
if ($title != '')
{
$DB_site->query("
REPLACE INTO " . TABLE_PREFIX . "datastore
(title, data)
VALUES
('" . addslashes(trim($title)) . "', '" . addslashes(trim($data)) . "')
");
}
}

I am happy to pay to sort it out, I am so excited to get this up and running. Pretty please with a cherry on top, please reply with any suggestions.

(Ok, yes its grovelling) but I want it sooooooo bad, VBAdvanced that is :)

Regards,

Ian

BTW: Same error occured, does that mean its my sql file or?

[Brian]

Strange... I have no idea how that would be happening on a default install, but if you'd like to submit a support ticket via the Members' Area here I'll be glad to take a look at things for you.

[alfaowner]

You Are A Top Man... its submitted!