Sistema de FAQ

[escaflowne]

Olá gostaria de uma ajuda para meu problema adicionei essa contribuição em minha loja: http://www.oscommerce.com/community/contri...,all/search,faq

porem aparece esse erro e não consigo arrumar-la

onsulta SQL:

CREATE TABLE `faq` (

`faq_id` INT( 11 ) NOT NULL AUTO_INCREMENT ,

`faq_status` TINYINT( 1 ) NOT NULL DEFAULT '1',

`sort_order` INT( 11 ) NOT NULL DEFAULT '0',

`last_modified` DATETIME NOT NULL ,

PRIMARY KEY ( `faq_id` )

) ENGINE = MYISAM DEFAULT CHARSET = utf8;

Mensagens do MySQL :

#1046 - No database selected

Escaflowne

[Douglas Jam]

Olá gostaria de uma ajuda para meu problema adicionei essa contribuição em minha loja: http://www.oscommerce.com/community/contri...,all/search,faq

porem aparece esse erro e não consigo arrumar-la

onsulta SQL:

CREATE TABLE `faq` (

`faq_id` INT( 11 ) NOT NULL AUTO_INCREMENT ,

`faq_status` TINYINT( 1 ) NOT NULL DEFAULT '1',

`sort_order` INT( 11 ) NOT NULL DEFAULT '0',

`last_modified` DATETIME NOT NULL ,

PRIMARY KEY ( `faq_id` )

) ENGINE = MYISAM DEFAULT CHARSET = utf8;

Mensagens do MySQL :

#1046 - No database selected

Escaflowne

Você precisar primeiro escolher um banco de dados, pois voce esta criando uma tabela.

para isso no php use a funcao:

mysql_select_db($db_bancodedados);

[escaflowne]

Cara valeu pela dica.. fi zo que você me disse deutudo certo pprém,. agora estou com essas duas mensagens:

no adim: Parse error: syntax error, unexpected T_STRING in /home/kalango/public_html/admin/includes/filenames.php on line 75

no index: Parse error: syntax error, unexpected ')' in /home/kalango/public_html/includes/database_tables.php on line 71

Por favor poderia me dar uma ajuda

Escaflowne

[vini_loock]

Poste o código dessas 2 paginas:

database_tables.php

filenames.php

[escaflowne]

Valeu Vini_loock

Segue abaixo:

Código: database_tables.php

/includes/database_tables.php on line 71

===================================================================================

<?php

/*

$Id: database_tables.php,v 1.1 2003/03/14 02:10:58 hpdl Exp $

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

Copyright © 2003 osCommerce - Modified by Valmy Gomes - valmygomes@legalzona.com.br valmygomes@hotmail.com in 19/04/2007

Released under the GNU General Public License

*/

// define the database table names used in the project

define('TABLE_ADDRESS_BOOK', 'address_book');

define('TABLE_ADDRESS_FORMAT', 'address_format');

define('TABLE_BANNERS', 'banners');

define('TABLE_BANNERS_HISTORY', 'banners_history');

define('TABLE_CATEGORIES', 'categories');

define('TABLE_CATEGORIES_DESCRIPTION', 'categories_description');

define('TABLE_CONFIGURATION', 'configuration');

define('TABLE_CONFIGURATION_GROUP', 'configuration_group');

define('TABLE_COUNTER', 'counter');

define('TABLE_COUNTER_HISTORY', 'counter_history');

define('TABLE_COUNTRIES', 'countries');

define('TABLE_CURRENCIES', 'currencies');

define('TABLE_CUSTOMERS', 'customers');

define('TABLE_CUSTOMERS_BASKET', 'customers_basket');

define('TABLE_CUSTOMERS_BASKET_ATTRIBUTES', 'customers_basket_attributes');

define('TABLE_CUSTOMERS_INFO', 'customers_info');

define('TABLE_LANGUAGES', 'languages');

define('TABLE_MANUFACTURERS', 'manufacturers');

