Guest Posted January 11, 2005 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
Guest Posted January 11, 2005 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!!
Guest Posted January 12, 2005 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?
Guest Posted January 12, 2005 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
Recommended Posts
Archived
This topic is now archived and is closed to further replies.