FastEddy Posted June 22, 2004 Posted June 22, 2004 (edited) I just installed FAQ desk and hope someone can help me with an error I'm getting 1146 - Table 'inksale_shop1.TABLE_FAQDESK_CONFIGURATION' doesn't exist select configuration_key as cfgKey, configuration_value as cfgValue from TABLE_FAQDESK_CONFIGURATION [TEP STOP] The error is in the right colum. Everything works well in the admin and the table does exist. The contrabution has been insataled as per the instructions, un-installed and re-installed. Any help you can give will be greatly appreciated. www.inksale.com -Ed Edited June 22, 2004 by FastEddy Quote
241 Posted June 22, 2004 Posted June 22, 2004 The error is in the right column because the faqdesk boxes appear in the right column. With it stating TABLE_FAQDESK_CONFIGURATION rather than faqdesk_configuration this would suggest that it is a define in the file database_tables.php for either catalog/includes or admin/includes there should be a line define('TABLE_FAQDESK_CONFIGURATION', 'faqdesk_configuration'); Quote No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes.
FastEddy Posted June 22, 2004 Author Posted June 22, 2004 Your answer is correct. 2 times I misread the directions during installation. The table definitions are included within another step and not separated with ############# like all the other steps in the directions. This is a classic example of a PEBKAC error. Problem exists between keyboard and chair. Thanks for your time and help. -Ed Quote
FastEddy Posted June 22, 2004 Author Posted June 22, 2004 There is a bad file name in the download catalog\includes\functions\faqdesk_general-.php Should be: catalog\includes\functions\faqdesk_general.php (NO -) Now that I have it somewhat up and going I am having 2 additional issues. Issue 1: in faqdesk_index.php Im getting this error: Fatal error: Cannot instantiate non-existent class: old_splitpageresults in /home/inksale/public_html/catalog/includes/modules/faqdesk/faqdesk_listing.php on line 31 in faqdesk_listing.php there is a lot of hacking here and I have no idea what to think. <?php $listing_numrows_sql = $listing_sql; // *** HACK *** // J0J0 ERROR FIX // OLD STYLE #$listing_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_FAQDESK_SEARCH_RESULTS, $listing_sql, $listing_numrows); // NEW STYLE? (forum) #$listing_split = new splitPageResults($listing_sql, MAX_DISPLAY_FAQDESK_SEARCH_RESULTS, '*', $HTTP_GET_VARS['page']); // MY STYLE $listing_split = new old_splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_FAQDESK_SEARCH_RESULTS, $listing_sql, $listing_numrows); // fix counted faqs $listing_numrows = tep_db_query($listing_numrows_sql); $listing_numrows = tep_db_num_rows($listing_numrows); if ($listing_numrows > 0 && (FAQDESK_PREV_NEXT_BAR_LOCATION == '1' || FAQDESK_PREV_NEXT_BAR_LOCATION == '3')) { ?> Second issue is there is no right column when I am on faqdesk_listing.php www.inksale.com The link is on the bottom right. Thanks -Ed Quote
Guest Posted June 23, 2004 Posted June 23, 2004 Hi, I am still having the problem and I do have these lines define('TABLE_FAQDESK', 'faqdesk'); define('TABLE_FAQDESK_DESCRIPTION', 'faqdesk_description'); define('TABLE_FAQDESK_TO_CATEGORIES', 'faqdesk_to_categories'); define('TABLE_FAQDESK_CATEGORIES', 'faqdesk_categories'); define('TABLE_FAQDESK_CATEGORIES_DESCRIPTION', 'faqdesk_categories_description'); define('TABLE_FAQDESK_CONFIGURATION', 'faqdesk_configuration'); define('TABLE_FAQDESK_CONFIGURATION_GROUP', 'faqdesk_configuration_group'); define('TABLE_FAQDESK_REVIEWS', 'faqdesk_reviews'); define('TABLE_FAQDESK_REVIEWS_DESCRIPTION', 'faqdesk_reviews_description'); in my database_tables both in catalog and admin section. It gives the following error:- 1146 - Table 'osCommerce.TABLE_FAQDESK_CATEGORIES' doesn't exist select c.categories_id, cd.categories_name, c.parent_id from TABLE_FAQDESK_CATEGORIES c, TABLE_FAQDESK_CATEGORIES_DESCRIPTION cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '0' order by c.sort_order, cd.categories_name [TEP STOP] Please help.. thanks\ ss Quote
FastEddy Posted June 23, 2004 Author Posted June 23, 2004 I guess this is the self help thread. I got my first issue resolved by changing the code to this. // *** HACK *** // J0J0 ERROR FIX // OLD STYLE //#$listing_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_FAQDESK_SEARCH_RESULTS, $listing_sql, $listing_numrows); // NEW STYLE? (forum) $listing_split = new splitPageResults($listing_sql, MAX_DISPLAY_FAQDESK_SEARCH_RESULTS, '*', $HTTP_GET_VARS['page']); // MY STYLE //$listing_split = new old_splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_FAQDESK_SEARCH_RESULTS, $listing_sql, $listing_numrows); I fixed my 2nd issue by changing faqdesk_index.php and faqdesk_info.php from this <!-- body_text_eof //--> <?php /* rechte Leiste weg <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> <!-- right_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_right.php'); ?> <!-- right_navigation_eof //--> </table></td> */ ?> </tr> </table> <!-- body_eof //--> to this <!-- body_text_eof //--> //<?php /* rechte Leiste weg <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> <!-- right_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_right.php'); ?> <!-- right_navigation_eof //--> </table></td> //*/ //?> </tr> </table> <!-- body_eof //--> I have no Idea what I did but it works. -Ed Quote
FastEddy Posted June 23, 2004 Author Posted June 23, 2004 Still getting different errors throughout the contribution. I un-installed it and installed a different system. http://www.oscommerce.com/community/contributions,1948/ Installed in 10 minutes and works like a charm. -Ed Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.