erisen Posted August 26, 2003 Share Posted August 26, 2003 Hello Henri,Thank you very much. Easy to install. Works Perfectly. One comment about the support system that incorporates email interaction: It needed to use the aliases, and people like myself who are using virtual hosts, were not very much in luck installing it properly.. One question: Which affiliate contribution did you happen to install? Mehmet. me dumb, your own of course, just found it :oops: :oops: Quote GALATASARAY RULES! ultrAslan - ultrAslan - ultrAslan Link to comment Share on other sites More sharing options...
henri Posted August 26, 2003 Author Share Posted August 26, 2003 Sorry, this did not work either. I wish I knew a little more php so I could figure it out. But thanks a lot for you help. Looked again ;) <?php if (tep_session_is_registered('customer_id')) { echo tep_draw_hidden_field('name',$customer['customers_firstname'] . ' ' . $customer['customers_lastname']) . $customer['customers_firstname'] . ' ' . $customer['customers_lastname']; } else { echo tep_draw_input_field('name', ($error ? $name : $first_name)); if ($error_name) echo ENTRY_ERROR_NO_NAME; } ?> must be changed to <?php if (tep_session_is_registered('customer_id') || tep_session_is_registered('affiliate_id')) { echo tep_draw_hidden_field('name',$customer['customers_firstname'] . ' ' . $customer['customers_lastname']) . $customer['customers_firstname'] . ' ' . $customer['customers_lastname']; } else { echo tep_draw_input_field('name', ($error ? $name : $first_name)); if ($error_name) echo ENTRY_ERROR_NO_NAME; } ?> The lines below the same Quote Link to comment Share on other sites More sharing options...
greytek Posted August 26, 2003 Share Posted August 26, 2003 Something strange is happening. when I go to view tickets and am logged in as a customer, it does not show any existing tickets. I was getting an error that reads: Warning: Missing argument 3 for splitpageresults() in /hsphere/local/home/admi0/hrcc.com/catalog/includes/classes/split_page_results.php on line 24 Warning: Missing argument 4 for splitpageresults() in /hsphere/local/home/admi0/hrcc.com/catalog/includes/classes/split_page_results.php on line 24 Only get this error in ticket_view.php when logged in as a customer. Code looks like this: <?php if (tep_session_is_registered('customer_id')) { $customers_tickets_raw = "select * from " . TABLE_TICKET_TICKET . " where ticket_customers_id = '" . tep_db_prepare_input($customer_id) . "' order by ticket_date_last_modified desc"; $customers_tickets_split = new splitPageResults($customers_tickets_raw, $customers_tickets_numrows); if ($customers_tickets_split->number_of_rows > 0 ) { ?> I changed the code to say this: <?php if (tep_session_is_registered('customer_id')) { $customers_tickets_raw = "select * from " . TABLE_TICKET_TICKET . " where ticket_customers_id = '" . tep_db_prepare_input($customer_id) . "' order by ticket_date_last_modified desc"; $customers_tickets_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $customers_tickets_raw, $customers_tickets_numrows); if ($customers_tickets_split->number_of_rows > 0 ) { ?> and the error went away, but it does not show a listing of existing tickets for the logged in customer. Any ideas what I could be doing wrong? I am not so good with php so any help will be greatly appreciated! Otherwise, this is a great contrib, and I appreciate your hard work. Also, there are folders called CVS in all your directories. Am I supposed to upload these? I am using OSC 2.2 MS1 Quote Greyson Schwing Link to comment Share on other sites More sharing options...
henri Posted August 26, 2003 Author Share Posted August 26, 2003 Did you get the right version of the ticket? MS2 != MS1 and earlier. Quote Link to comment Share on other sites More sharing options...
greytek Posted August 26, 2003 Share Posted August 26, 2003 The file I got is OSC-SupportTicketSystem_VS1.1.zip Is this correct? Quote Greyson Schwing Link to comment Share on other sites More sharing options...
henri Posted August 26, 2003 Author Share Posted August 26, 2003 The file I got is OSC-SupportTicketSystem_VS1.1.zip Is this correct? If you have MS2 Yes. Quote Link to comment Share on other sites More sharing options...
greytek Posted August 26, 2003 Share Posted August 26, 2003 I have MS1 Can you direct me to the proper version? Quote Greyson Schwing Link to comment Share on other sites More sharing options...
henri Posted August 26, 2003 Author Share Posted August 26, 2003 Downloadpage? Quote Link to comment Share on other sites More sharing options...
greytek Posted August 26, 2003 Share Posted August 26, 2003 huh? Quote Greyson Schwing Link to comment Share on other sites More sharing options...
henri Posted August 26, 2003 Author Share Posted August 26, 2003 AS i recall you find on the downloadpage two versions. One is for MS2 and the older one for everything before. Quote Link to comment Share on other sites More sharing options...
greytek Posted August 26, 2003 Share Posted August 26, 2003 :oops: Jeez, If only I took the time to read stuff lol thanks! Quote Greyson Schwing Link to comment Share on other sites More sharing options...
PropioWeb Posted August 26, 2003 Share Posted August 26, 2003 <?php if (tep_session_is_registered('customer_id')) { echo tep_draw_hidden_field('name',$customer['customers_firstname'] . ' ' . $customer['customers_lastname']) . $customer['customers_firstname'] . ' ' . $customer['customers_lastname']; } else { echo tep_draw_input_field('name', ($error ? $name : $first_name)); if ($error_name) echo ENTRY_ERROR_NO_NAME; } ?> must be changed to <?php if (tep_session_is_registered('customer_id') || tep_session_is_registered('affiliate_id')) { echo tep_draw_hidden_field('name',$customer['customers_firstname'] . ' ' . $customer['customers_lastname']) . $customer['customers_firstname'] . ' ' . $customer['customers_lastname']; } else { echo tep_draw_input_field('name', ($error ? $name : $first_name)); if ($error_name) echo ENTRY_ERROR_NO_NAME; } ?> The lines below the same Nope! that did not work either. Actually now if I'm logged in as a customer it tries to fill in the name and email but they are blank. :roll: Quote Samuel Mateo, Jr. osC 2.2 MS2 Installed Mods: WYSIWYG HTMLArea 1.7 | Basic Template System 1.0 | osC-Affiliate | OSC-SupportTicket Featured Products 1.3 | LoginBox 5.2 | LatestNews 1.1.3 | Extras for IE Link to comment Share on other sites More sharing options...
greytek Posted August 26, 2003 Share Posted August 26, 2003 Great news. All my problems went away when I installed the right version!!!!! Imagine that! :oops: ANyway. I am wondering now if there is a way to make the ticket ID a sequential set of numbers that includes the date. Example: 200308260001 200308260002 200308260003 and so on. I am thinking that the code that generates the Ticket ID is: $ticket_link_id = ''; for ($x=3;$x<10;$x++) { $ticket_link_id .= substr($time,$x,1) . tep_create_random_value(1, $type = 'chars'); } Instead of create random value, can it be made to pull in tht date and then generate the next number in the sequence? I am sure there is a function that can be written to do this, but of course I am not a programmer. Thanks again for everything, this helps a lot! Quote Greyson Schwing Link to comment Share on other sites More sharing options...
Tomas Posted August 27, 2003 Share Posted August 27, 2003 hi there guys: I've installed this contribution, but it doesn't work for me!! (murphy law). Links doesn't show at the admin page, and when I try to manually get into it by the URL bar, I get this: 1146 - Table 'store.TABLE_TICKET_ADMIN' doesn't exist select ticket_admin_id, ticket_admin_name from TABLE_TICKET_ADMIN where ticket_language_id = '3' [TEP STOP] I've read the readme file 100 times, but I still don't get It. I've uploaded all files again, created the database tables again, but nothing. I'm using the spanish language. What am I doing wrong? Thanks in advance! Quote Link to comment Share on other sites More sharing options...
PropioWeb Posted August 27, 2003 Share Posted August 27, 2003 hi there guys: I've installed this contribution, but it doesn't work for me!! (murphy law). Links doesn't show at the admin page, and when I try to manually get into it by the URL bar, I get this: 1146 - Table 'store.TABLE_TICKET_ADMIN' doesn't exist select ticket_admin_id, ticket_admin_name from TABLE_TICKET_ADMIN where ticket_language_id = '3' [TEP STOP] I've read the readme file 100 times, but I still don't get It. I've uploaded all files again, created the database tables again, but nothing. I'm using the spanish language. What am I doing wrong? Thanks in advance! It does seem to be a DB problem are you sure the tables were created succesfully? What are you using to create the tables phpMyAdmin is probably the best tool out there. BTW I translated the osC-Affiliate completely to Spanish. The one that is included is only partially translated. Right now I'm working on translating the Admin side, should be done by the weekend. Hopefully :roll: Quote Samuel Mateo, Jr. osC 2.2 MS2 Installed Mods: WYSIWYG HTMLArea 1.7 | Basic Template System 1.0 | osC-Affiliate | OSC-SupportTicket Featured Products 1.3 | LoginBox 5.2 | LatestNews 1.1.3 | Extras for IE Link to comment Share on other sites More sharing options...
Tomas Posted August 27, 2003 Share Posted August 27, 2003 Samuel: I've loaded the SQL dump into PHPMYADMIN, but I can't see that table. I've tried not twice but trice (sorry if it's mispelled), and no luck. PHPMYADMIN says this: DROP TABLE IF EXISTS ticket_admins;# MySQL ha devuelto un valor vac?o (i.e. cero columnas). CREATE TABLE ticket_admins( ticket_admin_id int( 11 ) NOT NULL default '0', ticket_language_id int( 11 ) NOT NULL default '0', ticket_admin_name varchar( 255 ) NOT NULL default '', PRIMARY KEY ( ticket_admin_id, ticket_language_id ) );# MySQL ha devuelto un valor vac?o (i.e. cero columnas). DROP TABLE IF EXISTS ticket_department;# MySQL ha devuelto un valor vac?o (i.e. cero columnas). CREATE TABLE ticket_department( ticket_department_id int( 5 ) NOT NULL default '0', ticket_language_id int( 11 ) NOT NULL default '0', ticket_department_name varchar( 60 ) NOT NULL default '', PRIMARY KEY ( ticket_department_id, ticket_language_id ) );# MySQL ha devuelto un valor vac?o (i.e. cero columnas). DROP TABLE IF EXISTS ticket_priority;# MySQL ha devuelto un valor vac?o (i.e. cero columnas). CREATE TABLE ticket_priority( ticket_priority_id int( 11 ) NOT NULL default '0', ticket_language_id int( 11 ) NOT NULL default '0', ticket_priority_name varchar( 60 ) NOT NULL default '', PRIMARY KEY ( ticket_priority_id, ticket_language_id ) );# MySQL ha devuelto un valor vac?o (i.e. cero columnas). DROP TABLE IF EXISTS ticket_reply;# MySQL ha devuelto un valor vac?o (i.e. cero columnas). CREATE TABLE ticket_reply( ticket_reply_id int( 11 ) NOT NULL default '0', ticket_language_id int( 11 ) NOT NULL default '0', ticket_reply_name varchar( 255 ) NOT NULL default '', ticket_reply_text text NOT NULL default '', PRIMARY KEY ( ticket_reply_id, ticket_language_id ) );# MySQL ha devuelto un valor vac?o (i.e. cero columnas). DROP TABLE IF EXISTS ticket_status;# MySQL ha devuelto un valor vac?o (i.e. cero columnas). CREATE TABLE ticket_status( ticket_status_id int( 5 ) NOT NULL default '0', ticket_language_id int( 11 ) NOT NULL default '0', ticket_status_name varchar( 60 ) NOT NULL default '', PRIMARY KEY ( ticket_status_id, ticket_language_id ) );# MySQL ha devuelto un valor vac?o (i.e. cero columnas). to name a few. (for non spanish speakers, "MySQL ha devuelto un valor vac?o (i.e. cero columnas)" means "MySQL hsa given an empty value (zero columns)). Pleaseeeee!! heeelpppp!! Quote Link to comment Share on other sites More sharing options...
PropioWeb Posted August 27, 2003 Share Posted August 27, 2003 Are you droping the tables manually or are you selecting the file from your computer and uploading it? I'm not sure if this makes any difference but that's what I did and it worked just fine. BTW, I made a mistake above. :roll: I meant to say I have a spanish version of Support Ticket and it's completely translated; admin and catalog. :D I also do have osC-Affiliate if you want it. :wink: Quote Samuel Mateo, Jr. osC 2.2 MS2 Installed Mods: WYSIWYG HTMLArea 1.7 | Basic Template System 1.0 | osC-Affiliate | OSC-SupportTicket Featured Products 1.3 | LoginBox 5.2 | LatestNews 1.1.3 | Extras for IE Link to comment Share on other sites More sharing options...
Tomas Posted August 28, 2003 Share Posted August 28, 2003 I've tried both... no luck yet... please!!! help!!!! Quote Link to comment Share on other sites More sharing options...
Tomas Posted August 28, 2003 Share Posted August 28, 2003 oohh... I forgot.... I can't see the admin features as well... that error is when I add the URL manually on the admin side. Thanks! Quote Link to comment Share on other sites More sharing options...
PropioWeb Posted August 28, 2003 Share Posted August 28, 2003 Hi Henri, I'm uploading the language files to your contribution in the Contributions section. Got one question. Are the language files compatible with both MS1 and MS2? I wanted to specify this in the description, but since I don't run MS1 I don't know. Thanks Quote Samuel Mateo, Jr. osC 2.2 MS2 Installed Mods: WYSIWYG HTMLArea 1.7 | Basic Template System 1.0 | osC-Affiliate | OSC-SupportTicket Featured Products 1.3 | LoginBox 5.2 | LatestNews 1.1.3 | Extras for IE Link to comment Share on other sites More sharing options...
edukes Posted August 30, 2003 Share Posted August 30, 2003 Hello, I installed the OSC TicketSystem but must have done something wrong. I have looked and looked but just can't spot the problem. On the main page where the new box is for the Tickets, all I get for the Title is: BOX_HEADING_TICKET Inside the box: BOX_TICKET_GENERATE BOX_TICKET_VIEW The admin section is working. TIA Quote Link to comment Share on other sites More sharing options...
PropioWeb Posted August 30, 2003 Share Posted August 30, 2003 Did you upload the ticket language file? That is where these are defined define ('BOX_HEADING_TICKET','Support Ticket'); define ('BOX_TICKET_GENERATE','Open Support Ticket'); define ('BOX_TICKET_VIEW','View Ticket'); Quote Samuel Mateo, Jr. osC 2.2 MS2 Installed Mods: WYSIWYG HTMLArea 1.7 | Basic Template System 1.0 | osC-Affiliate | OSC-SupportTicket Featured Products 1.3 | LoginBox 5.2 | LatestNews 1.1.3 | Extras for IE Link to comment Share on other sites More sharing options...
edukes Posted August 30, 2003 Share Posted August 30, 2003 I figured it out. I missed one of the files that needed to be modified. Thanks!!! Quote Link to comment Share on other sites More sharing options...
henri Posted August 31, 2003 Author Share Posted August 31, 2003 Hi Henri,I'm uploading the language files to your contribution in the Contributions section. Got one question. Are the language files compatible with both MS1 and MS2? I wanted to specify this in the description, but since I don't run MS1 I don't know. I think so. I only fixed small bugs, don't recall changing anything (but adding) to the language files. Cu Henri Quote Link to comment Share on other sites More sharing options...
Rustbullet Posted September 23, 2003 Share Posted September 23, 2003 The ticket systems seems to work fine except for one problem. 1. When a users leaves a new ticket, I get an email about a new ticket. 2. I go to admin and reply to the ticket. <problem> 3 User replies to my answer and i never know it because I never get an email saying they entered a new reply. With 20 tickets a day its takes a while to search all the tickets that are adding up to see if anyone replied and needs more information. Did I miss a step in the install ? CVS2M2 Dave Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.