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...
How to run SQL scripts -> the lazy man\'s way
TOPIC: How to run SQL scripts -> the lazy man\'s way
#26252
How to run SQL scripts -> the lazy man\'s way 10 Years, 1 Month ago  
I just figured out an easy way to update your SQL database with the necessary script(s)! This eliminates database errors like the \'Invalid arguement supplied for foreach()\' issue.

This applied to people like me who:
- Don\'t know anything about SQL or PHP
- Don\'t have shell access to SQL or PHPMyAdmin

You WILL need:
- to be able to install a joomla component.

1. Go to the Joomla extensions website and download a component called EasySQL.

2. Install the component, and open it. Don\'t play with any of the settings here.

3. Open your appropriate SQL script text file from the new version of Fireboard, and copy and paste this text (minus the silly header picture thingy)

4. Press \'exec SQL\'.

5. Done/Profit!
#26252
How to run SQL scripts -> the lazy man\'s way 10 Years, 1 Month ago  
I just figured out an easy way to update your SQL database with the necessary script(s)! This eliminates database errors like the \'Invalid arguement supplied for foreach()\' issue.

This applied to people like me who:
- Don\'t know anything about SQL or PHP
- Don\'t have shell access to SQL or PHPMyAdmin

You WILL need:
- to be able to install a joomla component.

1. Go to the Joomla extensions website and download a component called EasySQL.

2. Install the component, and open it. Don\'t play with any of the settings here.

3. Open your appropriate SQL script text file from the new version of Fireboard, and copy and paste this text (minus the silly header picture thingy)

4. Press \'exec SQL\'.

5. Done/Profit!
#26302
Re:How to run SQL scripts -> the lazy man\'s way 10 Years, 1 Month ago  
Looks like this might be something to add to your Joomla tool chest! I haven\'t used it as it seems to be pretty new but thanks for the heads up.
#26380
Re:How to run SQL scripts -> the lazy man\'s way 10 Years, 1 Month ago  
Copy and Paste what text??? Sorry....very new to this!
#26415
Re:How to run SQL scripts -> the lazy man\'s way 10 Years, 1 Month ago  
When you download the new version of Fireboard (1.0.3 or something) there will be several folders in the first zip file. One of those folders is called \'Upgrades\' and contains three SQL scripts; one for each previous unstable version of Fireboard.

You need to use the appropriate script to fix everything. You will need to read the PDF in there to find out which version you have.
#26713
Re:How to run SQL scripts -> the lazy man\'s way 10 Years, 1 Month ago  
When i go into the EasySQL to change the databases, how do i change the databases? And also, I noticed there is one bit that says i need to add a new table... how do i do that?

I am sorry... but i need a bit more detailed explanation... i have never done this before. I am upgrading from 1.0.1 to the newest...
#26714
Re:How to run SQL scripts -> the lazy man\'s way 10 Years, 1 Month ago  
Don\'t worry... i think i have figured it out.. dah! It\'s prety simple... should have read the instructions a bit better!
#31272
Re:How to run SQL scripts -> the lazy man\'s way 10 Years ago  
Whenever I execute any query in EasySQL i get following warnings -

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/blackie/public_html/kiwicard/includes/database.php on line 433

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/blackie/public_html/kiwicard/includes/database.php on line 440


Shall i make this particular file writable?? or wht is it?
#31273
Re:How to run SQL scripts -> the lazy man\'s way 10 Years ago  
It worked anyway :)

cheers :)
#31477
Re:How to run SQL scripts -> the lazy man\'s way 10 Years ago  
it worked for me, too. but: now I have my categories, with all the threads, but it says \"0 posts\" and \"0 Replies\", even though there are plenty in each category. how\'s that???

...uh, and the buttons are gone, instead I ony see text links...

edit: this is the link to the forum: www.dertrommelbauer.de
#31491
Re:How to run SQL scripts -> the lazy man\'s way 10 Years ago  
Perhaps you need to recount your statistics? You can do that in the fireboard menu in Joomla.

Or you ran the wrong SQL script?
Page: 12