FAQDesk v1.1 for MS2 / 20 Jun 2004 release.

[FastEddy]

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

[241]

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');

[FastEddy]

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

[FastEddy]

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

[Guest]

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

[FastEddy]

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

[FastEddy]

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