The Arcive of Official vBulletin Modifications Site.

URGENT: A HUGE line of error! · **Released**: 07-19-2005

I checked the FAQ, but it doesn't seem to have the answer to this.

When I go to showthread.php file, I get this error.

Code:

Database error in vBulletin 3.0.7:

Invalid SQL: 
		SELECT
			post.*, post.username AS postusername, post.ipaddress AS ip,
			user.*, userfield.*, usertextfield.*,
			userfield.field AS rpgname,
			user.ma AS uma,user.hp AS uhp,user.pp AS upp,user.ap AS uap,
			rpg_items_user.*,
			rpg_battle_stats.*,
			rpg_race.name AS rpgracename,
			rpg_race.alignment AS rpgalignmentname,
			rpg_class.name AS classname,
        	rpg_class.folder AS classfolder,
			rpg_element.name AS elename,
			rpg_clan.title AS clantitle,
	
			icon.title as icontitle, icon.iconpath,
			avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline,
			level,
			NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
			editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
			editlog.reason AS edit_reason,
			post_parsed.pagetext_html, post_parsed.hasimages,
			IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
			
		FROM post AS post
		LEFT JOIN user AS user ON(user.userid = post.userid)
		LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
		LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
		LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
		LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)
		LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND deletionlog.type = 'post')
		LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
		LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid)
		LEFT JOIN rpg_items_user AS rpg_items_user ON(rpg_items_user.userid=user.userid)
		LEFT JOIN rpg_battle_stats AS rpg_battle_stats ON(rpg_battle_stats.userid=user.userid)
		LEFT JOIN rpg_class AS rpg_class ON(rpg_class.id=user.rpgclass)
		LEFT JOIN rpg_element AS rpg_element ON(rpg_element.elementid=user.element)
		LEFT JOIN rpg_clan AS rpg_clan ON(rpg_clan.clanid=user.clan)
		LEFT JOIN rpg_race AS rpg_race ON(rpg_race.raceid=user.rpgrace)
			AND rpg_race.alignmentid=user.alignment
	
		WHERE post.postid IN (0,1)
		ORDER BY dateline 
	
mysql error: Unknown column 'userfield.field' in 'field list'

mysql error number: 1054

I've been trying to figure out the problem myself, but just can't notice it. Do you?

Thank you,
- Static

tamarian · #2 07-19-2005, 11:29 PM

Quote:

userfield.field AS rpgname,

Something went wrong installing an RPG hack?

I don't have any experience with RPG, but seems like you needed to define a custom user field for it, then specify which filed it was. Here it seems like the field has no number, while it should be something like field7 or field 20, depending on which field you made for it.

nirmah · #3 07-20-2005, 04:06 AM

Thanks for pointing it out tamarian!

I just noticed that the RPG Profile field was 5 and the RPG Name field had no number, which I think confused the system. Changed it to field5 and its working great now!

Thanks!

- Static

P.S. Before, I go, can I ask where I can find how to add another navigation bar below the current one so I can add the RPG links?

Thanks

Oops. I guess I shouted way too fast!

Alright, so now the showthread.php works, but even when I changed the field to field5, the showpost.php displays this error.

Code:

Invalid SQL: 
	SELECT
		post.*, post.username AS postusername, post.ipaddress AS ip,
		user.*, userfield.*, usertextfield.*,
		userfield.field5 AS rpgname,
		user.ma AS uma,user.hp AS uhp,user.pp AS upp,user.ap AS uap,
		rpg_items_user.*,
		rpg_battle_stats.*,
		rpg_race.name AS rpgracename,
		rpg_race.alignment AS rpgalignmentname,
		rpg_class.name AS classname,
       	rpg_class.folder AS classfolder,
		rpg_element.name AS elename,
		rpg_clan.title AS clantitle,

		icon.title as icontitle, icon.iconpath,
		IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
		,avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline
		,level,
		NOT ISNULL(deletionlog.primaryid) AS isdeleted,
		post_parsed.pagetext_html, post_parsed.hasimages
		
	FROM post AS post
	LEFT JOIN user AS user ON(user.userid = post.userid)
	LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
	LEFT JOIN rpg_items_user AS rpg_items_user ON(rpg_items_user.userid=user.userid)
	LEFT JOIN rpg_battle_stats AS rpg_battle_stats ON(rpg_battle_stats.userid=user.userid)
	LEFT JOIN rpg_class AS rpg_class ON(rpg_class.id=user.rpgclass)
	LEFT JOIN rpg_element AS rpg_element ON(rpg_element.elementid=user.element)
	LEFT JOIN rpg_clan AS rpg_clan ON(rpg_clan.clanid=user.clan)
	LEFT JOIN rpg_race AS rpg_race ON(rpg_race.raceid=user.rpgrace)
		AND rpg_race.alignmentid=user.alignment

	LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
	LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
	LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)
	LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
	LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid)
	WHERE post.postid = 1

mysql error: Column 'type' in on clause is ambiguous

mysql error number: 1052

[EDIT] I saw the FAQ, but where do I delete the "AND type = 'post'" and also, I'm running the latest version right now, so shall I do the same fix of deleted the and type = post part? Also, I'm very noobish, so I'd have to ask, where do I go to delete this?

Otikeu · #4 07-24-2005, 03:20 AM

I have alot of mysql issues like this too, what could be causing this? I mean, in updating rpg status, showthread.php, etc.

neolithic · #5 07-24-2005, 07:22 AM

I have noticed that this error only occurs on my forum when someone who isnt' registered tries to browse the threads. I've changed the way the unregistered usergroup works so that they can't browse anything unless they log in, testing that to see if it will stop those errors from flooding through.

nirmah · #6 07-24-2005, 01:54 PM

Actually, that error comes up when I'm in my administrator ID. So I don't think your solution will be helpful here neolithic. Thanks anyways.

- Static

tamarian · #7 07-24-2005, 01:55 PM

Try changing this line in showpost:

PHP Code:


			
LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')

To this:

PHP Code:


			
LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND deletionlog.type = 'post')

Revan · #8 07-29-2005, 12:39 PM

Tamarians fix is correct.
And I figured it would be quite obvious that you edit the file corresponding to the file in which you are recieving the error...

Hoffi · #9 07-29-2005, 01:21 PM

Ah, I just got this Error. Thanks.

Revan · #10 07-29-2005, 05:23 PM

This should not happen in future versions, Im gonna make sure the field is set properly and working. Probably just a bug in the installer.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.06113 seconds Memory Usage 2,308KB Queries Executed 25 (?)
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 (2)bbcode_php (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (9)postbit (10)postbit_onlinestatus (10)postbit_wrapper (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_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 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 pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!