By DavidMichael2222 on

Apparently the mysql version in Zend Server CE has some problems creating tables. Switched to Acquia Dev.

Have been trying to install Display Suite and keep getting an error message saying that the table ds_settings doesn't exist.

So I did the following:

Disable all Display Suite Modules
Uninstall Display Suite And Node Display Modules:
user warning: Unknown table 'ds_settings' query: DROP TABLE ds_settings in C:\Program Files (x86)\Zend\Apache2\htdocs\mysite.com\includes\database.mysql-common.inc on line 269.

Clear Cache – no errors
Enable Display Suite: user warning: BLOB/TEXT column 'settings' can't have a default value query: CREATE TABLE ds_
Enable other DS Modules: Message: Installation of Node displays is done.
Run Update PHP: Message: user warning: Table 'mysite.com.ds_settings' doesn't exist query: UPDATE ds_settings set fields = '' in C:\Program Files (x86)\Zend\Apache2\htdocs\mysite.com\sites\all\modules\ds\ds.module on line 277.
System Table: shows ds installed, schema version 6202; ds_ui installed, schema version 0; nd module installed, schema version 2.
During all this enabling and disabling the number of database tables has stayed constant.

Installed fresh copy of Drupal 6.24, Display Suite and Node Display as only contributed modules.
Upon enabling Display Suite: user warning: BLOB/TEXT column 'settings' can't have a default value query: CREATE TABLE ds_settings ( `module` VARCHAR(32) NOT NULL DEFAULT '', `type` VARCHAR(64) NOT NULL DEFAULT '', `build_mode` VARCHAR(64) NOT NULL DEFAULT '', `settings` LONGTEXT NOT NULL DEFAULT '', `fields` LONGTEXT NOT NULL DEFAULT '', INDEX module (module), INDEX build_mode (build_mode), INDEX type (type) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in C:\Program Files (x86)\Zend\Apache2\htdocs\drupal-6.24\includes\database.inc on line 551.
Upon attempting to edit Display Suite full-node layout: user warning: Table 'drupal-624.ds_settings' doesn't exist query: SELECT module, type, build_mode, settings, fields FROM ds_settings WHERE module = 'nd' AND type = 'poll' AND build_mode = 'full' in C:\Program Files (x86)\Zend\Apache2\htdocs\drupal-6.24\sites\all\modules\ds\ds.module on line 980.

Installed fresh copy of Drupal 6.22, Display Suite and Node Display as only contributed modules. Same results as with fresh install of 6.24.

I'm not sure what to do next. I would love to get this great module up and running. Any help would be greatly appreciated.

Thanks.

⋅ Categories: Drupal 6.x

Comments

zakir.gori’s picture

zakir.gori commented

I just updated the module Display suit and getting same kind of message.
user warning: Table 'appleztx_drupal.ds_settings' doesn't exist query: SELECT module, type, build_mode, settings, fields FROM ds_settings WHERE module = 'nd' AND type = 'project' AND build_mode = 'full' in /home/appleztx/public_html/sites/all/modules/ds/ds.module on line 977.

Please help my site is live.

zakir.gori

moran’s picture

moran commented

anyone? solution?

sclapp’s picture

sclapp commented

I'm not sure if I did the right thing, but it seems to have worked for me thusfar - I was getting the ds_settings table does not exist error message & could not save layout settings for build modes. So I tried to manually create the ds_settings table, per my understanding of what I saw in the ds.install file. The SQL equivalent of what I did is shown below. I used PHPMyAdmin to do this work directly on the database. Backup (& be prepared to restore) the database before trying this (& don't do this to a live production site). I ran update.php & then checked the logs & all seemed to be ok after adding this db table.

CREATE TABLE `mydatabasename`.`ds_settings` (
`module` VARCHAR( 32 ) NOT NULL DEFAULT '''''',
`type` VARCHAR( 64 ) NOT NULL DEFAULT '''''',
`build_mode` VARCHAR( 64 ) NOT NULL DEFAULT '''''',
`settings` TEXT NOT NULL ,
`fields` TEXT NOT NULL
)