Installing Drupal for first time using Cpanel
Hi ,
I am attempting to install Drupal for the first time using host UK2.net , cpanel and I am getting this error ( see below) . MySQL is installed and I have ticked the option for Drupal to create the database. Can any one please help me out?
user warning: 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 ') ORDER BY fit DESC LIMIT 0, 1' at line 1 query: SELECT * FROM i0mx_menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in /home/frontmas/public_html/drupal/includes/menu.inc on line 315.
user warning: 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 ') ORDER BY fit DESC LIMIT 0, 1' at line 1 query: SELECT * FROM i0mx_menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in /home/frontmas/public_html/drupal/includes/menu.inc on line 315.
regards
George
I haven't used that
I haven't used that option.
In cpanel, it is easy to use the mysql tool in the backend to create an empty database and a user (and give the user permissions to access the database). Then you just install drupal without the option to create the database - drupal will ask you for the database name, databse password, and username, all of which were set-up when the database was created.
I am still getting the same error message
Thankyou for your reply . I have tried what you have suggested but I am still getting the same error message.
Is this a fantastico
Is this a fantastico install?
If so, install drupal manually.
If you are already installing manually, each time you try again ensure that you:
· delete all browser cookies
· ensure javascript is switched on in your browser
· select and drop any tables which exist in your database using phpAdmin
· it could also be a php sessions problem, fixed by adding a line in your htaccess.
This is a known problem, but without a clear cause or solution.
Search the forums or google for "menu.inc on line 315"
Highly recommend to install
Highly recommend to install Drupal by yourself, installing from cPanel is not a good option, and the version there usually is not the latest one. After installing it, you will need to re-install Drupal again.
Best Drupal Hosting | Affordable Web Hosting | Drupal Tutorials
Yeah, let's be clear about
Yeah, let's be clear about this though...
To install manually, you still need to 'go through' or 'use' cpanel. For instance, the cpanel file manager is great for uploading the drupal zip file and then unpacking it (you can't unpack with an ftp client). And of course, you have to use the cpanel 'mysql' and 'myphpadmin' tools to create your database and user.
However, what you mustn't do is go to the cpanel 'software/services' section and click 'Fantastico De Luxe'.
If you've been doing that, then this is the most likely cause of your error.
Anti you are right. I have
Anti you are right. I have installed using Fantastico and it works a dream. Thank you for your help !
No! You misunderstand! You
No! You misunderstand! You *must not* install using fantastico!
It may work now, but it is an 'abnormal installation', and will bring you many problems in the future with regard to module incompatibility and upgrades. Just search in this forum for 'fantastico' to see the number of problems it causes.
If you can bear it, I recommend you delete everything and try again to install *manually*.
What I mean in my previous
What I mean in my previous post means "we should not install Drupal via fantastico actually'
Best Drupal Hosting | Affordable Web Hosting | Drupal Tutorials