Best of joomla gives you news, joomla templates, tutorials and websites about Joomla , FireBoard and FireMessage official page.
| No account yet?   |
Welcome, Guest
Please Login or Register.    Lost Password?
Re:HELP > Serious db problem (1 viewing) (1) Guest
Go to bottom Favoured: 0
TOPIC: Re:HELP > Serious db problem
#43226
HELP > Serious db problem 6 Months, 3 Weeks ago  
I installed fireboard, but now when I click on Forum I get this message:

Serious db problem:Unknown column \'fbviewtype\' in \'field list\' SQL=select fbviewtype from jos_comprofiler where user_id=\'62\'

No idea what's this.. Please HELP

www.casa-guia.com

thanks
Jorgek (User)
Fresh Boarder
Posts: 5
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
Last Edit: 2008/02/07 14:19 By Jorgek.
 
The administrator has disabled public write access.  
#43231
Re:HELP > Serious db problem 6 Months, 3 Weeks ago  
That is a Community Builder error.
grumblemarc (User)
Platinum Boarder
Posts: 3557
graph
User Offline Click here to see the profile of this user
Gender: Male
Logged Logged
 
The administrator has disabled public write access.  
#43248
Re:HELP > Serious db problem 6 Months, 3 Weeks ago  
I unistall CB (and com_profiler) and the error with Forum became this one:



Warning: include_once(/home/casa/public_html/components/com_comprofiler/plugin/language/default_language/default_language.php) [function.include-once]: failed to open stream: No such file or directory in /home/casa/public_html/components/com_fireboard/fireboard.php on line 228

Warning: include_once() [function.include]: Failed opening '/home/casa/public_html/components/com_comprofiler/plugin/language/default_language/default_language.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php' in /home/casa/public_html/components/com_fireboard/fireboard.php on line 228
Serious db problem:Unknown column \'fbviewtype\' in \'field list\' SQL=select fbviewtype from jos_comprofiler where user_id=\'62\'

----------------------------------------------------

I installed back com_profiler, and the error now is:

Serious db problem:Unknown column \'fbviewtype\' in \'field list\' SQL=select fbviewtype from jos_comprofiler where user_id=\'62\'

-----------------------------------------------------

But the issue is that before installing fireboard everything was working fine, so...what must I do to have fireboard working alonje and working with CB (if possible)?
Jorgek (User)
Fresh Boarder
Posts: 5
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#44216
Re:HELP > Serious db problem 6 Months, 2 Weeks ago  
Did you fix this yet?
I wonder if you need to configure the "Use Community Builder" buttons and selections in Fireboard configuration?
oleviiv (User)
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#44219
Re:HELP > Serious db problem 6 Months, 2 Weeks ago  
I fixed by uninstalling CB... Then, I'v install again CB and had no problem.
Jorgek (User)
Fresh Boarder
Posts: 5
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#47167
Re:HELP > Serious db problem 5 Months, 2 Weeks ago  
I had this same problem and uninstalling and reinstalling CB were not a possibility in my environment. So I stumbled through the German language answer and found that all I had to do was manually add these fields to jos_comprofiler:

Code:

  `fbviewtype` varchar(255) NOT NULL default '_UE_SB_VIEWTYPE_FLAT',
  `sbordering` varchar(255) NOT NULL default '_UE_SB_ORDERING_OLDEST',
  `sbsignature` mediumtext,



Now it works except posting has some sort of badwords issue, sigh
kittymcooper (User)
Fresh Boarder
Posts: 18
graphgraph
User Offline Click here to see the profile of this user
Location: Fort Collins, CO
Logged Logged
 
------------------------------------------------------------------
Kitty Munson Cooper, web designer and programmer,
Open Sky Web Design
 
The administrator has disabled public write access.  
#52156
Re:HELP > Serious db problem 2 Months, 1 Week ago  
Hey guys,
I had the same problem (Serious db problem:Unknown column \'fbviewtype\' in \'field list\' SQL=select fbviewtype from jos_comprofiler where user_id=\'62\'

I was able to fix it. I'm not sure if this will always solve the problem, but this is what did it for me. In order to integrate Fireboard with Community Builder, you need to go into the Fireboard configuration. Look under Integration -> Community Builder. You'll see the "Community Builder User Profiles" drop down box. Underneath that, there should be a link to "Create Community Builder forum profile." If you click this link, it will insert the appropriate entries into the Community Builder database in order to permit integration. Save the configuration and try viewing the forum again. It should be operational now.
DarkCheshire (User)
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#53058
Re:HELP > Serious db problem 1 Month, 3 Weeks ago  
Dark Cheshire's suggestion worked for me. I got the problem after upgrading the FB/CB plugin. Once I clicked "Create Community Builder forum profile." it worked again.
troldman (User)
Fresh Boarder
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#55517
Re:HELP > Serious db problem 3 Weeks ago  
Just wanted to also say thanks. After scratching my head for a few hours, I stubbornly came to the forum and found the solution quickly. I think this could have been avoided with a highlighted warning of what would happen without clicking that link.

TheGrayDog (User)
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
Go to top
Powered by FireBoard - Creditsget the latest posts directly to your desktop