Simple Review 2.1.2C Install Issue

[jaylee]

I'm using PHP 4.3.11 and MySQL 4.0.17 with Joomla 1.5.15

I got the following error upon upload/install:

JInstaller::install: SQL Error. DB function failed with error number 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 'ENGINE=MYISAM' at line 17 SQL=CREATE TABLE IF NOT EXISTS jos_simplereview_category ( categoryID int NOT NULL auto_increment, templateID int NOT NULL default '-1', categoryTemplateName VARCHAR( 255 ) NOT NULL DEFAULT 'Default', catOrder INT DEFAULT 0 NOT NULL, pageName TEXT NOT NULL, name TEXT NOT NULL, description TEXT NOT NULL default '', published tinyint(4) NOT NULL default '0', categoryImageURL VARCHAR( 255 ), userReviews TINYINT DEFAULT '0' NOT NULL, lft INT DEFAULT 0 NOT NULL, rgt INT DEFAULT 0 NOT NULL, INDEX idx_src_lft (lft), INDEX idx_src_rgt (rgt), PRIMARY KEY (categoryID) )ENGINE=MYISAM;
SQL =
CREATE TABLE IF NOT EXISTS  jos_simplereview_category (
        categoryID int NOT NULL auto_increment,
        templateID int NOT NULL default '-1',
        categoryTemplateName VARCHAR( 255 ) NOT NULL DEFAULT  'Default',
        catOrder INT DEFAULT 0 NOT NULL,
        pageName TEXT NOT NULL,
        name TEXT NOT NULL,
        description TEXT NOT NULL default '',
        published tinyint(4) NOT NULL default '0',
        categoryImageURL VARCHAR( 255 ),
        userReviews TINYINT DEFAULT '0' NOT NULL,
        lft INT DEFAULT 0 NOT NULL,
        rgt INT DEFAULT 0 NOT NULL,
        INDEX idx_src_lft (lft),
        INDEX idx_src_rgt (rgt),
        PRIMARY KEY  (categoryID)
)ENGINE=MYISAM;

Component Install: SQL error or missing or unreadable SQL file. DB function failed with error number 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 'ENGINE=MYISAM' at line 17 SQL=CREATE TABLE IF NOT EXISTS jos_simplereview_category ( categoryID int NOT NULL auto_increment, templateID int NOT NULL default '-1', categoryTemplateName VARCHAR( 255 ) NOT NULL DEFAULT 'Default', catOrder INT DEFAULT 0 NOT NULL, pageName TEXT NOT NULL, name TEXT NOT NULL, description TEXT NOT NULL default '', published tinyint(4) NOT NULL default '0', categoryImageURL VARCHAR( 255 ), userReviews TINYINT DEFAULT '0' NOT NULL, lft INT DEFAULT 0 NOT NULL, rgt INT DEFAULT 0 NOT NULL, INDEX idx_src_lft (lft), INDEX idx_src_rgt (rgt), PRIMARY KEY (categoryID) )ENGINE=MYISAM;
SQL =
CREATE TABLE IF NOT EXISTS  jos_simplereview_category (
        categoryID int NOT NULL auto_increment,
        templateID int NOT NULL default '-1',
        categoryTemplateName VARCHAR( 255 ) NOT NULL DEFAULT  'Default',
        catOrder INT DEFAULT 0 NOT NULL,
        pageName TEXT NOT NULL,
        name TEXT NOT NULL,
        description TEXT NOT NULL default '',
        published tinyint(4) NOT NULL default '0',
        categoryImageURL VARCHAR( 255 ),
        userReviews TINYINT DEFAULT '0' NOT NULL,
        lft INT DEFAULT 0 NOT NULL,
        rgt INT DEFAULT 0 NOT NULL,
        INDEX idx_src_lft (lft),
        INDEX idx_src_rgt (rgt),
        PRIMARY KEY  (categoryID)
)ENGINE=MYISAM;

Is it something to do with software versions?  I can't upgrade my existing software versions due to other compatibility of my other developed scripts.

What can I do to make things work?

[row1]

I think it is to do with the very old version of MySQL.

You can try to unzip the component.
In the folder admin\SQL open the sql files and remove all occurrences of:
ENGINE=MYISAM

[jaylee]

After the removal of all the occurrences of, I got the following error:

