Hello.

I had been looking information about this message and take some to stand aproximately what happend, but i don´t know exactly how to resolve...

Just a problem when try to install UTI mod i recive in the frontend:

1146 Table 'indexia_zencart.uti_attributes' doesn't exist
in:
[SELECT * FROM uti_attributes WHERE uti_row_id = 347]

I know that in other posts talking about DB_PREFIX and not DB_PREFIX databases, but I don´t know how to know my database format,

In myphpadmin I can see the database name as indexia_zencart,and tables: additional_images, adress_book, etc.., and one of this is uti, but any uti_attributes is listed.

When i execute the following SQL:

SET @temp_sort_order = 0;
SELECT (@temp_sort_order:=max(sort_order)+1) FROM configuration_group;
INSERT INTO configuration_group (configuration_group_title, configuration_group_description, sort_order, visible) VALUES('UTI','User Tracking Interface', @temp_sort_order,1);

SET @group_id = LAST_INSERT_ID();
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order) VALUES('UTI Cookie Name', 'UTI_COOKIE_NAME', 'uti_session', 'Name of UTI cookie', @group_id, 1);
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order) VALUES('UTI Cookie Livespan', 'UTI_COOKIE_LIVESPAN', '2678400', 'How much time <b>IN SECONDS</b> cookie should be kept in visitors browser memory? <b>Use calculator!</b> One day has 86 400 seconds.', @group_id, 2);
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order) VALUES('UTI Cookie Domain', 'UTI_COOKIE_DOMAIN', '.mydomain.com', 'To which domain cookie should be assigned? If Your domain is www.example.com You should probably set this to .example.com (Yes, without www, with dot at the begining)', @group_id, 3);
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order) VALUES('UTI Cookie Session String Length', 'UTI_SESSION_LENGTH', '40', 'How many characters should have tracking session_id? Bigger values are more scure, 40 should be enough.', @group_id, 4);
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function) VALUES('UTI Visitor Recognition Method', 'UTI_RECOGNITION_METHOD', 'tsid', 'How should visitor be recognized? By UTI session cookie/ by session OR ip address/by session AND ip address?', @group_id, 5, "zen_cfg_select_drop_down(array(array('id'=>'tsid', 'text'=>'UTI session'), array('id'=>'tsid_or_ip', 'text'=>'UTI session OR ip address'), array('id'=>'tsid_and_ip', 'text'=>'UTI session and ip address')),");
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added) VALUES('Last UTI database prune', 'UTI_LAST_DB_PRUNE',0,'Unix timestamp of last prune of uti table. Set to 0 to force prune on next <b>Admin</b> request.',@group_id,6, NOW(),NOW());

SELECT (@temp_sort_order:=max(sort_order)+1) FROM configuration_group;
INSERT INTO configuration_group (configuration_group_title, configuration_group_description, sort_order, visible) VALUES('UTI Variables','Variables of simple modules using UTI', @temp_sort_order,1);

SET @group_id = LAST_INSERT_ID();
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order) VALUES('[Recent Products] Max recent products to show', 'UTI_RECENT_PRODUCTS_MAX', '5', 'How many recent products should be displayed in sidebox?', @group_id, 1);
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order) VALUES('[Recent Searches] Max recent searches to show', 'UTI_RECENT_SEARCHES_MAX', '5', 'How many recent search results should be displayed in sidebox?',@group_id, 2);

CREATE TABLE `uti` (
`uti_row_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`tsid` varchar(255) NOT NULL,
`last_ip` int(10) unsigned NOT NULL,
`last_visit` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`date_created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`customer_id` int(11) NOT NULL,
PRIMARY KEY (`uti_row_id`),
UNIQUE KEY `unq_tsid` (`tsid`),
KEY `idx_last_visit` (`last_visit`)
) ENGINE=InnoDB;

CREATE TABLE `uti_attributes` (
`utia_row_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uti_row_id` int(10) unsigned NOT NULL,
`name` varchar(255) NOT NULL,
`value` varchar(64000) NOT NULL,
PRIMARY KEY (`utia_row_id`),
UNIQUE KEY `uti_id` (`uti_row_id`,`name`) USING BTREE
) ENGINE=InnoDB;

I obtain the following results:

17 statements processed.
ERROR: No se puede introducir configuration_key "UTI_COOKIE_NAME" porque ya existe
ERROR: No se puede introducir configuration_key "UTI_COOKIE_LIVESPAN" porque ya existe
ERROR: No se puede introducir configuration_key "UTI_COOKIE_DOMAIN" porque ya existe
ERROR: No se puede introducir configuration_key "UTI_SESSION_LENGTH" porque ya existe
ERROR: No se puede introducir configuration_key "UTI_RECOGNITION_METHOD" porque ya existe
ERROR: No se puede introducir configuration_key "UTI_LAST_DB_PRUNE" porque ya existe
ERROR: No se puede introducir configuration_key "UTI_LAST_DB_PRUNE" porque ya existe
ERROR: No se puede introducir configuration_key "UTI_LAST_DB_PRUNE" porque ya existe
ERROR: No se puede introducir configuration_key "UTI_LAST_DB_PRUNE" porque ya existe
ERROR: No se puede introducir configuration_key "UTI_RECENT_PRODUCTS_MAX" porque ya existe
ERROR: No se puede introducir configuration_key "UTI_RECENT_SEARCHES_MAX" porque ya existe
ERROR: No se puede crear la tabla uti porque ya existe
ERROR: No se puede crear la tabla porque ya existe
Note: 10 statements ignored. See "upgrade_exceptions" table for additional details.


Could please someone help me to solve this?

Thank you very much for your time.