PROBLEMA CON IL TEMPLATE E-vector

vito · Messaggio da **vito** » 22/10/2003, 12:21

salve,
ho provato ad importare nel mio database da phpmyadmin il files E-vector.sql

appena clicco su esegui appare questo errore:
Errore

query SQL :

INSERT INTO infobox_configuration
VALUES (

"4", "", "best_sellers.php", "BOX_HEADING_BESTSELLERS", "yes", "right", "6", "1", "2003-10-04 02:30:16", "2003-04-15 11:01:05", "Best Sellers", "box.tpl.php", "#ffffff"
)

Messaggio di MySQL:

#1146 - Table 'calicom_db.infobox_configuration' doesn't exist

come altre contribution ho sempre fatto cosi'
perche per questo templates o altri mi da errore?

il files vector.sql contine questo:

INSERT INTO infobox_configuration VALUES("4", "", "best_sellers.php", "BOX_HEADING_BESTSELLERS", "yes", "right", "6", "1", "2003-10-04 02:30:16", "2003-04-15 11:01:05", "Best Sellers", "box.tpl.php", "#ffffff");
INSERT INTO infobox_configuration VALUES("4", "", "categories.php", "BOX_HEADING_CATEGORIES", "yes", "left", "2", "20", "2003-10-04 19:32:53", "0000-00-00 00:00:00", "Categories", "box.tpl.php", "#ffffff");
INSERT INTO infobox_configuration VALUES("4", "", "currencies.php", "BOX_HEADING_CURRENCIES", "yes", "right", "6", "3", "2003-10-04 19:27:30", "2003-04-15 11:01:05", "Currencies", "box.tpl.php", "#2D6DC5");
INSERT INTO infobox_configuration VALUES("4", "", "languages.php", "BOX_HEADING_LANGUAGES", "no", "left", "15", "6", "2003-08-04 23:41:31", "2003-04-15 11:01:05", "Languages", "box.tpl.php", "#ffffff");
INSERT INTO infobox_configuration VALUES("4", "", "manufacturer_info.php", "BOX_HEADING_MANUFACTURER_INFO", "yes", "left", "12", "7", "2003-10-01 21:36:17", "2003-04-15 11:01:05", "Manufactures Info", "box.tpl.php", "#ffffff");
INSERT INTO infobox_configuration VALUES("4", "", "manufacturers.php", "BOX_HEADING_MANUFACTURERS", "yes", "left", "10", "8", "2003-10-04 02:29:59", "2003-04-15 11:01:05", "Manufactures", "box.tpl.php", "#ffffff");
INSERT INTO infobox_configuration VALUES("4", "", "order_history.php", "BOX_HEADING_CUSTOMER_ORDERS", "yes", "right", "4", "9", "2003-10-04 02:30:19", "2003-04-15 11:01:05", "Order History", "box.tpl.php", "#2D6DC5");
INSERT INTO infobox_configuration VALUES("4", "", "product_notifications.php", "BOX_HEADING_NOTIFICATIONS", "yes", "left", "14", "10", "2003-08-05 02:00:11", "2003-04-15 11:01:05", "Notifications", "box.tpl.php", "#ffffff");
INSERT INTO infobox_configuration VALUES("4", "", "reviews.php", "BOX_HEADING_REVIEWS", "no", "left", "3", "11", "2003-10-03 23:49:38", "2003-04-15 11:01:05", "Reviews", "box.tpl.php", "#ffffff");
INSERT INTO infobox_configuration VALUES("4", "", "search.php", "BOX_HEADING_SEARCH", "no", "left", "8", "12", "2003-10-04 02:30:06", "2003-04-15 11:01:05", "Quick Find", "box.tpl.php", "#ffffff");
INSERT INTO infobox_configuration VALUES("4", "", "shopping_cart.php", "BOX_HEADING_SHOPPING_CART", "yes", "right", "2", "13", "2003-10-03 23:49:30", "2003-04-15 11:01:05", "Shopping Cart", "box.tpl.php", "#2D6DC5");
INSERT INTO infobox_configuration VALUES("4", "", "specials.php", "BOX_HEADING_SPECIALS", "yes", "left", "4", "14", "2003-10-04 02:30:19", "2003-04-15 11:01:05", "Specials", "box.tpl.php", "#ffffff");
INSERT INTO infobox_configuration VALUES("4", "", "tell_a_friend.php", "BOX_HEADING_TELL_A_FRIEND", "yes", "left", "13", "15", "2003-08-05 02:02:04", "2003-04-15 11:01:05", "Tell A Friend", "box.tpl.php", "#ffffff");
INSERT INTO infobox_configuration VALUES("4", "", "whats_new.php", "BOX_HEADING_WHATS_NEW", "yes", "left", "9", "16", "2003-10-04 02:30:02", "2003-04-15 11:01:05", "Latest products", "box.tpl.php", "#ffffff");
INSERT INTO infobox_configuration VALUES("4", "", "newsbox.php", "BOX_HEADING_NEWSBOX", "yes", "left", "16", NULL, "2003-08-29 13:47:26", "0000-00-00 00:00:00", "News Box", "box.tpl.php", "#ffffff");
INSERT INTO infobox_configuration VALUES("4", "", "theme_select.php", "BOX_HEADING_TEMPLATE_SELECT", "yes", "left", "1", NULL, "2003-10-01 21:58:26", "0000-00-00 00:00:00", "Select Template", "box.tpl.php", "#ffffff");
INSERT INTO infobox_configuration VALUES("4", "", "featured.php", "BOX_HEADING_FEATURED", "yes", "left", "17", NULL, "2003-09-07 12:33:05", "0000-00-00 00:00:00", "featured", "box.tpl.php", "#ffffff");
INSERT INTO infobox_configuration VALUES("4", "", "affiliate.php", "BOX_HEADING_AFFILIATE", "yes", "right", "5", NULL, "2003-10-04 02:30:16", "0000-00-00 00:00:00", "Affiliate Info", "box.tpl.php", "#2D6DC5");
INSERT INTO infobox_configuration VALUES("4", "", "newsdesk.php", "BOX_HEADING_NEWSDESK_CATEGORIES", "yes", "left", "11", "21", "2003-10-04 02:29:56", "0000-00-00 00:00:00", "NewsDesk", "box.tpl.php", "#ffffff");
INSERT INTO infobox_configuration VALUES("4", "", "newsdesk_latest.php", "BOX_HEADING_NEWSDESK_LATEST", "yes", "left", "7", "21", "2003-10-04 02:30:09", "0000-00-00 00:00:00", "NewsDesk Latest", "box.tpl.php", "#ffffff");
INSERT INTO infobox_configuration VALUES("4", "", "faqdesk.php", "BOX_HEADING_FAQDESK_CATEGORIES", "yes", "left", "6", "21", "2003-10-04 02:30:12", "0000-00-00 00:00:00", "FaqDesk", "box.tpl.php", "#ffffff");
INSERT INTO infobox_configuration VALUES("4", "", "faqdesk_latest.php", "BOX_HEADING_FAQDESK_LATEST", "yes", "left", "5", "21", "2003-10-04 02:30:19", "0000-00-00 00:00:00", "FaqDesk Latest", "box.tpl.php", "#ffffff");
INSERT INTO infobox_configuration VALUES("4", "", "information.php", "BOX_HEADING_INFORMATION", "yes", "right", "11", "5", "2003-10-01 21:36:17", "2003-04-15 11:01:05", "Information", "box.tpl.php", "#2D6DC5");
INSERT INTO infobox_configuration VALUES("4", "", "loginbox.php", "BOX_HEADING_LOGIN", "yes", "right", "1", NULL, "2003-10-08 14:39:41", "0000-00-00 00:00:00", "Login", "infobox", "#000000");