define('TABLE_MANUFACTURERS_INFO', 'manufacturers_info');

define('TABLE_ORDERS', 'orders');

define('TABLE_ORDERS_PRODUCTS', 'orders_products');

define('TABLE_ORDERS_PRODUCTS_ATTRIBUTES', 'orders_products_attributes');

define('TABLE_ORDERS_PRODUCTS_DOWNLOAD', 'orders_products_download');

define('TABLE_ORDERS_STATUS', 'orders_status');

define('TABLE_ORDERS_STATUS_HISTORY', 'orders_status_history');

define('TABLE_ORDERS_TOTAL', 'orders_total');

define('TABLE_PRODUCTS', 'products');

define('TABLE_PRODUCTS_ATTRIBUTES', 'products_attributes');

define('TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD', 'products_attributes_download');

define('TABLE_PRODUCTS_DESCRIPTION', 'products_description');

define('TABLE_PRODUCTS_NOTIFICATIONS', 'products_notifications');

define('TABLE_PRODUCTS_OPTIONS', 'products_options');

define('TABLE_PRODUCTS_OPTIONS_VALUES', 'products_options_values');

define('TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS', 'products_options_values_to_products_options');

define('TABLE_PRODUCTS_TO_CATEGORIES', 'products_to_categories');

define('TABLE_REVIEWS', 'reviews');

define('TABLE_REVIEWS_DESCRIPTION', 'reviews_description');

define('TABLE_SESSIONS', 'sessions');

define('TABLE_SPECIALS', 'specials');

define('TABLE_TAX_CLASS', 'tax_class');

define('TABLE_TAX_RATES', 'tax_rates');

define('TABLE_GEO_ZONES', 'geo_zones');

define('TABLE_ZONES_TO_GEO_ZONES', 'zones_to_geo_zones');

define('TABLE_WHOS_ONLINE', 'whos_online');

define('TABLE_ZONES', 'zones');

define('TABLE_PRODUCTS_EXTRA_IMAGES', 'products_extra_images'); //Added for Extra Images Contribution

define('TABLE_PAGES', 'pages');

define('TABLE_PAGES_DESCRIPTION', 'pages_description');

define('TABLE_EXTRA_FIELDS','extra_fields');

define('TABLE_EXTRA_FIELDS_INFO','extra_fields_info');

define('TABLE_CUSTOMERS_TO_EXTRA_FIELDS','customers_to_extra_fields');

// Added for Xsell Products Mod

define('TABLE_PRODUCTS_XSELL', 'products_xsell');

define('TABLE_CUSTOMERS_TEMP', 'customers_temp');

define('TABLE_LEGALLOJA', 'rastreamento_legalloja');

//FAQDesk 2.2

define('TABLE_FAQ', 'faq');

define('TABLE_FAQ_DESCRIPTION', 'faq_description'););

?>

====================================================================================

Código: filenames.php

admin/includes/filenames.php on line 75

==============================================================

<?php

/*

$Id: filenames.php,v 1.1 2003/06/20 00:18:30 hpdl Exp $

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

Copyright © 2003 osCommerce - Modified by Valmy Gomes - valmygomes@legalzona.com.br valmygomes@hotmail.com in 19/04/2007

Released under the GNU General Public License

*/

// define the filenames used in the project

define('FILENAME_PERSONALIZACAO', 'personalizacao.php');

define('FILENAME_BACKUP', 'backup.php');

define('FILENAME_BANNER_MANAGER', 'banner_manager.php');

define('FILENAME_BANNER_STATISTICS', 'banner_statistics.php');

define('FILENAME_CACHE', 'cache.php');

define('FILENAME_CATALOG_ACCOUNT_HISTORY_INFO', 'account_history_info.php');

define('FILENAME_CATEGORIES', 'categories.php');

define('FILENAME_CONFIGURATION', 'configuration.php');

define('FILENAME_COUNTRIES', 'countries.php');

define('FILENAME_CURRENCIES', 'currencies.php');

