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!
Executing queries inside phpmyadmin (1 viewing) (1) Guest
Go to bottom Favoured: 0
TOPIC: Executing queries inside phpmyadmin
#22926
Executing queries inside phpmyadmin 1 Year, 2 Months ago  
Hi,

I am a total novice at phpmyadmin and seem to be stuck at running the queries.

I have opened the file Fireboard_101_to_1.0.3.Stable.sql and successfully run the first query: alter table `jos_fb_categories`

But after that one, I copy and paste in the next query:
add column `headerdesc` text NOT NULL after `description`

I then get the following error:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'add column `headerdesc` text NOT NULL after `description`' at line 1

I keep getting this same error for each additional query. What am I doing wrong?

Thanks,
Baruch
baruch (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.  
#22933
Re:Executing queries inside phpmyadmin 1 Year, 2 Months ago  
the entire block of text between the 'Alter table in Second database' lines is meant to be executed as one statement. copy and paste the entire block to execute it.
sebasvos (User)
Junior Boarder
Posts: 76
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Location: Leiderdorp, Netherlands Birthdate: 1982-12-11
Logged Logged
 
The administrator has disabled public write access.  
#22935
Re:Executing queries inside phpmyadmin 1 Year, 2 Months ago  
Thank you sebasvos. Worked like a charm except for this section of text: alter table `jos_fb_users`
But, I did the rest and the upgrade appears to be successful.
Thanks again.
baruch (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.  
Go to top