Log in

View Full Version : What happened with my db import?


Ransack
12-04-2008, 08:39 PM
I'm wondering if anyone has seen this before. I've imported a database which I'm in the process of moving from one server to another. When I import it I no longer see my forums in the main forum index.

I just see the headers: Forum Last Post Threads Posts
Then below it the Mark all forums read link.

In "Forum Manager" in the admincp I also do not see any forums.

I know the forums are there because I can see them in the db.
mysql> select count(*) from forum;
+----------+
| count(*) |
+----------+
| 40 |
+----------+
1 row in set (0.00 sec)

mysql>

When I browse directly to the forum using /url/forumdisplay.php?f=xxx
I get a permission error.


you do not have permission to access this page. This could be due to one of several reasons:

1. Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
2. If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.


Though I'm doing this as an admin user so I should have permission. I also see my forumpermissions table is populated. What else should I be looking for?

snakes1100
12-04-2008, 11:14 PM
maintenence, update counters, namely forum info.

check ownership of the files in the db folder as well, make sure root & mysql are playing nice together.

make sure the right owner owns the php files as well.

Ransack
12-05-2008, 03:51 AM
maintenence, update counters, namely forum info.


Thank you! Thank you!

It's obviously not a php file perm problem since those run, but I didn't know about this update counters stuff. Need to update counters after importing a db. Thanks so much.

--------------- Added 1228463253 at 1228463253 ---------------

Of course, now when I post in threads, the post I make is a post that was already posted in some other thread.. I've done both rebuild forum info and rebuild thread info.

--------------- Added 1228464294 at 1228464294 ---------------

I guess rebuilding post cache helps the issue I mention above.

Thanks for all the help.