[Inspector G]

Here is a list of errors to report back on...

DB error after Install I enabled the features in the admin CP rebuilt all styles and index and general updates to threads everything then when I went to front end I received this

Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT status.*,
avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
user.userid, user.username
FROM vb_status as status
LEFT JOIN vb_user ON user.userid = status.userid

LEFT JOIN vb_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON(customavatar.userid = user.userid)
where 1=1 AND status.hasimage != 1 order by status.dateline desc LIMIT 5;

MySQL Error : Unknown column 'user.userid' in 'field list'
Error Number : 1054
Request Date : Tuesday, February 5th 2013 @ 05:44:24 PM
Error Date : Tuesday, February 5th 2013 @ 05:44:26 PM
Script : http://www.freedomofspeech.cc/forum.php
Referrer : http://www.freedomofspeech.cc/online.php
IP Address :
Username :
Classname :
MySQL Version : 5.1.66-cll

.

DB error when widgets are active but the the wall is working fine so far
( I stand Corrected some features are working others are not) I will explain in detail...

This is a copy of the first error received until we removed the widgets from being active and deleted them completely...
[6:06:08 PM] Mark White: Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT status.*,
avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
user.userid, user.username
FROM vb_status as status
LEFT JOIN vb_user ON user.userid = status.userid

LEFT JOIN vb_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON(customavatar.userid = user.userid)
where 1=1 AND status.hasimage != 1 order by status.dateline desc LIMIT 5;

MySQL Error : Unknown column 'user.userid' in 'field list'
Error Number : 1054
Request Date : Tuesday, February 5th 2013 @ 05:44:24 PM
Error Date : Tuesday, February 5th 2013 @ 05:44:26 PM
Script : http://www.freedomofspeech.cc/forum.php
Referrer : http://www.freedomofspeech.cc/online.php
IP Address :
Username :
MySQL Version : 5.1.66-cll


Removed widgets and then no db error...went back to front end
wall was in profile and seemed to be working I was able to add hippy as friend...

When Hippy then clicked on a Post on my wall he selected dislike....

then we go the following DB error...
Invalid SQL:
SELECT dislikes.dislikeid, user.username, user.userid FROM vb_dislikes
LEFT JOIN vb_user on user.userid = dislikes.givenby
LEFT JOIN vb_status on status.id = dislikes.statusid
where dislikes.statusid = 2 AND dislikes.commentid = 0
order by (case dislikes.givenby when 1 then 0 else 1 end), dislikes.dateline desc LIMIT 3;

MySQL Error : Unknown column 'dislikes.dislikeid' in 'field list'
Error Number : 1054
Request Date : Tuesday, February 5th 2013 @ 06:10:03 PM
Error Date : Tuesday, February 5th 2013 @ 06:10:04 PM
Script : http://www.freedomofspeech.cc/member.php/1-Mark
Referrer : http://www.freedomofspeech.cc/member.php/1-Mark
IP Address :
Username :
Classname :
MySQL Version : 5.1.66-cll

Uninstalled pro version but this box was missing ,I think we call it the Status box...

See Screen shot 1...

To correct we followed these steps...
Installed Light version....then the pro version over the top, to get the Blue box Back...

Notice the 2 additional attached screen shots...# 2 and 3
You will notice the wall tab is lit. However the status and the other options have 0 effect when selected look at the activity stream below tabs you can see they are not changing at all no matter what tab you select...

Ever seen those errors on a web page when you click on the link and you See Javascriptvoid(0) same thing I think the links are broken if I understand it correctly...

I can select any of the tabs and it stays the same however the Tab does change to lit...

I think we still have a ways to go here with these plus the widget...



OK most of the tabs in Status window seem to be working somewhat...
Here is what I mean...

First Tab is Status with nice blue text box open...when I select any language it does nothing but still uses English...

So I am unsure if this is built in to your social/// looks like it is dependent on Language packs at VB level..

so I really do not want those, options could be removed or a tick box with message stating forum needs language pack to enable or

If they are supposed to work..well now you know they do not...

I have only English Installed Since the name of my site shows I want Americans on my site...
Would not mind Latino pack since we have so many in the US now and I work with Spanish also...
NOT being Racist at all folks My site is called Freedom Of Speech, and I would kinda like folks that visit to be able to read English in the forum...

Next Issue to tackle...
Next Tab is place I see no change at all happen...

Live event Tab I do get taken to add event page...

Poll Tab Nothing happens...
Yep created Poll just to see what functions this may or may not have and I stay on profile page with no actions evident...
Needs work here or an explanation...

Link Tab seems to show an Image of a Nikon Camera made into a clock I select view and see it kinda...
Have no clue what this option is really for at this time but Ok seems to be semi working...

Note Tab Selected Takes me to Blogs...Not good here...
Why not call it Blogs...
I have link on Forum for Blogs really dont need two...
So more work here...

Follow Box seems to work as planned...I added two and I see them when I click on Following...
I also know hippy was able to follow me I can see that when I select Followers...so A+ here...

I am tired Now..lol


Good luck to ya Dave you got a hand full now...