|
|
Re: Can't rebuild, compact or do datadump, and NNTP sync fails [message #159074 is a reply to message #159066] |
Sat, 02 May 2009 18:16 |
kerryg
Messages: 157 Registered: September 2008
Karma: 0
|
Senior Member |
|
|
Thanks Frank, I've increased php's memory to 256 meg and loosened some timeouts.
I checked and found that the files appear to be there but have subtly different names than the script says it can't find (note no hyphen) -
I was on 2.8.0 when I started getting these problems but upgraded to 2.8.1 on the off chance it might resolve them. I haven't been able to do a datadump for a while so my first preference would be to solve this "in situ" (although worst-case I can re-sync the forums to the NG and retrieve the posts that way).
The NG is up and running, I can access it via a USENET reader. I use a hosting service (Hostmonster), I'm not quite sure how to test if they can similarly access it.
[Updated on: Sat, 02 May 2009 18:27] Report message to a moderator
|
|
|
|
|
|
|
|
Re: Can't rebuild, compact or do datadump, and NNTP sync fails [message #159117 is a reply to message #159109] |
Wed, 06 May 2009 17:45 |
kerryg
Messages: 157 Registered: September 2008
Karma: 0
|
Senior Member |
|
|
OK, not having much luck here. I can't get the SQL Manager link to show up on the left side of my Admin Control panel despite recompiling the themes, and I'm wondering if if I've corrupted my default theme somehow during a misguided attempt to figure out the theming process. This would mean that everything I build from it will be corrupted too. Is there a way to download the entire "default" theme templates from CVS to replace my own to test this out?
edited to add: in case this is useful info - my themes all say Powered by: FUDforum 2.8.0 at the bottom, despite the upgrade I've now performed twice.
[Updated on: Wed, 06 May 2009 17:58] Report message to a moderator
|
|
|
|
|
Re: Can't rebuild, compact or do datadump, and NNTP sync fails [message #159131 is a reply to message #159124] |
Thu, 07 May 2009 18:24 |
kerryg
Messages: 157 Registered: September 2008
Karma: 0
|
Senior Member |
|
|
Happy to report that one aspect of the problem - the broken NNTP sync - has been resolved. Right around the same time I started experiencing these issues, my hosting service suddenly decided to restrict all access below port 1024 without notifying anyone (grrrrrrrrr) and it was solved with a phone call (they whitelisted the port for me).
So now there's the two (possibly related) issues to resolve - why the upgrade script is telling me it's done its job but the forums don't reflect that, and why the re-index/compact/data dump functions fail.
I checked and the data dump is indeed creating a file, so since I had installed another FUDforum in a test directory I imported that data dump into it. The problems immediately get duplicated at the new forum, so I'm thinking I might simply have a corrupted database.
[Updated on: Thu, 07 May 2009 18:24] Report message to a moderator
|
|
|
|
|
Re: Can't rebuild, compact or do datadump, and NNTP sync fails [message #159174 is a reply to message #159147] |
Sun, 10 May 2009 19:36 |
kerryg
Messages: 157 Registered: September 2008
Karma: 0
|
Senior Member |
|
|
Spot on, that was it. Maybe I was being absentminded that day and downloaded the wrong script.
[sfx: head banging on desk]
The database remains a problem - the MySQL query gives this result -
(/home/kerrygal/FUDforum/include/theme/default/db.inc:73
/home/kerrygal/public_html/ParisForums/adm/admsql.php:56
) 1146: Table 'kerrygal_parisforumsdata09.fud28_msg' doesn't exist
Query: SELECT file_id, count(*) FROM fud28_msg GROUP BY file_id;
_POST: array ( 'SQ' => '3959a727ab29b050fab3c7eac96eef83', 'sql' => 'SELECT file_id, count(*) FROM fud28_msg GROUP BY file_id;', )
Server Version: 5.0.75-community-log
[Referring Page] http://kerrygalloway.com/ParisForums/adm/admsql.php?&SQ=3959a727ab29b050fab3c7eac96eef83
but if I change it to my own db prefix it's this -
SQL Results
file_id count(*)
-80000 1
-70000 43
-60000 3
60000 48465
70000 48
80000 1635
100000 2
120000 2
130000 4
9 row(s) returned.
That MySQL manager's going to be *very* handy.
[Updated on: Sun, 10 May 2009 19:37] Report message to a moderator
|
|
|
|
|
|