vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   vBRecycle v3.0.7 (https://vborg.vbsupport.ru/showthread.php?t=91961)

VaaKo 09-29-2005 08:26 PM

does it work with 3.5 Gold?

Snake 09-29-2005 08:39 PM

I guess not. The hack has many bugs though.

LNTT 09-30-2005 12:13 PM

uhm, status vbrecycle is "Is in Beta stage"! But i think i fixed all errors for vb3.5.x with new install - but still some errors for update from 1.0.0 - 2.5.x to version 3.x.x!

LNTT 10-04-2005 10:55 AM

*updated 3.0.3* fixed all error for update

csidlernet 10-05-2005 02:37 AM

your the man!
/me hits install

LNTT 10-05-2005 10:25 AM

i will release vbrecycle in version 3.0.4 (3.0.3 have some errors for vb3.5.0 Gold)

Snake 10-05-2005 02:21 PM

I just noticed when clicking on the text part of "Move to Recycle" in Thread Tools, it doesn't work. Although it does work while clicking on the ratio button. Have a look yourself.

Evil X 10-05-2005 10:42 PM

im getting a database error..

Database error in vBulletin 3.5.0:

Invalid SQL:
select * from vb3_vbr_config;

MySQL Error : Table 'sseries_slums.vb3_vbr_config' doesn't exist
Error Number : 1146
Date : Wednesday, October 5th 2005 @ 07:42:08 PM
Script : http://www.gunitnation.com/board/adm...cle_admin.php?
Referrer :
IP Address :
Username : Gunitnation
Classname : vb_database

Snake 10-06-2005 07:24 PM

Me too!

PLEASE make sure to test this hack and that it works fully before releasing it! God what is wrong with you? The hack's already messing up with my board now.

mtha 10-06-2005 10:11 PM

Quote:

Originally Posted by ExtProof
im getting a database error..

Database error in vBulletin 3.5.0:

Invalid SQL:
select * from vb3_vbr_config;

MySQL Error : Table 'sseries_slums.vb3_vbr_config' doesn't exist
Error Number : 1146
Date : Wednesday, October 5th 2005 @ 07:42:08 PM
Script : http://www.gunitnation.com/board/adm...cle_admin.php?
Referrer :
IP Address :
Username : Gunitnation
Classname : vb_database


PHP Code:

$run "CREATE TABLE " TABLE_PREFIX "vbr_config (oid int(11) NOT NULL default 1, active int(11) NOT NULL default 1, forumid int(11) NOT NULL default 0, linkamfd int(11) NOT NULL default 2, linkamst int(11) NOT NULL default 1, typem int(11) NOT NULL default 1) ENGINE=MyISAM COMMENT='vBRecycle Config';";

$run "INSERT INTO " TABLE_PREFIX "vbr_config VALUES(1, 1, '', 2, 1, 1);";

$run "ALTER TABLE " TABLE_PREFIX "usergroup ADD vbr_per INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;";

$run "ALTER TABLE " TABLE_PREFIX "forum ADD recycle INT NOT NULL ;";

$run "ALTER TABLE " TABLE_PREFIX "forum ADD srecycle INT NOT NULL ;";

$vbulletin->db->query_write($run); 


this code will only run the last query!


use this for install code:
PHP Code:

$db->query_write("CREATE TABLE " TABLE_PREFIX "vbr_config (oid int(11) NOT NULL default 1, active int(11) NOT NULL default 1, forumid int(11) NOT NULL default 0, linkamfd int(11) NOT NULL default 2, linkamst int(11) NOT NULL default 1, typem int(11) NOT NULL default 1) ENGINE=MyISAM COMMENT='vBRecycle Config';");
$db->query_write("INSERT INTO " TABLE_PREFIX "vbr_config VALUES(1, 1, '', 2, 1, 1);");
$db->query_write("ALTER TABLE " TABLE_PREFIX "usergroup ADD vbr_per INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;");
$db->query_write("ALTER TABLE " TABLE_PREFIX "forum ADD recycle INT NOT NULL ;");
$db->query_write("ALTER TABLE " TABLE_PREFIX "forum ADD srecycle INT NOT NULL ;"); 



and do the same for uninstall

mtha 10-06-2005 10:50 PM

Quote:

Originally Posted by LNTT
i will release vbrecycle in version 3.0.4 (3.0.3 have some errors for vb3.5.0 Gold)


You should SAY it in your hack (first post) if you still have 3.0.3 there (that those who use 3.5.0 should NOT install until 3.0.4). otherwise, people will keep getting bad impressions of a ... buggie hack!

FROGGYJ 10-06-2005 11:11 PM

hrm I'm having the same problem, this install never created tables. So I tried running the above code and I get "Parse error: parse error, unexpected T_STRING".....help? Great idea, but doesn't work at the moment with 3.5

Blackbeard 10-07-2005 06:29 PM

Quote:

Database error in vBulletin 3.5.0:

Invalid SQL:
UPDATE forum SET
title_clean = 'Trash Can',
title = 'Trash Can',
description_clean = 'All Old and Broken posts will be transfered here.',
description = 'All Old and Broken posts will be transfered here.',
link = '',
displayorder = 1,
daysprune = -1,
parentid = 62,
newpostemail = '',
newthreademail = '',
### Bitfield: forum.options ###
options = IF(options & 8, options - 8, options),
options = IF(options & 16, options - 16, options),
options = IF(options & 32, options - 32, options),
options = IF(options & 131072, options - 131072, options),
options = IF(options & 32768, options - 32768, options),
options = IF(options & 8192, options - 8192, options),
options = IF(options & 4, options, options + 4),
options = IF(options & 1, options, options + 1),
options = IF(options & 2, options, options + 2),
options = IF(options & 16384, options, options + 16384),
options = IF(options & 256, options - 256, options),
options = IF(options & 64, options, options + 64),
options = IF(options & 128, options, options + 128),
options = IF(options & 512, options, options + 512),
options = IF(options & 1024, options, options + 1024),
options = IF(options & 2048, options, options + 2048),
options = IF(options & 4096, options, options + 4096),
options = IF(options & 65536, options, options + 65536),
styleid = 0,
password = '',
gallery = '0',
gallery_rows = '',
recycle = 0
WHERE forumid = 63;

MySQL Error : Unknown column 'recycle' in 'field list'
Error Number : 1054
I got this error when changing the settings in forums & mods for my trash can forum where i want all posts to be sent, tried in in all settings.

What could the problem be, and which of the 2 settings must be set for a forum u already have.

Xtremist 10-08-2005 07:07 PM

i did all the instructions but i try and open the Recycle bin Main Settings, Recycle Manager, Link After Moved and i get this error SQL i think

Code:

Database error in vBulletin 3.5.0:

Invalid SQL:
select * from vbr_config;

MySQL Error  : Table 'ross_Vbu.vbr_config' doesn't exist
Error Number : 1146
Date        : Saturday, October 8th 2005 @ 09:07:15 PM
Script      : http://interwebgaming.com/admincp/vbrecycle_admin.php?do=manager
Referrer    : http://interwebgaming.com/admincp/index.php
IP Address  : 86.132.118.60
Username    : Xtremist
Classname    : vb_database


danb00 10-08-2005 07:20 PM

Manual fix
After running the install run these SQL commnads using build in SQL command

PHP Code:

CREATE TABLE vbr_config (oid int(11NOT NULL default 1active int(11NOT NULL default 1forumid int(11NOT NULL default 0linkamfd int(11NOT NULL default 2linkamst int(11NOT NULL default 1typem int(11NOT NULL default 1ENGINE=MyISAM COMMENT='vBRecycle Config';

INSERT INTO vbr_config VALUES(11''211);

ALTER TABLE usergroup ADD vbr_per INT10 UNSIGNED DEFAULT '0' NOT NULL;

ALTER TABLE forum ADD recycle INT NOT NULL;

ALTER TABLE forum ADD srecycle INT NOT NULL


untold4you 10-09-2005 10:09 PM

This is the error i'm getting after i followed all your install steps, i get this error when i want to change settings in the ACP.

I checked and indeed the table is not made? Something wrong in the install file? Any suggestions? Tnx in advance!

Code:

  Database error in vBulletin 3.5.0:
 
  Invalid SQL:
  select * from vbr_config;
 
  MySQL Error  : Table 'vbull.vbr_config' doesn't exist
  Error Number : 1146
  Date                : Monday, October 10th 2005 @ 01:03:31 AM
  Script          : http://www.****/****/****/vbrecycle_admin.php?
  Referrer        : http://www.*****/****/****/index.php?do=nav
  IP Address  : ******
  Username        : *******
  Classname        : vb_database

Update: Sorry did not look at previous post, anyway created the table manually in phpMyAdmin and changed the install xml:

Quote:

Originally Posted by mtha
use this for install code:
PHP Code:

$db->query_write("INSERT INTO " TABLE_PREFIX "vbr_config VALUES(1, 1, '', 2, 1, 1);");
 
$db->query_write("ALTER TABLE " TABLE_PREFIX "usergroup ADD vbr_per INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;");
 
$db->query_write("ALTER TABLE " TABLE_PREFIX "forum ADD recycle INT NOT NULL ;");
 
$db->query_write("ALTER TABLE " TABLE_PREFIX "forum ADD srecycle INT NOT NULL ;"); 



and do the same for uninstall


nexialys 10-09-2005 11:37 PM

Hey LNTT, i think you can minimize a lot of the plugins so we can spare some space in our dB...

these:
Code:

/////////////////////////////////////
//      ::vBRecycle v3            //
///////////////////////////////////
// by LNTT(toai007@yahoo.com)  //
/////////////////////////////////
// http://www.fanfunvn.com    //
///////////////////////////////
// Start - IM - Fix Invalid //
/////////////////////////////

... completely useless, because they are never displayed anywhere... they are stored in the dB, in the plugin system, and only the scripts "see" them, so maybe in the next release you can save us these 6k (about 200 lines)

... i know you want your credits, but the system doesn't care... and we know you've done a great job... !!!

oh, btw, i have an alternative for the menu... instead of the bar you've created, i added an element in the tools bar... screenshot included... if you want it, i can send the modification next...

FROGGYJ 10-09-2005 11:59 PM

umm I think this is related to this mod so here goes.No matter what I try to change in any usergroup...whether default or a custom I get the following error.

Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /includes/class_core.php on line 635

MySQL Error : Unknown column 'vbr_per' in 'field list'
Error Number : 1054

FROGGYJ 10-10-2005 12:32 AM

ok I don't think any SQL actions in the script actually ran....I tried to run the xml file again with overwrite and still nothing....Ok I look in the product manager and copied what SQL was supposed to be performed...and tried to execute it, however I get an error Parse error: parse error, unexpected T_STRING on this line
Code:

$sql[] = "$run = "CREATE TABLE " . TABLE_PREFIX . "vbr_config (oid int(11) NOT NULL default 1, active int(11) NOT NULL default 1, forumid int(11) NOT NULL default 0, linkamfd int(11) NOT NULL default 2, linkamst int(11) NOT NULL default 1, typem int(11) NOT NULL default 1) ENGINE=MyISAM COMMENT='vBRecycle Config'";
but I'm not proficient in SQL and I'm not sure where the syntax error is?

FROGGYJ 10-10-2005 12:44 AM

ok well I went ahead and manually created the sql staments thought PhpMyAdmin however I am still having a problem. Here is a screenshot when I click on update usergroup. Although it says it saved...when I go back they are unchanged.

FROGGYJ 10-10-2005 04:58 AM

bump....anyone?

Mr Chad 10-10-2005 05:30 AM

Its adding my DB name infront of the template name like DB.VB_TEMPLATE which is giving me errors

Snake 10-10-2005 03:01 PM

Quote:

Originally Posted by nexialys
Hey LNTT, i think you can minimize a lot of the plugins so we can spare some space in our dB...

these:
Code:

/////////////////////////////////////
//      ::vBRecycle v3            //
///////////////////////////////////
// by LNTT(toai007@yahoo.com)  //
/////////////////////////////////
// http://www.fanfunvn.com    //
///////////////////////////////
// Start - IM - Fix Invalid //
/////////////////////////////

... completely useless, because they are never displayed anywhere... they are stored in the dB, in the plugin system, and only the scripts "see" them, so maybe in the next release you can save us these 6k (about 200 lines)

... i know you want your credits, but the system doesn't care... and we know you've done a great job... !!!

oh, btw, i have an alternative for the menu... instead of the bar you've created, i added an element in the tools bar... screenshot included... if you want it, i can send the modification next...

Oh boy I like that. Can I have the mod please?

nexialys 10-10-2005 03:38 PM

Quote:

Originally Posted by Aftermath
Oh boy I like that. Can I have the mod please?

when LTNN requires it, if he wants it... because i will not support this mod, so i don't release it myself...

mml770 10-10-2005 04:47 PM

I get this error messagge when I try to manage the VBRecycle:

Database error in vBulletin 3.5.0:

Invalid SQL:
select * from vbr_config;

MySQL Error : Table 'chabadt_ctforum.vbr_config' doesn't exist
Error Number : 1146

When I set a certain section as Recycle I get this:

Database error in vBulletin 3.5.0:

Invalid SQL:
UPDATE forum SET
title_clean = 'Recycle Bin',
title = 'Recycle Bin',
description_clean = '',
description = '',
link = '',
displayorder = 1,
daysprune = 1,
parentid = 26,
newpostemail = '',
newthreademail = '',
### Bitfield: forum.options ###
options = IF(options & 8, options - 8, options),
options = IF(options & 16, options - 16, options),
options = IF(options & 32, options - 32, options),
options = IF(options & 131072, options - 131072, options),
options = IF(options & 32768, options - 32768, options),
options = IF(options & 8192, options, options + 8192),
options = IF(options & 4, options, options + 4),
options = IF(options & 1, options, options + 1),
options = IF(options & 2, options, options + 2),
options = IF(options & 16384, options, options + 16384),
options = IF(options & 256, options - 256, options),
options = IF(options & 64, options, options + 64),
options = IF(options & 128, options - 128, options),
options = IF(options & 512, options, options + 512),
options = IF(options & 1024, options, options + 1024),
options = IF(options & 2048, options, options + 2048),
options = IF(options & 4096, options - 4096, options),
options = IF(options & 65536, options, options + 65536),
styleid = 0,
password = '',
recycle = 1
WHERE forumid = 51;

MySQL Error : Unknown column 'recycle' in 'field list'
Error Number : 1054

nexialys 10-10-2005 04:58 PM

you did not install the hack itself, usethe product file related to it...

FROGGYJ 10-10-2005 10:02 PM

this hack does not install any SQL with vb 3.5 gold. I'm still can't update usergroups....anyone having that problem. I tried other options and they save...but the Vbrecycle permissions won't save no matter how I change them.

mml770 10-11-2005 12:26 AM

Quote:

Originally Posted by nexialys
you did not install the hack itself, usethe product file related to it...

if possible please explain, I followed the instructions.

smokering 10-11-2005 02:29 AM

really like the product but got same db errors as above have uninstalled till more is posted on a fix i as a noob can understand really do like this tough and will be most happy to have it working thanks for all the hard effort and work

LNTT 10-11-2005 09:45 AM

*updated 3.0.4*
Sorry for slow update, i don't have time!

mml770 10-11-2005 02:49 PM

Quote:

Originally Posted by LNTT
*updated 3.0.4*
Sorry for slow update, i don't have time!

Thanks! But I still get the same errors...

mml770 10-12-2005 12:17 AM

I unistalled the hack and I get this error when moving some posts:

Warning: Invalid argument supplied for foreach() in /includes/class_postbit.php3(251) : eval()'d code on line 125

Warning: Invalid argument supplied for foreach() in /includes/class_postbit.php3(251) : eval()'d code on line 135

Unable to add cookies, header already sent.
File: /home/chabadt/public_html/forum/includes/class_core.php3
Line: 2903

I think you should warn users that the hack could make problems.

akanevsky 10-12-2005 12:33 AM

Could you make it so that recycling would occur based on last reply? Thx :)

phpnewbie 10-12-2005 10:48 AM

Database error in vBulletin 3.5.0:

Invalid SQL:
select * from vb3_vbr_config;

MySQL Error : Table '***_vbb35.vb3_vbr_config' doesn't exist
Error Number : 1146
Date : Wednesday, October 12th 2005 @ 06:41:12 PM
Script : http://www.***/forum/admincp/vbrecycle_admin.php?
Referrer : http://www.***/forum/admincp/index.php?do=nav
IP Address : ****
Username : admin
Classname : vb_database

murrtex 10-12-2005 12:14 PM

Quote:

Originally Posted by phpnewbie
Database error in vBulletin 3.5.0:

Invalid SQL:
select * from vb3_vbr_config;

MySQL Error : Table '***_vbb35.vb3_vbr_config' doesn't exist
Error Number : 1146
Date : Wednesday, October 12th 2005 @ 06:41:12 PM
Script : http://www.***/forum/admincp/vbrecycle_admin.php?
Referrer : http://www.***/forum/admincp/index.php?do=nav
IP Address : ****
Username : admin
Classname : vb_database


yes me to i did fresh install bu it has got errors

vbr_config' doesn't exist

why dont u fix it?

Riotblade 10-13-2005 10:05 PM

I was getting a missing vbr_config table error so I extracted the code off of the XML and did it manually.

tnguy3n 10-13-2005 10:24 PM

Quote:

Originally Posted by LNTT
*updated 3.0.4*
Sorry for slow update, i don't have time!

How this hack work? Does it automatically delete/empty threads in RecycleBin after XX days?

jimmyboy 10-14-2005 01:05 AM

it says
Table 'XXXXXXX.vbr_config' doesn't exist???

(xxxx is my database name)

i installed it rite

Dadoo 10-14-2005 07:21 AM

Quote:

Originally Posted by Riotblade
I was getting a missing vbr_config table error so I extracted the code off of the XML and did it manually.

Same thing.. but parameters are saved by default, when i change one, and save it, and refreshing page, it's DEFAULT parameters who appears...

so, when i attempt to move a topic in recycle bin, i have message

"you have not autorization to access this page...etc..." i'm ADMIN !!!

Scotty2k 10-14-2005 08:32 AM

I have one big problem with vbRecycle 3.04

Everytime I activate this product i get some vb database error messages like this:

Quote:

Invalid SQL:
SELECT * FROM forum WHERE forumid =;

MySQL-Fehler : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Fehler-Nr. : 1064
Datum : Friday, October 14th 2005 @ 11:27:02 AM
Skript : http://www.xxxxxx.de/forum/forumdisplay.php?do=markread
Referrer : http://www.xxxxxx.de/forum/search.php?searchid=3039
IP-Adresse : 84.61.138.203
Benutzername : xxxxxxxx
Klassenname : vb_database

Please help, don?t know what to do


All times are GMT. The time now is 03:55 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.01693 seconds
  • Memory Usage 1,874KB
  • 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
  • (5)bbcode_code_printable
  • (4)bbcode_php_printable
  • (12)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)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