Blog Search Problem

[NoDRaC]

When i click search blog it gives this error



Warning: ini_set() has been disabled for security reasons in [path]/blog_search.php on line 105

[NoDRaC]

when i want to add featured entry i take this error


Database error in vBulletin 3.7.3:

Invalid SQL:

SELECT blog.*, blog.options AS blogoptions, blog_text.pagetext, blog_text.ipaddress AS blogipaddress, blog_text.allowsmilie, user.*, bu.title AS blogtitle, bu.memberids,
blog_textparsed.pagetexthtml, blog_textparsed.hasimages, bu.options_member, bu.options_guest, bu.options_buddy,
blog_editlog.userid AS edit_userid, blog_editlog.dateline AS edit_dateline, blog_editlog.reason AS edit_reason, blog_editlog.username AS edit_username,
customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline, customprofilepic.width AS ppwidth, customprofilepic.height AS ppheight

, gm.permissions AS grouppermissions, IF(blog_subscribeentry.blogsubscribeentryid, 1, 0) AS entrysubscribed
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight



FROM blog AS blog
INNER JOIN blog_text AS blog_text ON (blog.firstblogtextid = blog_text.blogtextid)
LEFT JOIN blog_editlog AS blog_editlog ON (blog_editlog.blogtextid = blog.firstblogtextid)
LEFT JOIN blog_textparsed AS blog_textparsed ON(blog_textparsed.blogtextid = blog_text.blogtextid AND blog_textparsed.styleid = 16 AND blog_textparsed.languageid = 9)

LEFT JOIN user AS user ON (blog.userid = user.userid)
LEFT JOIN customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid)
LEFT JOIN blog_user AS bu ON (bu.bloguserid = blog.userid)
LEFT JOIN blog_groupmembership AS gm ON (blog.userid = gm.bloguserid AND gm.userid = 1)
LEFT JOIN blog_subscribeentry AS blog_subscribeentry ON (blog.blogid = blog_subscribeentry.blogid AND blog_subscribeentry.userid = 1)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
LEFT JOIN userlist AS ignored ON ignored.userid = blog.userid AND relationid = 1 AND ignored.type = 'ignore'
LEFT JOIN userlist AS buddy ON (buddy.userid = bu.bloguserid AND buddy.relationid = 1 AND buddy.type = 'buddy')


WHERE blog.blogid IN (1)
AND blog.dateline <= 1223118096
AND blog.pending = 0
AND blog.state = 'visible'
AND bu.options_buddy & 1
AND bu.options_member & 1
AND bu.options_guest & 1
AND ~blog.options & 8
AND (bu.options_ignore & 1 OR ignored.relationid IS NULL)

ORDER BY blog.dateline DESC;

MySQL Error : Column 'relationid' in on clause is ambiguous
Error Number : 1052
Request Date : Saturday, October 4th 2008 @ 02:01:36 PM
Error Date : Saturday, October 4th 2008 @ 02:01:37 PM
Script : http://arkasokak.net/blog.php
Referrer : http://arkasokak.net/
IP Address : 88.234.215.153
Username : NoDRaC
Classname : vB_Database
MySQL Version : 4.1.22-standard-log

[Steve Machol]

The first error is a server issue. You need to contact your host about this.

The second one is due to a third-party add-on that added an extra field that is causing this error. You will need to find and remove that add-on and the db changes it made.

[NoDRaC]

for first error what can i do what will i say to my host?

for second problem i disabled all product but problem still contiune

[Steve Machol]

Tell then to enable ini_set.

[NoDRaC]

Tell then to enable ini_set.

thanks
and for second error what can i do?

[Steve Machol]

As I posted:


The second one is due to a third-party add-on that added an extra field that is causing this error. You will need to find and remove that add-on and the db changes it made.

[NoDRaC]

i can not find problem ca i solve this problem directly database if i can how?

i find "relationid" under userlist table is it true should i delete it?

there is only 1 relationid colum under userlist table do i delete this?

[PitchouneN64ngc]

The 'relationid' column in the table 'userlist' comes with vBulletin and you must to keep it.

You have an other 'relationid' column in one of these tables:


blog
blog_text
blog_editlog
blog_textparsed
user
customprofilepic
blog_user
blog_groupmembership
blog_subscribeentry
avatar

Only you knows if you have it on one of these tables or not.

[NoDRaC]

The 'relationid' column in the table 'userlist' comes with vBulletin and you must to keep it.

You have an other 'relationid' column in one of these tables:


blog
blog_text
blog_editlog
blog_textparsed
user
customprofilepic
blog_user
blog_groupmembership
blog_subscribeentry
avatar

Only you knows if you have it on one of these tables or not.

thankyou PitchouneN64ngc (http://www.vbulletin.com/forum/member.php?u=38627) i double check these tables but there is no another relationid column what can i do ?

[NoDRaC]

these problems fixed after upgrade blog beta3:mad: i waste time to fix them