JInstaller::install: SQL Error. DB function failed with error number 1067
Invalid default value for 'createdDate' SQL=CREATE TABLE IF NOT EXISTS jos_simplereview_review ( reviewID int NOT NULL auto_increment, categoryID int NOT NULL, awardID int NOT NULL, score DECIMAL(5,1) NOT NULL default '0', name TEXT NOT NULL, pageName TEXT NOT NULL, content longtext NOT NULL, blurb text default NULL, thumbnailURL TEXT default NULL, imageURL TEXT default NULL, createdDate timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', lastModifiedDate timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', createdByID INT NOT NULL, lastModifiedByID INT NOT NULL, published tinyint NOT NULL default '0', userReview tinyint NOT NULL default '0', FULLTEXT KEY idx_srr_blurb_content (blurb,content), INDEX idx_srr_categoryID (categoryID), INDEX idx_srr_score (score), PRIMARY KEY (reviewID) );
SQL =
CREATE TABLE IF NOT EXISTS  jos_simplereview_review (
        reviewID int NOT NULL auto_increment,
        categoryID int NOT NULL,
        awardID int NOT NULL,
        score DECIMAL(5,1) NOT NULL default '0',
        name TEXT NOT NULL,
        pageName TEXT NOT NULL,
        content longtext NOT NULL,
        blurb text default NULL,
        thumbnailURL TEXT default NULL,
        imageURL TEXT default NULL,
        createdDate timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
        lastModifiedDate timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
        createdByID INT NOT NULL,
        lastModifiedByID INT NOT NULL,
        published tinyint NOT NULL default '0',
        userReview tinyint NOT NULL default '0',
      FULLTEXT KEY idx_srr_blurb_content (blurb,content),
        INDEX idx_srr_categoryID (categoryID),
        INDEX idx_srr_score (score),
        PRIMARY KEY  (reviewID)
);
Component Install: SQL error or missing or unreadable SQL file. DB function failed with error number 1067
Invalid default value for 'createdDate' SQL=CREATE TABLE IF NOT EXISTS jos_simplereview_review ( reviewID int NOT NULL auto_increment, categoryID int NOT NULL, awardID int NOT NULL, score DECIMAL(5,1) NOT NULL default '0', name TEXT NOT NULL, pageName TEXT NOT NULL, content longtext NOT NULL, blurb text default NULL, thumbnailURL TEXT default NULL, imageURL TEXT default NULL, createdDate timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', lastModifiedDate timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', createdByID INT NOT NULL, lastModifiedByID INT NOT NULL, published tinyint NOT NULL default '0', userReview tinyint NOT NULL default '0', FULLTEXT KEY idx_srr_blurb_content (blurb,content), INDEX idx_srr_categoryID (categoryID), INDEX idx_srr_score (score), PRIMARY KEY (reviewID) );
SQL =
CREATE TABLE IF NOT EXISTS  jos_simplereview_review (
        reviewID int NOT NULL auto_increment,
        categoryID int NOT NULL,
        awardID int NOT NULL,
        score DECIMAL(5,1) NOT NULL default '0',
        name TEXT NOT NULL,
        pageName TEXT NOT NULL,
        content longtext NOT NULL,
        blurb text default NULL,
        thumbnailURL TEXT default NULL,
        imageURL TEXT default NULL,
        createdDate timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
        lastModifiedDate timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
        createdByID INT NOT NULL,
        lastModifiedByID INT NOT NULL,
        published tinyint NOT NULL default '0',
        userReview tinyint NOT NULL default '0',
      FULLTEXT KEY idx_srr_blurb_content (blurb,content),
        INDEX idx_srr_categoryID (categoryID),
        INDEX idx_srr_score (score),
        PRIMARY KEY  (reviewID)
);

What else should I do next?

Thanks.

[row1]

You can also remove any instanced of the below
DEFAULT '0000-00-00 00:00:00'

Out of interest, what locale is your MySQL server setup as?

[jaylee]

I don't know what locale is my MySQL, how do I find out?  Is that important?  I have a managed hosting who takes care of my server administration.

After the removal of DEFAULT '0000-00-00 00:00:00', this time I got:

JInstaller::install: SQL Error. DB function failed with error number 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 '', lastModifiedDate timestamp NOT NULL', crea SQL=CREATE TABLE IF NOT EXISTS jos_simplereview_review ( reviewID int NOT NULL auto_increment, categoryID int NOT NULL, awardID int NOT NULL, score DECIMAL(5,1) NOT NULL default '0', name TEXT NOT NULL, pageName TEXT NOT NULL, content longtext NOT NULL, blurb text default NULL, thumbnailURL TEXT default NULL, imageURL TEXT default NULL, createdDate timestamp NOT NULL', lastModifiedDate timestamp NOT NULL', createdByID INT NOT NULL, lastModifiedByID INT NOT NULL, published tinyint NOT NULL default '0', userReview tinyint NOT NULL default '0', FULLTEXT KEY idx_srr_blurb_content (blurb,content), INDEX idx_srr_categoryID (categoryID), INDEX idx_srr_score (score), PRIMARY KEY (reviewID) );
SQL =
CREATE TABLE IF NOT EXISTS  jos_simplereview_review (
        reviewID int NOT NULL auto_increment,
        categoryID int NOT NULL,
        awardID int NOT NULL,
        score DECIMAL(5,1) NOT NULL default '0',
        name TEXT NOT NULL,
        pageName TEXT NOT NULL,
        content longtext NOT NULL,
        blurb text default NULL,
        thumbnailURL TEXT default NULL,
        imageURL TEXT default NULL,
        createdDate timestamp NOT NULL',
        lastModifiedDate timestamp NOT NULL',
        createdByID INT NOT NULL,
        lastModifiedByID INT NOT NULL,
        published tinyint NOT NULL default '0',
        userReview tinyint NOT NULL default '0',
      FULLTEXT KEY idx_srr_blurb_content (blurb,content),
        INDEX idx_srr_categoryID (categoryID),
        INDEX idx_srr_score (score),
        PRIMARY KEY  (reviewID)
);
Component Install: SQL error or missing or unreadable SQL file. DB function failed with error number 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 '', lastModifiedDate timestamp NOT NULL', crea SQL=CREATE TABLE IF NOT EXISTS jos_simplereview_review ( reviewID int NOT NULL auto_increment, categoryID int NOT NULL, awardID int NOT NULL, score DECIMAL(5,1) NOT NULL default '0', name TEXT NOT NULL, pageName TEXT NOT NULL, content longtext NOT NULL, blurb text default NULL, thumbnailURL TEXT default NULL, imageURL TEXT default NULL, createdDate timestamp NOT NULL', lastModifiedDate timestamp NOT NULL', createdByID INT NOT NULL, lastModifiedByID INT NOT NULL, published tinyint NOT NULL default '0', userReview tinyint NOT NULL default '0', FULLTEXT KEY idx_srr_blurb_content (blurb,content), INDEX idx_srr_categoryID (categoryID), INDEX idx_srr_score (score), PRIMARY KEY (reviewID) );
SQL =
CREATE TABLE IF NOT EXISTS  jos_simplereview_review (
        reviewID int NOT NULL auto_increment,
        categoryID int NOT NULL,
        awardID int NOT NULL,
        score DECIMAL(5,1) NOT NULL default '0',
        name TEXT NOT NULL,
        pageName TEXT NOT NULL,
        content longtext NOT NULL,
        blurb text default NULL,
        thumbnailURL TEXT default NULL,
        imageURL TEXT default NULL,
        createdDate timestamp NOT NULL',
        lastModifiedDate timestamp NOT NULL',
        createdByID INT NOT NULL,
        lastModifiedByID INT NOT NULL,
        published tinyint NOT NULL default '0',
        userReview tinyint NOT NULL default '0',
      FULLTEXT KEY idx_srr_blurb_content (blurb,content),
        INDEX idx_srr_categoryID (categoryID),
        INDEX idx_srr_score (score),
        PRIMARY KEY  (reviewID)
);

So it's something to do with default value?

What else can I do to fix that?

Thanks.

[row1]

you have an erroneous single quote at the end  after NOT NULL
createdDate timestamp NOT NULL',
lastModifiedDate timestamp NOT NULL',

[jaylee]

yes, the extra single quote is the cause of issue.

i've finally managed to get it install.

i'll try to get familiar with the configuration and start experimenting with it.

thanks again.