Welcome Guest Login Register Member List
ExpressionEngine Forums
Advanced Search
Username: Password:
Remember Me? forgot password?
You are here: Forum Home  >  Usage  >  Troubleshooting  >  Thread
   
 
Error with sql install file
 
Almadark
Posted: 06 March 2007 05:46 AM   [ Ignore ]  
Newbie
Rank
Total Posts:  2
Joined  2007-03-06

Hello, i have a little trouble:

consulta SQL:

– Dump of table contents
– Sample data to populate your database
– No data is included for users: create your own users via the http://YOURURL/signup page
– Dump of table contexts
– â€”———————————————————
INSERT INTO contexts( id, name, position, hide, user_id )
VALUES ( 1, â€˜agenda’, 1, 0, 1 )

MySQL ha dicho: Documentación
#1146 - Table â€˜tracks.contexts’ doesn’t exist 

it seems like i don’t have the structure of the database, i think i don’t have the correct sql with the tables, in the db folder when i try to load it from phpmyadmin, i have only a file called: tracks_1.04_content.sql

can anybody help me?

Profile
 
bsag
Posted: 06 March 2007 06:59 PM   [ Ignore ]   [ # 1 ]  
Administrator
Avatar
RankRankRankRank
Total Posts:  217
Joined  2006-03-05

You need to create the database first in MySQL, and specify that database in database.yml (make sure you fill in both the development and production sections of that file.

Then you should be able to open a terminal and do:


cd ~/Sites/tracks-1.04 # or wherever your tracks is installed
rake db:migrate

That should create the database tables for you. Then you can load the sample content if you want, but that’s an optional step.

Profile
 
Almadark
Posted: 07 March 2007 06:57 AM   [ Ignore ]   [ # 2 ]  
Newbie
Rank
Total Posts:  2
Joined  2007-03-06

Thanks, i think i’m one steep beyond, but now i have:

W:\www\tracks-1.043>rake db:migrate
(in W:/www/tracks-1.043)
rake aborted!
parse error on line 19, col 11: `' 

Thank you

Profile
 
bsag
Posted: 08 March 2007 07:02 PM   [ Ignore ]   [ # 3 ]  
Administrator
Avatar
RankRankRankRank
Total Posts:  217
Joined  2006-03-05

Almadark: You could try:


rake db_schema_import

See instructions here.

Profile
 
   
 
 
‹‹ How would one back up a single user (export / import just one user) ...      Stay Logged In Not Functioning ››

Powered By ExpressionEngine
Template Design By Sonnenvogel.com
Select a theme:

ExpressionEngine Discussion Forum - Version 2.1.2 (20091002)
Script Executed in 0.1223 seconds

Atom Feed
RSS 2.0