I am trying to do my first custom adon and when I import in the mysql file into phpmyadmin it is naming the table using the database name (c-Panel), not just zen_ and therefore I am getting this error.
1146 Table 'sabrina_zc1.zen_products_with_attributes_stock' doesn't exist
in:
[select * from zen_products_with_attributes_stock where products_id="7"]
I have no idea how to edit the sql so that it does not use the database name.
This is the table for the database.
CREATE TABLE products_with_attributes_stock (
stock_id INT NOT NULL AUTO_INCREMENT ,
products_id INT NOT NULL ,
stock_attributes VARCHAR( 255 ) NOT NULL ,
quantity INT NOT NULL ,
PRIMARY KEY ( stock_id )
)
;
INSERT INTO configuration (configuration_title, configuration_key, configuration_value,
configuration_description, configuration_group_id, sort_order,
last_modified, date_added, use_function, set_function)
VALUES ('Show Attributes Stock', 'PRODUCT_STOCK_ATTRIBUTE_SHOW', 'true',
'Show the stock of items that have stock set by attributes?', '1', '500', NULL,
now(), NULL, "zen_cfg_select_option(array('true', 'false'),");
UPDATE configuration SET configuration_value = "false" WHERE configuration_key = "STOCK_ALLOW_CHECKOUT";
Any input would be appreciated, thanks.