INSERT INTO template VALUES("4", "E-vector", "2003-10-02 23:55:06", "2003-10-06 18:51:22", NULL, "0", "5", "0", "8", "770", "0", "0", "yes", "yes", "165", "145", "yes", "1", "true", "yes", "no", "no", "no", "newsdesk.php", "new_products.php", "default_specials.php", "upcoming_products.php", "", "", "yes", "Welcome back %s! THIS IS A TEST<a href=\\\"%s\\\">new products</a> are available to purchase?", "", "Welcome Guest! THIS IS A TEST", "false");

Messaggio da **hozone** » 22/10/2003, 16:45

a prima vista sembra che deve esistere la tabella "calicom_db".

che immagino tu nn abbia nel tuo server MySQL.

vito · Messaggio da **vito** » 22/10/2003, 19:06

allora devo creare dal phpmyadmin nel mio database
la tabella e chiamarla calicom_db

quanti campi deve avere?
e come devo impostarli?

Messaggio da **hozone** » 22/10/2003, 19:30

non so.
non so nemmeno cos'è E-vector.

so solo che il log di SQL parla chiaro.

per trovare i cambi di calicom_db devi cercare tutti i riferimenti a calicom_db.xxxxxx le xxxx sono il nome dei campi della tabella.

ma in ogni caso non sapresti di che ti po crearli e che cosa contengono.

dovresti spiegare un po' meglio cosè sto e-vector.