Dear FireBoard users,
In order to further develope the need of Joomla for a robust forum, FireBoard component has been moved to its own new home and new name. You can find more information regarding the Kunena, the successor of FireBoard, at kunena.com. The current forum here will stay for some time more for referencing needs. You can find the FireBoard files under joomlacode.org and other files
Upgrading to Kunena is highly recommended!

Kunena! - To Speak!

A revolution is coming... Kunena - Swahili for: To Speak! THE Next generation of native Joomla based Forum ultra component. Forget what you know about Joomla based forums...
Amazingly Simple Lean and Clean Easier Customization
Kunena is about to redefine the world of Joomla! with the most simplistic ultra component out there. For ultimate performance based on state of the art development techniques, Kunena! is about to bring you... With an integrated plugin system that will allow you to extend Kunena beyond your wildest imaginations...
[Solved] SQL Error Userlist..help!
TOPIC: [Solved] SQL Error Userlist..help!
#20914
[Solved] SQL Error Userlist..help! 10 Years, 2 Months ago  
Hey Everyone..im busy upgrading, after copying the fireboard_100_to_1.0.3 into phpadmin sql, i got many errors, but my forum seems to be working fine, except for one error i get when opening the userlist i get the following error as a result:

[url]Warning: Invalid argument supplied for foreach() in /home/***/public_html/components/com_fireboard/template/default/plugin/userlist/userlist.php on line 380[/url]

I checked other threads but none of the problems there are the same as mine. Which sql query should i run to get this solved? :(
#20914
[Solved] SQL Error Userlist..help! 10 Years, 2 Months ago  
Hey Everyone..im busy upgrading, after copying the fireboard_100_to_1.0.3 into phpadmin sql, i got many errors, but my forum seems to be working fine, except for one error i get when opening the userlist i get the following error as a result:

[url]Warning: Invalid argument supplied for foreach() in /home/***/public_html/components/com_fireboard/template/default/plugin/userlist/userlist.php on line 380[/url]

I checked other threads but none of the problems there are the same as mine. Which sql query should i run to get this solved? :(
#21118
Re:SQL Error Userlist..help! 10 Years, 2 Months ago  
Seems to be related somewhat with my problem:
[url]http://www.bestofjoomla.com/component/option,com_fireboard/Itemid,38/func,view/id,20381/catid,77/[/url]

So others are also getting similar errors, too, I don\'t think the solution is to lower the error/warning level of Joomla as suggested by Danialt.

This must be a different problem \'cause I didn\'t have this issues with 1.0.2RC2 before.
#21122
Re:SQL Error Userlist..help! 10 Years, 2 Months ago  
Foreach() errors are database problems. Something didn\'t get updated properly. Please make sure all upgrade SQL statements were executed properly.
#21127
Re:SQL Error Userlist..help! 10 Years, 2 Months ago  
I\'m pretty sure that I executd all of those upgrade SQL statements in phpMyAdmin. At least none of them returned with an error.

I upgraded from 1.0.2RC2 to 1.0.3. So I had to run only two scripts at the end.
#21205
Re:SQL Error Userlist..help! 10 Years, 2 Months ago  
[b]palebluedot wrote:[/b]
[quote]Foreach() errors are database problems. Something didn\'t get updated properly. Please make sure all upgrade SQL statements were executed properly.[/quote]

I had so many sql errors from which i dont know how to solve (the answers in other threads didnt help), and i ran the scripts one by one, but stil few errors remained. Im upgrading from the nightly build version, so i didnt know anyway which sql queries to use..but tried both 100 and 101 to 103, but both with errors...but my forum is working fine! only the userlist not, so therefor i wanted to know which script i have to run again to make it work? Its not clear which script is focused on fixing the userlist.

Roaster..how do you lower your error level in joomla? Worth a try ahh ;)
#21409
Re:SQL Error Userlist..help! 10 Years, 2 Months ago  
you can try this
before the line that error says put this

[code:1]
echo $database->getErrorMsg();
[/code:1]

And tell the error here:
#21593
Re:SQL Error Userlist..help! 10 Years, 2 Months ago  
Thanks for helping denialt..i suck at sql.

I get the following error (using 100 to 103):

[code:1]SQL-query:

/* Alter table in Second database */ ALTER TABLE `jos_fb_categories` ADD COLUMN `headerdesc` text NOT NULL AFTER `description` ,
ADD COLUMN `class_sfx` varchar( 20 ) NOT NULL AFTER `headerdesc` ,
ADD COLUMN `id_last_msg` int( 10 ) NOT NULL DEFAULT \'0\' AFTER `class_sfx` ,
ADD COLUMN `numTopics` mediumint( 8 ) NOT NULL DEFAULT \'0\' AFTER `id_last_msg` ,
ADD COLUMN `numPosts` mediumint( 8 ) NOT NULL DEFAULT \'0\' AFTER `numTopics` ,
ADD COLUMN `time_last_msg` int( 11 ) NULL AFTER `numPosts` ,
DROP KEY `catid` ,
DROP KEY `catparent` ,
ADD KEY `msg_id` ( `id_last_msg` ) ,
ADD KEY `parent` ( `parent` ) ,
ADD PRIMARY KEY ( `id` ) ,
ADD KEY `published_pubaccess_id` ( `published` , `pub_access` , `id` ) ,
COMMENT = \'\';

MySQL returned documentation
#1091 - Can\'t DROP \'catid\'; check that column/key exists [/code:1]

so i tried to put your code in front of several lines, but it makes it give me even more errors..so im not sure where i should put the line you told me?

I see that when i run all the queries one by one i get only duplicate and cant drop errors.which should mean that everything is there no? Now i see that my error at the userlist is gone also..but no one, not one user appears in the list...so i guess still something goes wrong somewhere?
#21887
Re:SQL Error Userlist..help! 10 Years, 2 Months ago  
I have the same problem...

Anyone?
#22027
Re:SQL Error Userlist..help! 10 Years, 2 Months ago  
Same here

The only \"error\" I could see was: #1091 - Can\'t DROP \'catid\'; check that column/key exists

JP
#22382
Re:SQL Error Userlist..help! 10 Years, 2 Months ago  
This topic isnt about \'any sql error\'..i asked help specifically for the userlist! I dont have an error anymore now when i open the userlist, but none of my users are showing up! What should i doo??
Page: 12