Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: [SOLVED] 2.1.4 Error When Creating New Event

[SOLVED] 2.1.4 Error When Creating New Event 16 years 4 months ago #435

  • dlamparty
  • dlamparty's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 13
  • Thank you received: 0
I get the following error when trying to create a new event after installing the new release. I am using MYSQL 5

Event Title: Error 1: 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 '' at line 1

TIA, Woyzeck

Please Log in or Create an account to join the conversation.

[SOLVED] 2.1.4 Error When Creating New Event 16 years 4 months ago #436

  • jerica
  • jerica's Avatar
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 8
  • Thank you received: 0
I get this error as well. Please respond!!!!

Please Log in or Create an account to join the conversation.

[SOLVED] 2.1.4 Error When Creating New Event 16 years 4 months ago #437

  • dlamparty
  • dlamparty's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 13
  • Thank you received: 0
Hmmm.... I went in and changed line 85 in class.dtregister.php to:
$eventid = mysql_query("SELECT distinct(eventid) FROM jos_dtregister_group_event") or die("Error 1: <br>".mysql_error());
from:
$eventid = mysql_query("SELECT distinct(eventid) FROM #__dtregister_group_event") or die("Error 1: <br>".mysql_error());
And it is now working. Odd though as it should not matter, right? Woyzeck

Please Log in or Create an account to join the conversation.

[SOLVED] 2.1.4 Error When Creating New Event 16 years 4 months ago #438

  • dthadmin
  • dthadmin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 5470
  • Thank you received: 3
We had made changes in 2.1.4 to work for those who do not use jos_ for their database prefix. Looks like one change had an issue. We have corrected this. To get the fixed version, you can download 2.1.4 again from your account or you can just download this file and upload it as class.dtregister.php in /components/com_dtregister/

Attachment class.dtregister.txt not found

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Time to create page: 0.105 seconds