Forums

Unfortunately no one can be told what FluxBB is - you have to see it for yourself.

You are not logged in.

#1 2012-04-29 10:03:38

RedRocker227
Member
Registered: 2012-04-24
Posts: 122

"Error: Unable to fetch guest information."

I keep getting this error on every page. I'd installed FluxBB 1.4.8, but I wanted to transfer the database from a forum on PunBB-Hosting. The upload of the .sql file worked fine, in that it wasn't too big or anything. I deleted all the original FluxBB files from before the database transfer, renamed all the PunBB-Hosting files from things like "forumname$users" to "users". What's wrong?

Offline

#2 2012-04-29 14:00:07

arw
Member
Registered: 2012-03-20
Posts: 117

Re: "Error: Unable to fetch guest information."

it's on this line, the request is :

'SELECT u.*, g.*, o.logged, o.last_post, o.last_search FROM '.$db->prefix.'users AS u INNER JOIN '.$db->prefix.'groups AS g ON u.group_id=g.g_id LEFT JOIN '.$db->prefix.'online AS o ON o.ident=\''.$remote_addr.'\' WHERE u.id=1'

have you these table ( users, groups, online ) ?

edit :

and maybe you don't have the good prefix to check it you could add before the line :

die('@@@ Prefix = "'.$db->prefix.'" @@@');

if it's no good you can change it in config.php ( with the $db_prefix var )

Last edited by arw (2012-04-29 14:03:39)

Offline

#3 2012-04-29 16:05:37

RedRocker227
Member
Registered: 2012-04-24
Posts: 122

Re: "Error: Unable to fetch guest information."

Yes, I have the tables "users", "groups", and "online", if that's what you mean.

So I replace line 247 with what you posted?

And it's not a problem with a good prefix because I don't have a prefix on the table names.

Offline

#4 2012-04-29 16:08:32

Franz
Lead developer
From: Germany
Registered: 2008-05-13
Posts: 6,559
Website

Re: "Error: Unable to fetch guest information."

Please enable debug mode and paste the full error!


fluxbb.de | develoPHP

"As code is more often read than written it's really important to write clean code."

Offline

#5 2012-04-29 17:31:14

RedRocker227
Member
Registered: 2012-04-24
Posts: 122

Re: "Error: Unable to fetch guest information."

File: /home/u538645810/public_html/include/functions.php
Line: 247

FluxBB reported: Unable to fetch guest information

Database reported: Unknown column 'o.last_post' in 'field list' (Errno: 1054)

Failed query: SELECT u.*, g.*, o.logged, o.last_post, o.last_search FROM users AS u INNER JOIN groups AS g ON u.group_id=g.g_id LEFT JOIN online AS o ON o.ident='92.5.197.117' WHERE u.id=1

Offline

#6 2012-04-29 20:11:09

RedRocker227
Member
Registered: 2012-04-24
Posts: 122

Re: "Error: Unable to fetch guest information."

Anyone? hmm

Offline

#7 2012-04-29 20:16:33

Smartys
Former Developer
Registered: 2008-04-27
Posts: 3,139
Website

Re: "Error: Unable to fetch guest information."

PunBB-Hosting uses FluxBB 1.2. You need to upgrade your database before you can use it with 1.4.

Offline

#8 2012-04-29 20:18:18

Mark
Member
From: Southport, Uk
Registered: 2008-05-03
Posts: 535

Re: "Error: Unable to fetch guest information."

go to phpmyadmin, and check your online table and see if last_post is there.
by looks of that, it doesnt appear to be

Offline

#9 2012-04-29 20:23:00

RedRocker227
Member
Registered: 2012-04-24
Posts: 122

Re: "Error: Unable to fetch guest information."

Smartys wrote:

PunBB-Hosting uses FluxBB 1.2. You need to upgrade your database before you can use it with 1.4.

