vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   HelpDesk v1.63 (https://vborg.vbsupport.ru/showthread.php?t=77155)

Challenge 03-06-2005 04:28 PM

Quote:

Originally Posted by Challenge
Hi again.
A bug here: Now, after installing the hack, every time i recheave a PM i get the popup. Even though i have set PM Popup to off. (3.0.7)

Challenge.

Hmm... Dosent do it anymore...Wierd :S

WhSox21 03-06-2005 04:48 PM

Quote:

Originally Posted by Challenge
Hmm... Dosent do it anymore...Wierd :S

I have the query in the database to do the pop-up. I'll fix that so it is based on people's prefrences. Now I'm going to go through and try to fix these bugs everyone is having. It seems that the lower versions of MySQL is having the problems. I'll attach a file to a post below and anyone who wants to help out can.

WhSox21 03-06-2005 04:52 PM

Anyone having trouble with the database errors (not the delete error, that's next) try just uploading this helpdesk.php file and let me know if it works.

WhSox21 03-06-2005 04:55 PM

Quote:

Originally Posted by Slave
Seems I've found a bug ..

When you try to delete a ticket it comes up with a mysql error ..

Database error in vBulletin 3.0.3:

Invalid SQL: INSERT INTO domain_com_-_forums.ticketdeleted SELECT * FROM domain_com_-_forums.ticket WHERE ticketid = 3
mysql error: 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 '-_forums.ticketdeleted SELECT * FROM domain_com_-_forums.

mysql error number: 1064

Date: Sunday 06th of March 2005 06:42:38 AM
Script: http://www.domain.com/helpdesk.php?do=delete&tid=3
Referer: http://www.domain.com/helpdesk.php?do=ticket&tid=3
Username: Slave

Try this file to fix your delete problem. I tested it and it worked for me so let me know if it works for you.

WhSox21 03-06-2005 04:56 PM

Quote:

Originally Posted by Slave
Cheers WhSox21 .. :)

BTW .. is the system meant to send emails/pm to admin to let them know a new ticket is there? .. I don't seem to be getting them if it is ..?

Not it's not supposed to yet. Only an auto-reply when you create tickets.

MissKalunji 03-06-2005 04:57 PM

Quote:

Originally Posted by WhSox21
Anyone having trouble with the database errors (not the delete error, that's next) try just uploading this helpdesk.php file and let me know if it works.


where do they go to get that error ? i wanna see if i got the problem to...

WhSox21 03-06-2005 05:00 PM

Just about any administer link will give you the error. I believe it's a problem with the syntax I used, it doesn't support the older versions of MySQL. I've changed it to do exactly how vBulletin does so it should work.

WhSox21 03-06-2005 05:02 PM

Quote:

Originally Posted by LOTR
Thanks WhSox21.. but seems the bugs is still there. I've rewrite the helpdesk.php file (1.52)

This will be fixed in the next version once I sort out all the other bugs.

WhSox21 03-06-2005 05:04 PM

Quote:

Originally Posted by computer1
Can you upload 1.5 igen is invalid link so I cant download the nev version please

Why do you want the older version? There is a newer version out download that as it fixes bugs.

Bolas 03-06-2005 05:17 PM

I got the same database error with a CLEAN installation of 1.52 while running helpdesk.php.
my vb version is 3.06

Code:

Invalid SQL: INSERT INTO domain_com_-_forums.ticketdeleted SELECT * FROM domain_com_-_forums.ticket WHERE ticketid = 3
mysql error: 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 '-_forums.ticketdeleted SELECT * FROM domain_com_-_forums.

mysql error number: 1064

MySQL 3.23.58


All times are GMT. The time now is 11:33 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01525 seconds
  • Memory Usage 1,745KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete