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

TOPIC: SOLVED - Registration form MySQL error on line 344

SOLVED - Registration form MySQL error on line 344 13 years 8 months ago #13293

  • springsage
  • springsage's Avatar Topic Author
  • Visitor
  • Visitor
Hello all,

I'm hoping for a little diagnostic help here. DT Register was set up for me by a friend who has used it before but I'm brand new to DT Register, & attempting to set up my menu link for registration. Actually, I set it up but I evidently missed something important, either in the menu item configuration or in the DT configuration itself. When I test the form & select registration type (individual vs. group), I get about 40 of this particular error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/royalprc/public_html/libraries/joomla/database/database/mysql.php on line 344
Table 'royalprc_jo151.jos_dtregister_group' doesn't exist SQL=select * from jos_dtregister_group_member as gm inner join jos_dtregister_group as g on g.groupId= gm.groupUserId inner join jos_dtregister_user as u on u.userId = g.useid inner join jos_dtregister_member_field_values v on v.member_id = gm.groupMemberId where v.field_id=1 and CONCAT('|',v.`value`,'|') like '%|0|%' and u.payment_verified = 1 and u.eventId = 1


This is followed (if I scroll down far enough) by the actual correct form for the registration. Does anyone know what the heck is going on?

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

SOLVED - Registration form MySQL error on line 344 13 years 8 months ago #13295

  • springsage
  • springsage's Avatar Topic Author
  • Visitor
  • Visitor
quick caveat- the error messages are not identical,

v.field_id

numbers and

CONCAT('|',v.`value`,'|') like % %

numbers vary

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

SOLVED - Registration form MySQL error on line 344 13 years 8 months ago #13300

  • dthadmin
  • dthadmin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 5470
  • Thank you received: 3
Hello. Sorry, but I don't see any license for DT Register associated with your username. You should submit a ticket using the login account associated with your site and your license. Thanks.

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

SOLVED - Registration form MySQL error on line 344 13 years 8 months ago #13386

  • springsage
  • springsage's Avatar Topic Author
  • Visitor
  • Visitor
@dthadmin

I apologize for that- the person who was supposed to buy the license for this site mislead us. :oops: I have just purchased a single site license and should now show up in your database. :D

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

SOLVED - Registration form MySQL error on line 344 13 years 8 months ago #13387

  • springsage
  • springsage's Avatar Topic Author
  • Visitor
  • Visitor
Just an update, there were MySQL files missing from the host box. Wish I had more details, but the host admin uploaded the missing files & everything works.

Springsage

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

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