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)

question? 09-24-2005 07:44 AM

Quote:

Originally Posted by Sovereign
SQL error, help!
Code:


Database error in vBulletin 3.5.0 Release Candidate 2:
Invalid SQL:
update vb3_vbr_config set
active='1',
forumid='71',
typem='1'
where oid='1';
MySQL Error : Unknown column 'active' in 'field list'
Error Number : 1054
Date                : Thursday, September 22nd 2005 @ 09:31:47 PM
Script        : *****
Referrer        : *****
IP Address : *****
Username        : Sovereign
Classname        : vb_database

EDIT: Fixed with Nova2k's file...
New error, attempted to move post to recycle, got this:
Code:

Parse error: parse error, unexpected T_CASE in /home/alliance/public_html/vb/postings.php(204) : eval()'d code on line 2391

When i click mark all forums read, i get huge errors. http://www.vbulletin.com/forum/bugs3...iew&bugid=1379

LNTT 09-24-2005 11:14 AM

Quote:

Originally Posted by Sovereign
SQL error, help!
Code:


Database error in vBulletin 3.5.0 Release Candidate 2:
Invalid SQL:
update vb3_vbr_config set
active='1',
forumid='71',
typem='1'
where oid='1';
MySQL Error : Unknown column 'active' in 'field list'
Error Number : 1054
Date                : Thursday, September 22nd 2005 @ 09:31:47 PM
Script        : *****
Referrer        : *****
IP Address : *****
Username        : Sovereign
Classname        : vb_database

EDIT: Fixed with Nova2k's file...
New error, attempted to move post to recycle, got this:
Code:

Parse error: parse error, unexpected T_CASE in /home/alliance/public_html/vb/postings.php(204) : eval()'d code on line 2391

Uhm - i think you need reinstall vbrecycle 3.0.2 or run 3 queries bellow(go to admincp >> Maintenance >> Execute SQL Query or using phpmyadmin)

Code:

DROP TABLE IF EXISTS vbr_config
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'
Code:

INSERT INTO vbr_config VALUES(1, 1, '', 2, 1, 1)
Note: run query in turn

murrtex 09-27-2005 12:45 AM

i have still errors..queries do not work

LNTT 09-27-2005 12:05 PM

Quote:

Originally Posted by murrtex
i have still errors..queries do not work

whats error code?

murrtex 09-27-2005 02:45 PM

whne i click main sttings or the others


Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
select * from vbr_config;

MySQL Error : Table 'abc.vbr_config' doesn't exist
Error Number : 1146
Date : Tuesday, September 27th 2005 @ 06:37:54 PM
Script : http://www.......com/forum/admincp/vbrecycle_admin.php?
Referrer : http://www......com/forum/admincp/index.php
IP Address : 85.103.28.84
Username : ...
Classname : vb_database



when i try

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'

on acp or phpmyadmin,

it says

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax near 'ENGINE=MyISAM COMMENT='vBRecycle Config'' at line 1

murrtex 09-27-2005 03:23 PM

i did like that;

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
) TYPE=MyISAM COMMENT='vBRecycle Config'

and

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

query is ok...

but

now it follows from Recycle Manager when i click

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
select * from forum where recycle = 1;

MySQL Error : Unknown column 'recycle' in 'where clause'
Error Number : 1054
Date : Tuesday, September 27th 2005 @ 07:17:58 PM
Script : http://www.,,,,,,.com/forum/admincp/...php?do=manager
Referrer : http://www.,,,,,.com/forum/admincp/index.php
IP Address : 85.103.28.84
Username : ,,,,
Classname : vb_database


and


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

Azhrialilu 09-28-2005 08:41 AM

I'm getting the same errors as murrtex :) running RC3 (if that helps any ;) )

murrtex 09-28-2005 01:10 PM

finally i did this;

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

and everything is ok..
I am testing now..

Azhrialilu 09-28-2005 01:43 PM

Hasn't made any difference to me.. still getting errors

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
update forum set
recycle = 1
where forumid='1';

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

Snake 09-29-2005 07:20 PM

Man this hack consists A LOT of bugs. It needs to be re-coded and must be tested fully before releasing it.


All times are GMT. The time now is 01:01 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.01311 seconds
  • Memory Usage 1,750KB
  • 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
  • (7)bbcode_code_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