Guest Posted January 11, 2005 Share Posted January 11, 2005 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 More sharing options...
Guest Posted January 11, 2005 Share Posted January 11, 2005 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 <{POST_SNAPBACK}> 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 More sharing options...
Guest Posted January 12, 2005 Share Posted January 12, 2005 Sure enough it was the filenames.php needed modified. Now when I click on submit a support ticket the page goes blank! http://www.flat4online.co.uk/catalog/helpdesk_submit.php Any ideas where to start looking? Link to comment Share on other sites More sharing options...
Guest Posted January 12, 2005 Share Posted January 12, 2005 Sure enough it was the filenames.php needed modified. Now when I click on submit a support ticket the page goes blank! http://www.flat4online.co.uk/catalog/helpdesk_submit.php Any ideas where to start looking? <{POST_SNAPBACK}> Got it working in the end cheers Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.