4.7.4 Problem With Initializing MySQL Database
I have installed drupal 4.7.4 on my host and set up the MySQL drupal database, but cannot get Drupal to work. I have successfully installed drupal on other systems (both local and hosted), but can't seem to get this one up and running. I followed the basic installation guidelines, copying the downloaded drupal files onto the host, creating a drupal database and setting up a user with full privileges to that database, modifying the settings.php to use this new user and database.
However, when I attempt to access the site, instead of the generic drupal page, I get a series of MySQL errors as a result of commands from includes/database.mysql.inc, and back-end examination of the drupal db from phpMyAdmin shows that no tables are present in the database. So, for some reason, the tables aren't getting created, and I wonder whether anyone has suggestions on how to remedy this. A sample error looks like this:
Warning: Table 'drupal.sessions' doesn't exist query: SELECT sid FROM sessions WHERE sid = '9fca5810b3c5c86ed00300ce41853a7d' in /home/xxxxxxxx/public_html/devel/includes/database.mysql.inc on line 121
TIA,
David
tables
did you load the tables into the database? see: database/database.4.1.mysql
No, but...
With 4.7.x is that necessary? I thought that the bootstrap process automatically created the tables. At least, I thought it did the last time I set up a site...
And, of course, once I did what you suggested, it worked. I was of the belief that 4.7.x auto-established the tables.
Thanks.
Only for modules in 4.7
The 5.0 installer will create the main Drupal tables though.
--
Anton
New to Drupal? | Forum posting tips | Troubleshooting FAQ
creating drupal database
When I upload database 4.1 to Mysql it misses tables. When I single out the missing tables I find they contain syntax errors eg
CREATE TABLE blocks (
module varchar(64) DEFAULT '' NOT NULL,
delta varchar(32) NOT NULL default '0',
theme varchar(255) NOT NULL default '',
status tinyint(2) DEFAULT '0' NOT NULL,
weight tinyint(1) DEFAULT '0' NOT NULL,
region varchar(64) DEFAULT 'left' NOT NULL,
custom tinyint(2) DEFAULT '0' NOT NULL,
throttle tinyint(1) DEFAULT '0' NOT NULL,
visibility tinyint(1) DEFAULT '0' NOT NULL,
pages text DEFAULT '' NOT NULL
)
DEFAULT CHARACTER SET utf8;
Gives the result BLOB/TEXT column 'pages' can't have a default value
Whats going on .I've downloaded Drupal several times but get the same result. Could it be MySQL's fault?
Are you sure of the version of MySQL?
I have had trouble when I used the wrong version load file. For example, if I used the 4.1 load file with MySQL 4.0 (not knowing for sure what version was runing on my host).