Upgrade modphpbb 1.0.2 to 1.0.3
Posted: Mon Jul 07, 2008 4:00 pm
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?
Support Forum for ModphpBB3 and phpBB Community - Fully Modded phpBB3 Forum
https://www.modphpbb3.com/
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()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()