vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Major Additions - vBSocial.com Wall 2.5 (https://vborg.vbsupport.ru/showthread.php?t=294260)

daveaite 01-29-2013 04:36 AM

Four main issues identified, and are being investigated and patched up. Will update as soon as we have a fix!


Code:

1.
MySQL Error : Unknown column 'userlist.relationid' in 'where clause'

2.
Warning: trim() expects parameter 1 to be string, array given in [path]/includes/adminfunctions_options.php on line 1032

3.
MySQL Error  : Unknown column 'user.userid' in 'on clause'

4.
Remove core file overwrites
includes/class_profileblock
includes/functions

Thanks for the collaboration.

David

Inspector G 01-29-2013 04:42 AM

I DO HAVE GREAT NEWS FOR SOCIAL NOTIFICATIONS...Plus I need to check something since I have heavy Header code changes...
But Holly crow the Social Notification is completely awesome everything I can image plus...
I will update on the rest david let me look at something first then I will try what you suggest...

insaneoz 01-29-2013 05:02 AM

This is such an EPIC modification. Installed and working 100% on my site. Keep it up david.

Inspector G 01-29-2013 05:12 AM

What version are you running?
4.2 patch level 3 here...

RoC wonko 02-03-2013 09:28 AM

Quote:

Originally Posted by daveaite (Post 2400143)
What other mods do you have installed? vBSEO? please confirm

Yes have vbseo but disabled that but still the same

Inspector G 02-04-2013 03:08 AM

AME 3

Arcade

Bot Blocker

Custom CSS to be used oo.

Force Users to Read a Thread

Forum Runner

Frustration Suite

Gameroom

Inactive and Lurker Members 4.2.0.0

KeyCAPTCHA

Members who have Visited - Block

New Album Picture Forum Home

ProvB - Community News Letter

PurevB DarkCore Theme Manager

PurevB Socialize Theme Manager

PurevB Theme Manager

Spam Detector Suite

Unlimited Custom Pages

vbBux / vbPlaza

vBulletin Blog 4.2.0

vBulletin CMS 4.2.0

vBulletin-MagicZoom

Verify Mail before registration

:up:

daveaite 02-04-2013 06:52 PM

Update pending. :)

daveaite 02-05-2013 08:27 PM

Updated:

v2.1: Fixes 3 db error 1 .xml error

Demo: http://vbsocial.com/forum/member.php/9273-user
user: user
pass: test

Inspector G 02-05-2013 11:17 PM

1 Attachment(s)
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...

RoC wonko 02-06-2013 04:24 PM

I have sorted everything so it now works but can not get "about me" section, content text or background changes to suit my site to save or to save as site default, it just reverts back as soon as you navigate away then back again.
when I am using "customize my profile"

Inspector G 02-08-2013 09:14 PM

Roc are you running VB 4 or greater specifically 4.2 patch 3?
Thats what I am running and it is as listed not functional at all for now...

RoC wonko 02-10-2013 04:16 PM

Quote:

Originally Posted by Inspector G (Post 2402962)
Roc are you running VB 4 or greater specifically 4.2 patch 3?
Thats what I am running and it is as listed not functional at all for now...

running vb 4.2 patch 3

have uninstalled, just was not working as should, very disappointed really needed this feature to have worked for us.

daveaite 02-28-2013 08:41 PM

If your having having issues, please let us have access to your site. We're currently fixing reported issues, but need access as they may be site specific. Inspector G's site is currently offline, so unable to test there.

Thanks for your patience

Inspector G 02-28-2013 09:48 PM

Hold the phone...My site is live...Dave...lol
I was tweaking some settings last night I need to clear the log ins for you and then you will be good to test away...
vb 4.2 patch 3 with quite a few mods...

dizzynation 02-28-2013 11:34 PM

This seems like a sweet MOD..... Will wait to hear more reviews on 4.2 PL3

daveaite 03-01-2013 03:21 AM

Quote:

Originally Posted by dizzynation (Post 2407093)
This seems like a sweet MOD..... Will wait to hear more reviews on 4.2 PL3

Good mod, lots of potential, but need to tweak it up just a bit more before its ready.

daveaite 03-07-2013 06:32 PM

Big update pending, fixing all bugs to date.

kylek 03-19-2013 12:46 AM

Any word on the update yet? Would like to get this running and give it another try!

daveaite 03-19-2013 10:20 AM

vBSocial Wall 2.3 Lite Pending release today/tomorrow.

daveaite 03-20-2013 05:25 AM

vBSocial.com vBWall v.2.3 Released!
All bugs reported are resolved.

Fixes:
-Sideblock error
-Avatar database error
-Blue box installation
-Related links error
-Error when posting status
-Error when saving status
-10 other minor issues

