FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » FUDforum Installation Issues » upgrade problem
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Re: upgrade problem [message #17204 is a reply to message #17203] Fri, 19 March 2004 17:54 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Try downloading an upgrade script from the download page and running that script. If it still does not upgrade the tmpl files, tell me what PHP version are you are running and add
echo substr($data, $pos, ($end-$pos)) . "\n";
right above $end = strpos($data, "\n", $pos+1); line.
Re: upgrade problem [message #17267 is a reply to message #17204] Mon, 22 March 2004 15:04 Go to previous messageGo to next message
zhangming is currently offline  zhangming   United States
Messages: 24
Registered: March 2004
Karma: 0
Junior Member
The new version of upgrade.php did run through finally.

The new problem I'm having is the consistency check stops maybe due to the size of our database:

Validating User/Theme Relations
(/webpages/forum/fdata/include/theme/default/db.inc:114
/webpages/forum/adm/consist.php:620
) 1153: Got a packet bigger than 'max_allowed_packet'
Query: UPDATE fud23_users SET theme=1 WHERE id IN(117,113,114,10,45,46,47,48,49,55,54,53,50,51,44,56,57,58,59,
...

and the list of IDs is really long. Any advice?

Thanks!
Re: upgrade problem [message #17269 is a reply to message #17267] Mon, 22 March 2004 15:19 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
I quick solution is to run UPDATE fud23_users SET theme=1;

How many users do you have in the database?

The other solution is to raise MySQL's max_allowed_packet value.
Re: upgrade problem [message #17270 is a reply to message #17269] Mon, 22 March 2004 16:11 Go to previous messageGo to next message
zhangming is currently offline  zhangming   United States
Messages: 24
Registered: March 2004
Karma: 0
Junior Member
557,662 records in fud23_users.
Re: upgrade problem [message #17273 is a reply to message #17270] Mon, 22 March 2004 16:34 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
hmm, in this case just run the query i gave you.
Re: upgrade problem [message #17275 is a reply to message #17270] Mon, 22 March 2004 16:51 Go to previous messageGo to next message
zhangming is currently offline  zhangming   United States
Messages: 24
Registered: March 2004
Karma: 0
Junior Member
After increasing the mysql max_allowed_packet setting, the consistency check run through. The forum is up and running, but could you tell me what should I do to bring the cusomized look-and-feel back, it seems we lost that? Thanks!
Re: upgrade problem [message #17276 is a reply to message #17275] Mon, 22 March 2004 16:55 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
You need to port the customizations from errors/.backup to the new templates.
Re: upgrade problem [message #17278 is a reply to message #17276] Mon, 22 March 2004 17:57 Go to previous messageGo to next message
zhangming is currently offline  zhangming   United States
Messages: 24
Registered: March 2004
Karma: 0
Junior Member
How should I proceed to port?
For example: in the .backup directory I see two index.tmpl* files:

-rw-r--r-- 1 http nobody 8816 Mar 8 09:37 index.tmpl_1078760238
-rw-r--r-- 1 http nobody 8233 Mar 19 15:17 index.tmpl_WebTV_107973104

should I copy the first one to fdata/thm/default/templ/index.tmpl
and the soconrd to fdata/thm/webTV/index.tmp? And to do this to ALL template files?

Thanks!
Re: upgrade problem [message #17279 is a reply to message #17278] Mon, 22 March 2004 18:11 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Always use the file with the later date. Simply open the backed up file and manually copy the applicable changes into the new template.
Pages (2): [ «    1  2]  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: install.php causes no action.
Next Topic: Installation Problem
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 24 04:54:15 GMT 2024

Total time taken to generate the page: 0.02341 seconds