Your problem is that the columns on each table are different. So what you need to do is export a backup of the users table that specifies what columns are having values inserted. Same with posts.
2,427 2007-08-31 04:01
Re: Please advise on best upgrade approach and solution to SPAM (25 replies, posted in PunBB 1.2 troubleshooting)
Extensions, especially for fighting spam, are wonderful. Why? They don't tie you to one solution.
Maybe Akismet comes as a default extension. But your users keep getting their posts marked as spam (sometimes happens when users make short posts like "lol"). So then you want to replace it with a CAPTCHA. And then you have issues with user accessibility, so you try some DNSBLs. And on it goes
The extensions allow you to mix and match and find a group of spam fighting tools that work for you, rather than tying you to one set of tools.
2,428 2007-08-31 03:58
Re: Problem with forum in spanish (12 replies, posted in PunBB 1.2 troubleshooting)
Wordpress usually uses UTF-8, PunBB 1.2 does not by default. You can convert one of the two (I would suggest converting PunBB, search around a bit and you'll find a lot of topics on the subject)
2,429 2007-08-31 03:56
Re: Email notification about posts for admin (3 replies, posted in PunBB 1.2 modifications, plugins and integrations)
Moved to Modifications
You can use the RSS feed or use a modification which has PunBB send out emails for every post
2,430 2007-08-29 13:44
Re: Yet another integration issue - setting the cookie outside of punBB (6 replies, posted in PunBB 1.2 modifications, plugins and integrations)
Is $cookie_seed the same value as from config.php?
2,431 2007-08-29 11:08
Re: Error writing to cache (10 replies, posted in PunBB 1.2 troubleshooting)
You need to chmod your cache folder so that PHP can write to it
2,432 2007-08-29 11:07
Re: pgsql.php (1 replies, posted in PunBB 1.2 bug reports)
db_prefix should be a prefix for the table name, not a scheme name
Closed
2,433 2007-08-28 22:37
Re: Problems after moving to other host (18 replies, posted in PunBB 1.2 troubleshooting)
So you need to add auto_increment to all the primary key columns in the table
http://punbb.org/docs/dev.html#dbtables
The specific columns are identified there.
I would suggest simply editing your backup: if you want to generate a new backup of the current data, you can use that instead. Once you're done, simply import your backup.
2,434 2007-08-28 22:24
Re: PunBB 1.3 bug (3 replies, posted in PunBB 1.2 troubleshooting)
Yeah, the parser is currently being rewritten and we know about it failing with large posts
I'm going to close this, since as Bekko said we're not taking bug reports
2,435 2007-08-28 21:51
Re: Yet another integration issue - setting the cookie outside of punBB (6 replies, posted in PunBB 1.2 modifications, plugins and integrations)
Could you link to where you're actually trying this so we can see the output?
2,436 2007-08-28 21:08
Re: Donated, yet showing as member (2 replies, posted in PunBB 1.2 discussion)
Email Rickard about it, that kind of stuff is updated manually
2,437 2007-08-28 20:56
Re: Admin Options Just Stoped Working (5 replies, posted in PunBB 1.2 troubleshooting)
Hmm, it looks like your config table got dropped
You'll need to re-create it manually
2,438 2007-08-28 20:07
Re: Admin Options Just Stoped Working (5 replies, posted in PunBB 1.2 troubleshooting)
Enable debug mode, paste the full error
2,439 2007-08-28 20:07
Re: Pun Front page is no more? And Pun BB doesn't support a chat area? (4 replies, posted in PunBB 1.2 discussion)
Moved to PunBB Discussion
2,440 2007-08-27 21:35
Re: Problems after moving to other host (18 replies, posted in PunBB 1.2 troubleshooting)
The issue would affect all tables that use an auto_increment value
2,441 2007-08-27 21:13
Re: Problems after moving to other host (18 replies, posted in PunBB 1.2 troubleshooting)
I would open your backup, look for the create table statements, and add auto_increment to the proper columns
2,442 2007-08-27 21:13
Re: i can't delete user (2 replies, posted in PunBB 1.2 troubleshooting)
We can't tell more without seeing the error log
2,443 2007-08-26 13:39
Re: Problems after moving to other host (18 replies, posted in PunBB 1.2 troubleshooting)
Hmm, it sounds to me like your database backup was missing all the auto_increment settings as well
2,444 2007-08-26 13:03
Re: I do not recive any reports (14 replies, posted in PunBB 1.2 troubleshooting)
You would have to look for a modification on a site like PunRes.
As for the RSS feed, extern.php is documented here:
http://punbb.org/docs/dev.html#syndication
2,445 2007-08-26 12:51
Re: I do not recive any reports (14 replies, posted in PunBB 1.2 troubleshooting)
An unmodified copy of PunBB does not have a way to alert people every time there is a new message in the forum (unless you use the RSS feed).
2,446 2007-08-26 12:39
Re: Problems after moving to other host (18 replies, posted in PunBB 1.2 troubleshooting)
I think it's:
update prefixtopics set moved_to=null where moved_to=0
where prefix is your database prefix
2,447 2007-08-26 12:38
Re: I do not recive any reports (14 replies, posted in PunBB 1.2 troubleshooting)
You would need to find a modification for PunBB that allows that
2,448 2007-08-26 12:06
Re: I do not recive any reports (14 replies, posted in PunBB 1.2 troubleshooting)
No, it's used for people to report posts for some reason (eg: offensive content) and bring those posts to the attention of the administrators/moderators.
2,449 2007-08-26 11:40
Re: I do not recive any reports (14 replies, posted in PunBB 1.2 troubleshooting)
The reports table is not where new topics are added, new rows are added to the reports table when people report posts
2,450 2007-08-26 11:28
Re: I do not recive any reports (14 replies, posted in PunBB 1.2 troubleshooting)
The reports table is not where new topics are added, new rows are added to the reports table when people report posts