A clean restart

[SEOvB]

thanks saved me from doing the test lol

[y2ksw]

Originally Posted by seaweed

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]

Originally Posted by seaweed

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]

Originally Posted by y2ksw

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

Originally Posted by FRDS

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

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]

[Marco van Herwaarden]

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]

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

[seaweed]

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.

Originally Posted by nexialys

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]

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]

Originally Posted by seaweed

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