vb.org Archive
Page 14 of 27 « First 41213 14 151624 Last »
Show 40 post(s) from this thread on one page

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)

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(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';

INSERT INTO vbr_config VALUES(1, 1, '', 2, 1, 1);

ALTER TABLE usergroup ADD vbr_per INT( 10 ) 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.


All times are GMT. The time now is 09:36 AM.
Page 14 of 27 « First 41213 14 151624 Last »
Show 40 post(s) from this thread on one page

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.01245 seconds
  • Memory Usage 1,765KB
  • 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
  • (4)bbcode_code_printable
  • (2)bbcode_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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