Upgrade modphpbb 1.0.2 to 1.0.3
Upgrade modphpbb 1.0.2 to 1.0.3
Hi.I have a forum with modphpbb3 1.0.2.How can I update to 1.0.3 without creating new database?Must i update my phpbb3.0.1 to 3.0.2 first?
Re: Upgrade modphpbb 1.0.2 to 1.0.3
You could normally just add the update edits to ModphpBB3, but the phpBB in the download has been updated twice, so it would be a lengthy job to do.
Have you not been keeping up with the updates to the mods on version 1.0.2, I think that arcade was running 0.4.0, and now on 0.6.0
Have you not been keeping up with the updates to the mods on version 1.0.2, I think that arcade was running 0.4.0, and now on 0.6.0
Re: Upgrade modphpbb 1.0.2 to 1.0.3
So,I don't have to upload the file modded.sql to my database?
Re: Upgrade modphpbb 1.0.2 to 1.0.3
I uploaded now the new files of 1.0.3 and i face some problems.I had a portal and now is gone.Must i install it again?
When i go to refresh my style it shows this error:
What happened?
Moreover,when i go in arcade it shows that:
and in .mods tab in acp shows that:
Please help me.
When i go to refresh my style it shows this error:
Code: Select all
General Error
SQL ERROR [ mysql4 ]
Incorrect string value: '\xA9 Dyna...' for column 'template_data' at row 1 [1366]
SQL
UPDATE phpbb_styles_template_data SET template_id = 2, template_filename = 'poster_menu.html', template_included = '', template_mtime = 1196080228, template_data = '<script type=\"text/javascript\">\r\n\r\n/***********************************************\r\n* AnyLink Drop Down Menu- � Dynamic Drive (www.dynamicdrive.com)\r\n* This notice MUST stay intact for legal use\r\n* Visit http://www.dynamicdrive.com/ for full source code\r\n***********************************************/\r\n\r\n//Contents for menu 2, and so on\r\n<!-- BEGIN postrow -->\r\nvar menu{postrow.POSTER_ID}=new Array()\r\nmenu{postrow.POSTER_ID}[0]=\'<a href=\"{postrow.U_POST_AUTHOR}\"> {L_MENU_VIEWPROFILE}</a>\'\r\nmenu{postrow.POSTER_ID}[1]=\'<!-- IF postrow.U_PM --><a href=\"{postrow.U_PM}\"> {L_MENU_PM}</a><!-- ENDIF -->\'\r\nmenu{postrow.POSTER_ID}[2]=\'<!-- IF postrow.U_EMAIL --><a href=\"{postrow.U_EMAIL}\"> {L_MENU_EMAIL}</a><!-- ENDIF -->\'\r\nmenu{postrow.POSTER_ID}[3]=\'<!-- IF postrow.U_WWW --><a href=\"{postrow.U_WWW}\"> {L_MENU_WEBSITE}</a><!-- ENDIF -->\'\r\nmenu{postrow.POSTER_ID}[4]=\'<a href=\"{postrow.U_MENU_SEARCH}\"> {L_MENU_SEARCH}</a>\'\r\nmenu{postrow.POSTER_ID}[5]=\'<!-- IF postrow.U_WARN --><a href=\"{postrow.U_WARN}\"> {L_MENU_WARN}</a><!-- ENDIF -->\'\r\n<!-- END postrow -->\r\nvar menuwidth=\'170px\' //default menu width\r\nvar menubgcolor=\'#F2F2F3\' //menu bgcolor\r\nvar disappeardelay=\'500\' //menu disappear speed onMouseout (in miliseconds)\r\nvar hidemenu_onclick=\'yes\' //hide menu when user clicks within menu?\r\n\r\n/////No further editting needed\r\n\r\nvar ie4=document.all\r\nvar ns6=document.getElementById&&!document.all\r\nvar defaultwidth=menuwidth\r\nif (ie4||ns6)\r\ndocument.write(\'<div id=\"dropmenudiv\" style=\"visibility:hidden;width:\'+menuwidth+\';background-color:\'+menubgcolor+\'\" onMouseover=\"clearhidemenu()\" onMouseout=\"dynamichide(event)\"></div>\')\r\nfunction getposOffset(what, offsettype){\r\nvar totaloffset=(offsettype==\"left\")? what.offsetLeft : what.offsetTop;\r\nvar parentEl=what.offsetParent;\r\nwhile (parentEl!=null){\r\ntotaloffset=(offsettype==\"left\")? totaloffset+parentEl.offsetLeft : totaloffset+parentEl.offsetTop;\r\nparentEl=parentEl.offsetParent;\r\n}\r\nreturn totaloffset;\r\n}\r\nfunction showhide(obj, e, visible, hidden, menuwidth){\r\nif (ie4||ns6)\r\ndropmenuobj.style.left=dropmenuobj.style.top=-500\r\ndropmenuobj.widthobj=dropmenuobj.style\r\nif (typeof menuwidth==\'undefined\'||menuwidth==\'selfc\'){\r\ntmpspan.style.display=\'inline\'\r\ndropmenuobj.widthobj.width=tmpspan.offsetWidth+\'px\'\r\ntmpspan.style.display=\'none\'\r\n}\r\nelse if (menuwidth!=\'\')\r\ndropmenuobj.widthobj.width=menuwidth\r\nelse\r\ndropmenuobj.widthobj.width=defaultwidth\r\nif (e.type==\"click\" && obj.visibility==hidden || e.type==\"mouseover\")\r\nobj.visibility=visible\r\nelse if (e.type==\"click\")\r\nobj.visibility=hidden\r\n}\r\nfunction iecompattest(){\r\nreturn (document.compatMode && document.compatMode!=\"BackCompat\")? document.documentElement : document.body\r\n}\r\nfunction clearbrowseredge(obj, whichedge){\r\nvar edgeoffset=0\r\nif (whichedge==\"rightedge\"){\r\nvar windowedge=ie4 && !window.opera? iecompattest().scrollLeft+iecompattest().clientWidth-15 : window.pageXOffset+window.innerWidth-15\r\ndropmenuobj.contentmeasure=dropmenuobj.offsetWidth\r\nif (windowedge-dropmenuobj.x < dropmenuobj.contentmeasure)\r\nedgeoffset=dropmenuobj.contentmeasure-obj.offsetWidth\r\n}\r\nelse{\r\nvar topedge=ie4 && !window.opera? iecompattest().scrollTop : window.pageYOffset\r\nvar windowedge=ie4 && !window.opera? iecompattest().scrollTop+iecompattest().clientHeight-15 : window.pageYOffset+window.innerHeight-18\r\ndropmenuobj.contentmeasure=dropmenuobj.offsetHeight\r\nif (windowedge-dropmenuobj.y < dropmenuobj.contentmeasure){ //move up?\r\nedgeoffset=dropmenuobj.contentmeasure+obj.offsetHeight\r\nif ((dropmenuobj.y-topedge)<dropmenuobj.contentmeasure) //up no good either?\r\nedgeoffset=dropmenuobj.y+obj.offsetHeight-topedge\r\n}\r\n}\r\nreturn edgeoffset\r\n}\r\nfunction populatemenu(what){\r\nif (ie4||ns6){\r\nvar appendit=0\r\nif (typeof tmpspan==\'undefined\'){\r\ntmpspan=document.createElement(\'span\')\r\nappendit=1\r\n}\r\nif(appendit){\r\ntmpspan.style.position=\"absolute\"\r\ntmpspan.style.left=\"-1000px\"\r\ntmpspan.id=\'tspan\'\r\ndocument.body.appendChild(tmpspan)\r\ntmpspan.style.display=\'none\'\r\n}\r\ntmpspan.innerHTML=dropmenuobj.innerHTML=what.join(\"\")\r\n}\r\n}\r\nfunction dropdownmenu(obj, e, menucontents, menuwidth){\r\nobj.onmouseout=delayhidemenu;\r\nif (window.event) event.cancelBubble=true\r\nelse if (e.stopPropagation) e.stopPropagation()\r\nclearhidemenu()\r\ndropmenuobj=document.getElementById? document.getElementById(\"dropmenudiv\") : dropmenudiv\r\npopulatemenu(menucontents)\r\nif (ie4||ns6){\r\nshowhide(dropmenuobj.style, e, \"visible\", \"hidden\", menuwidth)\r\ndropmenuobj.x=getposOffset(obj, \"left\")\r\ndropmenuobj.y=getposOffset(obj, \"top\")\r\ndropmenuobj.style.left=dropmenuobj.x-clearbrowseredge(obj, \"rightedge\")+\"px\"\r\ndropmenuobj.style.top=dropmenuobj.y-clearbrowseredge(obj, \"bottomedge\")+obj.offsetHeight+\"px\"\r\n}\r\nreturn clickreturnvalue()\r\n}\r\nfunction clickreturnvalue(){\r\nif (ie4||ns6) return false\r\nelse return true\r\n}\r\nfunction contains_ns6(a, b) {\r\nwhile (b.parentNode)\r\nif ((b = b.parentNode) == a)\r\nreturn true;\r\nreturn false;\r\n}\r\nfunction dynamichide(e){\r\nif (ie4&&!dropmenuobj.contains(e.toElement))\r\ndelayhidemenu()\r\nelse if (ns6&&e.currentTarget!= e.relatedTarget&& !contains_ns6(e.currentTarget, e.relatedTarget))\r\ndelayhidemenu()\r\n}\r\nfunction hidemenu(e){\r\nif (typeof dropmenuobj!=\"undefined\"){\r\nif (ie4||ns6)\r\ndropmenuobj.style.visibility=\"hidden\"\r\n}\r\n}\r\nfunction delayhidemenu(){\r\nif (ie4||ns6)\r\ndelayhide=setTimeout(\"hidemenu()\",disappeardelay)\r\n}\r\nfunction clearhidemenu(){\r\nif (typeof delayhide!=\"undefined\")\r\nclearTimeout(delayhide)\r\n}\r\nif (hidemenu_onclick==\"yes\")\r\ndocument.onclick=hidemenu\r\n</script>' WHERE template_id = 2 AND template_filename = 'poster_menu.html'
BACKTRACE
FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()
FILE: includes/acp/acp_styles.php
LINE: 2474
CALL: dbal_mysql->sql_query()
FILE: includes/acp/acp_styles.php
LINE: 275
CALL: acp_styles->store_templates()
FILE: includes/functions_module.php
LINE: 471
CALL: acp_styles->main()
FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
Moreover,when i go in arcade it shows that:
Code: Select all
SQL ERROR [ mysql4 ]
Unknown column 'user_arcade_permissions' in 'field list' [1054]
SQL
UPDATE phpbb_users SET user_arcade_permissions = '\nzhxjwg', user_arcade_perm_from = 0 WHERE user_id = 2
BACKTRACE
FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()
FILE: includes/auth_arcade.php
LINE: 371
CALL: dbal_mysql->sql_query()
FILE: includes/auth_arcade.php
LINE: 71
CALL: auth_arcade->acl_cache()
FILE: arcade.php
LINE: 44
CALL: auth_arcade->acl()
Code: Select all
General Error
SQL ERROR [ mysql4 ]
Unknown column 'user_arcade_permissions' in 'field list' [1054]
SQL
UPDATE phpbb_users SET user_arcade_permissions = '\nzhxjwg', user_arcade_perm_from = 0 WHERE user_id = 2
BACKTRACE
FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()
FILE: includes/auth_arcade.php
LINE: 371
CALL: dbal_mysql->sql_query()
FILE: includes/auth_arcade.php
LINE: 71
CALL: auth_arcade->acl_cache()
FILE: includes/acp/acp_arcade.php
LINE: 34
CALL: auth_arcade->acl()
FILE: includes/functions_module.php
LINE: 471
CALL: acp_arcade->main()
FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
Re: Upgrade modphpbb 1.0.2 to 1.0.3
It looks unrepairable. You would have needed to edit the files via winmerge or similar, then ran the extra queries within database.
1.0.2 to 1.0.3 is a huge jump as it is running phpbb 3.0.2RC1 on the later version, and that's not including the portal you mention.
The only way of doing it now would be reinstalling your back up prior to overwriting the files, or install 1.0.3 / straight phpBB 3.0.1 or the portal version you were running.
1.0.2 to 1.0.3 is a huge jump as it is running phpbb 3.0.2RC1 on the later version, and that's not including the portal you mention.
The only way of doing it now would be reinstalling your back up prior to overwriting the files, or install 1.0.3 / straight phpBB 3.0.1 or the portal version you were running.
Re: Upgrade modphpbb 1.0.2 to 1.0.3
Is it a problem of database or files?What do you think?
Re: Upgrade modphpbb 1.0.2 to 1.0.3
I'd say both.
The top error is a serious mess.
The arcade errors could be where using newer files inc updates, but the database is needs updating.
The top error is a serious mess.
The arcade errors could be where using newer files inc updates, but the database is needs updating.