Topic: Urgent help required lost - Replies Views Last post

Hi all,

I am in the process of moving from sqlite to mysql. I have uploaded all data from the sqlite db to mysql.

The front page appears fine but when  go to browse a board I don't see the number of replies, views, or Last post. Not only that but when trying to browse a thread I get:
Bad request. The link you followed is incorrect or outdated.

I have no idea on how to fix this!!!
The server is meant to go live later today, so any help anyone can offer is appreciated.

my mind is on a permanent tangent
byUsers forum

Re: Urgent help required lost - Replies Views Last post

Debug info from viewforum:

Time (s)      Query
0.00064     SELECT u.*, g.*, o.logged, o.idle FROM users AS u INNER JOIN groups AS g ON u.group_id=g.g_id LEFT JOIN online AS o ON o.user_id=u.id WHERE u.id=1987
0.00017     UPDATE online SET logged=1182769455 WHERE user_id=1987
0.00029     SELECT * FROM online WHERE logged<1182769155
0.00028     SELECT f.forum_name, f.redirect_url, f.moderators, f.num_topics, f.sort_by, fp.post_topics FROM forums AS f LEFT JOIN forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id=1) WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND f.id=19
0.00021     SELECT COUNT(id) FROM reports WHERE zapped IS NULL
0.00012     SELECT COUNT(a.id) AS LAST_ID FROM akismet AS a where a.poster!=""
0.00071     SELECT id, poster, subject, posted, last_post, last_post_id, last_poster, num_views, num_replies, closed, sticky, moved_to FROM topics WHERE forum_id=19 ORDER BY sticky DESC, last_post DESC LIMIT 0, 30
0.00058     SELECT search_for, replace_with FROM censoring
Total query time: 0.003 s

debug from viewtopic:

Time (s)      Query
0.00063     SELECT u.*, g.*, o.logged, o.idle FROM users AS u INNER JOIN groups AS g ON u.group_id=g.g_id LEFT JOIN online AS o ON o.user_id=u.id WHERE u.id=1987
0.00017     UPDATE online SET logged=1182769496 WHERE user_id=1987
0.00030     SELECT * FROM online WHERE logged<1182769196
0.00039     SELECT t.subject, t.closed, t.num_replies, t.sticky, f.id AS forum_id, f.forum_name, f.moderators, fp.post_replies, s.user_id AS is_subscribed FROM topics AS t INNER JOIN forums AS f ON f.id=t.forum_id LEFT JOIN subscriptions AS s ON (t.id=s.topic_id AND s.user_id=1987) LEFT JOIN forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id=1) WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND t.id=3589 AND t.moved_to IS NULL
0.00022     SELECT COUNT(id) FROM reports WHERE zapped IS NULL
0.00013     SELECT COUNT(a.id) AS LAST_ID FROM akismet AS a where a.poster!=""
Total query time: 0.00184 s
my mind is on a permanent tangent
byUsers forum

Re: Urgent help required lost - Replies Views Last post

I'm guessing when you moved the data the ID numbers got messed up, not really sure what to suggest to fix it though...

Re: Urgent help required lost - Replies Views Last post

I thought of that, but everything seems ok - I'll re check against the sql file and see if I can spot any errors.

my mind is on a permanent tangent
byUsers forum

Re: Urgent help required lost - Replies Views Last post

got it!

exporting from sqlite had changed all NULL to ' '

so I've re-uploaded all affected tables and it appears to be working.

my mind is on a permanent tangent
byUsers forum