How do I upgrade it? (I'm a complete newbie, sorry).

Mark wrote:

go to phpmyadmin, and check your online table and see if last_post is there.
by looks of that, it doesnt appear to be

Not there. What do I do? Do I just make it manually?

Offline

#10 2012-04-29 20:58:34

Mark
Member
From: Southport, Uk
Registered: 2008-05-03
Posts: 535

Re: "Error: Unable to fetch guest information."

as smarty says, you need to update your database.

https://fluxbb.org/downloads/upgrade.html

Offline

#11 2012-04-29 21:20:16

RedRocker227
Member
Registered: 2012-04-24
Posts: 122

Re: "Error: Unable to fetch guest information."

That's for upgrading the FluxBB version though, right? I already have 1.4.8 which if I'm not mistaken is the latest (stable) release.

Offline

#12 2012-04-30 07:27:34

Franz
Lead developer
From: Germany
Registered: 2008-05-13
Posts: 6,559
Website

Re: "Error: Unable to fetch guest information."

Well, did you import your database from PunBB-Hosting, as Smartys said?


fluxbb.de | develoPHP

"As code is more often read than written it's really important to write clean code."

Offline

#13 2012-04-30 16:11:30

RedRocker227
Member
Registered: 2012-04-24
Posts: 122

Re: "Error: Unable to fetch guest information."

Yes.

Offline

#14 2012-04-30 20:17:12

RedRocker227
Member
Registered: 2012-04-24
Posts: 122

Re: "Error: Unable to fetch guest information."

I think I've pretty much got it working now, apart from one thing - when I try to move a thread or something it says:

Bad HTTP_REFERER. If you have moved these forums from one location to another or switched domains, you need to update the Base URL manually in the database (look for o_base_url in the config table) and then clear the cache by deleting all .php files in the /cache directory.

Now obviously I can understand what that means, but I don't know how to fix it, since there's no "o_base_url" row in config. Do PunBB-Hosting forums not have these or have I done something wrong? And if the answer is simply "Make o_base_url", how do I make it? (Once again, complete newbie).

Offline

#15 2012-04-30 20:48:07

arw
Member
Registered: 2012-03-20
Posts: 117

Re: "Error: Unable to fetch guest information."

i don't know, but to add it you can do the request :

INSERT INTO config VALUES('o_base_url','http://your_base_url_without_trailing_slash.com');

or if you have something like phpmyadmin, when you are on a table you can use the "Insert tab" to add manually an element :

ezWMY.jpg

( with this way, you will need to put the conf_name as o_base_url and conf_value as http://your_base_url_without_trailing_slash.com )

Offline

#16 2012-04-30 20:52:18

RedRocker227
Member
Registered: 2012-04-24
Posts: 122

Re: "Error: Unable to fetch guest information."

Thank you, I will try that. smile

Offline

#17 2012-04-30 20:58:30

RedRocker227
Member
Registered: 2012-04-24
Posts: 122

Re: "Error: Unable to fetch guest information."

I entered;

INSERT INTO config VALUES('o_base_url','http://themiscforums.tk');

And it came up with;

#1062 - Duplicate entry 'o_base_url' for key 'PRIMARY'

What does this mean? From the "Duplicate entry" part of it I'm guessing it means it's already in there but it's definitely not...

Offline

#18 2012-04-30 21:28:27

RedRocker227
Member
Registered: 2012-04-24
Posts: 122

Re: "Error: Unable to fetch guest information."

Oh, my mistake. It was there all along and I just wasn't searching through all the pages in database... I don't think this could be any more embarrassing if I wanted it to, haha.

Offline

#19 2012-04-30 21:47:09

arw
Member
Registered: 2012-03-20
Posts: 117

Re: "Error: Unable to fetch guest information."

and so there was a  bad value and you have updated it, or your issue with that is still not solved?

Offline

#20 2012-04-30 21:48:48

RedRocker227
Member
Registered: 2012-04-24
Posts: 122

Re: "Error: Unable to fetch guest information."

It's all fixed.

Offline

#21 2018-10-28 22:08:02

thelo4d1ng
Member
Registered: 2018-10-28
Posts: 8

Re: "Error: Unable to fetch guest information."

how did u fixed this

Offline

Board footer

Powered by FluxBB