Home » Forums » Ubercart » Support

Just installed ubercart_deluxe

Submitted by Dan-902 on Sun, 06/29/2008 - 13:25
Dan-902
Posts: 6
 Joined: 06/29/2008

Using the install profile for deluxe.

I get the three following user warnings?

. user warning: Field 'pages' doesn't have a default value query: INSERT INTO blocks (`module`,`delta`,`theme`,`status`,`weight`,`region`) VALUES ('uc_cart', 0, 'garland', 1, -9, 'left') in C:\ubercart_deluxe\includes\database.mysql.inc on line 172.
. user warning: Field 'pages' doesn't have a default value query: INSERT INTO blocks (`module`,`delta`,`theme`,`status`,`weight`,`region`) VALUES ('uc_store', 0, 'garland', 1, -10, 'left') in C:\ubercart_deluxe\includes\database.mysql.inc on line 172.
. user warning: Field 'pages' doesn't have a default value query: INSERT INTO blocks (`module`, `delta`, `theme`, `status`, `weight`, `region`) VALUES ('block', 1, 'garland', 1, -8, 'right') in C:\ubercart_deluxe\includes\database.mysql.inc on line 172.

Dan
permalink #1 Sun, 06/29/2008 - 16:47
Shawn Conn

Posts: 332
 Joined: 08/07/2007
Administrator

Both the pages and title columns of the Drupal blocks table don't have a default value it looks like. Oddly enough, I've been using this PHP code to setup the initial Ubercart blocks for a while and haven't seen it cause the SQL error before. Whatever the reason, I've fixed the PHP so that those columns are explicitly defined.

--

-Shawn Conn: If the Name Don't Rhyme It Ain't Mine

permalink #2 Sun, 06/29/2008 - 19:25
Dan-902
Posts: 6
 Joined: 06/29/2008

Should I manually run any sql queries...

Platform: Windows Vista SP1( I Know, I Know)
Apache 2.2.8
PHP Version 5.2.5
MYSQL 5.0.51a-community-nt MySQL Community Edition (GPL)