Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

New Helpdesk Errors??


Guest

Recommended Posts

Hi

 

I installed the Helpdesk contribution and modified all the files exactly as the install docs said but I am getting a couple of errors when I try to submit a new ticket or check a ticket.

I realy like the idea of the help desk and have seen it working on a few sites, and I know sometimes e-mails get lost, undelivered or swallowed up by anti spam so I would realy like to get this working but after searching for hours on the forums and backtracking what files I have modified I cant find a solution and need some help please!!

 

I have modified the tables in sql with the file included, so I can now access the Helpdesk module in admin but when I view closed tickets, view open tickets or search tickets I get this message:

 

 

Edit Helpdesk User

 

1146 - Table 'flat4online_co_uk.helpdesk' doesn't exist

 

SELECT * FROM helpdesk WHERE status != 'COMPLETED'

 

[TEP STOP]

 

 

On my website when I click on submit a support ticket I get the follwing error:

 

http://www.flat4online.co.uk/catalog/FILEN...HELPDESK_SUBMIT

with a "page could not be found"

 

I found a thread posted a while back where someone else was having the same problem and it was suggested that the filename has not been defined in includes/filnames.php

 

 

http://www.oscommerce.com/forums/index.php?showtopic=95777&hl=

 

I checked the filenames.php file and it points to helpdesk_submit.php

 

Copyright ? 2003 osCommerce

 

Released under the GNU General Public License

*/

 

// define the filenames used in the project

define('FILENAME_ACCOUNT', 'account.php');

define('FILENAME_ACCOUNT_EDIT', 'account_edit.php');

define('FILENAME_ACCOUNT_HISTORY', 'account_history.php');

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

define('FILENAME_ACCOUNT_NEWSLETTERS', 'account_newsletters.php');

define('FILENAME_ACCOUNT_NOTIFICATIONS', 'account_notifications.php');

define('FILENAME_ACCOUNT_PASSWORD', 'account_password.php');

define('FILENAME_ADDRESS_BOOK', 'address_book.php');

define('FILENAME_ADDRESS_BOOK_PROCESS', 'address_book_process.php');

define('FILENAME_ADVANCED_SEARCH', 'advanced_search.php');

define('FILENAME_ADVANCED_SEARCH_RESULT', 'advanced_search_result.php');

define('FILENAME_ALSO_PURCHASED_PRODUCTS', 'also_purchased_products.php');

define('FILENAME_CHECKOUT_CONFIRMATION', 'checkout_confirmation.php');

define('FILENAME_CHECKOUT_PAYMENT', 'checkout_payment.php');

define('FILENAME_CHECKOUT_PAYMENT_ADDRESS', 'checkout_payment_address.php');

define('FILENAME_CHECKOUT_PROCESS', 'checkout_process.php');

define('FILENAME_CHECKOUT_SHIPPING', 'checkout_shipping.php');

define('FILENAME_CHECKOUT_SHIPPING_ADDRESS', 'checkout_shipping_address.php');

define('FILENAME_CHECKOUT_SUCCESS', 'checkout_success.php');

define('FILENAME_CONTACT_US', 'contact_us.php');

define('FILENAME_CONDITIONS', 'conditions.php');

define('FILENAME_COOKIE_USAGE', 'cookie_usage.php');

define('FILENAME_CREATE_ACCOUNT', 'create_account.php');

define('FILENAME_CREATE_ACCOUNT_SUCCESS', 'create_account_success.php');

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

define('FILENAME_DEFAULT_SPECIALS', 'default_specials.php');

 

define('FILENAME_DOWNLOAD', 'download.php');

define('FILENAME_INFO_SHOPPING_CART', 'info_shopping_cart.php');

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

define('FILENAME_LOGOFF', 'logoff.php');

define('FILENAME_NEW_PRODUCTS', 'new_products.php');

define('FILENAME_PASSWORD_FORGOTTEN', 'password_forgotten.php');

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

define('FILENAME_POPUP_SEARCH_HELP', 'popup_search_help.php');

define('FILENAME_PRIVACY', 'privacy.php');

define('FILENAME_PRODUCT_INFO', 'product_info.php');

define('FILENAME_PRODUCT_LISTING', 'product_listing.php');

define('FILENAME_PRODUCT_REVIEWS', 'product_reviews.php');

define('FILENAME_PRODUCT_REVIEWS_INFO', 'product_reviews_info.php');

define('FILENAME_PRODUCT_REVIEWS_WRITE', 'product_reviews_write.php');

define('FILENAME_PRODUCTS_NEW', 'products_new.php');

define('FILENAME_REDIRECT', 'redirect.php');

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

define('FILENAME_SHIPPING', 'shipping.php');

define('FILENAME_SHOPPING_CART', 'shopping_cart.php');

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

define('FILENAME_SSL_CHECK', 'ssl_check.php');

define('FILENAME_TELL_A_FRIEND', 'tell_a_friend.php');

define('FILENAME_UPCOMING_PRODUCTS', 'upcoming_products.php');

define('FILENAME_HELPDESK_LOGIN', 'helpdesk_submit.php');

define('FILENAME_HELPDESK_STATUS', 'helpdesk_status.php');

define('FILENAME_HELPDESK_REOPEN', 'helpdesk_reopen.php');

?>

 

The 'helpdesk_submit.php' file is in my catolog folder so its not missing, when I load up http://www.flat4online.co.uk/catalog/helpdesk_submit.php the page goes blank!!

 

 

Any help would be very much appreciated!!

 

TIA

 

Scott

Link to comment
Share on other sites

Hi

 

I installed the Helpdesk contribution and modified all the files exactly as the install docs said but I am getting a couple of errors when I try to submit a new ticket  or check a ticket.