Release notes:
http://vbsocial.com/forum/showthread...-Release-Notes

kylek 03-20-2013 09:39 PM

Still have same problem as the last version. On profile page after install everything shows but now when on vbwall we have the profile page sidebar on the left, then another sidebar next to it (forum sidebar) that starts under the Friends Suggestion Block.

https://vborg.vbsupport.ru/attachmen...7&d=1359416800

daveaite 03-21-2013 05:49 AM

That may just be a theme issue. Try switching themes as a test and see what happens.

kylek 03-21-2013 07:07 AM

Thats the first thing I do and did - tested with default style and default memberinfo template.

daveaite 03-21-2013 07:38 AM

Which side is your sidebar meant to be on. Do you want it on left or right?

kylek 03-21-2013 09:37 AM

Thanks Daveaite!

If you mean the side bar that has always been on the profile page we want it on the left.

In your description you have "No sidebar in profiles or Group Pages" so if the Friends Suggestion block comes with the lite version is there any way that it could be incorporated into the left sidebar that is there on the profiles?

daveaite 03-21-2013 11:07 AM

Quote:

Originally Posted by kylek (Post 2411360)
Thanks Daveaite!

If you mean the side bar that has always been on the profile page we want it on the left.

In your description you have "No sidebar in profiles or Group Pages" so if the Friends Suggestion block comes with the lite version is there any way that it could be incorporated into the left sidebar that is there on the profiles?

Ah, I see your question, and no at this point. Would require some custom editing. :) Feel free to do so if you can.

daveaite 03-25-2013 09:18 PM

Please let us know if you have any issues.

kylek 03-25-2013 09:39 PM

1 Attachment(s)
Still have this issue of the forum sidebar that gets added to the friends suggestion block. Played around with the member_info_block_wall template and moved the sidebar to the right so friends suggestion block moved over but still have the whole forum home page sidebar displaying under the friends suggestion block.

Friends Suggestion (sidebar on right side)

daveaite 03-26-2013 02:59 AM

Quote:

Originally Posted by kylek (Post 2412277)
Still have this issue of the forum sidebar that gets added to the friends suggestion block. Played around with the member_info_block_wall template and moved the sidebar to the right so friends suggestion block moved over but still have the whole forum home page sidebar displaying under the friends suggestion block.

Friends Suggestion (sidebar on right side)

Its' designed that way, to do that.

daveaite 03-29-2013 03:54 AM

Thanks for the latest round of feedback.

daveaite 04-02-2013 01:48 AM

Any questions?

daveaite 04-03-2013 03:46 AM

Quote:

Originally Posted by kylek (Post 2412277)
Still have this issue of the forum sidebar that gets added to the friends suggestion block. Played around with the member_info_block_wall template and moved the sidebar to the right so friends suggestion block moved over but still have the whole forum home page sidebar displaying under the friends suggestion block.

Friends Suggestion (sidebar on right side)

Did that solve your answer?

daveaite 04-11-2013 07:21 AM

marked as solved.

daveaite 04-13-2013 05:58 AM

Thanks

daveaite 04-29-2013 08:52 AM

This mod is currently being ported to vB5.

daveaite 05-07-2013 05:52 PM

Any q's?

henrique araujo 05-07-2013 06:45 PM

Fatal error: Call to undefined function fetch_version_array() in /home/************/public_html/****************.com.br/includes/adminfunctions_plugin.php on line 1039

vb 4.2.1

daveaite 05-13-2013 05:15 AM

Quote:

Originally Posted by henrique araujo (Post 2420571)
Fatal error: Call to undefined function fetch_version_array() in /home/************/public_html/****************.com.br/includes/adminfunctions_plugin.php on line 1039

vb 4.2.1

Uploaded a new version. Just over-write existing files. No need to upload reup-.xml

evershawn 05-14-2013 09:41 AM

So I have uploaded your latest release...

Your product has DESTROYED my forum, when I try to add a product now, all I get is:

Importing Product, Please Wait...

[:]

Fatal error: Call to undefined function fetch_version_array() in /*****/*****/public_html/includes/adminfunctions_plugin.php on line 1039

Can you PLEASE tell us how to fix this ASAP, I am unable to modify any plugins on my site now and I have no idea what has been broken to make this happen. This happened immediately after uploading your product.

Thanks!

penguinboy888 05-14-2013 05:37 PM

You have backups? Restore the functions.php file and then reinstall. Make sure that the functions.php isn't in the package. I got mine going awhile ago but got the VIP version from vbsocial's site. Works great.


All times are GMT. The time now is 02:59 PM.

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.01304 seconds
  • Memory Usage 1,835KB
  • 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
  • (1)bbcode_code_printable
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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