New Support v1b

[Guest]

Hi,

I have been trying to configure the new Support v1b system for a couple of week now and come up with a few problems.

 

1)

On the site itself the box heading Title is showing BOX_HEADDING_SUPPORT rather than just SUPPORT

No matter what I have Tried, I can not get the title to just show Support.

 

2)

Again on the site itself, when Help Desk is clicked on I am taken to the support Page. Everything seems to be there that should be but under the Main, New Ticket etc headings. the Following Is showing:

 

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select * from support_tickets where customers_id = \'2\' and ti

 

select count(select * from support_tickets where customers_id = \'2\' and ticket_status=\'1\' order by ticket_date DESC) as total

 

[TEP STOP]

 

3)

Lastly, in Admin I am getting a fatal error report as follows:

 

Fatal error: Call to undefined function: tep_array_merge() in /catalog/admin/support.php on line 388.

The Offending Line being:

<td class="smallText" align="right"><?php echo HEADING_TITLE_STATUS . ' ' . tep_draw_pull_down_menu('status', tep_array_merge(array(array('id' => '', 'text' => TEXT_ALL_ORDERS)), $orders_statuses), '', 'onChange="this.form.submit();"'); ?></td>

 

I have been told to look in the instructions to rectefy this problem but I can find No mention of it anywhere in the instructions or in the Forum.

 

Can anyone please help me out with configuring support v1b on my site. Web address & Access will be given, via private email, to anyone who can help as I think it would be better to SEE the problems rather than me discribe them.

 

Thanks

Dave

[Guest]

Hi,

I have been trying to configure the new Support v1b system for a couple of week now and come up with a few problems.

 

1)

On the site itself the box heading Title is showing BOX_HEADDING_SUPPORT rather than just SUPPORT

No matter what I have Tried, I can not get the title to just show Support.

 

2)

Again on the site itself, when Help Desk is clicked on I am taken to the support Page. Everything seems to be there that should be but under the Main, New Ticket etc headings. the Following Is showing:

 

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select * from support_tickets where customers_id = \'2\' and ti

 

select count(select * from support_tickets where customers_id = \'2\' and ticket_status=\'1\' order by ticket_date DESC) as total

 

[TEP STOP]

 

3)

Lastly, in Admin I am getting a fatal error report as follows:

 

Fatal error: Call to undefined function: tep_array_merge() in /catalog/admin/support.php on line 388.

The Offending Line being:

<td class="smallText" align="right"><?php echo HEADING_TITLE_STATUS . ' ' . tep_draw_pull_down_menu('status', tep_array_merge(array(array('id' => '', 'text' => TEXT_ALL_ORDERS)), $orders_statuses), '', 'onChange="this.form.submit();"'); ?></td>

 

I have been told to look in the instructions to rectefy this problem but I can find No mention of it anywhere in the instructions or in the Forum.

 

Can anyone please help me out with configuring support v1b on my site. Web address & Access will be given, via private email, to anyone who can help as I think it would be better to SEE the problems rather than me discribe them.

 

Thanks

Dave

Can Anyone Please Help with this problem.

I have tyied loads off different ways to correct it but nothing seems to work.

I am now desperate to get the site up and running.

 

Thanks in advance

Dave

[Stuart]

Hi

 

OK, the first problem is quite easy to fix - you need to go into the languages files and copy one of the "define(" statements replacing the words in capitals with BOX_HEADDING_SUPPORT and then the text you want after the equals sign.

 

For the rest, the mysql problem looks like the sql file was not quite right - perhaps take a look at that in the file provided and post it if you still need help. The undefined function is the differences between MS1 and MS2 ... change tep_array to array and it may work - perhaps it might be worth looking for the contribution updated for MS2 ? I'm assuming that is what you are running.

 

Good luck

 

Stuart

[Guest]

Hi Stuart,

Firstly, thanks for your reply. I resolved the BOX HEADING No Problem using the method you suggested. ;)

 

The second problem has been more diffecult to put right. After many hours, Days in fact, searching the forum for a solution, I finaly found one :D

 

The support Ticket is now working fine both in the catalog and the Admin.

The only problem is, I was so relieved to find the fix, I forgot to make a not of where I found it <_< I now have to trawl throughmy History Files to see if I can locate it.

 

Thanks again for your most welcome help

 

Dave

[Stuart]

Hi Dave

 

Congrats on your successful hacking ... its all part of the fun eh!

 

Sorry I haven't replied quicker but the forum email doesn't seem to come to me any more. I actually came across your post again as I have a problem with the support ticket system which I'm trying to resolve - once someone has posted a support request by logging in and then going through the support.php page, the email is successfully sent but the user is logged out and redirected to the login page instead of remaining logged in and being redirected to the success page ... if you or anyone else have any suggestions I would be grateful - I think you may have to pm me the reply if you have any ideas as I won't get notified by the forum.

 

Cheers

Stuart :D

[jclark2906]

The second problem has been more diffecult to put right. After many hours, Days in fact, searching the forum for a solution, I finaly found one :D

SO what is the solution??? I;ve been trying to find out for a couple of weeks now, and while I'm pleased for you that you've got your site sorted, it would be nice if you could post the solution for me (and others?) to use too. :D