I realy like the idea of the help desk and have seen it working on a few sites, and I know sometimes e-mails get lost, undelivered or swallowed up by anti spam so I would realy like to get this working but after searching for hours on the forums and backtracking what files I have modified I cant find a solution and need some help please!! 

 

I have modified the tables in sql with the file included, so I can now access the Helpdesk module in admin but when I view closed tickets, view open tickets or search tickets I get this message:

Edit Helpdesk User 

 

1146 - Table 'flat4online_co_uk.helpdesk' doesn't exist

 

SELECT * FROM helpdesk WHERE status != 'COMPLETED'

 

[TEP STOP]

On my website when I click on submit a support ticket I get the follwing error:

 

http://www.flat4online.co.uk/catalog/FILEN...HELPDESK_SUBMIT

with a "page could not be found"

 

I found a thread posted a while back where someone else was having the same problem and it was suggested that the filename has not been defined in includes/filnames.php

http://www.oscommerce.com/forums/index.php?showtopic=95777&hl=

 

I checked the filenames.php file and it points to helpdesk_submit.php

 

Copyright ? 2003 osCommerce

 

  Released under the GNU General Public License

*/

 

// define the filenames used in the project

  define('FILENAME_ACCOUNT', 'account.php');

  define('FILENAME_ACCOUNT_EDIT', 'account_edit.php');

  define('FILENAME_ACCOUNT_HISTORY', 'account_history.php');

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

  define('FILENAME_ACCOUNT_NEWSLETTERS', 'account_newsletters.php');

  define('FILENAME_ACCOUNT_NOTIFICATIONS', 'account_notifications.php');

  define('FILENAME_ACCOUNT_PASSWORD', 'account_password.php');

  define('FILENAME_ADDRESS_BOOK', 'address_book.php');

  define('FILENAME_ADDRESS_BOOK_PROCESS', 'address_book_process.php');

  define('FILENAME_ADVANCED_SEARCH', 'advanced_search.php');

  define('FILENAME_ADVANCED_SEARCH_RESULT', 'advanced_search_result.php');

  define('FILENAME_ALSO_PURCHASED_PRODUCTS', 'also_purchased_products.php');

  define('FILENAME_CHECKOUT_CONFIRMATION', 'checkout_confirmation.php');

  define('FILENAME_CHECKOUT_PAYMENT', 'checkout_payment.php');

  define('FILENAME_CHECKOUT_PAYMENT_ADDRESS', 'checkout_payment_address.php');

  define('FILENAME_CHECKOUT_PROCESS', 'checkout_process.php');

  define('FILENAME_CHECKOUT_SHIPPING', 'checkout_shipping.php');

  define('FILENAME_CHECKOUT_SHIPPING_ADDRESS', 'checkout_shipping_address.php');

  define('FILENAME_CHECKOUT_SUCCESS', 'checkout_success.php');

  define('FILENAME_CONTACT_US', 'contact_us.php');

  define('FILENAME_CONDITIONS', 'conditions.php');

  define('FILENAME_COOKIE_USAGE', 'cookie_usage.php');

  define('FILENAME_CREATE_ACCOUNT', 'create_account.php');

  define('FILENAME_CREATE_ACCOUNT_SUCCESS', 'create_account_success.php');

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

define('FILENAME_DEFAULT_SPECIALS', 'default_specials.php');

 

  define('FILENAME_DOWNLOAD', 'download.php');

  define('FILENAME_INFO_SHOPPING_CART', 'info_shopping_cart.php');

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

  define('FILENAME_LOGOFF', 'logoff.php');

  define('FILENAME_NEW_PRODUCTS', 'new_products.php');

  define('FILENAME_PASSWORD_FORGOTTEN', 'password_forgotten.php');

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

  define('FILENAME_POPUP_SEARCH_HELP', 'popup_search_help.php');

  define('FILENAME_PRIVACY', 'privacy.php');

  define('FILENAME_PRODUCT_INFO', 'product_info.php');

  define('FILENAME_PRODUCT_LISTING', 'product_listing.php');

  define('FILENAME_PRODUCT_REVIEWS', 'product_reviews.php');

  define('FILENAME_PRODUCT_REVIEWS_INFO', 'product_reviews_info.php');

  define('FILENAME_PRODUCT_REVIEWS_WRITE', 'product_reviews_write.php');

  define('FILENAME_PRODUCTS_NEW', 'products_new.php');

  define('FILENAME_REDIRECT', 'redirect.php');

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

  define('FILENAME_SHIPPING', 'shipping.php');

  define('FILENAME_SHOPPING_CART', 'shopping_cart.php');

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

  define('FILENAME_SSL_CHECK', 'ssl_check.php');

  define('FILENAME_TELL_A_FRIEND', 'tell_a_friend.php');

  define('FILENAME_UPCOMING_PRODUCTS', 'upcoming_products.php');

  define('FILENAME_HELPDESK_LOGIN', 'helpdesk_submit.php');

  define('FILENAME_HELPDESK_STATUS', 'helpdesk_status.php');

  define('FILENAME_HELPDESK_REOPEN', 'helpdesk_reopen.php');

?>

 

The  'helpdesk_submit.php' file is in my catolog folder so its not missing, when I load up http://www.flat4online.co.uk/catalog/helpdesk_submit.php the page goes blank!!

Any help would be very much appreciated!!

 

TIA

 

Scott

 

I managed to fix the admin problem, just slowed down a bit, lloked at the problem and realsied it was staring me in the face, there was no helpdesk table in the database!!

I will keep ploding around and try and find out why I still cant submit a new ticket from my site, big learning curve!!

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...