Is there any way to do this in an easy way?
My post count doesn't add up since I've removed and added some posts during development of my site. Can I have all the users post counts recounted?
Anyway, I'll try making a mod for this in the meantime.
1 2005-11-05 15:01
Topic: Recounting userposts? (1 replies, posted in PunBB 1.2 troubleshooting)
2 2004-12-17 12:25
Re: Moderator-listings on the forums. (4 replies, posted in PunBB 1.2 bug reports)
Ah, it's time to upgrade I see.
3 2004-12-16 15:06
Topic: Moderator-listings on the forums. (4 replies, posted in PunBB 1.2 bug reports)
If you have a member that's moderating a specific forum.
THen if you turn him into a user without removing his moderated forums, he's still listed at the main page.
Is this done by intention?
I'm running Version: 1.1.5
4 2004-06-10 15:48
Re: MySQL-structure different in 1.1.4 since 1.0.* ? (8 replies, posted in PunBB 1.2 troubleshooting)
Never mind 
I fixed it hours ago, just forgot to mention it here
I had to remove subscriptions and config in the database and then proceed. Works like a charm now
5 2004-06-10 11:38
Re: MySQL-structure different in 1.1.4 since 1.0.* ? (8 replies, posted in PunBB 1.2 troubleshooting)
Alright, so it has nothing to do with the version of the markup language?
Weird, it keeps telling me that alot of tables can't be created, because they already exist.
6 2004-06-09 11:18
Re: MySQL-structure different in 1.1.4 since 1.0.* ? (8 replies, posted in PunBB 1.2 troubleshooting)
Alright. But I'm not sure I've updated the database for 1.0.1.
Can I see that in some way?
And is it enough to just run the update-file from 1.0.1 to 1.1 and then use the update-file that comes with the 1.1.4 ?
7 2004-06-09 10:53
Re: MySQL-structure different in 1.1.4 since 1.0.* ? (8 replies, posted in PunBB 1.2 troubleshooting)
Say what?
I thought that was only for the markup-part. So.. It's updating the database?
How can I be sure that it won't screw things up for me?
Edit: It looks like my version is PunBB 1.0.1 (yes, I'm not that up to date 
).
So the update won't work correct?
8 2004-06-09 10:20
Topic: MySQL-structure different in 1.1.4 since 1.0.* ? (8 replies, posted in PunBB 1.2 troubleshooting)
I just updated the forum and config:ed and everything. But all I get is:
An error was encountered
Error: Unable to update user visit data.
Almost sounds to me as it can't update stats for the users or something?
Well, please help me with this ASAP, it's quite urgent.
Thanx!
9 2004-01-13 06:50
Re: Rebulding index? (11 replies, posted in PunBB 1.2 troubleshooting)
When I prune and choose Not include stickies..
10 2004-01-12 22:49
Re: Rebulding index? (11 replies, posted in PunBB 1.2 troubleshooting)
No, I use 1.0.1 since not all PunBB-mods I use have been converted..
11 2004-01-12 17:59
Re: Rebulding index? (11 replies, posted in PunBB 1.2 troubleshooting)
But I still don't have a clue what Build Index is..
12 2004-01-12 15:25
Re: Rebulding index? (11 replies, posted in PunBB 1.2 troubleshooting)
I saw one thing now.. It deletes some topics each time.
So I ran it 4 times and now all the ones I wanted gone are..
13 2004-01-12 15:24
Re: Rebulding index? (11 replies, posted in PunBB 1.2 troubleshooting)
Fatal error: Cannot redeclare split_words() (previously declared in /home/hlcae/public_html/forum/include/searchidx.php:39) in /home/hlcae/public_html/forum/include/searchidx.php on line 39
14 2004-01-12 06:45
Topic: Rebulding index? (11 replies, posted in PunBB 1.2 troubleshooting)
Tried to prune but I got an error about split-something and something in searchidx.. So if I rebuild the index, what happends? I mean, what does it do?
15 2003-12-18 21:58
Re: Extended Forum Access Mod 1.0 by Cactuz (22 replies, posted in PunBB 1.2 modifications, plugins and integrations)
I just changed the php-file to look for version 1.0.1 instead of 1.0 so it would create the mysql-tables.. Then it's just rock and roll!
16 2003-12-13 17:53
Re: "Unable to fetch topic" ? (14 replies, posted in PunBB 1.2 troubleshooting)
It's really weird. Can't remember why it would have changed that line, must have been an old mod ?
Anyways. I took a brand new from the 1.0.1 zip and made the modification(locked forum etc) that I wanted and now it works!
At least I think it does. Bbl if it's cranky.
Thx for the help!
17 2003-12-13 17:39
Re: "Unable to fetch topic" ? (14 replies, posted in PunBB 1.2 troubleshooting)
Tried...
File: /home/hlcae/public_html/forum/viewforum.php
Line: 149
PunBB reported: Unable to fetch topic list for forum
Database reported: Unknown column 't.first_post_id' in 'on clause' (Errno: 1054)
18 2003-12-13 17:34
Re: "Unable to fetch topic" ? (14 replies, posted in PunBB 1.2 troubleshooting)
$result = $db->query('SELECT DISTINCT p.poster_id AS hasposted, m.message, t.id, t.poster, t.subject, t.posted, t.last_post, t.last_post_id, t.last_poster, t.num_views, t.replies, t.closed, t.sticky, t.moved_to FROM '.$db->prefix.'topics AS t LEFT JOIN '.$db->prefix.'posts AS p'.$useindex.' ON t.id=p.topic_id AND p.poster_id='.$cur_user['id'].' INNER JOIN '.$db->prefix.'posts AS m ON t.first_post_id = m.id WHERE t.id IN('.$threadids.') ORDER BY sticky DESC, last_post DESC' ) or error( 'Unable to fetch topic list for forum', __FILE__, __LINE__, $db->error() );
Is the code I found from the error.
t.replies 
Should I just change to t.num_replies?
19 2003-12-13 17:32
Re: "Unable to fetch topic" ? (14 replies, posted in PunBB 1.2 troubleshooting)
I have version 1.0.1 and the only mod I've performed and that has a connection to viewforum.php is EFAM.
So I compared the file with the EFAM-notes and everything checks out.
So, I don't really know what has happened.
Could you isolate the code that has to do with num_replies maybe? So I can check the .php ?
20 2003-12-13 17:04
Re: "Unable to fetch topic" ? (14 replies, posted in PunBB 1.2 troubleshooting)
Hmm, perhaps I am?
The file is 10 473 b big.
21 2003-12-13 16:36
Re: "Unable to fetch topic" ? (14 replies, posted in PunBB 1.2 troubleshooting)
CREATE TABLE `topics` (
`id` int(10) unsigned NOT NULL auto_increment,
`poster` varchar(25) NOT NULL default '',
`subject` varchar(70) NOT NULL default '',
`posted` int(10) unsigned NOT NULL default '0',
`last_post` int(10) unsigned NOT NULL default '0',
`last_post_id` int(10) unsigned NOT NULL default '0',
`last_poster` varchar(25) default NULL,
`subscribers` text,
`num_views` mediumint(8) unsigned NOT NULL default '0',
`num_replies` mediumint(8) unsigned NOT NULL default '0',
`closed` tinyint(1) NOT NULL default '0',
`sticky` tinyint(1) NOT NULL default '0',
`moved_to` int(10) unsigned default NULL,
`forum_id` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `topics_forum_id_idx` (`forum_id`)
) TYPE=MyISAM AUTO_INCREMENT=69 ;
22 2003-12-13 15:57
Re: "Unable to fetch topic" ? (14 replies, posted in PunBB 1.2 troubleshooting)
File: /home/hlcae/public_html/forum/viewforum.php
Line: 149
PunBB reported: Unable to fetch topic list for forum
Database reported: Unknown column 't.replies' in 'field list' (Errno: 1054)
23 2003-12-13 15:54
Re: "Unable to fetch topic" ? (14 replies, posted in PunBB 1.2 troubleshooting)
OH! Forgot that.. Hold on then
24 2003-12-13 14:50
Topic: "Unable to fetch topic" ? (14 replies, posted in PunBB 1.2 troubleshooting)
My server just got hacked, so I uploaded everything again since it was only index* files whom were deleted.
I can watch the forum and it's categories, even the topics.
But when I click on one it stops
What can they have done? Can somebody list all the forum-related tables in your database so I can see if something has vanished..
