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?
FireBoard Manual Latest release discussions Download FireBoard Spread FireBoard!
Community FireBoard Forum Latest Release Upgrading
Can't figure out the SQL query (1 viewing) (1) Guest
Go to bottom Favoured: 0
TOPIC: Can't figure out the SQL query
#25865
Can't figure out the SQL query 1 Year, 2 Months ago  
I'm trying to upgrade from 1.0.2 to 1.0.3, and I am in fact reading the manual, but maybe I'm making it too complicated?

5. Open “Upgrades/Fireboard_102_to_1.0.3.Stable.sql” file.
6. If necessary, rename all the “jos_” occurrences to your own database prefix. Hence, if your db prefix it “boj_” then you should rename all “jos_” to “boj_”.
7. Execute the queries on your remote host; either inside phpmyadmin or your favourite database manager. If you don’t know how to do this, please read: community.mybboard.net/showthread.php?tid=4720 If you get any error during the execution, e.g. you had done some modifications to the database before, then you should execute the rest of the queries and not all of them. The queries are executed in the order as they are listed in the upgrade. First at the top and last at bottom.

I have completed step 5, and even read the SQL query tutorial, but that wasn't the problem. I can run a query just fine, but I don't know what I'm actually supposed to type into the SQL field.
amnion (User)
Junior Boarder
Posts: 58
graphgraph
User Offline Click here to see the profile of this user
Gender: Male
Logged Logged
 
Yeah, but it\'s a sweet car bed. | www.fatalfitness.com
  
The administrator has disabled public write access.  
#25867
Re:Can't figure out the SQL query 1 Year, 2 Months ago  
I'm not quite sure what your trying to say. If you've run the queries that are listed in the .sql file and they completed successfully then your tables are up to date.
jabberwock (User)
We're flying today.
Junior Boarder
Posts: 43
graphgraph
User Offline Click here to see the profile of this user
Dynamic Code Works michaelmiller1 @nospamrm @hotmail.com Location: Canada
Logged Logged
 
We are what we repeatedly do. Excellence, then, is not an act, but a habit - Aristotle
  
The administrator has disabled public write access.  
#25880
Re:Can't figure out the SQL query 1 Year, 2 Months ago  
You don't type anything. You just copy and paste the appropriate patch and run it AS a query.
grumblemarc (User)
Platinum Boarder
Posts: 3559
graph
User Offline Click here to see the profile of this user
Gender: Male
Logged Logged
 
The administrator has disabled public write access.  
#25905
Re:Can't figure out the SQL query 1 Year, 2 Months ago  
Okay, crap. I wasn't thinking when I went to open the file and it did the old "window cannot open the file type" crap, so I didn't try using notepad, don't know what I was thinking. I feel DUMB right now. Thanks for helping me out though.
amnion (User)
Junior Boarder
Posts: 58
graphgraph
User Offline Click here to see the profile of this user
Gender: Male
Logged Logged
 
Yeah, but it\'s a sweet car bed. | www.fatalfitness.com
  
The administrator has disabled public write access.  
Go to top
Powered by FireBoardget the latest posts directly to your desktop