Jump to content
dev osCommerce
Forum
  • Checkout
  • Login
  • Contact Us
  • Get in touch

osCommerce

The e-commerce.

New Demo
Our Partners

New Helpdesk Errors??

Guest

By Guest
in General Support

Recommended Posts

Guest

Guest

Posted
Posted

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
Guest

Guest

Posted
Posted
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.

Go to topic listing
×
×
  • Create New...