Expanding WADA _Products Query
When I go to the bindings panel and expand the recordset WADAProducts, I get this error:
MySQL Error#: 1064
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 '' at line 2.
So I tried to re-create my local Products table from the one on the server to make sure it was up to date and compatible, but running the create table query gives:
#1064 - 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 '"products" (
"ProductID" int(12) NOT NULL auto_increment,
"ProductSKU" var' at line 1
SQL for that table:
CREATE TABLE IF NOT EXISTS `products` (
`ProductID` int(12) NOT NULL auto_increment,
`ProductSKU` varchar(50) NOT NULL,
`ProductName` varchar(100) NOT NULL,
`ProductPrice` float NOT NULL,
`ProductWeight` float NOT NULL,
`ProductCartDesc` varchar(250) NOT NULL,
`ProductShortDesc` varchar(1000) NOT NULL,
`ProductLongDesc` text NOT NULL,
`Specs` text,
`Accessories` text,
`ProductThumb` varchar(100) NOT NULL,
`ProductImage` varchar(100) NOT NULL,
`ProductCategoryID` int(11) NOT NULL,
`ProductUpdateDate` timestamp NOT NULL default CURRENT_TIMESTAMP,
`ProductStock` float default NULL,
`ProductLive` tinyint(1) default '0',
`ProductUnlimited` tinyint(1) default '1',
PRIMARY KEY (`ProductID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;
I finally got this to work by exporting the table and saving as a file, then importing that query from the file. But still get the 1064 error when trying to expand the recordset.
I'm running WAMP5 (MySQL 5.0.45) locally, 5.0.81 on the server.
Thanks.