Upgrade modphpbb 1.0.2 to 1.0.3

[old]

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?

[LDM]

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

[old]

So,I don't have to upload the file modded.sql to my database?

[old]

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:

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}\">&nbsp;{L_MENU_VIEWPROFILE}</a>\'\r\nmenu{postrow.POSTER_ID}[1]=\'<!-- IF postrow.U_PM --><a href=\"{postrow.U_PM}\">&nbsp;{L_MENU_PM}</a><!-- ENDIF -->\'\r\nmenu{postrow.POSTER_ID}[2]=\'<!-- IF postrow.U_EMAIL --><a href=\"{postrow.U_EMAIL}\">&nbsp;{L_MENU_EMAIL}</a><!-- ENDIF -->\'\r\nmenu{postrow.POSTER_ID}[3]=\'<!-- IF postrow.U_WWW --><a href=\"{postrow.U_WWW}\">&nbsp;{L_MENU_WEBSITE}</a><!-- ENDIF -->\'\r\nmenu{postrow.POSTER_ID}[4]=\'<a href=\"{postrow.U_MENU_SEARCH}\">&nbsp;{L_MENU_SEARCH}</a>\'\r\nmenu{postrow.POSTER_ID}[5]=\'<!-- IF postrow.U_WARN --><a href=\"{postrow.U_WARN}\">&nbsp;{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()

What happened?
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()

and in .mods tab in acp shows that:

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()

Please help me.

[LDM]

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.

[old]

Is it a problem of database or files?What do you think?

[LDM]

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.