SQL import problems
-
-
- joomuser
- Jr. Rocketeer
- Posts: 20
- Thanks: 0
-
Hi,
I've just downloaded and uploaded to my server the new Joomla 1.5.9 stable installation, and
I'm working the hard way to install it and make it work.
Number one, I couldn't find the configuration.php file in the package, only the Configuration PHP-DIST,so I've had to copy the config.php file from a previous version of Joomla;
and most of all, I can't perform a successful SQL database creation. When I import the joomla.sql file into my phpMyAdmin query window, I always get this error message:
SQL query:
#
#
# Table structure for table `#__migration_backlinks`
#
CREATE TABLE #__migration_backlinks (
`itemid` INT( 11 ) NOT NULL ,
`name` VARCHAR( 100 ) NOT NULL ,
`url` TEXT NOT NULL ,
`sefurl` TEXT NOT NULL ,
`newurl` TEXT NOT NULL ,
PRIMARY KEY ( `itemid` )
) TYPE = MYISAM CHARACTER SET `utf8`
MySQL said: Documentation
#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 'INT(11) NOT NULL,
`name` VARCHAR(100) NOT NULL,
`url` TEXT N
The other sql files seem to contain missing table reference errors. I'm using phpMyAdmin 2.6.4 and PHP 5. I've tried to seek help on Google, but I found only Mambo-dedicated forums.
Why all these errors in the Joomla sql files? If I install a PHP script as an end user, I expect the source files to be well coded. If you can help let me know,thank you.
P.S. By the way, don't answer 'learn SQL and fix errors manually'.
-
-
-
- Kat05
- Preeminent Rocketeer
- Posts: 25898
- Thanks: 334
-
Hi!
A very easy way to get Joomla running is if your host provides an Automatic Install, for example with Fantastico. It only takes minutes and the database gets created as well.
I had no idea about anything when i started with Joomla about 2 years ago, but the install was up and running within minutes.
Hope that helps, Kat - Kat05 / QA Lead & Support / Germany
-
-
-
- JEM
- Preeminent Rocketeer
- Posts: 17917
- Thanks: 4
-
If you are installing a fresh copy of Joomla, while you're at it why not install the template as well suing the Rocket Launcher?
Here are some notes for reference:
The Rocket Launcher is for a fresh install ONLY.
It contains a complete version of the latest Joomla release, the template, and all the sample data you see in the demo. Whether or not you decide to install the sample data is up to you. If you want to replicate the demo site, use it, if you want a clean install of Joomla with the template applied, don’t use it.
You can not use the Rocket Launcher in an existing install of Joomla. If you already have an existing install of Joomla, you will need to apply the template file to it.
Unzip the Rocket Launcher.
FTP the folder and its contents to, depending on your platform, public_html or httdocs
Alternately, you can upload the zipped RL package and extract it on your server through the control panel.
Before you start, you’ll need to create a database on your server.
Once you’ve uploaded the Rocket Launcher and created a database, browse to the folder,
Ex: www.mysite.com/template_directory_name
You don't have to navigate to the installation folder, if Joomla hasn't been installed yet, it will navigate to the install directory automatically. (How cool is that?!)
Note: It's a really simple point, but don't be confused by the ' www.mysite.com/ ' replace 'mysite.com' with your site's URL, for example, here it would be www.rockettheme.com/template_directory_name
The installation screen will appear.
Screen 1:
Choose language
Screen 2:
Pre-installation Check
Screen 3:
License
Screen 4:
You’ll need the following info to make the database connection with Joomla:
Host Name
Username (for the database you’ve created)
Password (for the database you’ve created)
Database Name (for the database you’ve created)
Screen 5:
You can skip this and use an FTP client
Screen6:
Site Name: This will appear in the title bar of your browser.
Your e-mail: the address you want to use to receive mail from the site
Password: this is for the admin login for Joomla, it can be different than the DB password.
Install Sample Data?
If you want to replicate the site with all the sample content, click on ‘Install Sample Data’.
If you don’t want to install the sample data, click next, a prompt will appear confirming that you want to skip.
Screen 7:
You’ll be prompted to delete or rename the installation directory.
Before you can view the site or login as administrator, you’ll need to browse to the directory in your FTP client or CP and do so. - Thanks,
jim
-
-
-
- joomuser
- Jr. Rocketeer
- Posts: 20
- Thanks: 0
-
Kat05 wrote:
Hi!
A very easy way to get Joomla running is if your host provides an Automatic Install, for example with Fantastico. It only takes minutes and the database gets created as well.
I had no idea about anything when i started with Joomla about 2 years ago, but the install was up and running within minutes.
Hope that helps, Kat
Hi, my hosting service does have an automatic install option, and I used it for my first website.
But now I want to learn to install Joomla on my own, not only to broaden my knowledge, but because the Joomla CMS has to be kept often up to date to prevent hackers' attacks, the update patches may conflict with the current database settings and templates, and this means that making a backup copy of the site and reinstalling the CMS are ordinary tasks I may have to do several times in the future. And the hosting service automatic install won't help, because hosting companies offer just a readymade pack of scripts to install, but no assistance on upgrades.
-
-
-
- prim
- Preeminent Rocketeer
- Posts: 17290
- Thanks: 217
-
"and this means that making a backup copy of the site and reinstalling the CMS are ordinary tasks"
Normally you would only use the patches that comes from the Joomla dev's. No reinstall is needed
- Please reply with a direct link to the issue & create a new thread for each new issue.
A template is only as good as the content that goes into it
- DanG
-
Time to create page: 0.066 seconds