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

TOPIC: [SOLVED] SQL error

[SOLVED] SQL error 16 years 2 months ago #760

  • babbsela
  • babbsela's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 10
  • Thank you received: 0
I've installed 2.1.4a on Joomla 1.0.15 with JEvents 1.4.2 When I go to the Registration Manager, click "New" and set up an event that was entered in JEvents, that I've selected from the drop-down list, I fill in all the required info, click "SAVE" and get this 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 ')' at line 1" How do I fix this?

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

[SOLVED] SQL error 16 years 2 months ago #761

  • dthadmin
  • dthadmin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 5470
  • Thank you received: 3
Are you using any custom fields? Please submit a support ticket with joomla admin and FTP access so we can check everything out. Thanks.

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

[SOLVED] SQL error 16 years 2 months ago #762

  • babbsela
  • babbsela's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 10
  • Thank you received: 0
No custom fields. This was the first attempt to set up a registration, using default settings. Ticket submitted. Thanks.

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

[SOLVED] SQL error 16 years 2 months ago #763

Just purchased! Same issue!! All default settings with first attempt to set up a registration!! Please help, URGENT !! JEvents 1.43RC, Joomla 1.5.1, DTRegister2_1_4 Thanks!

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

[SOLVED] SQL error 16 years 2 months ago #764

  • dthadmin
  • dthadmin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 5470
  • Thank you received: 3
Danny, your issue is because DT Register does not yet work with Joomla 1.5. We are working on that right now and it's taking longer than we hoped to get it released, but at this point our target is another week or so. Stay tuned!

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

[SOLVED] SQL error 16 years 2 months ago #765

  • dthadmin
  • dthadmin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 5470
  • Thank you received: 3
babbsela - We have determined the reason for your error. The box for event capacity needs to have something entered. Now we've set this up on many sites and not had this issue, but it must be related to your server config and SQL version. On your site, the error comes when no value is entered for capacity. If you enter "0

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

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