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

Home » FUDforum Development » Bug Reports » Can't rebuild, compact or do datadump, and NNTP sync fails
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
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 Go to previous messageGo to previous message
kerryg is currently offline  kerryg   Canada
Messages: 157
Registered: September 2008
Karma:
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

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: nntp import notice
Next Topic: NNTP Topic is Truncated sometimes with German Characters
Goto Forum:
  

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

Current Time: Fri Nov 22 01:55:31 GMT 2024

Total time taken to generate the page: 0.04976 seconds