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)

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 09:31 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.01192 seconds
  • Memory Usage 1,754KB
  • 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
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (9)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