vb.org Archive
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   RPG Integration Hack (https://vborg.vbsupport.ru/forumdisplay.php?f=102)
-   -   URGENT: A HUGE line of error! (https://vborg.vbsupport.ru/showthread.php?t=92526)

nirmah 07-19-2005 11:15 PM
URGENT: A HUGE line of error!
 
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 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 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 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 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 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 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 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 07-29-2005 01:21 PM
Ah, I just got this Error. Thanks.

Revan 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.


All times are GMT. The time now is 12:34 AM.
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

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.01090 seconds
  • Memory Usage 1,758KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (2)bbcode_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete