Hi Dave,
Thanks! Glad you like it.
As for that error, unfortunately I screwed up the SQL files a bit for some of the modules. Thanks for the heads up. This won't break the modules in your storefront, but will prevent you from viewing records for them in the control panel. I just updated the downloads so for anyone downloading Squirrelcart PRO v3.4.0 or any of the new module versions as of this writing, this problem shouldn't happen.
If you already upgraded, this error will occur in the control panel when viewing tables for the following modules:
- Download
- News
- Review
- Testimonials
To fix this, run the following queries in the control panel query utility (Tools > Database > Query) for the module(s) you are using.
Download Delivery:
Code:
INSERT INTO `Query` (`record_number`, `Name`, `Description`, `Primary_Table`, `SELECT`, `ORDER`, `GROUP`, `WHERE`, `App_Code`, `Last_Modified`) VALUES (27, 'Downloads', '', 'Downloads', 'SELECT \r\n d.record_number\r\n ,d.Name\r\n ,d.Release_Date\r\n ,d.Enabled\r\nFROM\r\n Downloads d', 'ORDER BY\r\n d.Name ASC', '', '', 'dl', '2006-03-28 11:13:00');
INSERT INTO `Query` (`record_number`, `Name`, `Description`, `Primary_Table`, `SELECT`, `ORDER`, `GROUP`, `WHERE`, `App_Code`, `Last_Modified`) VALUES (28, 'Download Sections', 'Default query for Download Sections table.', 'Download_Sections', 'SELECT record_number, Name, Enabled FROM Download_Sections', 'ORDER BY Name ASC', '', '', 'dl', '2006-03-27 12:51:00');
INSERT INTO `Query` (`record_number`, `Name`, `Description`, `Primary_Table`, `SELECT`, `ORDER`, `GROUP`, `WHERE`, `App_Code`, `Last_Modified`) VALUES (29, 'Downloads - by Section', '', 'Downloads', 'SELECT \r\n ds.Name AS Section\r\n ,d.record_number\r\n ,d.Name\r\nFROM\r\n `Downloads` d\r\n\r\nINNER JOIN\r\n REL_Downloads__Download_Sections dds\r\nON\r\n d.record_number = dds.Downloads_rn\r\nLEFT JOIN\r\n Download_Sections ds\r\nON\r\n dds.Download_Sections_rn = ds.record_number', 'ORDER BY\r\n ds.Name ASC, d.Name ASC', '', '', 'dl', '2006-03-28 11:14:00');
INSERT INTO `Query` (`record_number`, `Name`, `Description`, `Primary_Table`, `SELECT`, `ORDER`, `GROUP`, `WHERE`, `App_Code`, `Last_Modified`) VALUES (30, 'Download Agreements', 'Default query for Download Agreements table.', 'Download_Agreements', 'SELECT record_number, Name FROM Download_Agreements', 'ORDER BY Name ASC', '', '', 'dl', '2006-03-30 13:31:00');
INSERT INTO `Query` (`record_number`, `Name`, `Description`, `Primary_Table`, `SELECT`, `ORDER`, `GROUP`, `WHERE`, `App_Code`, `Last_Modified`) VALUES (31, 'Download Log', 'Default query for Download Log table', 'Download_Log', 'SELECT\r\n l.record_number\r\n ,d.Name\r\n ,l.File_Path AS File\r\n ,l.File_Size_Bytes\r\n ,l.Start_Date\r\n ,l.End_Date\r\n ,l.Duration\r\n ,IF(c.record_number IS NOT NULL, CONCAT(c.Last_Name,'', '',c.First_Name), ''Not logged in'') AS Customer\r\n ,l.IP_Address\r\n ,l.Hostname\r\nFROM\r\n Download_Log l\r\nLEFT JOIN\r\n Downloads d\r\nON\r\n l.Download_rn = d.record_number\r\nLEFT JOIN\r\n Customers c\r\nON\r\n l.User_rn = c.record_number', 'ORDER BY\r\n record_number DESC', '', '', 'dl', '2006-03-30 13:53:00');
News:
Code:
INSERT INTO `Query` (`record_number`, `Name`, `Description`, `Primary_Table`, `SELECT`, `ORDER`, `GROUP`, `WHERE`, `App_Code`, `Last_Modified`) VALUES (34, 'News Posts - Default', 'Default query for News Posts table', 'News_Posts', 'SELECT\r\n record_number\r\n ,Name\r\n ,Date_Posted\r\n ,Enabled\r\n ,Display_on_News_Page\r\n ,Display_in_Navigation\r\nFROM\r\n News_Posts\r\n', 'ORDER BY\r\n Date_Posted DESC', '', '', 'nw', '2006-07-05 18:01:00'),
(35, 'News Sections - Default', 'Default query for News_Sections table', 'News_Sections', 'SELECT\r\n record_number\r\n ,Name\r\n ,Enabled\r\nFROM\r\n News_Sections\r\n', 'ORDER BY\r\n Name ASC', '', '', 'nw', '2006-07-05 18:27:00'),
(36, 'News Mailings - Default', 'Default query for News_Mailings table', 'News_Mailings', 'SELECT\r\n record_number\r\n ,Subject\r\n ,From_Email_Address\r\n ,Sent_Date\r\nFROM\r\n News_Mailings\r\n', 'ORDER BY\r\n Sent_Date DESC', '', '', 'nw', '2006-07-05 18:33:00');
Review:
Code:
INSERT INTO `Query` VALUES (37, 'Reviewers', 'Default query for Reviewer Settings table', 'Customers', 'SELECT\r\n rs.`record_number`\r\n ,IF(LENGTH(rs.`Name`) >0,rs.`Name`,''-- none --'') AS Nickname\r\n ,CONCAT(c.`First_Name`,'' '',c.`Last_Name`) AS Real_Name\r\n ,c.Email_Address\r\n ,IF(rs.Approved = 1,''yes'',''no'') AS `Approved`\r\n ,COUNT(r.record_number) AS `# Reviews`\r\nFROM\r\n `Reviewer_Settings` rs\r\nINNER JOIN\r\n `Customers` c\r\nON\r\n rs.`record_number` = c.`record_number`\r\nLEFT JOIN\r\n Reviews r\r\nON\r\n rs.`record_number` = r.`Customer_rn`', 'ORDER BY\r\n Name ASC', 'GROUP BY\r\n rs.`record_number`', '', 'rv', '2007-12-27 13:59:00');
INSERT INTO `Query` VALUES (38, 'Reviews', 'Default query for Reviews table', 'Reviews', 'SELECT\r\n r.record_number\r\n ,r.`Title`\r\n ,CONCAT(r.`Rating`,'' out of 5'') AS Rating\r\n ,r.`Date`\r\n ,r.`Status`\r\n ,p.Name AS `Product`\r\nFROM \r\n `Reviews` r\r\nLEFT JOIN\r\n `Products` p\r\nON\r\n r.`Products_rn` = p.`record_number`', 'ORDER BY\r\n r.`Date` DESC\r\n', '', '', 'rv', '2007-12-27 00:00:00');
Testimonials:
Code:
INSERT INTO `Query` (`record_number`, `Name`, `Description`, `Primary_Table`, `SELECT`, `ORDER`, `GROUP`, `WHERE`, `App_Code`, `Last_Modified`) VALUES
(39, 'Testimonials', '', 'Testimonials', 'SELECT\r\n record_number\r\n ,First_Name\r\n ,Last_Name\r\n ,Date_Added\r\n ,Testimonial\r\n ,Approved\r\nFROM\r\n Testimonials\r\n', 'ORDER BY Date_Added DESC', '', '', 'ts', '2008-06-26 15:38:00');
If you are running Squirrelcart PRO, just run all of those queries.
Reply With Quote
