SEOvB
09-30-2008, 05:16 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.
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?
seaweed
10-01-2008, 09:35 PM
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
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]:confused::confused:
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.
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
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.