jamalissimo
Forum Replies Created
-
Yeah, I know, it is on purpose :-). The problem is that it doesn’t mater on what form I am, field contestant_subcategory__1 always contains the same values. I think it is due to the fact that the field has the same name on all three forms but unfortunately, I need it this way so I can process all forms the same way
Hi @codepeople ,
Here are all registrations from all three forms. I am always getting values from the last one – subcategory-set-multiple. I think the issue could be mitigated by registering only the record set that exists on the current page and not all at once.
/* -------------------------- FORM 1 ------------------------- */ [cf7-recordset id="contest-set-four" type="database" query="SELECT * FROMwp_contestWHERE active=1 AND DATE(do) > CURDATE()"] [cf7-recordset id="subcategory-set-four" type="database" query="SELECT * FROMwp_contest_subcategoryWHERE active=1 AND category=2 ORDER BY sequence ASC"] [cf7-link-field recordset="contest-set-four" field="contest" value="ID" text="name" limit="1"] [cf7-link-field recordset="subcategory-set-four" field="contestant_subcategory__1" value="ID" text="name"] [cf7-link-field recordset="subcategory-set-four" field="contestant_subcategory__2" value="ID" text="name"] /* -------------------------- FORM 2 ------------------------- */ [cf7-recordset id="contest-set-solo" type="database" query="SELECT * FROMwp_contestWHERE active=1 AND DATE(do) > CURDATE()"] [cf7-recordset id="subcategory-set-solo" type="database" query="SELECT * FROMwp_contest_subcategoryWHERE active=1 AND category=1 ORDER BY sequence ASC"] [cf7-link-field recordset="contest-set-solo" field="contest" value="ID" text="name" limit="1"] [cf7-link-field recordset="subcategory-set-solo" field="contestant_subcategory__1" value="ID" text="name"] /* -------------------------- FORM 3 ------------------------- */ [cf7-recordset id="contest-set-multiple" type="database" query="SELECT * FROMwp_contestWHERE active=1 AND DATE(do) > CURDATE()"] [cf7-recordset id="subcategory-set-multiple" type="database" query="SELECT * FROMwp_contest_subcategoryWHERE active=1 AND category=3 ORDER BY sequence ASC"] [cf7-link-field recordset="contest-set-multiple" field="contest" value="ID" text="name" limit="1"] [cf7-link-field recordset="subcategory-set-multiple" field="contestant_subcategory__1" value="ID" text="name"] [cf7-link-field recordset="subcategory-set-multiple" field="contestant_subcategory__2" value="ID" text="name"] [cf7-link-field recordset="subcategory-set-multiple" field="contestant_subcategory__3" value="ID" text="name"] [cf7-link-field recordset="subcategory-set-multiple" field="contestant_subcategory__4" value="ID" text="name"]Hi, sorry for the late response. I checked the logs and there is a plenty of errors like this:
Table 'MYWPDB.wp_bwg_file_paths' doesn't exist. Query: SELECT COUNT(*) FROMwp_bwg_file_pathsWHEREpath= '/' ORDER BYis_dirDESC, date_modified desc LIMIT 0, 60. Function: do_action('wp_ajax_addImages'), WP_Hook->do_action, WP_Hook->apply_filters, BWG->bwg_filemanager_ajax, FilemanagerController->execute, FilemanagerController->display, FilemanagerModel->get_file_lists.Could it be caused by insufficient rights of the db user? I mean that the plugin should create the table but didn’t have rights?
Forum: Plugins
In reply to: [Photo Gallery by 10Web - Mobile-Friendly Image Gallery] Custom paginatorDidn’t have time to investigate photo gallery plugin. I used nextgen gallery and I am getting images from gallery with this:
$gallery = $nggdb->get_gallery($_POST["gall_id"], 'filename', 'ASC', true, $_POST["limit"], $_POST["offset"]); foreach($gallery as $image) { echo '<a href="'.$image->imageURL.'" rel="lightbox">'; echo '<img src="'.$image->thumbnailURL.'" alt="'.$image->alttext.'" title="'.$image->description.'">'; echo '</a>'; }Hope it will help somebody 😉