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)

Hippy 01-24-2013 11:36 PM

installing for a client
and I get this DB error

Code:

Database error in vBulletin 4.2.0:

Invalid SQL:

            SELECT status.id
            FROM vb_status as status
            LEFT JOIN vb_user ON user.userid = status.userid
           
                        where 1=1  AND ((status.observer <> '0') AND (status.observer = '96'))  AND status.whocanview <> 2 order by status.dateline desc;

MySQL Error  : Unknown column 'user.userid' in 'on clause'
Error Number  : 1054
Request Date  : Thursday, January 24th 2013 @ 07:34:22 PM
Error Date    : Thursday, January 24th 2013 @ 07:34:23 PM
Script        : http://www.freedomofspeech.cc/member.php/96-Hippy
Referrer      : http://www.freedomofspeech.cc/forum.php
IP Address    : XX.XX.XX.XX
Username      : Hippy
Classname    : vB_Database
MySQL Version : 5.1.66-cll

any ideas ?
thanks

Hippy 01-25-2013 12:06 AM

also when I try and set the group permission in the admin cp I get this error message

Code:

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

MaxSof 01-25-2013 02:36 PM

I get this DB error

Quote:

Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT status.id
FROM vb_status as status
LEFT JOIN vb_user ON user.userid = status.userid
LEFT JOIN vb_userlist ON userlist.userid = status.userid
where 1=1 AND ((status.observer <> '0') AND (status.observer = '5')) AND status.whocanview <> 2 AND ((((userlist.relationid = 5 AND userlist.userid = status.userid AND userlist.type = 'buddy' AND userlist.friend = 'yes') OR
status.userid = 5)) OR status.whocanview <> 2) order by status.dateline desc;

MySQL Error : Unknown column 'userlist.relationid' in 'where clause'
Error Number : 1054
Request Date : Friday, January 25th 2013 @ 06:36:12 PM
Error Date : Friday, January 25th 2013 @ 06:36:12 PM
Script : http://saabotazh.by/member.php/5-Max77
Referrer : http://saabotazh.by/usercp.php
IP Address : 46.53.195.169
Username : Max77
Classname : vB_Database
MySQL Version : 5.0.51a-24+lenny5
why????

gretchen712 01-25-2013 07:59 PM

Is this working properly for anyone running 4.2.0?

hugh_ 01-25-2013 08:44 PM

Quote:

Originally Posted by Chadi (Post 2399253)
includes/class_profileblock
includes/functions

That's pretty bad. These should be file modifications no? These file changes broke a couple other mods for me. :(

Hippy 01-26-2013 01:28 AM

Quote:

Originally Posted by hugh_ (Post 2399540)
That's pretty bad. These should be file modifications no? These file changes broke a couple other mods for me. :(

the files that are in the archive are the exact same files replaces so it must of been my accident




no answer on why we are getting this DB error when we view profile with the mod enabled ?

daveaite 01-26-2013 06:59 AM

Quote:

Originally Posted by gretchen712 (Post 2399519)
Is this working properly for anyone running 4.2.0?

We have it fine working on 2 seperate forums.

Seems like only 2 of you guys are getting that same DB error of:
Code:

Unknown column 'user.userid' in 'on clause
and one error of:

Code:

Warning: trim() expects parameter 1 to be string
Both have been logged in our bug tracker at https://github.com/daveaite/Wall/issues

Some may be related specifically to a users installation as we have it working fine on ours...

Thanks for the patience.

hugh_ 01-26-2013 09:02 AM

I'm using 4.2 and it's not working at all. Great mod though.

hakkuo23 01-26-2013 12:05 PM

The sql errors are because you don't check whether there is a prefix in the db. This is the same issue as with version 1 and I had to manually go through the plugin adding vb_ to everything.

Hippy 01-27-2013 02:26 AM

Quote:

Originally Posted by daveaite (Post 2399614)
We have it fine working on 2 seperate forums.

Seems like only 2 of you guys are getting that same DB error of:
Code:

Unknown column 'user.userid' in 'on clause
and one error of:

Code:

Warning: trim() expects parameter 1 to be string
Both have been logged in our bug tracker at https://github.com/daveaite/Wall/issues

Some may be related specifically to a users installation as we have it working fine on ours...

Thanks for the patience.

I assure you it's not users installation..!
if nothing turned up it will be uninstalled
thanks


All times are GMT. The time now is 10:02 AM.

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.01275 seconds
  • Memory Usage 1,746KB
  • 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
  • (6)bbcode_code_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (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