define('FILENAME_CUSTOMERS', 'customers.php');

define('FILENAME_DEFAULT', 'index.php');

define('FILENAME_DEFINE_LANGUAGE', 'define_language.php');

define('FILENAME_FILE_MANAGER', 'file_manager.php');

define('FILENAME_GEO_ZONES', 'geo_zones.php');

define('FILENAME_LANGUAGES', 'languages.php');

define('FILENAME_LOGIN', 'login.php');

define('FILENAME_MAIL', 'mail.php');

define('FILENAME_MANUFACTURERS', 'manufacturers.php');

define('FILENAME_MODULES', 'modules.php');

define('FILENAME_NEWSLETTERS', 'newsletters.php');

define('FILENAME_ORDERS', 'orders.php');

define('FILENAME_ORDERS_INVOICE', 'invoice.php');

define('FILENAME_ORDERS_PACKINGSLIP', 'packingslip.php');

define('FILENAME_ORDERS_STATUS', 'orders_status.php');

define('FILENAME_POPUP_IMAGE', 'popup_image.php');

define('FILENAME_PRODUCTS_ATTRIBUTES', 'products_attributes.php');

define('FILENAME_PRODUCTS_EXPECTED', 'products_expected.php');

define('FILENAME_REVIEWS', 'reviews.php');

define('FILENAME_SERVER_INFO', 'server_info.php');

define('FILENAME_SHIPPING_MODULES', 'shipping_modules.php');

define('FILENAME_SPECIALS', 'specials.php');

define('FILENAME_STATS_CUSTOMERS', 'stats_customers.php');

define('FILENAME_STATS_PRODUCTS_PURCHASED', 'stats_products_purchased.php');

define('FILENAME_STATS_PRODUCTS_VIEWED', 'stats_products_viewed.php');

define('FILENAME_TAX_CLASSES', 'tax_classes.php');

define('FILENAME_TAX_RATES', 'tax_rates.php');

define('FILENAME_WHOS_ONLINE', 'whos_online.php');

define('FILENAME_ZONES', 'zones.php');

define('FILENAME_PDF_CATALOGUE', 'pdf_catalogue.php'); // PDF Catalog

define('FILENAME_PDF_DEFINE_INTRO', 'pdf_define_intro.php'); // PDF Catalog

define('FILENAME_PDF_LINK', '../catalogues/catalog_4.pdf'); // PDF Catalog v. 1.58

define('FILENAME_QUICK_PRICEUPDATES', 'quick_priceupdates.php');

define('FILENAME_EDIT_NEWS', 'edit_news.php');

define('FILENAME_EDIT_TOPO', 'edit_topo.php');

define('FILENAME_EDIT_DIREITO', 'edit_direito.php');

define('FILENAME_EDIT_ESQUERDO', 'edit_esquerdo.php');

define('FILENAME_EDIT_RODAPE', 'edit_rodape.php');

define('FILENAME_EDIT_CSS', 'edit_css.php');

// Change Password v2.0

define('FILENAME_CHANGE_PASSWORD', 'change_password.php');

define('FILENAME_STATS_LOW_STOCK', 'stats_low_stock.php');

define('FILENAME_PRODUCTS_EXTRA_IMAGES','products_extra_images.php'); //Added for Extra Images Contribution

define('FILENAME_PAGE_MANAGER', 'extra_info_pages.php');

define('FILENAME_EXTRA_FIELDS','extra_fields.php');

define('FILENAME_XSELL_PRODUCTS', 'xsell.php');

define('FILENAME_ADMINISTRATORS', 'administrators.php');

define('FILENAME_LOGIN', 'login.php');

define('FILENAME_COUNTER_RESET', 'counter_reset.php');

define('FILENAME_STATS_CUSTOMERS_ORDERS', 'stats_customers_orders.php')

//FAQDesk 2.2

define('FILENAME_FAQ','faq.php');

?>

===================================================================================

Obrigado pela sua atenção

Agradeço desde já

Escaflowne