1 Reply by liquidblaze

(18 replies, posted in PunBB 1.2 troubleshooting)

sorry for the late response, I was away a couple of days.

I did what you suggested and added the auto_increment value to the tables that should have it. Now rebuilding the search index works and I can view topics again.

The only thing that still does not work is forumhome's link to a topic: the link always shows up like this --> http://domain.com/viewtopic.php?pid=0#p0  for every forum / subforum.

any thoughts on that?

[UPDATE]

I just did a REPAIR / OPTIMIZE in phpMyAdmin and now this is working too, thanks smile

Go to forum: PunBB 1.2 troubleshooting

2 Reply by liquidblaze

(18 replies, posted in PunBB 1.2 troubleshooting)

ah, yes, that would make sense, that would make a lot of sense actually.

mySQL isnt necessarily my strongest point so any help you could provide would be _greatly_ appreciated.

Go to forum: PunBB 1.2 troubleshooting

3 Reply by liquidblaze

(18 replies, posted in PunBB 1.2 troubleshooting)

My Backup is already imported into the SQL DB, so should I export it again and then edit the topics table?

Go to forum: PunBB 1.2 troubleshooting

4 Reply by liquidblaze

(18 replies, posted in PunBB 1.2 troubleshooting)

please? :-)

Go to forum: PunBB 1.2 troubleshooting

5 Reply by liquidblaze

(18 replies, posted in PunBB 1.2 troubleshooting)

there's a good chance that that is true. is that something I can fix with a SQL statement?

Go to forum: PunBB 1.2 troubleshooting

6 Reply by liquidblaze

(18 replies, posted in PunBB 1.2 troubleshooting)

I did that, but I guess that I may have analyzed my problem the wrong way:

File: httpdocs/post.php
Line: 288

PunBB reported: Unable to create topic

Database reported: Duplicate entry '0' for key 1 (Errno: 1062)

Is what I get.

Go to forum: PunBB 1.2 troubleshooting

7 Reply by liquidblaze

(18 replies, posted in PunBB 1.2 troubleshooting)

sweet! care to tell me what the exact query should look like? smile

Go to forum: PunBB 1.2 troubleshooting

8 Reply by liquidblaze

(18 replies, posted in PunBB 1.2 troubleshooting)

I realize that this is a _very_ old thread, but I am having the same problem and I would like to fix it too.

on which tables do I have to run the update statement?

Go to forum: PunBB 1.2 troubleshooting

9 Reply by liquidblaze

(13 replies, posted in PunBB 1.2 bug reports)

ok thx ... I'll see how I can accomplish that, considering that the forum I used as a knowledge base was the 1.1.4 version smile

would it help if I'd install the newest version with the old config.php values?

Go to forum: PunBB 1.2 bug reports

10 Reply by liquidblaze

(13 replies, posted in PunBB 1.2 bug reports)

when you say

"you could look in index.php at the indexes", where exactly would you have me look at ?

Go to forum: PunBB 1.2 bug reports

11 Reply by liquidblaze

(13 replies, posted in PunBB 1.2 bug reports)

ouch.

I'll have a go. but wouldnt phpmyadmin's function to create indexes work as well?

does anyone have another solution? something ... a bit simpler smile

Go to forum: PunBB 1.2 bug reports

12 Reply by liquidblaze

(13 replies, posted in PunBB 1.2 bug reports)

Nothin at all. Just a plain punBB

Go to forum: PunBB 1.2 bug reports

13 Reply by liquidblaze

(13 replies, posted in PunBB 1.2 bug reports)

anyone got any thoughts on this?

I'd really love to get my knowledge base up and running again smile

Go to forum: PunBB 1.2 bug reports

14 Reply by liquidblaze

(13 replies, posted in PunBB 1.2 bug reports)

sounds good to me.

and just how would I achieve this? :-$

phpmyAdmin suggests:

---

Indexes:

Warning No index defined!

Create an index on X columns

---

should I do just that ?

how much should X be? standard value currently is 1

Go to forum: PunBB 1.2 bug reports

15 Reply by liquidblaze

(13 replies, posted in PunBB 1.2 bug reports)

nope - that didnt help.

[EDIT]

i'm not sure if this is related or not, but when I repaid the tables, it works for all except this one:

database.punbbonline      repair      error      The handler for the table doesn't support repair

all others repair / optimize fine.

what I also noticed - the punbbonline is 1.6 megs in size, which is kinda big considering the only person its reporting online is me.

Go to forum: PunBB 1.2 bug reports

16 Topic by liquidblaze

(13 replies, posted in PunBB 1.2 bug reports)

Hello guys,

I've been using punBB on a few sites for quite some time now and just recently moved from one server to another.
Naturally, this included dumping the DBs and reuploading them - all no problem, or so I thought.

I use one punBB Installation to save quotes and other stuff I want to remember and when I accessed it today, I only got the following:

Unable to fetch newest registered user

There was a thread here somewhere with the same problem, but the user got help from the admin and no solution was posted.

Here's more debug information:

File: /home/httpd/vhosts/example.com/httpdocs/index.php
Line: 152

PunBB reported: Unable to fetch newest registered user
Database reported: Got error 124 from table handler (Errno: 1030)

Go to forum: PunBB 1.2 bug reports