TOPIC: [SOLVED] 2.1.4 Error When Creating New Event

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

dlamparty Topic Author Offline 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 Check this box to be notified of replies to this topic. Note: BBcode and smileys are still usable.
	Please Log in or Create an account to join the conversation.

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

jerica Offline Fresh Boarder Posts: 8 Thank you received: 0	I get this error as well. Please respond!!!! Check this box to be notified of replies to this topic. Note: BBcode and smileys are still usable.
	Please Log in or Create an account to join the conversation.

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

dlamparty
Topic Author
Offline
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 10 months ago #438

dthadmin
Offline
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/

TOPIC: [SOLVED] 2.1.4 Error When Creating New Event

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

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

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

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

Attachment class.dtregister.txt not found