It looks as though you may have missed a section of the SQL installation script.
The sql should be run as a complete script, as it should set the variable (@configuration_group_id) prior to running the script that errored. Please can you check whether the first part has installed by seeing if the configuration section has been installed.
This can be done via the admin; see if "Facebook Catalog Browser" is in the configuration menu. If so, get the configuration group ID from the URL and then replace the variable (@configuration_group_id) with the ID you have just copied.
e.g.
On my installation the URL (in my URL bar) is .../configuration.php?gID=39
The ID, in this case 39, should be use to replace @configuration_group_id in the script below:
Code:
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function)
VALUES (NULL, 'Catalog Browser Plugin Key', 'BSS_PLUGIN_KEY', SUBSTRING(MD5(RAND()) FROM 1 FOR 9), 'This plugin key is used during Facebook Application setup, feel free to change this unique key a secure alternative if required.', @configuration_group_id, 0, NOW(), NULL, NULL);
Bookmarks