vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)
-   -   A clean restart (https://vborg.vbsupport.ru/showthread.php?t=192246)

seaweed 09-29-2008 05:20 PM

A clean restart
 
I have found some error in my DB and my admin control panel. Im pretty sure it happend when i upgraded the versions.

My question is can i take my user,usergroup, permissions, post structure etc basically everything meat and potatos, back them up and install a clean copy of vbulletin and import the data back in.

Is this possible? Please point me in the right direction.

TIA
Seaweed

iRO Wiki 09-29-2008 05:41 PM

A good place to start may be troubleshooting the errors you are getting first!

SEOvB 09-29-2008 08:39 PM

Use impex available for download at your vBulletin.com members area

seaweed 09-30-2008 12:02 AM

Quote:

Originally Posted by FRDS (Post 1633393)
Use impex available for download at your vBulletin.com members area

thanks, that was th push I needed

balance12 09-30-2008 02:36 PM

I want the same thing... so i download the impex... it work to save data of my vb and then import it in a new install?

Marco van Herwaarden 09-30-2008 02:37 PM

Yes, see the manual Appendix 5: ImpEx Import System

nexialys 09-30-2008 03:49 PM

the problem with ImpEx is that all your data will be renumbered, all your userids will be changed, all your actual links on google will have to be reindexed by the crawlers to be working again, so you will have a load of error404 in the meantime...

why don't you start with a checkup ?!... dB errors may be corrected easily usually.

seaweed 09-30-2008 05:07 PM

Quote:

Originally Posted by nexialys (Post 1633982)
why don't you start with a checkup ?!... dB errors may be corrected easily usually.

Can you be more specific? thanks for the advice

Seaweed

SEOvB 09-30-2008 05:16 PM

Quote:

Originally Posted by nexialys (Post 1633982)
the problem with ImpEx is that all your data will be renumbered, all your userids will be changed, all your actual links on google will have to be reindexed by the crawlers to be working again, so you will have a load of error404 in the meantime...

why don't you start with a checkup ?!... dB errors may be corrected easily usually.

Does it renumber everything even if you started the old forum from scratch, and then reimport it again on a new install?

Wouldn't it start at 0 or 1, and then go from there like a new install does?

nexialys 09-30-2008 05:38 PM

i made that test once FRDS... everything is renumbered to drop the deleted entries...

so if you have userid 100 deleted, the #101 will take its place, etc... same for forumid, threadid etc... so it will renumber everything most of the time, or you really have a small forum..;)

SEOvB 09-30-2008 05:40 PM

thanks saved me from doing the test lol :D

y2ksw 09-30-2008 07:30 PM

Quote:

Originally Posted by seaweed (Post 1634041)
Can you be more specific? thanks for the advice

Seaweed

with phpmyadmin there are many options for maintaining a database and its tables.

however you may issue also queries manually:

CHECK TABLE tablename
http://dev.mysql.com/doc/refman/5.0/en/check-table.html

REPAIR TABLE tablename
http://dev.mysql.com/doc/refman/5.0/en/repair.html

The latter article covers also other methods, which are available to users with SHELL/Terminal Services access on dedicated servers.

SEOvB 09-30-2008 08:26 PM

Quote:

Originally Posted by seaweed (Post 1634041)
Can you be more specific? thanks for the advice

Seaweed

What are the errors you are getting first, then we can help you with more details.

seaweed 10-01-2008 09:35 PM

Quote:

Originally Posted by y2ksw (Post 1634164)
with phpmyadmin there are many options for maintaining a database and its tables.

however you may issue also queries manually:

CHECK TABLE tablename
http://dev.mysql.com/doc/refman/5.0/en/check-table.html

REPAIR TABLE tablename
http://dev.mysql.com/doc/refman/5.0/en/repair.html

The latter article covers also other methods, which are available to users with SHELL/Terminal Services access on dedicated servers.

Thanks i will look in to that

Quote:

Originally Posted by FRDS (Post 1634193)
What are the errors you are getting first, then we can help you with more details.

https://vborg.vbsupport.ru/showthread.php?t=192245
I posted one here, but havent had a chance to follow advice yet.

The other error i get is when trying to vote in a poll, I get full page of the below and more.
It almost seems to me that it is all of the code from the page in text

Code:

Fatal error: Field votetype is not defined in $validfields in class vB_DataManager_PollVote in [path]/includes/class_dm.php on line 485
#0 vb_error_handler(256, Field votetype is not defined in $validfields in class vB_DataManager_PollVote, /chroot/home/spearfis/spearfishingplanet.com/html/includes/class_dm.php, 485, Array ([this] => vB_DataManager_PollVote Object ([validfields] => Array ([pollvoteid] => Array ([0] => 3,[1] => 3,[2] => _-_mEtHoD_-_,[3] => verify_nonzero),[pollid] => Array ([0] => 3,[1] => 1),[userid] => Array ([0] => 3,[1] => 1),[votedate] => Array ([0] => 3,[1] => 2),[voteoption] => Array ([0] => 3,[1] => 0)),[condition_construct] => Array ([0] => pollid = %1$d,[1] => pollid),[table] => pollvote,[pollvote] => Array ([pollid] => 27,[votedate] => 1222900290,[voteoption] => 1,[userid] => 2),[bitfields] => Array (),[setfields] => Array ([pollid] => 1,[votedate] => 1,[voteoption] => 1,[userid] => 1),[rawfields] => Array (),[registry] => vB_Registry Object ([datastore] => vB_Datastore Object ([defaultitems] => Array ([0] => options,[1] => bitfields,[2] => attachmentcache,[3] => forumcache,[4] => usergroupcache,[5] => stylecache,[6] => languagecache,[7] => products,[8] => pluginlist,[9] => cron,[10] => profilefield,[11] => loadcache,[12] => noticecache),[itemarray] => Array (),[registry] => vB_Registry Object ( *RECURSION*,[dbobject] => vB_Database Object ([functions] => Array ([connect] => mysql_connect,[pconnect] => mysql_pconnect,[select_db] => mysql_select_db,[query] => mysql_query,[query_unbuffered] => mysql_unbuffered_query,[fetch_row] => mysql_fetch_row,[fetch_array] => mysql_fetch_array,[fetch_field] => mysql_fetch_field,[free_result] => mysql_free_result,[data_seek] => mysql_data_seek,[error] => mysql_error,[errno] => mysql_errno,[affected_rows] => mysql_affected_rows,[num_rows] => mysql_num_rows,[num_fields] => mysql_num_fields,[field_name] => mysql_field_name,[insert_id] => mysql_insert_id,[escape_string] => mysql_escape_string,[real_escape_string] => mysql_real_escape_string,[close] => mysql_close,[client_encoding] => mysql_client_encoding),[registry] => vB_Registry Object ( *RECURSION*,[fetchtypes] => Array ([2] => 2,[1] => 1,[0] => 3),[appname] => vBulletin,[appshortname] => vBulletin,[database] => spearfis_spearfishingplanet,[connection_master] => Resource id #7,[connection_slave] => Resource id #7,[connection_recent] => Resource id #7,[multiserver] => ,[shutdownqueries] => Array ([lastvisit] => UPDATE user SET lastactivity = 1222900290 WHERE userid = 2 ),[sql] => ,[reporterror] => 1,[error] => ,[errno] => ,[maxpacket] => 0,[locked] => ,[querycount] => 8),[prefix] => ),[input] => vB_Input_Cleaner Object ([shortvars] => Array ([f] => forumid,[t] => threadid,[p] => postid,[u] => userid,[a] => announcementid,[c] => calendarid,[e] => eventid,[q] => query,[pp] => perpage,[page] => pagenumber,[sort] => sortfield,[order] => sortorder),[superglobal_lookup] => Array ([g] => _GET,[p] => _POST,[r] => _REQUEST,[c] => _COOKIE,[s] => _SERVER,[e] => _ENV,[f] => _FILES),[scriptpath] => ,[reloadurl] => ,[wolpath] => ,[url] => ,[ipaddress] => ,[alt_ip] => ,[registry] => vB_Registry Object ( *RECURSION*),[db] => vB_Database Object ([functions] => Array ([connect] => mysql_connect,[pconnect] => mysql_pconnect,[select_db] => mysql_select_db,[query] => mysql_query,[query_unbuffered] => mysql_unbuffered_query,[fetch_row] => mysql_fetch_row,[fetch_array] => mysql_fetch_array,[fetch_field] => mysql_fetch_field,[free_result] => mysql_free_result,[data_seek] => mysql_data_seek,[error] => mysql_error,[errno] => mysql_errno,[affected_rows] => mysql_affected_rows,[num_rows] => mysql_num_rows,[num_fields] => mysql_num_fields,[field_name] => mysql_field_name,[insert_id] => mysql_insert_id,[escape_string] => mysql_escape_string,[real_escape_string] => mysql_real_escape_string,[close] => mysql_close,[client_encoding] => mysql_client_encoding),[registry] => vB_Registry Object ( *RECURSION*,[fetchtypes] => Array ([2] => 2,[1] => 1,[0] => 3),[appname] => vBulletin,[appshortname] => vBulletin,[database] => spearfis_spearfishingplanet,[connection_master] => Resource id #7,[connection_slave] => Resource id #7,[connection_recent] => Resource id #7,[multiserver] => ,[shutdownqueries] => Array ([lastvisit] => UPDATE user SET lastactivity = 1222900290 WHERE userid = 2 ),[sql] => ,[reporterror] => 1,[error] => ,[errno] => ,[maxpacket] => 0,[locked] => ,[querycount] => 8),[userinfo] => Array ([userid] => 2,[temp] => ,[field1] => ,[field2] => ,[field3] => ,[field4] => ,[subfolders] => ,[pmfolders] => ,[buddylist] => 27,[ignorelist] => ,[signature] => [B]

:confused::confused:

Marco van Herwaarden 10-02-2008 08:55 AM

Both errors (the above and in the other thread) are most likely caused by modifications. Please follow th advice in the other thread and disable your modifications.

y2ksw 10-02-2008 10:17 AM

The votetype error comes from an incomplete plugin installation or uninstallation.

seaweed 10-03-2008 02:25 AM

The only mod I have was installed by Photpost, the problem didnt appear until well after. The last change i made was centering the parent forum ( cant find the how to i followed). Before that was an upgrade to 3.7, i didnt find it so easy, and prob screwed it up.

Someone mentioned uplaoding files,and would like to try that but dont want overwrite anything critical or damage db. Can i just dl the lastest vb software and upload, would it replace missing files or or overwrite all existing.


Quote:

Originally Posted by nexialys (Post 1634059)
i made that test once FRDS... everything is renumbered to drop the deleted entries...

so if you have userid 100 deleted, the #101 will take its place, etc... same for forumid, threadid etc... so it will renumber everything most of the time, or you really have a small forum..;)

I dont understand the repercussions or why it may be a bad thing.
Sorry for being such a newb.
Seaweed

Dismounted 10-03-2008 02:27 AM

If the forum ID was 101, for example, and then it changes to 5, because of the renumbering. Any links inbound to your site that used to go to forum ID 101 will not work.

y2ksw 10-03-2008 11:46 AM

Quote:

Originally Posted by seaweed (Post 1636162)
Someone mentioned uplaoding files,and would like to try that but dont want overwrite anything critical or damage db. Can i just dl the lastest vb software and upload, would it replace missing files or or overwrite all existing.

It will usually add missing files and update/overwrite existing files. Depends on your FTP settings though. Some servers won't overwrite unless deleting first.

If you have no PHP code changes, this operation is safe. Don't forget to run install/upgrade.php after copying the files ;)


All times are GMT. The time now is 03:59 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.01211 seconds
  • Memory Usage 1,793KB
  • 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
  • (9)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (19)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete