TOPIC: SOLVED - Registration form MySQL error on line 344
SOLVED - Registration form MySQL error on line 344
13 years 8 months ago #13293
springsage
Topic Author
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?
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.
SOLVED - Registration form MySQL error on line 344
13 years 8 months ago #13386
springsage
Topic Author
Visitor
@dthadmin
I apologize for that- the person who was supposed to buy the license for this site mislead us. I have just purchased a single site license and should now show up in your database.
SOLVED - Registration form MySQL error on line 344
13 years 8 months ago #13387
springsage
Topic Author
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.