Download & Extend
Side Content » Issues

Returning user warnings - "table 'sidecontent' doesn't exist

Posted by munkeyxis on May 18, 2009 at 3:29pm
Project:Side Content
Version:6.x-1.0-beta1
Component:Code
Category:support request
Priority:normal
Assigned:Unassigned
Status:closed (fixed)

Issue Summary

Hi, I'm running drupal 6.12 and have just finished following the install and configuration process for this module. Each of my pages displays the red user warning box and which says things along the lines of:

user warning: Table 'cmsdev.sidecontent' doesn't exist query: SELECT * FROM sidecontent WHERE nid = 77 in C:\Inetpub\wwwroot\cmsdev\sites\all\modules\sidecontent\sidecontent.module on line 204.
user warning: Table 'cmsdev.sidecontent' doesn't exist query: SELECT s.format, s.sidetitle, s.sidecontent FROM sidecontent s WHERE nid = 77 in C:\Inetpub\wwwroot\cmsdev\sites\all\modules\sidecontent\sidecontent.module on line 107.

I looked at the database and indeed there is no sidecontent table. I got a red warning box when i first enabled the module but in my haste I didn't copy it or look at it too closely.

I'm assuming the table just didn't get created when sidecontent was enabled. What can I do to get this module working?

Thank you!

Login or register to post comments

Comments

#1

Posted by Robert Castelo on May 18, 2009 at 3:41pm

Try uninstalling the module, then installing again.

1. Disable Side Content module (untick checkbox, click submit)
2. Uninstall (see uninstall tab)
3 Enable module (tick checkbox, click submit)

If there is an error message when you install can you post it here.

If not please close this issue.

#2

Posted by munkeyxis on May 18, 2009 at 7:21pm

Ah ok thanks, I followed your instructions and upon re-enabling sidecontent I get the red warning box which states :

user warning: BLOB/TEXT column 'sidecontent' can't have a default value query: CREATE TABLE sidecontent ( `nid` INT NOT NULL DEFAULT 0, `format` INT NOT NULL DEFAULT 0, `sidetitle` VARCHAR(128) NOT NULL DEFAULT '', `sidecontent` LONGTEXT NOT NULL DEFAULT '', INDEX nid (nid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in C:\Inetpub\wwwroot\cmsdev\includes\database.inc on line 515.

This is the same warning i got the first time. I'm on IIS6 if that helps any.

#3

Posted by Robert Castelo on May 18, 2009 at 10:51pm

What database are you using - MySQL or Postgrs?

#4

Posted by munkeyxis on May 19, 2009 at 1:30pm

mysql

#5

Posted by munkeyxis on May 21, 2009 at 5:55pm

any ideas?

#6

Posted by Robert Castelo on May 21, 2009 at 9:48pm
Status:active» fixed

Fixed in 6.x-1.0-beta2.

Be sure to run the update if module is already installed.

#7

Posted by System Message on June 4, 2009 at 9:50pm
Status:fixed» closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.