Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 Programming Discussions
Prev Previous Post   Next Post Next
  #1  
Old 04-01-2010, 10:34 PM
Jaxel Jaxel is offline
 
Join Date: Sep 2005
Posts: 1,160
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default How do you check multifield unique keys in DataMan?

So I'm using the DataMan, and it seems pretty simple... however, I am having problems checking for unique values... This is one of my VF_METHOD functions...

Code:
function verify_serviceVAL(&$serviceVAL)
{
	$serviceID = $this->fetch_field('serviceID');

	if (!$media = $this->dbobject->query_first("
		SELECT * FROM " . TABLE_PREFIX . "media AS media
		WHERE serviceVAL = '" . $serviceVAL . "'
			AND serviceID = '" . $serviceID . "'
	"))
	{
		$this->error('media_already_exists');
		return false;
	}

	return true;
}

Theoretically, with this code, if the combined values for serviceVAL and serviceID are not unique, it should return an error. However, it doesn't seem to be working for me, and I keep getting a database error...

Code:
Database error in vBulletin 4.0.2:

Invalid SQL:
INSERT INTO media
	(categoryID, userID, serviceID, serviceVAL, username, title, description, length, dateline)
VALUES
	(2, 1, 2, '9953368', 'Jaxel', 'Nature by Numbers', 'A SHORT MOVIE INSPIRED ON NUMBERS', 224, 1270164500);

MySQL Error   : Duplicate entry '2-9953368' for key 2
Error Number  : 1062

In my table, I have a UNIQUE KEY called "service" for "serviceID, serviceVAL"; which is why its posting the error. However, the code in the datamanager I have above should prevent this hard error from showing it up. But its not working...

Am I doing something wrong?

--------------- Added [DATE]1270165322[/DATE] at [TIME]1270165322[/TIME] ---------------

Also, quick question about data managers... what is the difference between REQ_NO and REQ_AUTO; the manual doesn't really explain a difference.
Reply With Quote
 

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 11:06 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03559 seconds
  • Memory Usage 2,245KB
  • Queries Executed 12 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (2)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (2)post_thanks_box
  • (2)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (2)post_thanks_postbit_info
  • (2)postbit
  • (2)postbit_onlinestatus
  • (2)postbit_wrapper
  • (1)showthread_list
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_threadedmode.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids_threaded
  • showthread_threaded_construct_link
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete